I am starting to use SQL Tool Kits to implement some database function for SQL Server 2008. I am having this DBPutRecord error, and I want to ask how to troubleshoot the problem.
The error code is:
--------------------------------------------------------
NON-FATAL RUN-TIME ERROR
Function DBPutRecord: (return value == -2147352567 [0x80020009]).
Errors occurred. Possible cause: value too large for field/column and ADO provider does not support retry with truncated data
...
--------------------------------------------------------
I know that I have the following table, from SQL Server:
ID - primary key, uniqueidentifier, not null
NAME - varchar(255)
ZOOM - float
In CVI, I have the table structure setup as the following
double id;
char name[255];
float zoom;
I am using DBActivateSQL() to query the table, and DBCreateRecord() to create a row, and the error happens at DBPutRecord().
Peggy
