SELECT SUM(factures.MONTTC) ; FROM

[ahmed1973]

SELECT SUM(factures.MONTTC) ;
FROM GEST_JUR!factures ;
WHERE FACTURES.NUMAB=this.Parent.text1.Value AND factures.paiement="T" ;
INTO TABLE GEST_JUR!factempGLOB
this.Parent.text8.Value=FACTEMPGLOB.SUM_monttc
I received an error message "Alias 'FACTEMPGLOB' is not found".
How do I resolve this error PLease!

 

[EzLogic]

Is the table FactEmpGlob open?

if not, you need to open it

if not used("FactEmpGlob")
use FactEmpGlob in 0
endif

make sure you specify the path to the table if it is not in the correct/default diretory/folder.

example: use c:\MyApp\MyData\FactEmpGlob.dbf in 0


Ali Koumaiha
TeknoSoft Inc.
Michigan

 

[Mike Lewis]

I think you might have the syntax slightly wrong. Instead of this:

....
INTO TABLE GEST_JUR!factempGLOB
....

try this:

....
INTO TABLE factempGLOB DATABASE GEST_JUR
....

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Olaf Doschke]

I'd recommend to switch to cursors. That means instead of INTO TABLE you select INTO CURSOR.

It's not a good thing to add tables to a DBC, when working with muliutple users, at least. Indeed that can lead to errors, especially when you always overwrite. Unless the DBC is local, a DBC is not the place to store temp data.

Also Instead of relying on the autonaming of the SUM() expression to end in the field name SUM_monttc, specify the name directly in the SQL:

SELECT SUM(factures.MONTTC) as MontccTotal;
FROM ...

You gain more control and have more freedom in naming the fields.

Bye, Olaf.

 

[Mike Lewis]

I just realised that the error message might have come up on the second line (this.Parent.text8.Value=FACTEMPGLOB.SUM_monttc) rather than the SELECT.

If that's so, then Ali's advice is good. Or, you could change it to this:

this.Parent.text8.Value=GEST_JUR!FACTEMPGLOB.SUM_monttc

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy