Cannot retrieve data from Oracle table

General discussion forum about all databases other than SqlBase.
jocamus

Cannot retrieve data from Oracle table

Post by jocamus » 25 Jan 2011, 17:44

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

Re: Cannot retrieve data from Oracle table

Post by jmcnamara » 25 Jan 2011, 19:43

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

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 2 guests