Check out this message and the links in it for more information.
Title: Re: VFP / Macro substitution / SQL Equivalent
Message #
1029652 >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