Hi!
Some more reasons.
1. Is that fields spelled correctly? Is it in that table?
2. Are all characters in the name correct? I know russians have a problem with characters that look similar but really represent different character codes cause such weird errors. For example, 'e' might have 2 different character codes in russian codepage. When you occasionally switch to another codepage and type such character, it is hard than to distinguish which character used - English or russian. Try to retype field name completely.
3. If that field is memo field, check if memo file is not corrupted.
4. As Ko said, look for #DEFINE constants in your code. If you have somewhere #DEFINE Dir_emp
- this is really one of the reson of your problem. To check if it defined as a constant, try to use "? Dir_emp" code line before your SQL Select statement and see what value will be printed on the active form when this command executed.
>They are 28 fields:
>
>SELECT nrh10300.Numemp, nrh10300.Area, nrh10300.Cate, nrh10300.Sdo_dia, nrh10300.Sec, nrh10300.Subsec, ;
>nrh10300.Dir, nrh10300.Empresa, nrh10300.Cta_gasto, nrh10300.Depto, nrh10300.Programa, nrh10300.Consec, ;
>nrh10300.Tnoemp, nrh10300.Desup, nrh10200.Nomemp, nrh10200.Rfc, nrh10200.Alta_nom, nrh10200.Alta_gob, ;
>nrh10200.Fec_baja, nrh10200.Cla_sin, nrh10200.Quin_dia, nrh10200.Num_quin, nrh10200.N_imss, nrh10200.Fonacot, ;
>nrh10200.Curp, nrh10200.Tarchc, nrh14000.Col_emp, nrh14000.Telefono, nrh14000.Dir_emp ;
>
>Not much eh?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.