Hi. I'm accessing a Btrieve database via ODBC, i need to run a sql command for selecting a group of records.. Do i have to select all the table's records and then run my query? This is the only way it seems to work...

sqlexec(gnConnHandle,"select * from SC0100_Stck_Transact" , "SC0100_Stck_Transact")

select Stock_Code, Warehouse_Number, Orig__Batch_ID, sum(val(Qty)) as howmany from SC0100_Stck_Transact WHERE Stock_Code='16081LQA106' group by Stock_Code, Warehouse_Number, Orig__Batch_ID order by Stock_Code, Warehouse_Number, Orig__Batch_ID

Thanks a lot in advance.