That sounds like a nice thing for my app too. I'd like to be able to merge to sets of data with a simple "merge" command (I'd never be able to learn to make a replication engine like you are doing).<br><br>
<div class="gmail_quote">On Mon, Jan 24, 2011 at 10:36 PM, John Sims <span dir="ltr"><<a href="mailto:john@conceptualight.com">john@conceptualight.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On 1/21/11 9:24 AM, Ivan Smahin wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 1/21/2011 4:13 PM, william humphrey wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Yes and with example livecode? In fact I'd love to see a livecode implementation done by someone who knows SQL so well.<br>
</blockquote>
No, I mean just ideas in plain english or sql<br>
<br>
</blockquote></div>
Hi Ivan,<br>
<br>
Well, for a long time I have hoped to try to use Valentina in our environment which pretty much requires data replication/synchronization. We have people who work on laptops in areas where you cannot guarantee any level of Internet or network access (3rd world countries and things like that). Having triggers and stored procedures, I should be able to write my own replication/synchronization engine for traditional type database tables. But I'd like to be able to use Binary Links in the application so I'd need to know when changes were made to them also.<br>
<br>
The only other difficulty I see is dealing with the uniqueness of Vale's RecID and Object Pointers. There's no way I am aware of change the RecID of a record so keeping the records homogeneous across database installations will be pretty much impossible...so, I'll have to try to work around that.<br>
<br>
Just thinking out loud, I don't suppose there is a way to enable Valentina to create "Partial" clones:<br>
<br>
I'd like to choose a specific record from a certain table then have that record and any records of any tables down the relationship tree cloned. If there are any tables that are not in the relationship tree, all records for those tables would be cloned.<br>
<br>
That, and Triggers on Binary Links, would take me a long way towards being able to build my replication engine.<br>
<br>
Thanks for listening. Please let me know if you have any other questions.<br><font color="#888888">
<br>
-John</font><div><div></div><div class="h5"><br>
_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><a href="http://www.bluewatermaritime.com">http://www.bluewatermaritime.com</a><br>