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

 

[GuptaSteve]

Is the SQL handle connected ? If so try qualifying both the tablewindow and the sql handle. eg 'frm1.tbl1' and 'frm1.hSql'.
If you return from SalTblPopulate , you can see if the Populate is actually executing ie 'If SalTblPopulate() Return TRUE , else Return FALSE' - put a break point AFTER the SalTblPopulate. Also immediatley before the SalTblPopulate, you should have a 'When SQL error' clause to trap any local SQL errors that occur with this execute. Come back if you need to know what to put in your 'When SQLError' clause.


See me at:

http://www.linkedin.com/in/sleighton