Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field value error!!
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00162579
Message ID:
00162736
Vues:
23
My datasession is set to default, I'm including a snippet to show what's what(I changed to REPLACE to show where the error occurs.)

USE "&lcAssigneePath" IN 9 ALIAS assignee EXCLUSIVE
SELE 9
ZAP
REINDEX

FOR i = 1 TO ALEN(gacAssignees)
SELECT DISTINCT exp_1, exp_2, mnemonic, s_or_type, ass_sclass, CNT(*) ;
FROM assignee_temp INTO CURSOR temp_1 ;
WHERE exp_2 = gacAssignees[i] ;
GROUP BY mnemonic
SELE temp_1
FOR j = 1 TO ALEN(gacProj_Sel)
SET FILTER TO s_or_type = 'Customer' AND mnemonic = gacProj_Sel[j]
GO TOP
DO WHILE !EOF()
lnCustSum=0
SELE 9
LOCATE FOR ((assignee.ata = temp_1.exp_1) AND (assignee.mnemonic = temp_1.mnemonic))
IF !FOUND()
SELE assignee
GO BOTTOM
APPEND BLANK
&&Error REPLACE assignee.mnemonic WITH temp_1.mnemonic
REPLACE assignee.ata WITH temp_1.exp_1
&&error REPLACE assignee.ass_sclass WITH temp_1.ass_sclass
REPLACE assignee.Cust_Tot WITH temp_1.CNT
REPLACE assignee.Tp_Tot WITH 0

As I said before, this code works in debug mode, but not with the .exe.

Thanx again


>>Hi all,
>>
>>I'm having a minor problem with an INSERT INTO statement. When I run the procedure in the debugger, the statement recognises the cursor name, no problems. When I run the utility stand-alone, I get a variable not found error. Could this happen if I do not execute a SELECT MyCursor statement before the INSERT INTO statement.
>>
>>TIA
>
>You do not need a SELECT MyCursor before doing an INSERT INTO. You may be having a datasession problem. Are you using private datasessions?
Perry E. Chrzanowski
Programmer/Analyst
Saturn (Solutions) Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform