Thank you very much Paul.
Greetings.
Walter.
On Mon, Dec 16, 2013 at 11:40 PM, paul wrote:
>
>
>
> Hallo Walter,
>
>
> > Then, no makes sense to declare a cursor just for retrieving rows?
>
> No, for just retrieving rows FOR SELECT is easier and safer.
>
> If you want to perform positioned u
Hallo Walter,
> Then, no makes sense to declare a cursor just for retrieving rows?
No, for just retrieving rows FOR SELECT is easier and safer.
If you want to perform positioned updates or deletes, use FOR SELECT ...
AS CURSOR.
DECLARE cursor (with the need for OPEN, FETCH, CLOSE, as well as c
Ok, thank you Mark.
Then, no makes sense to declare a cursor just for retrieving rows?
Where I can see an example of WHERE CURRENT OF clause?
Greetings.
Walter.
On Mon, Dec 16, 2013 at 2:04 PM, Mark Rotteveel wrote:
>
>
> On 15-12-2013 20:25, W O wrote:
> > If in a stored procedure I need t
On 15-12-2013 20:25, W O wrote:
> If in a stored procedure I need to extract data from a table I can use a
> FOR SELECT or a DECLARE VARIABLE MyVar CURSOR FOR ( ) statement.
>
> Which would be the advantage of using CURSOR FOR?
>
> In which cases it is better than a FOR SELECT?
For one thing,
I see the issues on 12.04 it doesn't work
you can install firebird and use as alternative inside a schroot
http://www.binarytides.com/setup-chroot-ubuntu-debootstrap/
http://www.binarytides.com/setup-chroot-ubuntu-debootstrap/
install
sudo apt-get install software-properties-co
Try with apt and here is my results on 13.10 , i will test in 5 minutes on
12.04 too
sudo apt-get install firebird2.5-superclassic:i386
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
firebi
>I have two tables, TABLE_A and TABLE_B
>
>TABLE_A:
>--
>ID: INT
>DATA_A: INT
>
>TABLE_A data:
>(ID, DATA_A)
>1, 11
>2, 12
>3, 13
>4, 14
>9, 19
>
>TABLE_B:
>--
>ID: INT
>DATA_B: INT
>
>TABLE_B data:
>(ID, DATA_B)
>1, 100
>2, 200
>3, 200
>5, 100
>7, 300
>9, 100
>
>I want to do the following:
Select * from TABLE_A aa where Exists (Select ab.id From table_b ab And
ab.data_b = 100 And aa.id = ab.id)
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of peter_...@yahoo.com
Sent: Monday, December 16, 2013 12:41 PM
To: firebird-support@yahoogroup
Hi,
I have two tables, TABLE_A and TABLE_B
TABLE_A:
--
ID: INT
DATA_A: INT
TABLE_A data:
(ID, DATA_A)
1, 11
2, 12
3, 13
4, 14
9, 19
TABLE_B:
--
ID: INT
DATA_B: INT
TABLE_B data:
(ID, DATA_B)
1, 100
2, 200
3, 200
5, 100
7, 300
9, 100
I want to do the following: get all records from TAB