Re: [sqlite] about sqlite3_prepare()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 yoky wrote: > I create a table include about 200 columns, http://en.wikipedia.org/wiki/Database_normalization > like "insert into tablename (Field1,Field2,Field3,...) values > (Value1,Value2,Value3.)" ,and it's length is more

Re: [sqlite] about sqlite3_prepare()

yoky <[EMAIL PROTECTED]> writes: > > Hi all, > I create a table include about 200 columns, before insert a record to > this table, I use sprintf() and strcat() to build a very very long SQL > statement > like "insert into tablename (Field1,Field2,Field3,...) values > (Value1,Value2,V

[sqlite] about sqlite3_prepare()

Hi all, I create a table include about 200 columns, before insert a record to this table, I use sprintf() and strcat() to build a very very long SQL statement like "insert into tablename (Field1,Field2,Field3,...) values (Value1,Value2,Value3.)" ,and it's length is more tha