>>Are you having to update these tables or just viewing them?
>>If just view then change your query to output to a cursor instead of a table. >Then when you rerun the query it will automaticly over write the old cursor. >Nothing to delete.
>
>I've never used cursors. How do you read the info stored in them?
>
>Steph.
You use them just like a table.
Example:
Select * from yourdata order by yourfield into cursor mycursor
Now you can scan,skip locate. Unless you change the field names they will be the same as the parent table. You CANNOT update a cursor like this. You can only view it.
HTH Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com