General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
The weirdest bug I've seen
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only