Where clause issue

[Anonymous]

Initially when i was loading from QVD, these where clauses work sucesssfully, but now the script hangs when i load from the foxpro .db

WHERE LEFT(clicod,1) = 'B';

WHERE NOT clicod = 'IN' and NOT LEFT(clicod,1) = 'B';

[#2 · Accepted solution]

Maybe with : WHERE clicod <> 'IN' and LEFT(clicod,1) <> 'B';

[er_mohit]

try to work this Code before Load Your Table from foxpro.db

means in preceding load

like

load A,

B

where B=10;

load * from foxpro.db;