AW: AW: Building cursor from record list V4MD

[Ruslan Zasukhin]

on 11/17/03 6:08 PM, Florian Bogeschdorfer at fb at memedia.de wrote:

>>> Of course. But what if I have 10000 or more records? Could
>> I still do this.
>>> Where are the limits for the SQL-String?
>> 
>> Well, today there is no technical limit.
>> 
>> What you try to do?
>> Save list of selected records?
>> 
>> Just in RAM ?
>> 
>> What for ?
>> 
> For a mailing, you may save selections, These selections are saved as SQL
> Query string and as a list of the Ids (not RecIDs, my own Ids) so that the
> customer can choose to use the "hardwired" selection list of records or
> refresh the list. This is interesting when you spread a mailing over a
> period (sending maybe 100 letters a day).

Aha, and you can use

    WHERE fld in (v1,v2,v3)

> Now each record may be valid for letter mailing or not. So I try to find all
> records FROM THE LIST that are valid for letter (or eMail...). As I see it,
> I will have to select each record one by one and check... :-)

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