Second best suggestion to date. The one I liked better was to quit trying to use new technology when old tech does the job fine. To wit, I now just do a plain old select -- SQL to get my data, and then use the cursor for the program, instead of making a view. Thanks for giving it some thought, David!
>Todd,
>
>You could use a temp dbc to hold your views.
>
>>I have a program that needs a special view of the remote database. To allow for changes in the remote database structure, I would like to re-create the view every time I run the program. (Maybe not the best way, but its expedient.)
>>
>>Will running CREATE SQL VIEW myview multiple times create a bloat? I remember that INDEX ON ... TAG MYTAG run a bunch of times without deleting the tag first would end up making the CDX file grow. Does the same problem exist with .dbc files?
--Todd Sherman
-Wake Up! Smell the Coffee!