Subject | TIB_Cursor and TIB_Dataset no data at run time |
---|---|
Author | clivewalden |
Post date | 2005-12-20T04:58:40Z |
Background:
I have a TIB_Cursor which I am passing to one of my classes as a
TIB_Dataset.
AutoFetchAll = True
AutoFetchFirst = True
ReadOnly = True
RequestLive = False
I set the SQL dynamically then call
FDataset.SQL.SaveToFile('datasetSQL.SQL'); // For debug
FDataset.Prepare;
FDataset.First;
I get no data back.
EOF = True
If I try to access the field values I get an exception.
I have tried casting back to a TIB_Cursor; but that made no difference.
In the IDE, if I Edit the TIB_Cursor and paste the contents of the
saved file ('datasetSQL.SQL') into the SQL of the Cursor tab I get the
correct data that I expect at run time.
What am I missing?
Many thanks,
Clive.
I have a TIB_Cursor which I am passing to one of my classes as a
TIB_Dataset.
AutoFetchAll = True
AutoFetchFirst = True
ReadOnly = True
RequestLive = False
I set the SQL dynamically then call
FDataset.SQL.SaveToFile('datasetSQL.SQL'); // For debug
FDataset.Prepare;
FDataset.First;
I get no data back.
EOF = True
If I try to access the field values I get an exception.
I have tried casting back to a TIB_Cursor; but that made no difference.
In the IDE, if I Edit the TIB_Cursor and paste the contents of the
saved file ('datasetSQL.SQL') into the SQL of the Cursor tab I get the
correct data that I expect at run time.
What am I missing?
Many thanks,
Clive.