Re: [firebird-support] Re: Error on Gfix

2015-10-01 Thread hv...@users.sourceforge.net [firebird-support]
> ---In firebird-support@yahoogroups.com, wrote : > > Hi Vlad, thank for your e-mail! > > I understood what you said, however, in the link > http://www.firebirdsql.org/manual/gfix-dbverify.html > http://www.firebirdsql.org/manual/gfix-dbverify.html I got the following >

[firebird-support] How To Get Entire Linked Group Details

2015-10-01 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
Hi All,  I have attached a table DDL and Insert  record script in "Table Script.txt" text file. And also attached a snap of how data looks in the table in the file "Entire Table Data.png" I need to get all the details for the main group called "Vishal Group1", please refer "Expected

Re: [firebird-support] How To Get Entire Linked Group Details

2015-10-01 Thread liviusliv...@poczta.onet.pl [firebird-support]
Hi, this group does not support attachments regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Thursday, October 01, 2015 2:59 PM To: Yahoo! Inc. Subject: [firebird-support] How To Get Entire Linked Group Details Hi All, I have attached a table DDL and

[firebird-support] Error while attempting to add a Primary key to a table that has no records

2015-10-01 Thread 'stwizard' stwiz...@att.net [firebird-support]
Greetings, Firebird v2.5.4 I use Database Workbench v 5 as my database development tool. I have this table which is currently empty (0 rows). It originally had a primary key on TRUST_STATEMENT_ID and ORIGINAL_PMT_ID CREATE TABLE TRUST_STATEMENT_PMT_BACKOUT_CHK (

RE: [firebird-support] Error while attempting to add a Primary key to a table that has no records

2015-10-01 Thread 'stwizard' stwiz...@att.net [firebird-support]
Hmmm, I tried again this evening and it would allow me to add the primary key. Very strange. Since we moved to a new windows server 2012 R2 and upgraded to v2.5.4 firebird running Classic Super Server from v1.5.4 running Classic Server, could any of that have anything to do with it?

Re: [firebird-support] How To Get Entire Linked Group Details

2015-10-01 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
Hi All, There is some change in my previous SQL. Please consider below SQLs. CREATE TABLE MYGROUP (  PK_GROUP GUID DEFAULT 'newid()' NOT NULL,  DESCRIPTION Varchar(255),  LINKED_TO_GROUP GUID,  PRIMARY KEY (PK_GROUP)); COMMIT; INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES

Re: [firebird-support] How To Get Entire Linked Group Details

2015-10-01 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
In tree format, the logical structure looks like as below: Vishal Group||---Vishal Group1| |Vishal Group1.1| |--Vishal Group1.1.1||---Vishal Group2| |Vishal Group2.1| |--Vishal Group2.1.1||---Vishal

Re: [firebird-support] Error while attempting to add a Primary key to a table that has no records

2015-10-01 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> Hmmm, > > > > I tried again this evening and it would allow me to add the primary key. Very > strange. Since we moved to a new windows server 2012 R2 and upgraded to > v2.5.4 > firebird running Classic Super Server from v1.5.4 running Classic Server, > could > any of that have anything to