Getdate() return error

TIMOTHY_LAM · September 23, 2021, 1:40pm

Hi,
If using the following statement, it will return the error “Unsupported function call in DA SQL aExpression: getdate()”

RemoteDataAdapter.FillWithDASql(ServerDate, ‘select getdate() SysDate’, nil);

EvgenyK · September 23, 2021, 3:55pm

Hi,

DASQL doesn’t support custom functions.
However, you can use CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP functions

TIMOTHY_LAM · September 25, 2021, 5:44am

Hi,

Noted with thanks. If DASQL doesn’t support, I will change to use getdate() in SQL SP and call SP from DA.