SQL ExecNonQuery("INERT INTO table..

[tcgoh]

Hi,


I have a edittext.text value that I wanted to insert into a SQL table, but I am unable to get the code right, what is wrong?

SQL1.ExecNonQuery("INSERT INTO CREW VALUES(' " & edittext.text & " ', 'b', 'c', 'd', 'e')")

Thanks

 

[NJDude]

Try this:

SQL1.ExecNonQuery2("INSERT INTO CREW VALUES (?,?,?,?,?)", Array As String(EditText.Text, "b", "c", "d", "e")

 

[tcgoh]

Try this:

SQL1.ExecNonQuery2("INSERT INTO CREW VALUES (?,?,?,?,?)", Array As String(EditText.Text, "b", "c", "d", "e")

Thanks, that worked. BTW what the diff between Array as String & Array as Object?

Sorry I'm Noob and no proper training in programing.

 

[Erel]

BTW what the diff between Array as String & Array as Object?

There is no difference in this case. If you want to add BLOB fields which are made of arrays of bytes then you need to use Array As Object. Otherwise the bytes array will be converted to a meaningless string.

 

[merlin2049er]

Thanks, took a while before I realized that I should have been using
SQL1.ExecNonQuery2 instead of SQL1.ExecNonQuery1