INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Cannot retrieve data from Oracle table

Cannot retrieve data from Oracle table

(OP)
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

RE: Cannot retrieve data from Oracle table

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close