Re: Type Mismatch In Field 'UserID' expecting Integer actual Float

Posted by WAllison on January 28, 2002 at 21:13:05:

In Reply to: Type Mismatch In Field 'UserID' expecting Integer actual Float posted by Steve on January 22, 2002 at 18:51:54:

: Have Oracle field defined as number(38).

: Get this misage even though the BDE connection has the property Allow Integers set to true.

I dont't know much about oracle but even though you've set the Allow Integers to true this won't make a difference if the field(oracle) is set to float/number(0.000000 etc) - i take it, the app raises a conversion exception? - u should have posted the DB Defs and the code in question - try converting the integer to real - or change the DB Defs.