Bit


Hi,

After

select "X" as dbcase from test1_cursor union all;

select "Y" as dbcase from test2_cursor;

into cursor temp_cursor

i> I need to view the content of temp_cursor,

Is it correct to use:

select temp_cursor

browse

ii> Is it correct to say that union all means content selected from test1_cursor or test2_cursor

Regards,

BIT




Re: How to view the content of a cursor?

CetinBasoz


1)

select "X" as dbcase from test1_cursor ;

union all ;

select "Y" as dbcase from test2_cursor ;

into cursor temp_cursor

browse

or:

select temp_cursor

browse

as you did.

2) Yes, "union all" selects the records from both cursors. It's as if you appended one after another. In your sample result would be a cursor with a single dbcase field, having N "X" and M "Y" records (where N and M are test1, test2 cursors' selectable record count).