Newbie 1

[ChicagoDan]

I am working with a Visual Foxpro application. I am VERY new to Visual Foxpro and can't seem to get the command and syntax I need. The application has a command window that will accept any VFP command. I am trying to manipulate the data in one of the free tables used by the application. So far my command looks like:

DELETE FOR SCREEN="PRESORT"
APPEND FROM "c:\Accuzip6 4.0\support\azsettings_new.dbf" FOR SCREEN="PRESORT"

The problem is I am always prompted for a table name in an Open dialog box. How can I open the table azsettings.dbf before I do the delete so that I don't get prompted for the table name.

TIA

 

[craigsboyd]

Use ("c:\Accuzip6 4.0\support\azsettings.dbf&quot in 0 Slighthaze = NULL

 

[ramani]

HI

SELECT 0
USE myTable && use it with full path specified.
** suitably change the name of myTable.
DELETE FOR SCREEN="PRESORT"
APPEND FROM "c:\Accuzip6 4.0\support\azsettings_new.dbf" FOR SCREEN="PRESORT"

Be careful with what Slighthaze wrote above. By mistake he has suggested to open the table from which you are appending. That could delete your wanted records from the source table whereas you want to delete from yet another table which you have not specified in your question.


ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[ramani]

Hi slighthaze..
May be you are right.. since you have left out the '_new' in the table opening. But I am not sure.
ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[craigsboyd]

Yes Ramani, as I understood it Tia wanted to select azsettings.dbf before the delete...if I assumed wrongly I hope Tia has a backup ) Slighthaze = NULL