I need to map a out numeric parameter as ftFloat, but it is being mapped as ftFMTBcd.
I am using dbexpida46 with source code; Delphi XE1 Pro; Firebird 2.5.3.
SQL Connection Parameters:
- DriverUnit=DBXDevartInterBase
DriverAssemblyLoader=Devart.DbxIda.DriverLoader.TCRDynalinkDriverLoader,Devart.DbxIda.DriverLoader,Version=15.0.0.1,Culture=neutral,PublicKeyToken=09af7300eec23701
MetaDataAssemblyLoader=Devart.DbxIda.DriverLoader.TDBXDevartInterBaseMetaDataCommandFactory,Devart.DbxIda.DriverLoader,Version=15.0.0.1,Culture=neutral,PublicKeyToken=09af7300eec23701
DriverPackageLoader=TDBXDynalinkDriverLoader,DBXCommonDriver.bpl
MetaDataPackageLoader=TDBXDevartInterBaseMetaDataCommandFactory,DbxDevartInterBaseDriver150.bpl
ProductName=Interbase
GetDriverFunc=getSQLDriverInterBase
LibraryName=dbexpida40.dll
VendorLib=fbclient.dll
Database=R:\MyDatabase.fm10db
User_Name=SYSDBA
Password=masterkey
SQLDialect=3
MaxBlobSize=-1
LocaleCode=0000
DevartInterBase TransIsolation=ReadCommitted
WaitOnLocks=True
CharLength=1
EnableBCD=False
OptimizedNumerics=True
LongStrings=True
UseQuoteChar=False
FetchAll=False
UseUnicode=False
Code: Select all
create or alter procedure Teste1
returns ( Ret numeric(9,4) )
as
begin
Ret = 3.1416;
suspend;
end
- DataType: ftFMTBcdField
NumericScale: 4
ParamType: ptOutput
Precision: 9
Size: 9
What is wrong?
Thanks in advance.