Pass through Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I assumed responsibility for an existing database linked by ODBC to an SQL
Server database. There is a Pass-Through-Query which refers to two people
identified by a4r6 and UME1..
Could you please just help me understand what it's doing, the previous owner
is no longer with the company.

update [bcbsfl\a4r6].qms_tblReviewers set LastExit = '3/2/2006 3:29:15 PM'
where RACF = 'UME1';

Thanks
Dan
 
Apparently you have a table named qms_tblReviewers in a sql database named
bcbxfl\a4r6 with a date field named LastExit. This SQL updates the value in
that field to '3/2/2006 3:29:15 PM' where the value of the RACF field is
equal to 'UME1'.

I expect there is code somewhere that modifies the SQL property of your
saved pass-through query.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass-Through Query Error 1
Pass Through Query - not returning rows 1
Question on Pass-through Query 4
undefined name in pass-through query 1
Access Pass-through Query to SQL Server 6
pass through query 1
Pass-Through Query / Multiple ODBC Connections 1
Pass through query and variables 2

Back
Top