Version 2.7.1. test - 2

[Fabio Gianellini]

dear all, i have an other problem using 2.7.1 version and compiling the project with harbour and xharbour
the xharbour version work fine, the harbour version produce an error during the update process on an sql table.
the error (the image is included) usually appear when a program try to insert in a field a value more lenght then the
field lenght
i have tried to reproduce the error using an mdb file but in this case the program work fine.
i don't know if you can test the project using an ms-sql database, if you can in the attached project there is
the script to create the table
thank's a lot

Attached files test.zip (59.6 KB)Â

[ignacio]

Fabio Gianellini escribió el vie, 26 octubre 2012 12:06dear all, i have an other problem using 2.7.1 version and compiling the project with harbour and xharbour
the xharbour version work fine, the harbour version produce an error during the update process on an sql table.
the error (the image is included) usually appear when a program try to insert in a field a value more lenght then the
field lenght
i have tried to reproduce the error using an mdb file but in this case the program work fine.
i don't know if you can test the project using an ms-sql database, if you can in the attached project there is
the script to create the table
thank's a lot
Hello,
I'm afraid your sample is a copy & paste from your code with a lot of unnecessary code. And it even does not compile due a missing library. BTW, at run-time the ADO cConnect property is not resolved correctly either.
In order to help you, I suggest you tell us how to reproduce your error with any Xailer sample. If you need to modify any of them to reproduce it. Go ahead! TIA.
Regards,

[Fabio Gianellini]

i try to explain the problem:
1. to test it you must have a microsoft sql (2005 or 2008)
2. after some other test ( i have eliminated one per one each fiel type ) the problem appear related to the datetime field
where the field is contained in the select clause but not used in the update process, tipically a 'select *'
here attached the project with no external library, only the necessary code to test:
if you select the checkbox the program use all the table fields (the field dataclessidra is selected but not used) and with harbour there is an error, using xharbour it work fine
i hope that these informations can help you
thank's

Attached files test.zip (14.8 KB)Â

[ignacio]

Sorry I do not have a Microsoft SQL to test it.
Regards,

[Milan Mehta]

Dear Fabio,
Did your problem solved ? If yes, how ?
I am facing similar problem while migrating from xHarbour to Harbour using
MySQL.
The problem occurs when trying to insert empty value in datetime field.
It gives out "Mutliple-step operation generated errors.Check each status
value".
TIA
Milan.
"Fabio" <gianellini[at]coopservice[dot]it> wrote in message
news:508a6096$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> dear all, i have an other problem using 2.7.1 version and
> compiling the project with harbour and xharbour
>
> the xharbour version work fine, the harbour version produce
> an error during the update process on an sql table.
>
> the error (the image is included) usually appear when a
> program try to insert in a field a value more lenght then
> the field lenght
> i have tried to reproduce the error using an mdb file but in
> this case the program work fine.
>
> i don't know if you can test the project using an ms-sql
> database, if you can in the attached project there is the script to create
> the table
>
>
> thank's a lot
>