>
> I am using Bold in Delphi 7 Architect and SQLite over the DBXpress driver from bcp-software.
>
> Works fine, it creates the database as it should, I had to put off the timestamp of the records,
> which was no problem as I do not need that.
>
> Than it comes to inserting data, which works fine too.
>
> Then I stop the application and start it again, and suddenly other queries start to run, because
> there are data in the database, and I get weird errors, like: "Field 'fieldname' not found."
>
> Resuming:
> Without data it starts fine and let me insert data, with data it comes to errors and the application
> does not connect the Bold-controls to the database, which makes the application useless.
>
> I wonder, does someone have a clue, experience with this, or tips.
>
> Thanks very much in advance
Strange that my message never appeared on the sqlite list!! Maybe a system/server problem??
Ok, problem is solved now.
I found the answer, happily I have the source-code of the dbxpress driver.
SQLite does return the table name when it is used in a join, like it is documented below
-----------------------------------------
PRAGMA full_column_names = ON; (1)
PRAGMA full_column_names = OFF; (0)
The column names reported in an SQLite callback are normally just the name of the column itself, except for joins when "TABLE.COLUMN" is used. But when full_column_names is turned on, column names are always reported as "TABLE.COLUMN" even for simple queries.
-----------------------------------------
So I changed the DbXpress driver so that it does strip of the tablename, as Bold always executes joins with tablename but it seems to expect column-names without tablenames, anyway, this short code-change did the trick
Bert Verhees
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
