Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Entry Form using vfp7/sql backend
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Data Entry Form using vfp7/sql backend
Miscellaneous
Thread ID:
00594256
Message ID:
00594256
Views:
57
I have a form that is setup like the wizard based form. I have a remote view that is based on a table with 10K records. The view has a filter to the ProcID.

The view code is:
SELECT *;
 FROM coproc Coproc;
 WHERE Coproc.procid = ?gnSelProcID
On the form, I use the txtbtns of the wizbtns.vcx for data navigation. I have the next/prev/top/bottom buttons with visible=.f. Prior to tonight, I did not have a filter on the view, I got all the records (not the right way), and everything worked fine. I could add/edit ok. Now that I have put a filter on the view, the edit button won't enable. The add button is enabled, but the edit button is not. On the find button, I call a form to locate the desired record, it returns the procID. I then set the variable (gnSelProcID) and issue a requery("coProcs"). The form goes display the right record, but the edit button is not enabled.

Any help appricated.

Kirk

p.s. Sorry if this in not in the right forum, I didn't know which one to post it in.
Next
Reply
Map
View

Click here to load this message in the networking platform