Thread: order by in c code??

I am writing an ap in c,  everything works fine
except the order by portion of my query.

I am generating my query like this:

sprintf(querystr, "select * from %s order by %s", table,  field);


however,  the returned query is not sorted,  it comes out as
the order the data is stored in the table.

Any ideas????

Thanks.

ken

kvp@ocol.com