RE: [firebird-support] info

> If I try the select, I don’t have any record where realindex is null Check RDB$INDEX_INACTIVE for non-zero\not-null values Regards, Vlad

RE: [firebird-support] info

> If I try the select, I don’t have any record where realindex is null Then I would next check the database for any possible problems... corruption etc. http://www.ibphoenix.com/resources/documents/how_to/doc_5 Regards Paul

RE: [firebird-support] info

.com/carfacbvba> Van: 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] [mailto:firebird-support@yahoogroups.com] Verzonden: vrijdag 22 december 2017 13:16 Aan: firebird-support@yahoogroups.com Onderwerp: RE: [firebird-support] info Try the following... Partner index d

RE: [firebird-support] info

Try the following... Partner index description not found (175)) internal gds software consistency check (partner index description not found. Missing index for a primary or a foreign key. The problem may be caused by physical database corruption or by a bug. Recovery process: To find the miss

Re: [firebird-support] info

On 22-12-2017 10:29, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: This is the third topic you started with the non-descriptive subject "info". In the future, could you please come up with a succinct but informative subject when posting? Subjects should summarize your questi

Re: [firebird-support] info

On 22-12-2017 10:29, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: > Problem > Engine Error (code = 335544333): internal Firebird consistency check (partner > index description not found (175), file: idx.cpp line: 1271). > SQL error (code = -902): Unsuccessful execution caused

RE: [firebird-support] info

Insert into OrderTypeDescriptions (OrderTypeId, OrderTypeDescription, LanguageId) values (1, 'Test', 1) Nico Speleers Team Lead Analyse & Consultancy Carfac bvba [Beschrijving: Beschrijving: Beschrijving: CarfacAS (klein)]Driving on experience Ambachtstraat 8 | 970

Re: [firebird-support] Info

On 2017-12-20 19:38, 'Zoran' zoran...@gmail.com [firebird-support] wrote: > Hello Helen > > I understand that we shouldn't mess up with IDENTITY column, as you > said. I have the same problem as original poster and I'm using this > code > > SELECT G.RDB$GENERATOR_NAME > > FROM RDB$RELATION_FIEL

RE: [firebird-support] Info

(assuming that RDB$ table structures don't change)? Thanks. Zoran From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Tuesday, December 19, 2017 2:29 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Info Hello Nic

Re: [firebird-support] Info

Hello Nico, Wednesday, December 20, 2017, 4:34:09 AM, you wrote: > CREATE TABLE ADDRESSES ( > IDINTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL, > ADDRESSNAME VARCHAR(100) COLLATE UNICODE_CI_AI, > Id = 1 / AddressName = Test / .. > Id = 2 / Ad

Re: [firebird-support] Info

19.12.2017 16:34, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: > I want to know the next Id number in my table Addresses without an insert. In > my example > it will be 3. I want to reserve (without an insert) Id number 3 because > someone else can > also ask the next Id nu

Re: [firebird-support] info

On Wed, Jan 4, 2017 at 9:41 AM, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] < firebird-support@yahoogroups.com> wrote: We want to create table- and fieldnames (Firebird 3) in camelcase. If we > want to write a select statement we have to use quotes around a tablename. >

Re: Re: [firebird-support] info

Arno Brinkman ABVisie -Oorspronkelijk bericht- From: Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] Sent: Thursday, January 5, 2017 10:36 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] info Based on table- and columnnames in camelcase ou

Re: [firebird-support] info

matic > create their objects and classes. Therefore we need to create our table- and > columnnames in camelcase. Another reason is readability. We found camelcase > more readable then UPPERCASE. > > Have you got a solution for my problem ? > > Nico Speleers > Analyst &

Re: [firebird-support] info

y, January 5, 2017 10:36 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] info Based on table- and columnnames in camelcase our programmers can automatic create their objects and classes. Therefore we need to create our table- and columnnames in camelcase. Another reason

Re: [firebird-support] info

Hello Nico, >I want to create a tablename in camelcase without using quotes. > >If I execute Create table MyTable(aField integer) then the tablename is >saved as MYTABLE. And yes then you can use camelcase >without quotes. > >Can you find a solution ? The only solution to preserving case, is to

Re: [firebird-support] info

05.01.2017 10:36, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > Have you got a solution for my problem ? There is no solution for your problem. -- WBR, SD. ++

RE: [firebird-support] info

] Verzonden: donderdag 5 januari 2017 10:23 Aan: firebird-support@yahoogroups.com Onderwerp: Re: [firebird-support] info 05.01.2017 8:51, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > If I execute Create table MyTable(aField integer) then the tablename is saved &

Re: [firebird-support] info

05.01.2017 8:51, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > If I execute Create table MyTable(aField integer) then the tablename is saved > as MYTABLE. Why do you care how it is saved? Just don't look into system tables when writing your queries. --

RE: [firebird-support] info

Onderwerp: Re: [firebird-support] info 04.01.2017 15:41, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > We want to create table- and fieldnames (Firebird 3) in camelcase. If > we want to write a select statement we have to use quotes around a > tablen

Re: [firebird-support] info

Hello Nico, If you want the case preserved, you have to use double quotes, always. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird. We want t

Re: [firebird-support] info

04.01.2017 15:41, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > We want to create table- and fieldnames (Firebird 3) in camelcase. If we want > to write a > select statement we have to use quotes around a tablename. This is not > userfriendly. Is > there a way