SQL Server Error:Fractional Truncation

[billch]

Hi All,

I'm getting this msg.:

"Connectivity error: [Microsoft][ODBC SQL Server Driver]Fractional Truncation"

when attempting to append a record to a SQL Server table, then search it from FoxPro.

An internet search indicates this msg. pertains to candidate fields. However, none of these fields are candidate.

Using VFP 6.0 SP5, SQL Server 2000, SP4.

thanks,



Bill Chambers
Chambers & Associates

http://www.ChambersData.com

 

[Mike Lewis]

Bill,

Not sure how "candidate fields" come into this (not even sure what a candidate field is, in this context).

Fractional truncation means just what it says -- the fractional part of a number has been chopped off. It usually happens because you are passing more decimal places than are allowed for in the scaling of your numeric columns.

You can verify that by converting any numeric values in your new record to integers. If that causes the problem to go away, either round the data before sending it, or review the columns on the server.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[billch]

Thanks for your reply Mike.

I've already done as you have suggested by excluding or rounding numeric expressions.

For some reason I think the message "Fractional Truncation", in this case, may mean something other that what it appears.

Does anyone have specific experience with this problewm?



Bill Chambers
Chambers & Associates

http://www.ChambersData.com

 

[Mike Lewis]

Bill,

Sorry I couldn't be more help. The only other thing I can think of is datetime fields being out of range. I hope someone else can come up with something.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[billch]

The problem, I beleive, is my technique of APPENDing a BLANK record to the SQL Server table, then populating it. The technique seemed to work in SQL server 7.0. I also tried INSERT INTO SQLtablename FROM MEMVAR but that gave me problems as well.

I have created a work-around whereby I populate a record in a seperate VFP table then append the VFP table to the SQL server table... Anyway, it works.

Still curious about the exact meaning of the "Fractional Truncation" msg.

Onward and upward.

Bill Chambers
Chambers & Associates

http://www.ChambersData.com