Re: [Firebird-devel] Index is corrupt (missing entries) in table

2011-04-19 Thread borut . maricic
Thank you for your suggestion Nick: > 1 Drop the primary key constraint of the table in question > 2 create index on the 6 fields > 3 validate I have tried this during the night: no, that does not help either, i.e. the fact that index is being built as a secondary one and without unique-constrain

Re: [Firebird-devel] Possible bug in isc_dsql_exec_immed2()

2011-04-19 Thread Support List
> Are you sure you have passed the 3rd dialect in that call? > What version of gds32/fbclient did you use? Thank you! That was the problem. Somehow a hard coded constant was there instead of using the dialect from my connection component. Thanks, Jason ---

Re: [Firebird-devel] Possible bug in isc_dsql_exec_immed2()

2011-04-19 Thread Dmitry Yemanov
20.04.2011 4:11, Support List wrote: > > Using this generator: > > CREATE GENERATOR "Holy cow!"; > > I tried to execute the statement below via the above mentioned API call. > > I got a token not found error with the double quoted identifier but it > worked fine for a regular identifier that didn't

[Firebird-devel] Possible bug in isc_dsql_exec_immed2()

2011-04-19 Thread Support List
Hello all! Using this generator: CREATE GENERATOR "Holy cow!"; I tried to execute the statement below via the above mentioned API call. I got a token not found error with the double quoted identifier but it worked fine for a regular identifier that didn't need double quotes. SELECT GEN_ID ( "

Re: [Firebird-devel] ICU. VS2010 project files

2011-04-19 Thread Adriano dos Santos Fernandes
On 19-04-2011 13:02, Paul Reeves wrote: > > However, if it hasn't been changed it would require a ton of work for each > icu > version, which is one of the reasons why we haven't upgraded icu. > No, it's surely not. I've done a patch for a previous version which fixed like we did for 3.0. It h

Re: [Firebird-devel] ICU. VS2010 project files

2011-04-19 Thread Philippe Makowski
Paul Reeves [2011-04-19 18:02] : > Our main problem is likely to be finding icu binaries built with > MSVC10. > something like these ? http://site.icu-project.org/download/46 icu4c-4_6_1-Win32-msvc10.zip7.7 MB Windows (win32 x86 32-bit) Visual Studio 10 icu4c-4_6_1-Win64-msvc10.zip7.9

Re: [Firebird-devel] ICU. VS2010 project files

2011-04-19 Thread Paul Reeves
On Tuesday 19 April 2011 at 16:47 Philippe Makowski wrote: > > Where ? > the only link I found is : http://site.icu-project.org/download > and with this we can't do a 'one click install' We wouldn't want to do that anyway. The icu binaries would be specific to a particular version of Firebird.

Re: [Firebird-devel] ODS12. RDB$FUNCTION_ARGUMENTS. Description field.

2011-04-19 Thread Dmitry Yemanov
19.04.2011 9:49, Kovalenko Dmitry wrote: > Hi > The system table "RDB$FUNCTION_ARGUMENTS" (in ODS12) still exists > without "RDB$DESCRIPTION" field. It was surely missed on my part, to be added. > RDB$PROCEDURE_PARAMETERS contains this (and RDB$SYSTEM_FLAG also) field. I'm not so sure about RDB$

Re: [Firebird-devel] ICU. VS2010 project files

2011-04-19 Thread Philippe Makowski
Alex Peshkoff [2011-04-18 19:44] : > As a separate download ICU binaries are always available from IBM site > (including win32/64). Where ? the only link I found is : http://site.icu-project.org/download and with this we can't do a 'one click install' we must provide binaries inside our Windows p

Re: [Firebird-devel] Index is corrupt (missing entries) in table

2011-04-19 Thread Nick Upson
Have you tried making an index only 1 Drop the primary key constraint of the table in question 2 create index on the 6 fields 3 validate if that's ok, do it again but create an unique index and see what that does -- Bene

Re: [Firebird-devel] Index is corrupt (missing entries) in table

2011-04-19 Thread borut . maricic
Thank you for your time Maya. You wrote: > Just some more info here. When you restore a database, it looks at your > index definitions, and current data, and builds the indices from that. > That is why backing up and restoring will rectify the problem > (temporarily, till a new corruption occurs)

Re: [Firebird-devel] Charset and collations

2011-04-19 Thread Nikita Konyuchenko
>> Any suggestions? > Always use UTF8 and you won't miss. It's not my caprice. Our users should be able to define charset and collation for database. So I need to get them somehow. Of course I can hardcode them but what to do with new charsets? -

Re: [Firebird-devel] Charset and collations

2011-04-19 Thread Dimitry Sibiryakov
19.04.2011 13:30, Nikita Konyuchenko wrote: > Any suggestions? Always use UTF8 and you won't miss. -- SY, SD. -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use

[Firebird-devel] Charset and collations

2011-04-19 Thread Nikita Konyuchenko
Is there any way to get charsets and collations from the server remotely and without connection to any database? In case I'm to create a new database and I need to know which charsets and collations are available. Generally speaking I need fbintl.conf content. Any suggestions? ---

Re: [Firebird-devel] The boot build again

2011-04-19 Thread Alex Peshkoff
On 04/19/11 09:48, Claudio Valderrama C. wrote: >> -Original Message- >> From: Vlad Khorsun [mailto:hv...@users.sourceforge.net] >> Sent: Domingo, 17 de Abril de 2011 5:21 >> >>> I mean, it should be >>> able to complete itself without my manual intervention to >> copy some files in >>>