Hi,
I'm running a SQL SELECT statement in a form. I'm using six tables and they are connected with a LEFT OUTER JOIN each.
I never have problems with this way of doing it, but here I encounter a strange behavior:
Certain fields are going wrong, they always show the values of the FIRST record of the main table. Also, what I don't understand, is, that I need to have the tables in the dataenvironment. I thought, with a SQL SELECT, I need not to USE the tables, or even to have them in the Dataenvironment, or I'm wrong in this point? Interactively, I can SELECT without USE the table.
What might I do wrong in the cursor?
Thank you for your time!
Christian Isberner
Software Consultant