tries to create the table with a primary index:
CREATE TABLE DETAILS_DATA
(ID_MASTER INTEGER NOT NULL,
ID_PARAM INTEGER NOT NULL,
PARAM_VALUE VARCHAR(64) NOT NULL,
CONSTRAINT "PK_DETAILS_DATA" PRIMARY KEY ("ID_MASTER","ID_PARAM"));
---Messaggio originale---
Da: brucedickin...
Have you user -u SYSADM -p masterkey (come user and password in command
gbak)
Regards
---Messaggio originale---
Da: sboyd...@gmail.com [firebird-support]
Data: 17/07/2015 20.22.57
A: firebird-support@yahoogroups.com
Oggetto: [firebird-support] Re: Duplicate key error during datab
if not indicate id_master the query must scroll all id_master (then the
entire archive) so you better define the index: CREATE UNIQUE INDEX ON
UNQ_DETAILS_DATA DETAILS_DATA (ID_PARAM, ID_MASTER) to limit your search to
only id_param = 60 with query where id_param = 60. greetings
---Mes
simple
(field1,field2) (field2,field1)
1111
2x 1 4
3x 1 8
41 x 2
5x x 3
6x x 5
7x x 6
81
it makes sense to use parts of keys provided are used those with the highest
level because significantly reduce the readings otherwise should build an
index for that purpose. greetings
---Messaggio originale---
Da: brucedickin...@wp.pl [firebird-support]
Data: 20/07/2015 14.20.37
and 'exactly this way because you do not know the value of ID_MASTER then
want all ID_MASTER without have index based on ID_PARAM. hello
---Messaggio originale---
Da: Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
Data: 20/07/2015 15.57.13
A: firebird-support@yahoogroups.com
Og
The first procedure provides you safe from data loss.
you can directly execute the change of the charset after doing a complete
backup of the database.
---Messaggio originale---
Da: Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Data: 21/07/2015 18.38.39
A: firebird-sup
you run the query manually from the command prompt dos using ISQL
---Messaggio originale---
Da: Aage Johansen aagjo...@online.no [firebird-support]
Data: 21/07/2015 22.45.36
A: firebird-support@yahoogroups.com
Oggetto: [firebird-support] Re: Firebird 1.5.3 on Windows 2012 R2 Serv
Is possible to run the query manually from the command prompt dos using ISQL
---Messaggio originale---
Da: Aage Johansen aagjo...@online.no [firebird-support]
Data: 21/07/2015 22.45.36
A: firebird-support@yahoogroups.com
Oggetto: [firebird-support] Re: Firebird 1.5.3 on Windows
without considering the merits of your problem, I can say that the response
time of the selects depends on more factors: the first and 'the structure of
the indexes on the table but also on how and' written queries. Without know
the details, I can say that the absence of a group by in the presence
This is solution:
select * from tabella A where Group_ID in (Select min(Group_ID) in tabella B
where B.ID=A.ID);
---Messaggio originale---
Da: Maya Opperman m...@omniaccounts.co.za [firebird-support]
Data: 29/07/2015 13.49.41
A: firebird-support@yahoogroups.com
Oggetto: [firebird
This is solution:
select * from tabella A where Group_ID in (Select min(Group_ID) in tabella B
where B.ID=A.ID);
---Messaggio originale---
Da: 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Data: 29/07/2015 18.59.03
A: firebird-support@yahoogroups.com
Oggetto: [firebird-su
Want to provide for my unsubscription because I get too many e mail. thank you
[Non-text portions of this message have been removed]
13 matches
Mail list logo
