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.
 
Back
Top