christian.gambas wrote:
> Le mercredi 20 août 2008, Benoit Minisini a écrit :
>
>> But do that:
>>
>> res = mDatabase.conn.Exec("INSERT INTO customer VALUES(name) (&1)",
>> TextBox1.Text)
>>
>
> You're right, Benoît, one could never be careful enough !
>
> But, just to avoid confusion to
Le mercredi 20 août 2008, Benoit Minisini a écrit :
> But do that:
>
> res = mDatabase.conn.Exec("INSERT INTO customer VALUES(name) (&1)",
> TextBox1.Text)
You're right, Benoît, one could never be careful enough !
But, just to avoid confusion to João Luís, you surely mean :
res = mDatabase.
On mercredi 20 août 2008, christian.gambas wrote:
> Le mercredi 20 août 2008, João Luís a écrit :
> > sql = "INSERT INTO customer VALUES(name), ('" & TextBox1.Text & "')"
>
> I think It must be (at least with sqlite) :
> sql = "INSERT INTO customer (name) VALUES('" & TextBox1.Text & "')"
>
> cheer
Le mercredi 20 août 2008, João Luís a écrit :
> sql = "INSERT INTO customer VALUES(name), ('" & TextBox1.Text & "')"
I think It must be (at least with sqlite) :
sql = "INSERT INTO customer (name) VALUES('" & TextBox1.Text & "')"
cheers :)
---
