How can I feed results in one query into a pass through query

[crispy02]

I need some help and hopefully someone can help me. I have a select query that I have created and it gives me back call statements to be hopefully used in a pass through query. My problem is I do not know how to make this happen. I will need to run the pass through query for each call statement. There could be as many as 300 call statements or as little as 1 call statement.

empty (Name of the field)
call P_PATROLINSP_FLDLIST(-1229999914,-9998452);
call P_PATROLINSP_FLDLIST(-1229999915,-9998453);
call P_PATROLINSP_FLDLIST(-1229999916,-9998442);
call P_PATROLINSP_FLDLIST(-1229999917,-9998332);
call P_PATROLINSP_FLDLIST(-1229999918,-9998439);


Thanks,
Chris

 

[Liv Manto]

You want to pass these data

(-1229999914,-9998452)

to a query?

and they are in a table?

 

[crispy02]

What I am trying to do is call a stored procedure on Sybase Central using the call statements and (-1229999914,-9998452); are the 2 parameters that are needed to run the stored procedure which is why I am using the pass through query. So, can I still use any of your options below?

I am sorry that I did not explain myself better the first time.

Chris

 

[pbaldy]

I use code from the Access Developer's Handbook, if you have access to that. It's a function called PassThroughFixUp, I believe. I use it for SQL Server pass through queries, but I assume it can also be used for Sybase. I don't have the book here at home.

 

[crispy02]

I have the book that you mentioned(Access 2000 Developer's handbook Volume 1 and 2) but I cannot seem to find the function that you have mentioned., If you have an example of the function that you would not mind sharing it would be greatly appreciated.

Chris

 

[pbaldy]

My apologies; I've learned so much from that book (ADH) I assumed the code came from there. It actually came from another book I've found very valuable, "Microsoft Access Developer's Guide to SQL Server", by Chipman & Baron. I'll track down the code.