TSQLquery.CreateDataSet raises the error "SQL statement not set"

[dpap]

I'm tying to cretate a table in a SQLite database usisnf a TSQLquery component with some fieldDefinitions. I use SQLquery1.CreateDataSet but I receive the error in theme. I supposed that defining the fields was enough. What is my error ?

The help says "CreateDataset uses the FieldDefs and Fields properties to determine which property contains the structure for the dataset". So why wants the SQL statement?

[cdbc]

Hi
'TSQLquery' is based on TBufDataset, i.e.: it inherits the ability to act like a 'TClientDataset'.
I think 'CreateDataset' stems from TBufdataset, but what you want to use is actually a SQL database, with 'TSQLquery', thus it wants you to fill in the 'TSQLquery.Sql.Text' with a "CREATE TABLE IF NOT EXIST Sometablename ..." statement and the call ExecSql;
HTH
Regards Benny