>>>
>>>Just as a .02 worth for others tracking this thread, I don't use any SET RELATIONS either. I do the same as you here with parameterized views throughout.
>>>
>>>Steve
>>
>>
>>Steve,
>>
>>Do not know whether this is related or not but do you not find it akward to have to rely on the DBC when you want to change a view. Would that not be easier is every thing would be contained in the source prg, you would call it your client, and I call it the DE, but what is in a name :).
>>
>>Marc.
>
>I don't use the view designer at all. All of my view definitions are in a prg which I can update and run whenever I need to. I don't find that awkward in that the views I do put in the DBC are relatively fixed in nature. Sure, they might change, but not significantly. But I also have views that are really just cursors (not created using the CREATE command and not stored in the DBC), that have their code stored in "Client" or wherever needed.
>
>Steve
Steve,
How are they created then, excuse me for my ignorance. And is there a way to create your on (updateable) fields on the fly with a view. Excuse my ignorance again. And can you recompile your project while other are using the database in production? Well if you can, I might drop my reservations ... :)
Thanks,
Marc
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.