Albert,

Try

l_timestamp = DATETIME()
l_cmd = "update xyz set .......,d_updated = ?l_timestamp where ...."

>
>when starting my form from the ide (froxpro 8.0) everything works well
>when starting my form from an exe i receive an error ?????
>
>
>I want to insert or update a record in a maxdb database table
>the field d_updated is type timestamp !!
>
>i do :
>
>SET DATE TO ansi
>l_timestamp = ALLTRIM(TRANSFORM(DATE()) + " " + TRANSFORM(TIME(TIME())))
>SET DATE TO GERMAN
>
>the result is something like "2004-12-24 12:33:17.55" which is the right datetime format for maxdb(sapdb)
>
>l_cmd = "update xyz set .......,d_updated = ?l_timestamp where ...."
>sqlexec(connetion,l_cmd)
>
>when i do this from a test.prg in the ide everything is OK !!!
>open connection
>do form xxx
>close connection
>
>when i an generate an exe (main=test.prg) i receive an error from the database when inserting or updating a record??
>datetime field overflow !! Invalid timestamp format !!
>
>What is the difference between calling from ide and calling from exe ??????
>
>