>>I have a program that is not been transfered to OOP yet. It generates commission amounts and then prints out too much paper. No data interaction, just give a date and print.
>>
>>
>>So a mega union view that joins our ar history file with a current ar transaction file works fine in a VFP command session or running the program from the command line. But compile the app to an EXE and it's a no go.
>>
>>Error message is : File does not exist.
>>
>>Line of code is the use lv_invoice_details
>>
>
> Are you sure the database is open first?


Yes there are quite a few views that have all fired prior to this one. Ed wonderded about using a cursor instead? I think that I am converting data that is not updated in the view for use later. Actually there is a lot of that to fit the commission rules du-joir.

It is a wild thing ?

__Stephen Russell