Subject | Re: [IBO] IBOQuery stubborn about remembering fields |
---|---|
Author | Hans Hoogstraat |
Post date | 2004-11-11T02:21:05Z |
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
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
|
|
|
|
|
|
|