3.0 question (low priority)

[Sims, John (CDC/CCHP/NCBDDD) (CTR)]

> -----Original Message-----
> From: valentina-beta-bounces at lists.macserve.net 
> [mailto:valentina-beta-bounces at lists.macserve.net] On Behalf 
> Of Ruslan Zasukhin
> Sent: Friday, December 15, 2006 1:52 AM
> To: valentina-beta at lists.macserve.net
> Subject: Re: 3.0 question (low priority)
> 
> On 12/06/14 7:15 PM, "Sims, John (CDC/CCHP/NCBDDD) (CTR)" 
> <ayu8 at cdc.gov>
> wrote:
> 
> Hi John,
> 
> > I am hoping to replace a few systems that rely fairly heavily on 
> > Access replication.  I hate Access.  But, we have several 
> researchers 
> > that work remotely on laptops, often travelling to 
> countries without 
> > good or any infrastructure that would support the Internet.  So, we 
> > use Access replication to distribute the database to the various 
> > laptops yet still keep all of the data in a central repository as 
> > often as the researchers are able to sync up their replica. 
>  I would 
> > like to look into replacing Access with Valentina (in fact, I have 
> > already done a little work towards this).  The problem comes with 
> > replication.  I have put some work into creating the 
> functionality but 
> > always seem to come a little short of what I need for 
> various reasons.  
> > When Valentina 2 was in its early stages and we were discussing its 
> > features, it occurred to me that if I could get a list of 
> RecIDs that 
> > are modified or inserted (or, ideally, deleted) during an 
> SQLExecute, 
> > I should be able to finally achieve what I need.  One of 
> the biggest 
> > problems is that the code for the applications is fairly large and 
> > having to re-write it all to work strictly with cursors and not SQL 
> > Inserts/Updates/Deletes would probably take more time than 
> I would be 
> > allowed.  If I had the list of RecIDs, it would be less work.
> 
> What worry me in this feature is:
> 
> * SqlExecute() is possible in 2.x execute not single command 
> but several.
> 
>         "ISERT ...         ;
>          UPDATE  ......    ;
>          DELETE  ......... ;"
> 
> As I see you think and expect to get list of RecIDs which 
> contains RecIDs of records affected by the same operation?
> 
> 
> --
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information http://www.paradigmasoft.com

Hi Ruslan,

I don't usually use multiple executions as they tend to open your code
up for SQL Injection, but you make a very good point.  So, my best bet
at this point would perhaps be triggers.  Are you still considering
implementing triggers at some point in the future?  Or do you have other
thoughts of a way I could implement database replication?

Thanks again for your time.

-John