>I send the SPT to SQL Server and receive the recordset with a VFP Cursor. In the processing with that cursor, when I want to filter a field whether it's empty or null by using these functions like EMPTY() or ISNULL(), I can't get a correct answer eventhough the field is having NULL value. For Example:
>
>IF ISNULL(temployee.remarks) or EMPTY(temployee.remarks)
> this.value=""
>ELSE
> this.value=temployee.remarks
>ENDIF
>
>The condition is always false eventhough the value is having NULL.
>What else function should i use or am i wrong filtering?
>Appreciating all your suggestions.
>Thanks.
>
>Mya
In addition to Tore, are you sure you didn't bound that TextBox to the NULL field?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.