RE: [firebird-support] Firebird 3.0.3 no longer compatible with InterBase 7.5.1 clients

2017-12-22 Thread FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support]
That’s great – thanks! I can confirm this issue no longer exists in nightly build 3.0.3.32857 and InterBase 7.5.1 clients connect with protocol 10. Looking forward to moving ahead with our migration to Firebird in the new year :) Steve From: firebird-support@yahoogroups.com

Re: [firebird-support]Engine Error - Partner Index

2017-12-22 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello Nico, Friday, December 22, 2017, 10:29:05 PM, you wrote: > 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

RE: [firebird-support] info

2017-12-22 Thread hv...@users.sourceforge.net [firebird-support]
> 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

2017-12-22 Thread 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]
> 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] Engine Error - Partner Index

2017-12-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 22-12-2017 13:27, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: > I only see version 3.0.1. How can I see the digits after comma ? There is no comma in the version number, but if you mean after the third dot, there are several ways: - Flamerobin: right click on server,

RE: [firebird-support] info

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support]
If I try the select, I don’t have any record where realindex is null Nico Speleers Team Lead Analyse & Consultancy Carfac bvba [Beschrijving: Beschrijving: Beschrijving: CarfacAS (klein)]Driving on experience Ambachtstraat 8 | 9700 Oudenaarde Tel. +32 55 23 00 00 |

RE: [firebird-support] Engine Error - Partner Index

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support]
I only see version 3.0.1. How can I see the digits after comma ? Nico Speleers Team Lead Analyse & Consultancy Carfac bvba [Beschrijving: Beschrijving: Beschrijving: CarfacAS (klein)]Driving on experience Ambachtstraat 8 | 9700 Oudenaarde Tel. +32 55 23 00 00 | Fax

Re: [firebird-support] Engine Error - Partner Index

2017-12-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 22-12-2017 13:10, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: > We are using Firebird 3.0. What is the full version (eg 3.0.2.32703)? -- Mark Rotteveel

RE: [firebird-support] Engine Error - Partner Index

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support]
We are using Firebird 3.0. Nico Speleers Team Lead Analyse & Consultancy Carfac bvba [Beschrijving: Beschrijving: Beschrijving: CarfacAS (klein)]Driving on experience Ambachtstraat 8 | 9700 Oudenaarde Tel. +32 55 23 00 00 | Fax +32 55 31 00 95

RE: [firebird-support] info

2017-12-22 Thread 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]
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

Re: [firebird-support] info

2017-12-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

Re: [firebird-support] info

2017-12-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

[firebird-support] info

2017-12-22 Thread Rustam Musa-Akhunov rusta...@ukr.net [firebird-support]
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?

RE: [firebird-support] info

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support]
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 |

[firebird-support] info

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support]
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

[firebird-support] info

2017-12-22 Thread Рустам Муса-Ахунов rusta...@ukr.net [firebird-support]
Attachments in you email is dropped. Try describe you problem with words.

[firebird-support] info

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support]
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