> > 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/Still some work alright others give the same error
ggggggggggg