Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursors question
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00749807
Message ID:
00749819
Views:
24
This message has been marked as a message which has helped to the initial question of the thread.
I think you mean something like this:
*table1 contents
*ID  LASTNAME
* 1  Smith
* 2  Jones
* 3  Canright
*table2 contents
*ID  FIRSTNAME
* 1  Harry
* 2  Jane
* 3  Scott
* 3  Becky

USE table1 && parent table has fields: id, lastname. main tag is id
set order to tag id
sele 2
USE table2  && child table has fields:  id, firstname.  main tag is id
set order to tag id
sele table1
set RELATION TO ID INTO table2
GO TOP
SCAN
	SELE table1
	scatter MEMVAR MEMO TO mainarray
	DISPLAY MEMORY LIKE main*
	SELE table2
	SCAN WHILE table2.id=table1.id
		scatter MEMVAR MEMO TO childarray
		DISPLAY MEMORY LIKE child*
	ENDSCAN
ENDSCAN
>Can you use two cursors at the same time?
>
>Scan
> Scan
>
> EndScan
>
>EndScan
>
>Also, how could I scan through a cursor and place its contents into an array?
>
>Thx!
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Reply
Map
View

Click here to load this message in the networking platform