I am trying to insert a record in Frontbase using the SQL tab. Here is the command:
INSERT INTO club.club_member_charge (charge_id, registration_id, charge_date, charge_amount, charge_successful, next_charge_date) VALUES (1000778, 1000660, 2008-08-19 16:30:00, -9.95, 'y', 2008-08-19 16:30:00);
and it returns syntax error 022
I know it has something to do with the date formating because I have successfully added records and edited other fields successfully, but cannot get the date field to either edit nor insert.
Can someone please help me with the correct syntax for dates in Frontbase?
I have tried it with ' ' but then I get an error saying value does not match column charge_date.
If I use MySQL on my other database the insert works perfectly but there is something about the date formatting in Frontbase that won't allow this work.
Any advice would be greatly appreciated.