More SQL questions

[HARRY]

Hi everybody,

I have to add a number of fields to a table if those fields do not already exist.
I have been playing around with IF NOT EXISTS, but I don't get it working.

Also, I have no idea how to intercept error messages from SQlite; then I could just ignore certain error codes, a.o the error if a field already exists.

With VB I have done quite complicated things with SQL; may be that the problem is that I try to do it in the same way.

Are there some SQLite experts among the forum members?

Harry

 

[Erel]

I'm not a SQLite expert.
Also try sqlite site: http://www.sqlite.org/support.html

For now it is not possible to catch error messages with the ErrorLabel method.
It is high in the ToDo list and will be available in the near future.

 

[glook]

I am definitely no SQLite expert either!

However a simple method could be - do a SELECT * on the table and open it with DataReader, then use FieldCount to test if the fields exist. Finally do ALTER TABLE with an ExecuteNonQuery, if needed.

Alternatively, if you need more column information, use ExecuteTable instead, then the Table control's ColCount and ColName properties.

Just a suggestion.
Geoff.