|
Posted by Tech Bob on July 14, 2008, 11:12 pm
Please log in for more thread options Hello YidMo,
That makes sense due to the fact that using the same store ID which I take
is the AutoID was the reason why we had users, and other internal information
that the AutoID was the same.
So I take it we should just use 4 being that there are still stores 1, and 3
are up and running.
Thank you,
--
Bob McQuay
ADI Business Solutions
Network Technician
"YidMo" wrote:
> Hey there Bob ;)
>
> I'll give you both the long and the short versions;
>
> Short: "Not really."
>
> Long: This has to do with a few things, but namely the primary AutoID of the
> Store table in HQ. Like any ID field, it can not have duplicates, nor can
> you delete it and make a "new" 2, as the ID counter can only hit the number 2
> once while the table constraint exists (this is NOT where you go find out how
> to remove the constraint, that is a BAD BAD BAD IDEA).
>
> Remember that RMS is a SQL client, albeit a fancy one, and it's bound to the
> laws and constraints of SQL. If you want to "replace" store "number 2", the
> only real option is to use the "existing/old" number 2 and wipe out all the
> associated information from the previous store and fill-in the store info for
> that number with the "new" information. I'd advise against this for only one
> specific reason; that you're not going to have an easy time wiping all the
> information unless you do it one table a time, as there's LOADS of stuff in
> the HQ database that you can't see from the HQ front-end. In all honesty,
> it'd be easier to just deal with having the new location as "store 4".
>
> YidMo
>
>
> "Tech Bob" wrote:
>
> > Can a store be deleted. We are trying to add a new store to HQ and there was
> > at one time three stores. The second store went out of business and was
> > deleted in HQ. Now when we went to add a store to HQ we chose the store ID
to
> > be 2. After doing all that and then placing it on a new POS terminal it has
> > all of the second stores information on it. So my question is.... when you
> > delete a store does it really delete it or does the information stay
somwhere
> > in HQ?
> > --
> > Bob McQuay
> > ADI Business Solutions
> > Network Technician
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap