Subject Re: [IBO] IBOQuery stubborn about remembering fields
Author Hans Hoogstraat
Called unprepare. .. about anything else I could call. Doesn't help :)
SQL queries all built at run time
Only the inserted 'commit' via ExecSql seems to clear something
allowing the second query to work.

I don't understand why at time of the TableTwo open via it's
own designated SQL query, the TIBOQuery complains about
FieldNames missing from a SQL query on a total different
TableOne used in the same TIBOQuery


----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, November 10, 2004 6:41 PM
Subject: Re: [IBO] IBOQuery stubborn about remembering fields


|
| At 06:29 PM 10/11/2004 -0700, you wrote:
|
| >Maybe this problem has been resolved in 4.5
| >
| >But
| >
| >with IBOQuery do
| > begin
| > close;
| > SQL.Clear;
| > SQL.Add(Select * from TableOne);
| > SQL.Prepare;
| > open;
| >
| > close;
| > SQL.Clear;
| > SQL.Add(Select * from TableTwo);
| > SQL.Prepare;
| > open;
| >
| >If TableTwo has different Field\Names than TableOne, I get errors on
| >FieldNames not found from TableOne. Tried everything to force some kind
of
| >clear internal FieldNames.
|
| I don't see any sign of TDataset's Fields.Clear ?
|
| Don't forget that TDataset creates persistent field objects!! They
| *persist* unless you do something that clears them.
|
| With the TIBO* dataset, I believe you can take care of the whole lot
| (TDataset's Fields as well as the InternalDataset.Fields, by explicitly
| calling Unprepare.
|
| Helen
|
|
|
|
|
|
|
|
___________________________________________________________________________
| IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
| without the need for BDE, ODBC or any other layer.
|
___________________________________________________________________________
| http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
| keyword-searchable FAQ, community code contributions and more !
| Yahoo! Groups Links
|
|
|
|
|
|
|