[Gambas-user] gambas 3 and mysql

[Unaise EK]

hai,
i worte these code for storing data into mysql database, all data stored
into database except date_ad.


Public Sub Save_button_Click()
Dim InsertDb As String
'Dim Dx As Date
'Format(Dx, "dd/mm/yyyy")
InsertDb = "INSERT INTO name_tbl (adm, name, place, date_ad) VALUES ('" &
(TextBox1.Text) & "','" & (TextBox2.Text) & "', '" & (TextBox3.Text) & "',
'" & DateBox1.Value & "' )"
MODMain.MyConn.Exec(InsertDb)
message("Data saved")
clear1


pls help
-- 
M. Unaise. E.K
9895687604
Librarian,
(BLISc, MLIS)
JDT Islam Polytechnic College,
Vellimadukunnu.