Linking Connection to Grid
Posted: Sat 08 Jun 2013 15:05
Hi,
I am having problems doing the simplest task here. I have gotten the demo for SimpleDataSet to work pretty well, but after setting up my own new project, and keeping it VERY simple, I see the column names in the grid, but NO data appears. The data shows fine in my SQLite utility, SQLite Maestro. I am using DXE2 and the Devart SQLite driver (dbexpsqlite40.dll) from Dec, 2011. What I did is basically:
1. set up Connection, SimpleDataSet, DataSource and Grid, trying to follow the settings, links, and properties in the demo.
2. I mostly used component properties from the demo, but tried many variations. Also tried a lot of things in the SQLConnections.Database.Params basically from the demo examples.
3. Kept the actual code I wrote really brief (3 lines). Put a button on the form with the following code:
{$I .\SetLibName.inc}
SQLConnection1.Open;
SimpleDataSet1.Open;
I copied the SetLibName.inc. used by the demo into my own project folder. Again, when I click on my button, the column names appear but no data.
Thanks for any clues!
P. Scott
I am having problems doing the simplest task here. I have gotten the demo for SimpleDataSet to work pretty well, but after setting up my own new project, and keeping it VERY simple, I see the column names in the grid, but NO data appears. The data shows fine in my SQLite utility, SQLite Maestro. I am using DXE2 and the Devart SQLite driver (dbexpsqlite40.dll) from Dec, 2011. What I did is basically:
1. set up Connection, SimpleDataSet, DataSource and Grid, trying to follow the settings, links, and properties in the demo.
2. I mostly used component properties from the demo, but tried many variations. Also tried a lot of things in the SQLConnections.Database.Params basically from the demo examples.
3. Kept the actual code I wrote really brief (3 lines). Put a button on the form with the following code:
{$I .\SetLibName.inc}
SQLConnection1.Open;
SimpleDataSet1.Open;
I copied the SetLibName.inc. used by the demo into my own project folder. Again, when I click on my button, the column names appear but no data.
Thanks for any clues!
P. Scott