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:50:42
 
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:
01184754
Views:
14
>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?
>Thanks in advance
>Raymond

I would build a cursor on fly:
Create Cursor mycursor (recordtype C(1))
FOR nLoop=1 TO 5
	cFieldname='field'+STR(nLoop,1)
	ALTER Table mycursor ADD COLUMN &cFieldname. C(10)
ENDFOR
INSERT INTO mycursor (recordtype,field1,field2,field3,field4,field5) ;
	values('D','Mon','Tue','Wed','Thu','Fri')	&& day of weeks record
INSERT INTO mycursor (recordtype) values('H')	&& hours record
INSERT INTO mycursor (recordtype) values('T')	&& tasks record
*** fill other fields in 'H','T' records by searching in a table
and use it as grid.resordsource
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform