Within VBA code for Access 2000 I'm

[wrbodine]

Within VBA code for Access 2000 I'm calling a stored procedure (SQL 7.0). The row of data is being inserted correctly, except for one problem, its only inserting the first character of the data (except for the ones that are money datatype in SQL, which insert fine). These datatypes are nvarchar(50) in the SQL database.

I've used a msgbox to print out the parameter string list and all the other characters are there. (I've also tried appending the parameters using the parameter object and have the same problem of only one character going thru.) Does anyone have any idea why this might be?

Thanks,
Ray

 

[wrbodine]

Actually this was a simple SQL problem that we just found; in the stored procedure the lengths of the variables weren't specified, and were defaulting to 1!!