Cannot retrieve data from Oracle table

[jocamus]

I have this app in TD 2.1, so based in orademo.app from samples I tried to retrieve data from a a table which already exists. The login form works fine, but in the next window I have this line:

Call SalTblPopulate( tbl1, hSql, "SELECT ITEM_NO, QUANTITY, AMOUNT
INTO :tbl1.colItemNo, :tbl1.colQuantity, :tbl1.colAmount
FROM INVOICE_DETAIL
WHERE INVOICE_ID = 125454", TBL_FillAll )

but the app goes freeze. Any clue?? thanks


jorge

[jmcnamara]

Just a guess - you're connecting to an Oracle 10g or 11g with a pre Oracle 9 router.