Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The weirdest bug I've seen
Message
From
23/01/2001 09:54:24
Héctor Lizarraga
Gobierno Del Edo de Querétaro
Querétaro, Mexico
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
The weirdest bug I've seen
Miscellaneous
Thread ID:
00467263
Message ID:
00467263
Views:
52
I have a simple query

SELECT some fields, ... nrh14000.Dir_emp ; <<--- This field is the problem
FROM nrh10300, nrh10200, nrh14000 ;
INTO TABLE outrh\Maemp ;
WHERE nrh10200.Numemp = nrh10300.Numemp ;
AND nrh14000.Numemp = nrh10300.Numemp ;
AND (nrh10300.Numemp <> 0 ;
AND nrh10200.Tarchc = 'S' ;
AND nrh10300.Tnoemp <> 'J' ;
AND nrh10300.Tnoemp <> 'P' ;
AND nrh10300.Tnoemp <> 'B' ;
AND nrh10300.Numemp IN (SELECT nrh34100.Numemp FROM nrh34100 WHERE nrh34100.Checador <> 0)) ;
AND &cDepSec ;
ORDER BY nrh10300.Numemp

When i exec the app it stops in the query with a 'Syntax Error' popup. If I remove that field (nrh14000.Dir_emp) from the query this runs OK. Why? I have anothers fields with the '_' char. I've recompiled, rewrited, reetc the app's method. I've already tried with an alias for that field, but nothing ...
What could be wrong? This thing it's driving me crazy.

thanks in advance
Héctor L.
Next
Reply
Map
View

Click here to load this message in the networking platform