RE: SQL Problem

Is something like this valid?
stmt='Select cmpny, cmpnam, cmpost ' +
'from rco ' +
'where cmpny between :lowCmpny and :highCmpny ' +
'and cmpnam between :lowCmpnam and :highCmpnam ' +
'and cmpost between :lowCmpost and :highCmpost ' +
'order by ?';
exec sql prepare sqlstmt from :stmt;
exec sql declare c1 cursor for sqlstmt;
exec sql open c1 using :SortOrder;

Not sure if you can do that SortOrder stuff. Trying that but I have to
rush off to a meeting.


Rob Berendt