Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bound vs Unbound Data
Message
From
31/12/2001 09:31:14
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00599203
Message ID:
00599346
Views:
23
>I recently purchased the book Special Edition Using VFP6 and there is a topic about using Bound vs unbound data. Similar to VB where you can use a data control to bind the data to a table I understand I can bind a text box on a form to do the same thing, As a textbox is is tyoed in the data in the correpsonding field is updated or added. But what if you need to do some conditonal processing before adding the new record? Can you use SQL to add the record? Wont I have more control of the data If I dont have the textbox tied directly to a field? I know the preferred way is to use the control source but I would like to to try adding it a different way.

You can use buffering. Even if the data is "bound", you don't issue TableUpdate() until you do the additional processing.

Some relevant commands you should check in the manual (if you don't happen to know them, already):
CursorSetProp()
GetNextModified()
GetFldState()
TableUpdate()
TableRevert()
>
>
>Basic Data Entry screen
>
>Last Name
>First Name
>Address
>
>once info is entered how do I add it to a single table or multiple table in a multi-user environment?

If you use buffering, before issuing TableUpdate(), the data is not saved to table. In fact, it doesn't even have its definitive recno() (the records get negative recnos instead).

HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform