> vfp6 sql pass through
>
> receiving fields
>
> CHLD1, varchar(160),
> CHLD2, varchar(160),
> CHLD3, varchar(160),
> CHLD4, varchar(160),
> CHLD5, varchar(160),
> CHLD6, varchar(160),
>
>
> A1CHLD1=(NVL(A1.CHLD1,''))
> A1CHLD2=(NVL(A1.CHLD2,''))
> A1CHLD3=(NVL(A1.CHLD3,''))
> A1CHLD4=(NVL(A1.CHLD4,''))
> A1CHLD5=(NVL(A1.CHLD5,''))
> A1CHLD6=(NVL(A1.CHLD6,''))
>
> strSQL = strSQL + "values (?A1.idno,?A1.empno,?A1.fname,"
> strSQL = strSQL + "?A1CHLD1,?A1CHLD2,?A1CHLD3,?A1CHLD4,?A1CHLD5,?A1CHLD6,"
> strSQL = strSQL + "?A1aqual1,?A1aqual2,?A1aqual3,?A1aqual4,?A1aqual5,?A1aqual6 )"
>
>
>
Error Occured -Connectivity Error Microsoft [ODBC SQL Server Driver
>
> SQL SERVER string or binary data will be truncated.>
>
> I have increased the receiving field sizes well over what is required still having this error message.
>
>
> Some of the records are updated ok, others generate this error.
>
>
> Please assist
>
> Thanks
Please try A1CHLD1=(NVL(A1.CHLD1,chr(160))) etc.
Respectfully
http://praisachion.blogspot.ro/