SQL use

[JJM]

Hi,
I don't understand the synthax of the cmd.CommandText

I saw for example in a Erel's programm

cmd.CommandText="SELECT name FROM sqlite_master WHERE type = 'table'"
For me is japanese !

Have you some examples of commands with explanations?

Thanks a lot

Best regards

JJ M

 

[dzt]

cmd.commandtext takes an SQL statement. The statement of Erel,s program returns after execution all the names of tables in the SQLite database.

A good SQL start:
http://www.w3schools.com/sql/default.asp

 

[Erel]

You could find the SQLite documentation here:
http://www.sqlite.org/docs.html

 

[JJM]

Thank you for your help.
JJ M