> 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
> 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
.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 description
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
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
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
Try declare column ORDERTYPEDESCRIPTION without 'COLLATE UNICODE_CI_AI' and see
results.
What default character set has your DB (used in CREATE DATABASE) and what
character set you use at connection?
hdc-software-nv>[Twitter]<https://twitter.com/carfacbvba>
Van: Рустам Муса-Ахунов rusta...@ukr.net [firebird-support]
[mailto:firebird-support@yahoogroups.com]
Verzonden: vrijdag 22 december 2017 10:38
Aan: firebird-support@yahoogroups.com
Onderwerp: [firebird-support] info
Show you INSE
Hello,
I have a problem with inserting a row in table OrderTypeDescriptions. Here you
can find the sql script for the tables OrderTypes and OrderTypeDescriptions.
CREATE TABLE ORDERTYPES (
ID INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,
STOCKORDER BOOLEAN DEFAULT FALSE
Attachments in you email is dropped. Try describe you problem with words.
Hello,
I have a problem with inserting a row in table OrderTypeDescriptions. Here you
can find the sql script for the tables OrderTypes and OrderTypeDescriptions.
CREATE TABLE ORDERTYPES (
ID INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,
STOCKORDER BOOLEAN DEFAULT FALSE
)?
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 Nico,
Wednesday, December 20, 2017, 4:34:09 AM, you wrote
As I answer you on your first time question - use this query to get next ID.
Then supply this ID in your next INSERT query.
select
gen_id(GEN_TABLENAME, 1)
from RDB$DATABASE
Where GEN_TABLENAME - generator for your A.ID column. In this case you not need
to declare you column as IDENTITY.
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 /
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
Hi,
Ex.
CREATE TABLE ADDRESSES (
IDINTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,
ADDRESSNAME VARCHAR(100) COLLATE UNICODE_CI_AI,
STREETNAMEVARCHAR(100) COLLATE UNICODE_CI_AI,
STREETNUMBER VARCHAR(100) COLLATE
select
gen_id(GEN_XXX, 1)
from RDB$DATABASE
Where GEN_XXX - generator for your A.ID column
Hello,
Ex.
Table A
Id (AutoInc)
Description
Id = 1 / Description = Test
Id = 2 / Description = Test2
I want to know the next Id number in my table 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
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.
olve this.
Kind Regards,
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 columnna
ag 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
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 is readabi
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
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.
]
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 sa
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.
--
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
>
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
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
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 that we don't have to use the quotes in
SQL-statements ?
We don't want to create our table- and fieldnames
30 matches
Mail list logo