| Fantom 2006-04-07, 3:43 am |
| > F> For example i have 2 remote database. i first user name is 111, and in
> F> second user name is 222.
> F> And "where @mlu=111" is not always true, because sometimes is 222=111
> F> (this is false) ! upload_update script is this same form user 111 and
> F> 222.
>
> Why would you want to "hard code" a value in your synchronization
> scripts? If you do that, you have to start creating different script
> versions for every user. This is a maintenance nightmare and defeats
> the performance caching MobiLink does.
>
> I think you need to come up with a sample of rows in the consolidated,
> rows in 2 remotes. Show us what actions the remote's make and show us
> what action you want the consolidated to take and WHY it should make
> that choice.
>
> Once we have a better picture, we could offer better suggestions.
In examples is work this :
- i upload data to insert
- in upload_insert i insert in adding columns last_download, active and
username_table
- if i want download only some records (ml_username = username_table)
This is ok, but i want not add columns username_tables :
- i get username_temp
- i upload data to insert
- in upload_insert i insert in adding columns last_download, active
- if i want download only some records (ml_username = username_temp)
in this i dont must add one column to all table - and work this this same is
first method.
Fantom
|