Hi all,

Can someone clarify for me;

1. Should the IBOQuery be prepared before accessing the params property but
after the SQL strings has been set?
2. What if the IBOQuery has already been prepared by a previous statement?
Does it need to be Unprepared before or after the SQL Strings property is
set?
3. Will calling prepare, unprepare any previous prepare?
4. None of this was required in the BDE version. Why is it needed here?

Ben


-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 29 October 2003 08:49
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] TIBOQuery modify Order affects Params


At 08:37 AM 29/10/2003 +0000, you wrote:

>I wish the solution was that simple! If you try this, it crashes

What do you mean by "crash"? You'll get an AV if you try to reference the
Params[] array in an unprepared query. That's a crash.

>on
>the *SECOND* prepare statement with previously mentioned date format
>error.

So you don't mean "crashes" at all, but "throws an exception"? Can you put
an actual line that shows you assigning a particular date value to the
parameter? And how you arrive at this value?

Sorry, but you aren't giving us much to go on.

Helen




Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=243273.4089246.5300282.1261774/D=egroupweb/S=17050071
83:HM/A=1750744/R=0/SIG=129b4nr3d/*http://servedby.advertising.com/click/sit
e=552006/bnum=1067417355801160> Click to learn more...

<http://us.adserver.yahoo.com/l?M=243273.4089246.5300282.1261774/D=egroupmai
l/S=:HM/A=1750744/rand=344236030>

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com <http://www.ibobjects.com> - your IBO community
resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]