integer seen as float

[jimpoe]

I have this sql in an OracleDataSet - SELECT Trunc( :CARR_ID ) CARR_ID, ST.ST_ID
FROM ST, DUAL

:CARR_ID is defined as an integer. In the fields editor, CARR_ID is defined as an integer. When I activate the query using MIDAS, I get this error 'dstAUTH_ST: Type mismatch for field 'CARR_ID', expecting: Integer actual: Float'.

How can I get rid of this error message?

Thanks

 

[lynn_sai]

make sure your oracledataset's variables property for :CARR_ID is selected integer.....

 

[jimpoe]

I did as noted in my original message. ":CARR_ID is defined as an integer."

Thanks

 

[Marco Kalter]

The integer variable in the select list is reported by oracle without scale and precision, and is therefore treated as a float by the dataset. I don't think there is any SQL function you can use to change this behavior.

The only way to change this field to a TIntegerField is by setting TOracleSession.Preferences.IntegerPrecision to 38 (the maximum number precision). Now all fields that have a 0 scale will be treated as an integer, at the risk that the values are too large (32 bits, 9 digits maximum). There may also be side effects for other dataset fields linked to this session.

------------------
Marco Kalter
Allround Automations

 

[jimpoe]

Thanks for the info. At least I know what to expect now.

Jim