|
Posted by YidMo on July 14, 2008, 7:20 pm
Please log in for more thread options When worksheets process, they're not actually linked across the two (store
and HQ) databases, info is passed through temp tables, so the answer is: no.
On the other hand, there's other options like back-end SQL server linking
that could easily accomplish what you're looking to do from what I gather.
If you were to set-up the HQ database as a linked db at each location with
the same name, then you could use a 51 to pass a query down and run on each
location's db which would grab from HQ. This would NOT work if there's
firewalls or other barriers that would stand in the way of a SQL linked
server connection. If you'd like more information/help, please feel free to
contact me ;)
YidMo
"T Parks" wrote:
> thanks for the reply. The problem is it's a custom table at HQ that we want
> to sync up with a version at each store. Hence the problem in trying to
> reference the HQ database in the sql statement
>
> thanks
> T.
>
> "convoluted" wrote:
>
> > DO NOT USE worksheet 51 to copy data from hq to stores....use the
appropriate
> > worksheet to download hq data to the stores - there is one worksheet for a
> > specific area to update (ie 250 for item updates, 204 for departments and
> > categories, 209 for reason codes, etc) - worksheet 51 should only be used by
> > experienced technicians well versed in SQL when the store changes required
> > cannot be implemented via a standard worksheet - but out of the box, there
is
> > a worksheet for whatever entry you've done in the hq db - if you're unsure
> > about which worksheet to use, consult the help guide (there is a worksheet
> > summary that explains what different worksheets do) - I would also strongly
> > recommend you hire an experienced rms partner fora day or two of training -
> > especially if headquarters is involved - hope this helps.....
> >
> > "T Parks" wrote:
> >
> > > We would like to use worksheet 51 to copy data from the HQ database to
each
> > > store database. Is there a syntax in the SQL to reference the HQ database?
> > >
> > > It appears to can only make isolated edit/delete/updates on each store d/b
> > > independently
> > >
> > > thanks
> > > T.
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap