Unable to retrieve fields definition from dataset
lazarus / 16-Databases

----------------------------------------------------------------------
CrazyRam · 2019-06-29 22:10

Hi,

I am currently following the SQLdb Tutorial, I can view the data in a
DBGrid but I want to create a form so that I can view individual
records. I understand I should be able to use DBEdit and set the
'DataField'  property in the Object Inspector. However, when I try
that I get the error 'Unable to retrieve fields definition from
dataset' Any ideas ?

Ram.

----------------------------------------------------------------------
Zoran · 2019-06-29 22:46

Can you connect in design time?

Provide the password to connection component, and everything needed to
connect. Then set connected to true.

Then, with active database connection, you should be able to do it.

After that, you can (and should) close the connection, remove the
password from object inspector...

----------------------------------------------------------------------
CrazyRam · 2019-06-29 23:00

Hi Zoran,

Yes I believe it is connected at design time. Though, the DBGrid is
not populated at design time.

I'm using SQLite no password set.

UPDATE:

I've figured it out. Though, 'object SQLTransaction1: TSQLTransaction
was set to 'Active = True' & Database 'Connected' was set to true. I
also needed to set object SQLQuery1: TSQLQuery to Active to 'True'
once I'd set the SQL property to 'select * from CUSTOMER '.

I am now able to 'DataField' the drop down is now populated with the
column headers and the DBGrid is also populated at Design Time.

----------------------------------------------------------------------
mangakissa · 2019-07-01 06:35

When you tell  TSQLQuery to set property  Active to 'True a signal is
sent to TSQLConnection to get info from the database you asked. This
connection is available untill the moment active is false.

----------------------------------------------------------------------
CrazyRam · 2019-07-22 11:28

Thanks mangakissa.