Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Visual Foxpro equivalent of Ditto!
Message
From
03/01/2001 23:29:16
 
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00459224
Message ID:
00459227
Views:
21
>I have a database that has a lot of repetitive data in fields, though nothing that could be set as a default. I am thinking about adding some features to enhance data entry. Is there anyway to have a keystroke that repeats the value from the last record's field value?

You can take a look at SET CARRY. It's a feature I've never had a use for, but it's there :-). The 3.0 Hacker's Guide is not keen on it.

With VFP there is more flexibility in tackling this. For example, in a record's SAVE method you could SCATTER NAME the record just saved to an object, and store a reference to it in a form property. In a textbox Keypress event, you could trap a specific key and call up the appropriate Thisform.oLastSavedRecord.Field value.

If you find you're doing this a lot, your database design may need to be reconsidered - store the repeated information in a parent table, and the non-repeating portion in a child table via a one-to-many relationship.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform