date time

[Ivan Smahin]

Hello Damon,

Saturday, June 4, 2005, 2:59:34 PM, you wrote:

DP> HI all,

DP> I am using Valentina for Realbasic 2.0

DP> dbase.SQLExecute("Create Table EventLog(damon byte)")
DP> dbase.SQLExecute("Alter Table EventLog ADD LDateTime TimeStamp")
DP> dbase.SQLExecute("Alter Table EventLog ADD Loperator char(50)")
DP> dbase.SQLExecute("Alter Table EventLog ADD Levent char(100)")

DP> This creates the table fine.

You should set appropriate date/time separators and formats before inserts.
Obviously it is not '-' and not YMD for your locale.




-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua