DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Pre-query

  1. #1
    Join Date
    Jun 2001
    Am having a master-detail relation btn a master block and a detail block.......Master block has a composite Primary Key. Can i Pass two conditions in Pre-Query to execute my query i.e. to fetch all the detail records....Passing one condition works in Pre-Query......If i pass two conditions it doesn't work.......
    Is there any other way to fetch the detail records besides using Cursor ?? I want to know if it is possible use Pre-query to execute the detail records when two conditions r passed.....Do let me know pl.


  2. #2
    Join Date
    May 2001
    I normally use the POST-QUERY. It seems to cause me less pain.

    Can you supply an example of the one condition and two condition so we can help suggest a solution.

  3. #3
    Join Date
    Oct 2000
    Unless I'm getting the wrong end of the stick, all you have to do is create a Relationship between the two blocks and Forms will create all the functionality itself. You can have more than one field when defining a relationship.

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.