Category Archives: Foxpro

Different Pack with Zap command in foxpro

Posted on April 6, 2015 by ubsacc2004

Pack – Physically Delete Records Tagged For Deletion Pack <– permanently removes all records tagged for deletion. Zap – Delete All Records From Database  Zap <– permanently removes all records.

Posted in Foxpro | Tagged | Leave a comment

copy structure to – Create A New Database With The Same Structure

Posted on April 6, 2015 by ubsacc2004

copy structure to – Create A New Database With The Same Structure Copy Structure To FileName <– create a database file, called FileName, that contains the same structure/layout as the current database. The new file has 0 records. Copy Structure … Continue reading →

Posted in Foxpro | Tagged , | Leave a comment

Modify Structure – Alter The Database Layout

Posted on April 6, 2015 by ubsacc2004

Modify Structure – Alter The Database Layout Modify Structure<– alter the database layout/structure. The modify structure command returns you to the file/creation program. You will have the opportunity to change the name of the fields, change the field datatypes, change … Continue reading →

Posted in Foxpro | Tagged | Leave a comment

Moving the Read/Write Pointer

Posted on April 6, 2015 by ubsacc2004

Moving the Read/Write Pointer GoTo Top <– move read/write pointer to first record.  Optional go top with ommited “to”. GoTo 1 <– move read/write pointer to first record. GoTo 5 <– move read/write pointer to record 5. GoTo Bottom <– … Continue reading →

Posted in Foxpro | Tagged | Leave a comment

? – Display in console

Posted on April 6, 2015 by ubsacc2004

?– Display In Console ? 3 * 4 <– display the product of 3 * 4 – 12 ? “3” + “4”<– display the concatenation of “3” + “4” – 34 ? 2 ^ 3 + 3 * 2 – … Continue reading →

Posted in Foxpro | Tagged | Leave a comment

use command

Posted on April 6, 2015 by ubsacc2004

Use – Open/Close Database Use FileName <– close any database open in the current work area and opens the specified database. The database must have a .dbf extension. The read/write record pointer is positioned at the first record when file … Continue reading →

Posted in Foxpro | Tagged | Leave a comment

Sample structure

Posted on April 6, 2015 by ubsacc2004

Sample StructureWhat is DBF ? Its stands for database files. In real world project , normally we will create dbc (database container to stores all related dbf files into DBC). Let us assume the Client.dbf for the following illustrations. The … Continue reading →

Posted in Foxpro | Tagged | Leave a comment

For those who dont know what is Visual Foxpro or never learn foxpro before in they life :p

Posted on April 6, 2015 by ubsacc2004

Microsoft Visual FoxPro database development system is a powerful tool for quickly creating high-performance desktop, rich client, distributed client, client/server, and Web database applications.  Yes web database applications. Employ its powerful data engine to manage large volumes of data, (I`m not quite … Continue reading →

Posted in Foxpro | Leave a comment

where to download foxpro runtime libraries?

Posted on October 28, 2010 by ubsacc2004

You can download a separate Runtime-installer from: http://www.foxpert.com/runtime.htm

Posted in Foxpro | Leave a comment

VFP migrate to SQL Server more faster performance

Posted on July 19, 2010 by ubsacc2004

Today i had do a research for VFP vs SQL server 2005. Then i start googling  around to look for informations.  Before that i know that VFP had 2 GB limitations only. And to 11 years foxpro based programmer, my … Continue reading →

Posted in Foxpro | 2 Comments