Page 1 of 1
SQL v10 numeric field = -1
Posted: Sun Aug 03, 2003 2:28 pm
by Guy
Hello,__I^m using for the first time the sql version and after conversion of my old report xbase version, i saw that all numeric value with my MSSQL server 2000 now look just with -1. No good data. all my fields characters are all right.__Where is a problem__Thank you__Guy
=> RE: SQL v10 numeric field = -1
Posted: Sun Aug 03, 2003 3:10 pm
by kfleming
Which ODBC driver are you using? What is the data type that is being used within SQL Server? Does same problem happen with a new report?____Kathleen__R&R Support
==> RE: SQL v10 numeric field = -1
Posted: Mon Aug 04, 2003 3:20 am
by Guy
I tried with 2 different driver (SqL server 2000.81.9031.14 and data direct sql server 4.20) it^s the same__With a new report it^s the same also__And my numeric data are decimal 5__Thanks for help
==> RE: SQL v10 numeric field = -1
Posted: Mon Aug 04, 2003 5:34 am
by Guy
After a lot of test, i noticed that just "int" works fine. Decimal, numeric, money... doesn^t work__May be a problem with comma and delimeters ? I^m french with a system french, don^t you ?__But should i do to work fine ?__Guy
===> RE: SQL v10 numeric field = -1
Posted: Wed Aug 06, 2003 1:20 am
by Guy
Hello,__Nobody to help me ?__Guy
====> RE: SQL v10 numeric field = -1
Posted: Wed Aug 06, 2003 11:46 am
by kfleming
My SQL Server 2000 uses US settings and can see each of these field types without error.____What happens if you use another application such as MSAccess to connect via ODBC to your server? Is it good or bad?____Kathleen__R&R Support
=====> RE: SQL v10 numeric field = -1
Posted: Fri Aug 15, 2003 2:38 pm
by Guy
I tested with a windows 2000 pro french station and all is allright.__Only with windows xp pro it^s not good . i search what happens but i don^t find.__Help