Craig,
it's not too clear what you are really asking here. When you say "different procedures" are you talking about VFP functions/procedures or stored procedures in SQL? Can you show a short code fragment of what you are doing? It would help us help you.
>I'm accessing SQL table via pass through and remote views, but calling different procedures in the same program. I do have different variable names for each procedure.
>
>I will be accessing the same files/view but each procedure may point to a different SQL table record/row. Which may happen at the same time, or at least at the start of the procedure(s).
>
>Question:
>Is there and easy way in using SQL other than get and loading up a variable with the record pointer for each particular procedure? Also, there is no user interface with this procedures.