Subject RE: [IBO] TIBOQuery modify Order affects Params
Author Ben Sollis
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
3. Will calling prepare, unprepare any previous prepare?
4. None of this was required in the BDE version. Why is it needed here?


-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 29 October 2003 08:49
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.

>the *SECOND* prepare statement with previously mentioned date format

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.


Yahoo! Groups Sponsor


e=552006/bnum=1067417355801160> Click to learn more...


IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ <> - 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
<> .

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