Need some suggestion

Need some suggestion

Post by GTi » Sun, 20 Oct 2002 21:37:00

I have a Btrieve app. running on one location.
Every database files have one unique DWORD index.
To day I use autoincrement on this field.

Now I want two separate locations to have the same
app. and the databases will be synchronized (merged).

Using autoincrement on the index will cause duplicates
when merged.

So i have two solutions:

The index field have a max value of:
4294967295 (DWORD)

So if I separate each location and give them unique values
from 1 to 428.
So location one have a range from
001 0000001 to 001 9999999
location two:
002 0000001 to 002 9999999
...and so on.

But how can I store the unique numbers ( 0000001 to 9999999 )
I can use get less or equal of 0019999999 and then get highest
number used on location one. But this will take one extra request
on the database.

Is there any other good solutions ?

I must use DWORD as the index.


1. Need a suggestion..

Hello every body,

I need to build an application that takes responses from people accross
different locations and then intelligently understands and decides as what
should be done as a next step. Can someone suggest me a starting point?

Any  help and suggestion will be appreciated.

Thanks in advance.

2. Linking to SQL db not working correctly

3. Need a Suggestion

4. how to create toolbar like ie40 browser

5. Need Help....Suggestions on Updating a text field

6. Repeating fields question

7. Need Replication suggestion for online store db.

8. 7.3.3. no longer available.

9. Need some suggestions at best practices asap please...

10. Need some suggestions in Datawarehouse

11. #Temp tables scope....Need practical suggestions, not bookish

12. Replication need some suggestions!!!

13. Need a suggestion