>>>"MYTABLE.DATE_FLD >= CTOD('" + DTOC( dDateValue ) + "')" >>>>>>
>> MYTABLE.DATE_FLD >= dDateValue >>>>
>cWhereExpr = "MYTABLE.DATE_FLD >= CTOD('" + DTOC( dDateValue ) + "')" >cSqlSelect = " select * from mytable where " + cWhereExpr >If you're passing cSqlSelect into SQLEXEC() then:
cWhereExpr = "MYTABLE.DATE_FLD >= ?dDateValue" cSqlSelect = " select * from mytable where " + cWhereExpr ... nRetVal = SQLEXEC(nCon, cSqlSelect, "csrResult")As Borislav stated, make sure that dDateValue is in scope when the SQLEXEC() is executed.
&cSqlSelect.
* above expands to: select * from mytable where MYTABLE.DATE_FLD >= dDateValue
As Borislav stated, make sure that dDateValue is in scope when the macro expansion takes place.