Query problems

[vadilloe]

i have a problem with a query, i am a newbee developer, i thing this is a problem with the display syntax or maybe the tables joining, this is my code, and this is my second program using databases and tables, what i want is view the contents in the query-fields, i've made the code for the nextbtn only but it didnt work, please help me!!!

 

[NightRiderWS6]

Hey there.

I can't open your file in AppBuilder because I don't have your DB. At any rate, I had a look and you've commented out your GET NEXT qry1 which you'll want to leave in there when advancing to the next record in your query. However, you have to take special note of the fact that you have defined a query "qry1" at the top of your program however the query "Dialog-Frame" is what is bound to the frame you are using. This is the query where you actually set up all of your "relationships".

The BROWSE-2 query is what your browser is currently using and all it's grabbing is a FOR EACH Order NO-LOCK INDEXED-REPOSITION. That doens't help you much when you want other information in there!

Try right clicking on the browse widget and changing it's query to match something like you did for your Dialog-Frame which was:

FOR EACH Order NO-LOCK,
EACH Order-Line NO-LOCK
WHERE Order.OrderNumber = Order-Line.OrderNumber,
EACH Item NO-LOCK
WHERE Item.ItemNumber = Order-Line.ItemNumber

Try changing your GET NEXT qry1 to GET NEXT BROWSE-2 and see where that gets you.

As a general question, are you trying to advance through rows in your browser by clicking navigation buttons?