i have the following table:
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_Divisie ';
cSQL := cSQL + '(';
cSQL := cSQL + 'Divisie_ID Word PRIMARY KEY ASC,';
cSQL := cSQL + 'Divisie_Tekst varchar(25),';
cSQL := cSQL + 'Divisie_Gebruiken Boolean,';
cSQL := cSQL + 'Divisie_Volgorde Word,';
cSQL := cSQL + 'Divisie_Voluit varchar(75),';
cSQL := cSQL + 'Divisie_Vergoeding_Ref Float,';
cSQL := cSQL + 'Divisie_Vergoeding_Lmn Float';
cSQL := cSQL + ');';
Connect_RefereeDB.ExecuteDirect(cSQL);
and now i am trying to write a record to this table with the following code:
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Divisies ';
cSQL := cSQL + 'VALUES (1,"(All)",1,1,"All Divisions,0.0,0.0")';
Connect_RefereeDB.ExecuteDirect(cSQL);
But the code gives an error with the floating points.
How can i write a floating point?