getting the same record multiple times in a cursor

[Ruslan Zasukhin]

On 18/2/07 4:26 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> On 18/2/07 4:21 PM, "Francois Van Lerberghe" <fvanlerberghe at freegates.be>
> wrote:
> 
> Btw, this thread better do on Valentina list.
> It is not related to beta issues :-)
> 
>> le 18/02/07 14:14, jda <jda at his.com> a écrit :
>> 
>>> I'd like to create a cursor in which the same table record can be
>>> represented more than once. That is, if the user asks for the same
>>> record twice in a single query, I'd like two records returned in the
>>> cursor.
>>> 
>>> Is that possible?
>> 
>> Yes.
>> In order to achieve this I have created a table ("Duplicate") with 1 field
>> ("linkedField" as Vbyte). The other tables, if I need them, have a similar
>> field.
>> 
>> If I want 3 copies, I add 3 records in the "Duplicate" table and I link it
>> in my SQLQuery.

Ivan recommends take a look on UNION,
Although this also seems not a way for this task.

So check Francois suggestion.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]