Environment versions
Network:
Windows 2000 Server
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only