hi!

is it possible that i can use input parameter in the sql select statement like this.

simple sql:-
SELECT MAX(INV_NO) FROM INV_MAST.

to
SELECT MAX(@FIELD_NO) FROM @TABLE_NAME

if it is possible then plz let me knw. cuz i cudnt solve this prob. and one thing more abt the SQLEXEC() and CURSOR_ADAPTER technology.
if we can handle each n every opration through the SQLEXEC() then y people use CURSOR_ADAPTER technology? is CURSOR_ADAPTER is more convinient than the SQLEXEC() or SQLEXEC() itself is more convinient ? PLZ give me some detail knwoledge abt these. what is the main difference of these both? which way is the best professional way to handle the end user application?

as u told me, i had used all the select,insert,update,procedures,views anything which can i run in the sql server is working fine so far from the vfp8.0 front end screens. so plz guide me which way to go for better application.cuz i need to make a big big application on HOTEL MANAGEMENT SYSTEM.
thankx n regards.
atif