Hi Sergey,
Here is the code that im having problem with. It's an insert sql command using the tips that you gave me in the update. The update command works but it does not work with the insert command. I think I have a logical error with this one for it does not generate any error.
If Empty(.Entrydate)
cEntrydate = "NULL "
Else
cEntrydate = [{] + Dtoc(.Entrydate) + [}]
Endif
cSQL = "INSERT INTO bbfs!callinv(" +;
[dcno] +;
[callrefno] +;
[entrydate] +;
"values(" + Alltrim(Str(cdcno)) +", +;
" + Alltrim(Str(cdcno)) +", +;
+ cEntrydate)"
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.