> I don't think different environment is the issue here.
even though it is working in one environment and not another?
--
Chris Keating
****************************************
Please only post to the newsgroup
SQL Anywhere Developer Community
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com
Ben wrote:
> Chris,
>
> Forgot to inform you that it is only that specific report that generates the
> error.
> The program runs okay and all other reports work fine *both in user's pc and
> mine*
>
> fyi, users are using windows XP SP2, mine also. Our server runs on x64 w2003
> I don't think different environment is the issue here.
>
> thanks
>
>
>
> "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com> wrote
> in message news:489fa6d0@forums-1-dub...
>> And to confirm, based on your previous post you indicate you are using
>> ODBC, you should deploy pbodbX.ini where X is the version of PB you are
>> using.
>> --
>>
>> Chris Keating
>>
>> ****************************************
>> Please only post to the newsgroup
>>
>> SQL Anywhere Developer Community
>> http://www.sybase.com/developer/library/sql-anywhere-techcorner
>> SQL Anywhere Blog Center
>> http://www.sybase.com/sqlanyblogs
>> Maintenance releases and EBFs
>> http://downloads.sybase.com/swx/sdmain.stm
>> Use Case Express to report bugs
>> http://case-express.sybase.com
>>
>>
>> Chris Keating (Sybase iAnywhere) wrote:
>>> Does the statement work outside of PB?
>>>
>>> Have you explored what the differences between the two environments?
>>> i.e.,DBMS version? ODBC driver? OS?
>>>
>>>
>>>
>>> --
>>>
>>> Chris Keating
>>>
>>> ****************************************
>>> Please only post to the newsgroup
>>>
>>> SQL Anywhere Developer Community
>>> http://www.sybase.com/developer/library/sql-anywhere-techcorner
>>> SQL Anywhere Blog Center
>>> http://www.sybase.com/sqlanyblogs
>>> Maintenance releases and EBFs
>>> http://downloads.sybase.com/swx/sdmain.stm
>>> Use Case Express to report bugs
>>> http://case-express.sybase.com
>>>
>>>
>>> Ben wrote:
>>>> Pls help me.
>>>> I wanna know why my user got error message invalid descriptor index
>>>> SQLSTATE = 1092
>>>> whilst on my laptop (development machine) the report runs fine.
>>>>
>>>> here is the excerpt of sql statement behind the dw:
>>>> SELECT distinct
>>>> "arinv"."arinvid",
>>>> "arinv"."orderid",
>>>> customer.custnm,
>>>> "arinv"."dateplaced",
>>>> "arinv"."amt",
>>>> arinv.disc,
>>>> sf_getArinvAmtDue (arinv.arinvid) as AmtDue,
>>>> sf_getArinvAmtPaid (arinv.arinvid) as AmtPaid
>>>>
>>>> FROM
>>>> arinv, customer
>>>>
>>>> WHERE
>>>> arinv.custid = customer.custid AND
>>>> (Amt > AmtPaid or AmtPaid IS NULL) AND (AmtDue > 0) AND
>>>> arinv.coid = :ll_coid AND
>>>> ArInv.IsDeleted = 0
>>>>
>>>> ORDER BY arinv.arinvid, customer.custnm
>>>>
>
>
|