[V4RB 0000144]: Ability of SqlExecute to return array of RecID's affected

[Sims, John]

Hi Ruslan,

Thanks for at least giving this some consideration.  It is what make
Paradigma Software, and yourself, so special!

Take care.

-John

> -----Original Message-----
> From: valentina-beta-bounces at lists.macserve.net 
> [mailto:valentina-beta-bounces at lists.macserve.net] On Behalf 
> Of Ruslan Zasukhin
> Sent: Wednesday, December 01, 2004 5:29 PM
> To: valentina-beta at lists.macserve.net
> Subject: Re: [V4RB 0000144]: Ability of SqlExecute to return 
> array of RecID's affected
> 
> 
> On 12/1/04 7:30 PM, "Sims, John" <AYU8 at CDC.GOV> wrote:
> 
> Hi John,
> 
> > Yes, using the cursor API would work fine if I was looking at a 
> > specific task.  However, what I am looking at trying to build is a 
> > replication engine for Valentina that I can use for several 
> projects 
> > (and make available to others if it comes out well).  To do 
> this, I'll 
> > need to wrap all of the functionality that Valentina 
> provides in a set 
> > of classes that also know how to maintain the replication 
> information.  
> > I could make the replication engine work for only the 
> classes way of 
> > Valentina but I would like to make it work with the SQL way 
> also.  To 
> > do this, I would need to know what records are affected by 
> > Insert/Update/Delete statements
> 
> Do you realize that this can be big set of data for big db ? 
> Well, on the other hand cursor itself is not smaller.
> 
> > so that I can make appropriate updates to the replication 
> information.
> 
> 
>  >Otherwise, I will have to parse the
> > Insert/Update/Delete statements enough to rebuild them with my 
> > replication information
> 
> Hard task
> 
> > included in the statement and to determine what
> > other replication information needs to be added/modified.  
> It occurred 
> > to me that if Valentina could tell me what records were 
> affected, it 
> > would make many of my tasks much simpler --- schema changes will be 
> > more interesting :-)
> 
> I see. I cannot promise this for 2.0.
> May be for 2.5, you have add it to mantis, so good.
> 
> IT seems this will require some new mechanism.
> Will see.
> 
> > I hope I have made sense.  As always, thank you so much for 
> you hard 
> > work and your willingness to work with your users.  Also, as many 
> > others have stated, my thoughts are with you and your 
> country as your 
> > country tries to resolve its presidential election dispute for the 
> > betterment of its people.
> 
> Thank you.
> 
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------