Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MikeyLuken

    Mercator fails when no data found

    Ok, Thanks for the assistance on all of this. I really appreciate the help. Thanks, Mike
  2. MikeyLuken

    Mercator fails when no data found

    BocaBurger, Thanks again for your reply, the -bd option seems to have resolved the problem. Quick Question: How does Mercator constitute good and bad data? I've sent some e-mails trying to locate that guide. Thanks, Mike
  3. MikeyLuken

    Mercator fails when no data found

    Also, I just noticed that I don't currently have insert privleges which is obviously an issue itself. I'm trying to resolve that now. Would that cause the error. Obviously that would cause an error, but if there are no results should it just ignore the insert/update? Thanks, Mike
  4. MikeyLuken

    Mercator fails when no data found

    janhes, BocaBurger Thank you for your replies. It's failing in the output section, I wanted to skip the output(insert/update) if there was no data found. Thanks to janhes I can force the FAIL() to abort the map with the code: =IF(PRESENT(ATTRIBUTE_ID Column:Row:C_FROM_EXTENDED_ATTRIBS)...
  5. MikeyLuken

    Mercator fails when no data found

    Hi, I'm having an issue that I can't seem to resolve. I'm pretty new to Mercator so any assistance would be appreciated. I'm using Mercator 6.7. What I need to do is pull all data from 7 tables based on a last updated date field, and insert/update the data into 7 exact tables on another...

Part and Inventory Search

Back
Top