Question About Using Andre Garzia's DBLib
Posted: Thu Oct 25, 2012 7:33 pm
Hi,
Hope this is not off topic for this forum, but it is related to databases.
I am trying to use Andre's DBLib and I am running into a few problems. In his example he links a SQLite table to a DataGrid using two lines of code.
This code then fills in the datagrid fields First Name, Last Name, Email, Age, and Country. It works great.
But what if you are not using the datagrid, but instead individual text fields, with the same names. What is the code for getting the data out of the table and loading it as a recordset into the individual text fields.
If anyone has used Andre's DBLib and knows how to do this, I would certainly appreciate knowing what the code is. I have tried posting this on Andre's forum, but its been over 24 hours and have not heard anything back. I'm sure he is a busy guy, but I like to keep going with my project.
Jim
Hope this is not off topic for this forum, but it is related to databases.
I am trying to use Andre's DBLib and I am running into a few problems. In his example he links a SQLite table to a DataGrid using two lines of code.
Code: Select all
put dbGet("contacts") into tDataA
set the dgdata of control "contacts" to tDataAThis code then fills in the datagrid fields First Name, Last Name, Email, Age, and Country. It works great.
But what if you are not using the datagrid, but instead individual text fields, with the same names. What is the code for getting the data out of the table and loading it as a recordset into the individual text fields.
If anyone has used Andre's DBLib and knows how to do this, I would certainly appreciate knowing what the code is. I have tried posting this on Andre's forum, but its been over 24 hours and have not heard anything back. I'm sure he is a busy guy, but I like to keep going with my project.
Jim