Sure, return a cursor from the server like this.
Create a 1 record table on the server called timedummy.
SQLEXEC(nConnectionHandle, 'SELECT DATETIME() as datetime FROM timedummy', 'cDatetime')
>Hi All,
>
>Is there a way to get the current datetime() from the VFP database server.
>I have a client talking via ODBC to VFP DBC on the network ( Client/Server app designed in VFP backend is VFP DBC).
>When i create a record using Client i would like to stamp it NOT with DATETIME() from the CLient PC but with datetime() from the VFP server.
>
>
>THanks
>
>Regards
>
>Dejan