onlineand
tlUpdatewith fieldtype 'Character' , online is populated with 'TRUE', 'FALSE', .NULL., tlUpdate is populated with a Datetimeexpression or .NULL.
FOR me the most logical approach would be: TEXT TO sqltxt noshow pretext 15 TEXTMERGE select CAST(coalesce(online,'TRUE',.T.,.F.) as L) as online , CAST(coalesce(tlupdate,'') as T) as tlUpdate from HORSART_WORKS ENDTEXT lcResult = sqlexec(lnRet, lcSql,"curHorsart_Works") IF lcResult < 0 * Error ELSE DO my thing ENDIF