That solved the problem. I have spent about 4 hours trying to solve it
before I came here. I was convinced it was my problem. Thanks for a VERY
fast and accurate response.

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: 23 May 2001 21:11
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Incorrect values within SQLDA structure *** URGENT
***


Check the timestamp on the GDS32.DLL on your workstation. If it doesn't
match the server you are connecting to you will have problems.

This has caused me no end of frustration since I frequently have to bounce
between versions of InterBase.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "DaveR" <mailings@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, May 23, 2001 1:10 PM
Subject: [IBO] Incorrect values within SQLDA structure *** URGENT ***


> Help!
>
> I'm really lost on this one. I have an IB_Query with is giving me a great
> deal of grief. I think the problem is down to dates and IB6, since it
> worked on an IB5.5 version of the DB.
>
> I have attached a fairly full trace of what's happening in the hope that
> someone cam shed light on the matter, if more info is needed, just ask.
> Please excuse the long post. I really don't know where to start. I have
> other queries that use Dates in the same app, but they seem OK.
>
> Preparing the Query in design mode does not give an error.
>
> This is really urgent, so ANY pointers would be a help.
>
> I'm using IBO 3.6D, and IB6.01 on W2KP.
>
> CONNECT DATABASE ....
> DB_HANDLE = 13589424
> START TRANSACTION
> DB HANDLE COUNT 1
> TR_HANDLE = 13589252
> ----
> PREPARE STATEMENT
> TR_HANDLE = 13589252
> STMT_HANDLE = 20248152
>
> SELECT ID
> , UNIT
> , RESORT
> , ( SELECT UNITS.UNIT
> FROM UNITS WHERE
> UNITS.ID = WEEKS.UNIT ) AS DISP_UNIT
> , WEEK
> , SEASON
> , FIRSTOCCUPANCY
> , PAIDTO
> , BASECOST
> , TRADEPRICE
> , RETAILPRICE
> , SALEPRICE
> , RCIPOINTS
> , VENDOR
> , VENDORREF
> , PURCHASER
> , DATEENTERED
> , DATECONFIRMED
> , SUSPENDDATE
> , DATERESERVED
> , DATESOLD
> , NOTES
> FROM WEEKS
> WHERE weeks.resort=? /* MLNK_RESORT_0 */
>
> PLAN (UNITS INDEX (RDB$PRIMARY19))
> PLAN (WEEKS INDEX (RDB$FOREIGN23))
>
> FIELDS = [ Version 1 SQLd 22 SQLn 22
> WEEKS.ID = <NIL>
> WEEKS.UNIT = <NIL>
> WEEKS.RESORT = <NIL>
> [DISP_UNIT] = <NIL>
> WEEKS.WEEK = <NIL>
> WEEKS.SEASON = <NIL>
> WEEKS.FIRSTOCCUPANCY = <NIL>
> WEEKS.PAIDTO = <NIL>
> WEEKS.BASECOST = <NIL>
> WEEKS.TRADEPRICE = <NIL>
> WEEKS.RETAILPRICE = <NIL>
> WEEKS.SALEPRICE = <NIL>
> WEEKS.RCIPOINTS = <NIL>
> WEEKS.VENDOR = <NIL>
> WEEKS.VENDORREF = <NIL>
> WEEKS.PURCHASER = <NIL>
> WEEKS.DATEENTERED = <NIL>
> WEEKS.DATECONFIRMED = <NIL>
> WEEKS.SUSPENDDATE = <NIL>
> WEEKS.DATERESERVED = <NIL>
> WEEKS.DATESOLD = <NIL>
> WEEKS.NOTES = <NIL> ]
>
> EXECUTE STATEMENT
> TR_HANDLE = 13589252
> STMT_HANDLE = 20248152
> PARAMS = [ Version 1 SQLd 1 SQLn 1
> [MLNK_RESORT_0] = 174 ]
>
> INTERPRETE BUFFER =
> ERRCODE = 17
>
> INTERPRETE BUFFER = Dynamic SQL Error
> ERRCODE = 21
>
> INTERPRETE BUFFER = SQL error code = -804
> ERRCODE = 39
>
> INTERPRETE BUFFER = Incorrect values within SQLDA structure
> ERRCODE = -1
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>




Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/