HomePowerBuilderAppeon Documentation Center

Data type in Dynamic SQL Format 4

In PowerBuilder, the Oracle database may return the numeric data as the decimal type. 

Row=1, Column=1, type=Decimal, value=1
Row=2, Column=1, type=Decimal, value=2

While in PowerServer, the Oracle database may return the numeric data as the longlong type. 

Row=1, Column=1, type=LongLong, value=1
Row=2, Column=1, type=LongLong, value=2

It is recommended that the developer use "choose case" to support the longlong-type numeric data. 

CHOOSE CASE SQLDA.OutParmType[n]
case TypeLongLong!
   ls_DataType = 'LongLong'
   ls_Value = String(adda_parm.GetDynamicDecimal(li_Idx))
Prev  Up  Next
TransactionName  Home  Decimal data type in static SQL or DataWindow