Re: SQLite and Delphi 2007


"TD" <dlee@xxxxxxxxxxx> wrote in message news:098dd3c6-97f4-4c4c-84a5-32b6bbbcccfe@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jun 27, 12:53 am, "BRoberts" <berdontem...@xxxxxxxxxx> wrote:


Thanks for relpying. I have the TASQLITE3DB connected to the database
file; database does have data in it. I have the TASQLITE3TABLE setup
to access the table "runlog". I have the TDatasource conected to the
TASQLITE3TABLE. I have TDBEdit's datasource set to the TDatasource
and TDBEdit's datafield set to "Unit" which is a field in the "runlog"
table. I know the database connection is working at design time
because when I right click on "Fields" under the TASQLITE3TABLE and
select "Add Fields" I can see all of the fields in that table. Could
it be that the connection is not there at runtime?


Make sure that the table is open at runtime. I'm not familiar with the components you are dealing with but try

aTable.Open;

in your form's constructor (onCreate).

.

Relevant Pages

  • Re: SQLite and Delphi 2007
    ...  I have the TASQLITE3DB connected to the database ... database does have data in it. ... it be that the connection is not there at runtime? ... where you get an error message after you exit the field that it can ...
    (alt.comp.lang.borland-delphi)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
    (microsoft.public.data.ado)