Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Display several records vertically on a form
Message
From
11/01/2007 14:48:02
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01184742
Message ID:
01184750
Views:
17
>I need to do a pajavascript:MessageSubmit()
>[Save this message so it will appear for other members immediately] rent-child form as follows:
>The top part displays the employee data.
>The bottom part the dayly pertinent information.
>
>What I need to do is place the following on the child part of the form:
>
>Monday Tuesday Wednesday Thursday Friday
> hours hours hours hours hours
> task task task task task
>
>but each day is one record in a table. (This looks like a grid but placed vertically instead of horizontally)
>
>Is it possible to do this? And how do you upgrade esch record?

Of course it's possible, this is Fox :). I figure there'd be at least two more possible solutions.

Here's what I'd do: I'd create a container class with three textboxes (or maybe a label, textbox and a combo), one for day of week, one for hours, one for task. Then I'd line up five such containers horizontally. Each container would be bound to a given record. Container class would have its own .save method so it'd know to go to its record where it needs to save its data, and would have a .oRec property which would be filled by Scatter Memvar Name for that record. The controls' controlsource would be "this.parent.oRec.DOW", "this.parent.oRec.Hours" and "this.parent.oRec.task".

There'd have to be some extra logic for handling five records at the same time - I'd just have a cursor with those records, which would be filled when loading the records. Form.save would first call each container's .save (which would update this cursor) and then it would save from cursor into the underlying table(s).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform