>The column is define as allowing NULLS
>The insert is something like :
>INSERT INTO mytable(oneval, twoval, oneday) VALUE(lc1,lc2,ldate)
>
>I run this and copy the output to the cliptext. It comes back with only the values of lc1 and lc2.
>Like (“firstval”, “secondval”
>that’s all it reads, not even close parentheses.
>
>I declare ldate as I showed you before NVL(ldate, NULL) so that if it is null I want to insert a NULL.
>I use what I have in the clipboard adding the NULL like this:(“firstval” “secondval”,NULL) and it runs
>that's why I thought I needed to send a something to the sql sever.
I'm assuming the INSERT above is used in a SQLEXEC() - this has worked for me
lc1 = "value_one"
lc2 = "value_two"
ldate = null
SQLEXEC(lnhandle, "insert into mytable (oneval, twoval, oneday) values (?lc1, ?lc2, ?ldate)")
Insanity: Doing the same thing over and over and expecting different results.