Hi guys,

How do you code an sql update and execute it via SQL Passthrough or ADO. Im having problems in particular with date fields on how to insert Null to the date field if the value is empty . The code is shown below. When executing this code, it does not prompt for an error but it does not update the table.

If Empty(Entrydate)
cEntrydate = .NULL.
Else
cEntrydate = Ttod(Entrydate)
Endif

cSQL = [UPDATE bbfs!callinv SET callername = "]+ ALLTRIM(.callername) +[",] +;
[callerlocation = "]+ ALLTRIM(.callerlocation) +[",] +;
[entrydate = ] + "cEntrydate " +; [WHERE callrefno = ] + Alltrim(Str(cCallrefno))

This.oConn.Execute(cSQL)