Jump to content
Sign in to follow this  
john.daly

Finding in Multiple Databases

Recommended Posts

Write a script to perform a find in Database A with error capture on. If Status[CurrentError] = 401 (no records found) after performing the find then run an external script in Database B and repeat the process if no records are found in B.

Share this post


Link to post
Share on other sites

I have three databases:

A) holds current projects

: holds completed projects

C) The other uses information about the projects.

All projects have unique ID's.

Is there a way that I can make a search request that will (by ID) that will look first in A, and if not found there, will look in B and return the results???

All three are related - I can get the results I need back as long as I only search in one of the databases.

Thanks,

Shane

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.