>Hi Jamie,
>I'm on SQL Server 6.5 already, that's where the errors occur. Not sure what version of the SQL Server ODBC driver we're using, but will investigate. MS Knowledge Base lists other bugs in various drivers, Sqlsvr32.dll (versions 2.65.0252, 3.50.0300, 3.50.0303, and 3.50.0311) all have a problem with rounding decimal values down when TABLEUPDATE() is issued.
>
That's just what I didn't want to hear! Have you tried using the Intersolv drivers? You can download a 30-day trial from
www.intersolv.com. Unfortunately these drivers aren't cheap so they're not a perfect solution.
>Hard enough the c/s technology there are no books, few resources, very few threads on this forum, seems to be relatively few people implementing VFP as front-end client for SQL Server. Help!
I agree. Or those who are using c/s with VFP & SQL Server are doing very data-simple apps.
I'll be investigating further and will post under the C/S topic if I find any other solutions.
Regards,
Jamie.
-----
Jamie Forgan
Senior Consultant
WST Pacific Pty Ltd