Greg,

What is an ADD statement? You mean you mean ALTER TABLE? Don't think you can ALTER TABLE a cursor. Instead of cursor, select into a table. You can ALTER it.

Also, as a part of the SELECT statement you can create the new fields. If you do that, there is no need to ALTER the result. This is better than ALTER TABLE, because the table won't have to be rewritten (ALTER TABLE has to rewrite the entire file).


If I'm off-base on what you are trying to do, it would help if you post a sample of your code.

>After creating a cursor, we are immeiately altering the cursor with ADD statements. The creation of he cursor appears to work but the following ADD line to alter the cursor creates the error message ... "c:\docume!1\merlie\locals~1\temp\ca0w000v.tmp does not exits".
>
>Anyone have any suggestions? We are out of ideas!