Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid Subscript Reference Error
Message
 
 
À
25/02/2005 16:53:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 6 SP3
Database:
Visual FoxPro
Divers
Thread ID:
00990628
Message ID:
00990770
Vues:
31
>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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform