|
| Author |
Message |
Bloo Chocolate
|
| Sat Jul 21, 2007 2:35 pm FOXPRO commands |
|
|
open (name)
USE (path)
modify structure
display structure
clear |
|
|
|
M
|
| Sat Jul 21, 2007 3:00 pm |
|
|
Quote:
Create
Use
Modify Structure
Display Structure
Browse < Open Table
Append < Input Data
Change / Edit
List < Output
Delete < Highlight Field
Pack < Confirmation for remove
Recall < Remove Highlight
Goto
Skip
http://fox.wikis.com/wc.dll?Wiki~VFPBasicDataConcepts~VFP#sorting |
|
|
|
Bloo Chocolate
|
| Tue Jul 24, 2007 2:03 pm |
|
|
Scan looping - perform series of actions or manipulations for each record in a table
For - specifies how many times the section of code needs to be performed
Do-while - execute a section of code as long as a certain condition is met or staisfied |
|
|
|
M
|
| Thu Aug 02, 2007 1:52 pm |
|
|
Search Field
Code: locate for thisform.text1.value = Icode
If found()
thisform.text1.value=Icode
thisform.text2.value=Descri
thisform.text3.value=Price
Else
messagebox("File Not Found","Error")
endif
Confirm Changes
Code: Replace Icode with Thisform.text1.value
Replace Descri with Thisform.text2.value
Replace Price with Thisform.text3.value
|
|
|
|
| |