J JJM Active Member Licensed User Longtime User May 30, 2007 #1 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
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
D dzt Active Member Licensed User May 30, 2007 #2 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
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 B4X founder Staff member Licensed User Longtime User May 31, 2007 #3 You could find the SQLite documentation here: http://www.sqlite.org/docs.html