python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - firebird2.5

Does Firebird have an addition assignment operator?

Does Firebird have an addition assignment (+=) to be used in procedures?
test-img

Estevanbs

firebird

firebird2.5

Votes: 0

Answers: 1

Latest Answer

No, Firebird doesn't have compound assignment operators.
test-img

Mark Rotteveel

Use a returning value from an INSERT table (A) into another table (B)

I need to use the returning value of the Table A (ID) and insert it in Table B as a parameter: insert into tableA (ID, Name , Address) values (GEN_ID(GENERATOR,1),'John','123 street') returning ID -...
test-img

Tonathiu Redrovan

sql

firebird

firebird2.5

Votes: 0

Answers: 1

Latest Answer

The only way to do this in a single statement, is to use EXECUTE BLOCK (basically an anonymous one-off procedure). It uses the same syntax as normal stored procedures in Firebird. You can do: execute ...
test-img

Mark Rotteveel

How to remove a parenthesized part at the end of a string?

I have stock list values like this VALANTINE (BY ECK) DAMIER STONE(XL) SARIYER (BY ECK) MNV1983(XL7) I want to update stocks list values to this VALANTINE (BY ECK) DAMIER STONE SARIYER (BY ECK) MNV19...
test-img

Birikim Bilgisayar

sql

firebird

firebird2.5

Votes: 0

Answers: 1

Latest Answer

In Firebird 2.5, you can do something like: case when val similar to ('%\(%\)') escape '\' then substring(val from 1 for char_length(val) - position('(' in reverse(val))) else val end This does t...
test-img

Mark Rotteveel

Union all not displaying all queries

I'm making a query with multiple UNION ALL statements and it's not showing all the results it should show. The SELECT statements all have the same amount of columns, the same aliases and same data typ...
test-img

Felipe Soberanski

sql

firebird

firebird2.5

Votes: 0

Answers: 1

Latest Answer

Ok, so it turns out it was because of the table's structures that were different, doesn't really make much sense for me, but it's working now
test-img

Felipe Soberanski

Posts

Questions

Blogs

Jobs