>I am creating a in house utitity that will allow a field comparison of two selected tables or Queries. The problem I am running into is when an ALIAS is selected for use in the Query and you save and modify in the Query Designer. If you look into the SQL view and it has the name of the original table name plus the ALIAS name. When you run the QPR it looks for the original table. For me that's a big problem and since SQL view is read only I am unable to modified it. Does anyone know of a way around it. Thanks in advance
>
>Example :
>SELECT *;
> FROM somast01 A_tmpnew;
> ORDER BY A_tmpnew.sono;
> INTO TABLE test1.dbf
Use the designer to get your first cut of code. Click the SQL button to view the generated SQL. You can drag your mouse over the code to copy it. Then paste the code into a PRG. THere you can tweek it to your heart's content.
Mark McCasland
Midlothian, TX USA