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';
Maybe with : WHERE clicod <> 'IN' and LEFT(clicod,1) <> 'B';
try to work this Code before Load Your Table from foxpro.db
means in preceding load
load * from foxpro.db;
Retrieving data ...