Thanks a lot...
I'll try it..
The val() function belongs to VFP, fortunately, you can use several VFP commands in SQL structures, for example Between() and val(), those are the most i use..


>Jonathan, try this. I never works with Btrieve, but hope that will work
>
>

>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...
>
>sql_command = "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"
>
>sqlexec(gnConnHandle,sql_command, "SC0100_Stck_Transact")
>

>Other question did the BTrieve has the function VAL()?