Invalid precision value in TMemoField under 3-tier

[Andy Wong]

Enclosed SQL log is extracted from a middle tier using a TQuery to insert a
record to AS/400 using Client Access ODBC Driver. There are 6 TMemoFields
with blob data (actually they are just long text fields). I can perform
update and delete operation properly but when I insert a new record, I got
the error with invalid precision value (see seq. 35577).
I'm sure the problem is not caused by the ODBC driver since I can perform
the insert operation in 2 tier suiccessfully.
Any idea??

35561 14:21:22 SQL Prepare: Client Access ODBC Driver (32-b - insert into
"WRKLIB"."BMREG"
("BMPARCOD", "BMSECCOD", "BMBLDCOD", "BMADRC", "BMADRP", "BMCONPRZ",
"BMCON1", "BMCON2", "BMCONOBJ", "BMOBS", "BMIHOBS")
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
35562 14:21:22 SQL Data In: Client Access ODBC Driver (32-b - Param = 1,
Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16
35563 14:21:22 SQL Data In: Client Access ODBC Driver (32-b - Param = 2,
Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 03
35564 14:21:22 SQL Data In: Client Access ODBC Driver (32-b - Param = 3,
Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = AB
35565 14:21:22 SQL Blob IO: Client Access ODBC Driver (32-b - Return blob
data
35566 14:21:22 SQL Blob IO: Client Access ODBC Driver (32-b - Return blob
data
35567 14:21:22 SQL Blob IO: Client Access ODBC Driver (32-b - Return blob
data
35568 14:21:22 SQL Data In: Client Access ODBC Driver (32-b - Param = 7,
Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = sdfsdfsdf
35569 14:21:22 SQL Data In: Client Access ODBC Driver (32-b - Param = 8,
Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = dsfdsfs
35570 14:21:22 SQL Blob IO: Client Access ODBC Driver (32-b - Return blob
data
35571 14:21:22 SQL Blob IO: Client Access ODBC Driver (32-b - Return blob
data
35572 14:21:22 SQL Blob IO: Client Access ODBC Driver (32-b - Return blob
data
35573 14:21:22 SQL Execute: Client Access ODBC Driver (32-b - insert into
"WRKLIB"."BMREG"
("BMPARCOD", "BMSECCOD", "BMBLDCOD", "BMADRC", "BMADRP", "BMCONPRZ",
"BMCON1", "BMCON2", "BMCONOBJ", "BMOBS", "BMIHOBS")
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

35574 14:21:22 SQL Vendor: ODBC - SQLAllocStmt
35575 14:21:22 SQL Vendor: ODBC - SQLBindParameter
35576 14:21:22 SQL Vendor: ODBC - SQLError
35577 14:21:22 SQL Error: Client Access ODBC Driver (32-b - [IBM][Client
Access Express ODBC Driver (32-bit)]Invalid precision value.
35578 14:21:22 SQL Vendor: ODBC - SQLError
35579 14:21:22 SQL Error: Client Access ODBC Driver (32-b - Unmapped SQL
Error Code: 0
35580 14:21:22 SQL Stmt: Client Access ODBC Driver (32-b - Reset
35581 14:21:22 SQL Vendor: ODBC - SQLFreeStmt

[Steven P. Goldsmith]

I assume you have set up CA for 3-tier (cwbcfg and registry key permission).
If so, try ADO or ActiveX controls and see if you have the same problem.
"Andy Wong" <an...@post1.com> wrote in message news:3a4ae1bd_2@dnews...