Transactions and Triggers for Binary Links

[william humphrey]

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).

On Mon, Jan 24, 2011 at 10:36 PM, John Sims <john at conceptualight.com> wrote:

> On 1/21/11 9:24 AM, Ivan Smahin wrote:
>
>> On 1/21/2011 4:13 PM, william humphrey wrote:
>>
>>> Yes and with example livecode? In fact I'd love to see a livecode
>>> implementation done by someone who knows SQL so well.
>>>
>> No, I mean just ideas in plain english or sql
>>
>>  Hi Ivan,
>
> 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.
>
> 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.
>
> Just thinking out loud, I don't suppose there is a way to enable Valentina
> to create "Partial" clones:
>
> 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.
>
> That, and Triggers on Binary Links, would take me a long way towards being
> able to build my replication engine.
>
> Thanks for listening.  Please let me know if you have any other questions.
>
> -John
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110125/28668a8a/attachment.htm>