what is pass-through query?? is it like a store proc?? 2

[qajussi]

what is pass-through query??
is it like a store proc??

 

[fredericofonseca]

It is a basic rule that before posting a question to anyone you first do some investigation. On this case

http://www.microsoft.com

would have you required information and so would the F1 key.


No it is not like a stored procedure.

Your F1 key will give you more information as will

http://msdn.microsoft.com/library/d...ommandsMSAccessSqlDatabasePassthroughQueS.asp

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[qajussi]

frederico!!

I am sorry if I sounded like asking it without checking with google.

I did but because I am still a little fuzzy about it so I came here and asked.

I read it as the path through SQL is sql statement which runs on the sql server.
That is the most answer I got.

ANyway, thanks for your help.

 

[BNPMike]

With Access, if you wish to access data from another database, it typically translates your Access SQL into ODBC which is passed to the target database which in turn will re-translate it into its own SQL. A pass-through is where you write the query in the target database's SQL and Access passes that string to the target to run directly. The advantages or disadvantages of this will depend on the circumstances.

A stored procedure is typically a set of instructions which is more complex than a simple SQL statement. Where Jet is concerned this can be managed via the ODBC route. They are not really core to Jet. You have to manage them via code which is really missing the whole point of Access. My feeling is if you're into stored procedures within Jet then you should be looking at an alternative database management system.

 

[qajussi]

Thank you so much BNPMike for your explanation.
Now it is very clear to me.
I appreciate very much for your time.

 

[jsteph]

gajussi,
To expand on BNPMikes answer, you can call any SQL DML or DDL statment from a Pass-thru, including stored procedures, Create/Alter table, etc. Nearly anything legal on the backend's command-line is acceptable via pass-thru; you can pass parameters but you can't return them.

Also, most newer ODBC drivers will translate simple JET queries--those created in Design View in the query grid with Linked Tables---into sort of 'virtual Passthru', that is, they will execute on the server--even semi complex joins. However, you'll break this rule and revert to JET processing if you use Access/vba functions or joins to local tables.
--Jim

 

[qajussi]

Thank you so much forthe additional info, Jim.
I picked up another pointer about the PT that it doesn't return recordsets.
Thanks again.

Philip