Re: [sqlite] Problem loading extension in Delphi (FTS2)

2007-08-16 Thread Zlatko Matic
Ralf, How about Lazarus version of DISQLite3?:) Regards, Zlatko - Original Message - From: "Ralf Junker" <[EMAIL PROTECTED]> To: Sent: Thursday, August 16, 2007 11:54 AM Subject: Re: [sqlite] Problem loading extension in Delphi (FTS2) Hello Joe Wilson,

Re: [sqlite] incredible slow performance of a trigger

2007-08-09 Thread Zlatko Matic
"TEXT(40)". Finally, indexes help queries performances. []'s, Marco Antonio Abreu IT Quality Systems [EMAIL PROTECTED] http://www.itquality.com.br Zlatko Matic wrote: Hello. I have terrible performance when executing the following query, which inserts rows from table "products&qu

Re: [sqlite] New User: Creating/Modifying tables

2007-08-09 Thread Zlatko Matic
Has anybody successfuly ported DISQLite3 from Delphi to Lazarus? - Original Message - From: "Michael Hooker" <[EMAIL PROTECTED]> To: Sent: Thursday, August 09, 2007 9:47 AM Subject: Re: [sqlite] New User: Creating/Modifying tables How do I create/alter

[sqlite] incredible slow performance of a trigger

2007-08-09 Thread Zlatko Matic
Hello. I have terrible performance when executing the following query, which inserts rows from table "products" to table "bom_products": INSERT INTO bom_products ( plant, product, product_description, product_base_qty_units, product_base_qty) SELECT DISTINCT