Looking for someone to do the following task
Only condition is I need it done ASAP.
I am too busy now and this needs to be done ASAP therefore am looking to
hire someone for this task only.
Please provide a time and cost estimate.

Thanks
Matt
kink_jp AT hotmail

Biz logic
---------
I have a table called customer which has a unique index on name, address,
ph1.
Which stops the user from inserting the same customer more than once.

However sometimes the same customer will visit different locations and that
customers details will be inserted into both remotes. 2 different remotes
insert the same
customer information (name, address, phone) but they have unique
customer #s. The unique customer number is due to the use of global
autoincrementation.

The problem about stopping this is that each customer_number is associated
with a sale_number. So if the dual customer is not inserted then the sale
becomes useless for reporting in the consolidated...Sales
Table(customer_number[fk])..
--------------

Task
-------------------
That means you would have to do the following in your MobiLink scripts:
1. For the parent and all child tables upload your changes into
[GLOBAL] TEMPORARY tables.

2. In the end_upload event, call a stored procedure.
The stored procedure goes through EACH row uploaded (in the parent
temporary table) and checks to see if the same unique index (with a
different primary key) is already in use in the consolidated
database.

If it is, then for all the remaining CHILD tables, replace their
parent PK with the one you just found.

Then you must DELETE these rows from the REMOTE. This means you
must store the PK of the conflicting row in some table that you
would reference in your download_delete_cursor for the PARENT table.

You do NOT have to write download_delete_cursor's for the CHILD
tables since dbmlsync will automatically delete those rows when the
parent gets deleted, regardless of whether you use ON DELETE CASCADE
in your FK definitions.

Delete all rows from these temporary tables.

--------------------------