Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stepping through field names myfield1, myfield2, myfield
Message
From
01/03/2000 10:43:16
 
 
To
01/03/2000 10:30:17
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00339788
Message ID:
00339808
Views:
18
>I have a db table that has a series of fields like this....
>
>myfile.butn1
>myfile.cap1
>myfile.butn2
>myfile.cap2
>myfile.butn3
>myfile.cap3
>...
>

This is a bad design, split the table into two:

myfile.rowid
myfile.applystowholeset1
myfile.applystowholeset2
...
myfile.applystowholesetN

mybutn.rowid
mybutn.butn
mybutn.cap

Now it is simply to loop through the buttons and you do not have to change the table structure if you change the max number of buttons. Additionally, you will not be allocating space for buttons that are empty.
Previous
Reply
Map
View

Click here to load this message in the networking platform