Using Pass-Throw query

  • Thread starter Thread starter Oded Kovach
  • Start date Start date
O

Oded Kovach

Hello there

I have pass_throw query that display data

Now i need to store the data on temp table and display it afterword

I've tried to place on the pass_throw query 3 sentences:
1.deleting the data from the temp table
2. inserting the needed data to the temp table
3. show the data on the temp table

It gave me an error that it didn't return any records

Can someone help me to know how can i do this?
 
Hi Oded,

Which database are you trying to store the temp info in? If you are storing
it in Access, you'll have to use Access queries to delete and append the
local data (because the remote database processes pass thru queries and it
doesn't see your Access database). The append query can use a pass thru
select query as the data source, but it needs to be an Access query.

If all of the data is being read, deleted and appended on the remote
database, you'll need to post the SQL and the database type (since pass thru
queries need to be in the SQL syntax of the remote database) for anyone to
really be able to give you any specific help. Of course you would also need
permissions that allow you to make those changes in the remote database.

HTH, Ted Allen
 
Back
Top