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

[Ruslan Zasukhin]

On 12/1/04 6:03 PM, "vbt at paradigma.ukrcom.kherson.ua"
<vbt at paradigma.ukrcom.kherson.ua> wrote:

Hi All,

I think this have no many sense.

IF you want to control the affected records, then you can do this using
Cursor API:

    curs = db.SqlSelect()....
        // so you have now records which will be affected.
    
    curs.UpdateAllRecords()


The same effect as UPDATE WHERE, but you have on hands the set of affected
records. 

Works ?


> The following issue has been SUBMITTED.
> ======================================================================
> <http://paradigma.ukrcom.kherson.ua/bt/view.php?id=144>
> ======================================================================
> Reported By:                John Sims
> Assigned To:     
> ======================================================================
> Project:                    V4RB
> Issue ID:                   144
> Category:                   Feature Request
> Reproducibility:            N/A
> Severity:                   feature
> Priority:                   normal
> Status:                     new
> ======================================================================
> Date Submitted:             12-01-2004 18:03 EET
> Last Modified:              12-01-2004 18:03 EET
> ======================================================================
> Summary:                    Ability of SqlExecute to return array of RecID's
> affected
> Description: 
> If at all possible, I would like the ability for SqlExecute to return an
> array of RecID's affected by the Insert/Update statement that was passed.
> So, if I send Valentina a statement like "UPDATE Person SET bRetired=TRUE
> WHERE Age>65" then I would get an array of all of the RecID's for the
> people I just marked as retired.
> ======================================================================
> 
> Issue History
> Date Modified  Username       Field                    Change
> ======================================================================
> 12-01-04 18:03 John Sims      New Issue
> ======================================================================
> 

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------