Hello there !
I’m new to this site, and also completely new to Clarion.
At the moment I’m working on a small program, and i can’t seem to get my head around what’s wrong, and i hope that you are willing to help, and point me in the right direction.
The complete code can be found here
I’m trying to tranfer records from a .TPS file, to a MSSQL database. The .TPS file consists of several different datatypes, which are transfered to MSSQL just fine.
BUT! One of the fields is a blob field, and for some reason, using ADD, I can’t transfer this field to MSSQL - what i end up with is all fields from the .TPS file correctly transferred to the MSSQL database, except the BLOB field, which is “NULL” (The blob field from the .TPS file is definetly not NULL) .
The reason for the close-, open-, set expressions, is because the program will stop without them - clumsy hack, but it works. The loop has contained only the “Do assignRecord”, and that didn’t change a thing, thus i suspect the error is not inside the for loop, but might be in the assignRecord, where i incorrecly assign blob data to the MSSQL variable?