Here is a small snip from one of my programs. The return values are all good, but the data is NEVER entered into the table even though it says it did.
Here is what I get from the print line above:
Now, an interesting thing is that if CategoryList$ is null, the record is created just fine. If this variable contains anything at all, the actual data is not written to the file even though I get return value of 0 and a valid record number from slGetInsertID. I've tried changing the name of the variable, adding apostrophes, replacing "NULL" with just "", just about everything I can think of, but the results are always the same.
I'm stumped. Any ideas?
Code Select
CategoryList$ = "'" + CategoryList$ & "'"
KeyWords$ = "NULL"
AuthorID$ = "'0'"
Copywrite$ = "NULL"
CompilerID$ = "'0'"
Win32Version$ = "NULL"
Comments$ = "NULL"
SQL$ = "INSERT INTO ClipMaster VALUES (NULL,'" & ClipName$ & "','" & ClipPath$ & "'," & _
CategoryList$ & "," & _
KeyWords$ & "," & _
AuthorID$ & "," & _
Copywrite$ & "," & _
CompilerID$ & "," & _
Win32Version$ & "," & _
Comments$ & ");"
e& = slEXE(SQL$,"E")
ClipID& = slGetInsertID
? SQL$ & $CRLF & "ClipID:" & STR$(ClipID&) & $CRLF & "Cat: " & CategoryList$
Here is what I get from the print line above:
Quote
INSERT INTO ClipMaster VALUES(NULL,"!aaatest","\\Undefined\","5;6;9;11","NULL","0","NULL","0","NULL","NULL");
ClipID: 986
Cat: "5;6;9;11"
Now, an interesting thing is that if CategoryList$ is null, the record is created just fine. If this variable contains anything at all, the actual data is not written to the file even though I get return value of 0 and a valid record number from slGetInsertID. I've tried changing the name of the variable, adding apostrophes, replacing "NULL" with just "", just about everything I can think of, but the results are always the same.
I'm stumped. Any ideas?