Hi,

I have a problem with the following query.

When I have more then 4000 products its seam to take more then 3 hour and somtimes it get stack with this error :

java.sql.SQLException: [QODBC] Column not found: NAME

 The query:

select ItemInventory.Name,ItemInventory.listid,QuantityOnHand,{fn IFNULL(CustomFieldon_hand_backup,'0')} CustomFieldon_hand_backupDec from ItemInventory where IsActive=1
 and ({fn Convert({fn IFNULL(QuantityOnHand,0.00)},SQL_INTEGER)}<>{fn Convert({fn IFNULL(CustomFieldon_hand_backup,'0')},SQL_INTEGER)} )

Please adise

Amir