hi,
thank you for reply,and code

this is good idea,i'll keep it ,

have a nice time.

>Hi,
>Would it be better to use a temporary cursor, they clean themselves up when you exit the program.
>
>Here is an example from VFP Help
>
>

>CLOSE DATABASES
>CLEAR
>CREATE CURSOR employee ;
> (EmpID N(5), Name Character(20), Address C(30), City C(30), ;
>  PostalCode C(10), OfficeNo C(8) NULL, Specialty Memo)
>DISPLAY STRUCTURE
>WAIT WINDOW "Press a key to add a record."
>
>INSERT INTO employee (EmpId, Name, Address, City, PostalCode, ;
>   OfficeNo, Specialty);
>   VALUES (1002, "Dr. Bonnie Doren", "University of Oregon", "Eugene", ;
>   "98403", "", "Secondary Special Education")
>BROWSE
>
>* At this point you can copy this record to a permanent table.
>CLOSE ALL   && Once the cursor closes, all data is flushed from memory.
>CLEAR
>

>
>
>>hi,
>>thank you for reply,it works
>>
>>i try to get data from my table AFM, via select somthing put all records at
>>table am2,select again from afm put all records at am3,
>>every time i run my form ,becuse i get this data form outside my dirctory
>>
>>for that i need to delete the 3 tables afm,am2 and am3 every time.
>>
>>thanks
>>
>>>>hi all,
>>>>
>>>>any idea ,help
>>>>
>>>>i need to drop 2 tables am2,am3 from my database(mydbc1),
>>>>every time i run my form.
>>>>

>>>>drop e:\depstudy\mydbc1\am2
>>>>drop e:\depstudy\mydbc1\am3
>>>>

>>>>
>>>>thanks
>>>
>>>

>>>OPEN DATABASE e:\depstudy\mydbc1\mydbc1
>>>if indbc('am2','Table')
>>>  DROP TABLE am2
>>>endif
>>>if indbc('am3','Table')
>>>  DROP TABLE am3
>>>endif
>>>

If you would drop them every time you run a form why are you adding them to a database in the first place.
>>>Cetin