Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Quick and dirty ADD for dozens of tables
Message
From
06/10/2005 00:12:35
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Quick and dirty ADD for dozens of tables
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01056606
Message ID:
01056606
Views:
54
I have dozens of small and infrequently used tables (remote SQL views) that I need a quick way to develop an ADD form. It does NOT have to be pretty.

I thought of haveing a PRG that is called with file number
Then a Case statement to open correct table.

I hoped I could use only one generic ADD Form.
Open the database before I call the form.
Append blank at form load
Use EDIT command to show fields (this is a new record and not yet updated)
Put two command button at bottom Save & Cancel
Save has a tableupdate(), Cancel has Tablerevert()
Then thisform.release

YES, this is crude but quick to build.

Question: on EDIT command, can I put it on a Form and can I limit user to editing just that one record?
Next
Reply
Map
View

Click here to load this message in the networking platform