On 10/20/2011 11:28 AM, gastrocus wrote:
--- In firebird-support@yahoogroups.com
mailto:firebird-support%40yahoogroups.com, Helen Borrie
helebor@... wrote:
What is the analogous way to achieve this in Firebird (2.5) ?
INSERT INTO emp (fruits) values ('mango')
where not exists
On 10/26/2011 9:34 AM, eric_developer wrote:
Hi,
how to solve? simple example:
RECREATE VIEW TMP_REGC100 AS
SELECT CODFOR
FROM TMP_NFENT
GROUP BY 1
UNION all
SELECT CODEMP
FROM TMP_NFSAI
---
Dynamic SQL Error
SQL error code = -607
Invalid command
must specify
On 10/23/2011 10:01 AM, Mark Rotteveel wrote:
On 23-10-2011 16:05, ibmcom2011 wrote:
now i have a table such as:
f1 f2
1 aa
2 tf
1 bb
3 cc
2 ht
i want the result seems as:
f1 f2
1 aa, bb
2 tf, ht
3 cc
any help is appreciated, thanks.
The following query
I am using FB 1.5 and doing a delete from a large table using the
primary key as a reference from a sub select
delete from tableA where ID in (select ID from tableB where someval = 'x')
The subquery is fast and looks like it uses the index. But the plan for
the delete is (ID NATURAL) and take