Subject Re: [IBO] TIBOQuery modify Order affects Params
Author Jason Wharton
Have you looked to see if those exceptions are actually handled?

Jason Wharton

----- Original Message -----
From: "teamtlas" <mark.h@...>
To: <>
Sent: Tuesday, October 28, 2003 8:38 PM
Subject: [IBO] TIBOQuery modify Order affects Params

> Hi
> I am converting a number of BDE applications to IBO. Many of these
> apps modify the Query SQL strings "ORDER BY" clause dynamically in
> response to user input. The queries generally contain parameterised
> "WHERE" clauses.
> The problem I am having is that since converting to IBO the first
> "Open" of a query executes fine but after closing the query and
> modifying the "ORDER BY" clause dynamically, the second "Open" causes
> parameter problems such as "nn/nn/nn nn:nn:nn.nnnn is not a valid
> date and time".