Results 1 to 3 of 3

Thread: query question

  1. #1
    Join Date
    Jun 2002

    Wink Unanswered: query question

    SQL> select cr_reference from td_har.cros_ref where cr_key_1 = 45;

    BUG_45_td_Capture 1.jpg
    BUG_45_td_Capture 2.jpg

    when I do a query using sql plus I get the following message which is fine and correct.

    I have a front end gui which displays a form. T
    he form has a unique id and this is corresponding to the cr_key_1 which is 45.

    My problem is if I open a new form the id changes to let us say 50.

    How do I query the database based on the current id of the form??.

  2. #2
    Join Date
    Feb 2002
    well can u explain more on the the front end that u are usiong VB..aslo how have u stored the id of the form???

  3. #3
    Join Date
    Jun 2002


    The tool is a custom tool and it generates the form and it associates with active x components. and the the name of the object is the field which is defined as a column in the database at the back end.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts