SQL harbour vs SQL xharbour

[Fabio Gianellini]

dear all, regarding my previous message #50073 i must solve this situation otherwise i cannot migrate anyone of mine projects
the problem i releated to the Harbour version contained in xailer for the datetime fields on MS SQL database.
i have understood that you don't have any MS SQL engine but here attached a little project containin only a connection to a database
a select on a table and finally one update on a datetime field using an empty date ( ctod() ).
using xailer - Xharbour it's ok
using xailer - Harbour don't work
using the same version of only harbour (downloaded from the harbour site) it work ok
the error is contained in the attached project (error.log)
some year ago, if i remerber correctly, there was a similar problem using Xharbour and you have modified the winole program.
thank in advance
and Merry christmas and happy new year to all the xailer group

Attached files Test1.zip (3.3 KB)Â

[ignacio]

Fabio Gianellini escribió el vie, 21 diciembre 2012 15:06dear all, regarding my previous message #50073 i must solve this situation otherwise i cannot migrate anyone of mine projects
the problem i releated to the Harbour version contained in xailer for the datetime fields on MS SQL database.
i have understood that you don't have any MS SQL engine but here attached a little project containin only a connection to a database
a select on a table and finally one update on a datetime field using an empty date ( ctod() ).
using xailer - Xharbour it's ok
using xailer - Harbour don't work
using the same version of only harbour (downloaded from the harbour site) it work ok
the error is contained in the attached project (error.log)
some year ago, if i remerber correctly, there was a similar problem using Xharbour and you have modified the winole program.
thank in advance
and Merry christmas and happy new year to all the xailer group
Hello,
We have not change a single line of olecore.c Harbour source code. Since you are not using our Datacontrols to access MSSQL, you are indeed not using Xailer at all to do that job.
BTW, we can not test your program because we do not have any MSSQL server in house, but since the connection is done with ADO, the problem should also arise with Access databases, for example.
In any case, we highly recommend to use our datacontrols.
Please test with future Xailer 3 version that will be published really soon.
Regards,
Regards,

[Fabio Gianellini]

ok, i can wait
but in the previous post i have used only xailer datacontrol with the same result obtained in this last project, the problem don't appear related to the datacontrol