Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why is my cursor empty?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Why is my cursor empty?
Miscellaneous
Thread ID:
00551388
Message ID:
00551388
Views:
42
Why is my cursor ATTS empty? I had ? attempts.ext, ? attempts.seqno and displayed the values for the ATTEMPTS table so I know I found a record with values to go into the ATTS cursor, but when I do the REPLACEs from the ATTEMPTS table into the ATTS cursor, nothing is saved. When I BROWSE the ATTS cursor it's empty. Do you see what I am doing wrong? Thanks for the help.

Here is my code:
SELECT tube
SET ORDER TO TAG MAST_ID
GO TOP
SEEK SEEKID
IF FOUND()
	SET ORDER TO TAG date
	SCATTER MEMVAR MEMO
	* Find Attempts record that goes with Tube record
	CREATE CURSOR atts;
	(Ext C(3), Seqno N(2), Placed C(18), Route C(10), Ext_Reas C(12))
	SELECT attempts
	SCAN FOR attempts.mast_id = tube.mast_id
		SELECT atts
		REPLACE atts.ext WITH attempts.ext
		REPLACE atts.seqno WITH attempts.seqno
		REPLACE atts.placed WITH attempts.placed
		REPLACE atts.route WITH attempts.route
		REPLACE atts.ext_reas WITH attempts.ext_reas
		? atts.ext
		? atts.seqno
		? atts.placed
		? atts.route
		? atts.ext_reas
		WAIT WINDOW
		SKIP
		SELECT attempts
	ENDSCAN
	SELECT atts
	BROWSE
	SELECT tube
ELSE
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Next
Reply
Map
View

Click here to load this message in the networking platform