Devart Forums

Like one of the other posters here, I am trying to learn how to use the dbExpress driver for SQLite.

I have the TSQLConnection on my form, I have created a database manually called clients with 5 fields per record.

How do I connect this connection to a DataSource or Dataset so that I can link the edit and string list components on the form to the database I have created.

Thanks!

Robert

Hello,

For work with DataSet (data editing), you can use the following components binding

SQLConnection<-SimpleDataSet<-DataSource<-DBGrid

or

SQLConnection<-SQLQuery<-DataSetProvider<-ClientDataSet<-DataSource<-DBGrid

You can find the work examples in the ...\Devart\Dbx\SQLite\Demos\ folder

Thanks Alex for this clear explanation of the connections.

So now, I want to connect my data to Listbox, edit and graphic controls on the form, and this is with Firemonkey.

Can you tell me how this is done? I do not understand the relationship between the datasource and these controls.

Thanks,

Robert

Hello,

For mapping data from DataSet in the standart components of the FieMonkey application, you should use LiveBinding. The LiveBinding samples can be find in the folder with demo samples distributed together with Rad Studio.

SQLConnectionContextMenu->Link To DB Field->, and choose the necessary field.
The LiveBinding components will be added and tunned automatically