Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid Subscript Reference Error
Message
 
 
To
25/02/2005 16:53:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP3
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00990628
Message ID:
00990770
Views:
32
>No, it do a evaluation at the current record,
>and if you are in EOF() the pol.fr_type is 0.
>

It's incorrect. See my other messages in this thread for explanation how it works. Below is the code that confirms it.
CLEAR
CLEAR

CREATE CURSOR joindata (fr i)
INSERT INTO joinData VALUES (2)

CREATE CURSOR table1 (f2 i)
INSERT INTO table1 VALUES (1)
INSERT INTO table1 VALUES (2)
INSERT INTO table1 VALUES (3)
INSERT INTO table1 VALUES (4)
GOTO 1 
DELETE

GOTO 3
? "f2", f2
?
? "One table"
SELECT *, tudf(f2) ;
	FROM table1 ;
	INTO CURSOR crsOne

?	
? "Two tables"
SELECT *, tudf(f2) ;
	FROM table1 ;
	JOIN joinData ON fr = f2 ;
	INTO CURSOR crsOne
	
FUNCTION tudf
LPARAMETERS tvParam
? PROGRAM(), tvParam
RETURN tvParam
With one table VFP uses the first record ( deleted ). With two records it uses blank record.
<snip>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform