Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MAJOR question...
Message
From
25/01/2001 17:31:53
 
 
To
25/01/2001 10:47:46
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00468472
Message ID:
00468839
Views:
10
>VFP 6.0
>
>I have come to the point where I may be confused with how to program with Primary key, multi-users, (maybe) OOP, etc... I have MS VFP 6.0 Programmer's Guide and have read some other books, so I am not interested in buying a new book. If you could help me find it in MS (VFP) online Help article (or in my MS Programmer's Guide book) where I can read about how to best use uniquely the ID's (which I thought the Primary key was supposed to do that, but appearly not). I need to study (and program the coding) how to work with when allowing the user to input the ID, then check if this ID exist (via, if yes-> error message, if no-> enable the rest of the fields). But that's not done yet, I need to somehow "double-check" if another user in multi-network is using the same ID (highly unlikely, but still) so I can program to inform (either or both or whatever) that there is a possibly of duplicating ID. Maybe the only way is to catch this is when one of them saved the record, then the "next/last"
>user will be prompted with the error message?
>
>We did hired a consultant and this person is pretty good, but keeps reading the help files all the time and asks me, "Wow, thats nice, how to do that", stuff like that... Furthermore, I have CodeMine 6.1 framework, it is somewhere behind me (don't have that much of understanding of VFP).
>
>Keep in mind that I am former FPW 2.6 and I do very well with that, so stepping into VFP 6.0 for a while was a challenge, but I don't want to give up. Also, (not your fault <g>) I need to do this in timely manner (I am in the middle of the project right now and I am just like a sitting duck).
>
>Thank you.
>
>Chuck


Look at the article on PKs on my web site. If you have questions after that, I'll be glad to help you.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform