Re: [firebird-support] JOIN ON SELECT PROCEDURE

06.12.2016 8:18, hugo.lar...@yahoo.com [firebird-support] wrote: > *I tried the following but it does not work. * Your join must be right, not left in this case. -- WBR, SD.

Re: [firebird-support] How to change cpu utilization in Firebird engine?

06.01.2017 3:54, trsk...@yahoo.com [firebird-support] wrote: > please help me to point out which codes I should change & if my knowledge is > enough is I > only have basic C? No way you or someone else can do this with current Firebird architecture, sorry. -- WBR, SD.

Re: [firebird-support] Insert SQL Deadlock Issue

04.01.2017 13:36, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > Error 3: > *validation error for column VAT, value "*** null ***"* > *-sql_dialect set database dialect n* > * > * First of all fix fbclient.dll(gds32.dll) - firebird.msg version

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

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

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] Fb 3: error code 336068898 when recreating package

05.01.2017 12:17, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: > Any idea what this error code means? "Default values for parameters are allowed only in declaration of packaged function @1.@2" Make sure that you use fbclient.dll and firebird.msg

Re: [firebird-support] slow connection time to the db

05.01.2017 14:40, Marianne Castel - Titelive caste...@titelive.be [firebird-support] wrote: > Has somebody an idea, where is the sytem loosing time ? Most often (x)inetd waste time trying to identify client by ident protocol or reverse DNS to get host name. -- WBR, SD.

Re: [firebird-support] Fb 3: error code 336068898 when recreating package

05.01.2017 15:35, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: >> Make sure that you use fbclient.dll and firebird.msg of version 3. > I didn't the '@', that I usually see when mismatching fbclient/firebird.msg > ;) You get it when use firebird.msg

Re: [firebird-support] How to change cpu u tilization in Firebird engine?

07.01.2017 12:06, trsk...@yahoo.com [firebird-support] wrote: > If cpu utilization can be set, perhaps, all operation, including queries can > benefit from > higher cpu performance. It is not given at all. Inter-thread synchronization has its price. -- WBR, SD.

Re: [firebird-support] Version statement

20.12.2016 14:33, Emil Totev em...@tot-consult.com [firebird-support] wrote: > I feel it would be nice if in some highly visible place on the > firebird site there is a clear statement about the versions and > sub-versions available and recommended. Right part of the main page with big red

Re: [firebird-support] using a stored procedure to return the value for an existing field in the table

24.03.2017 17:26, av...@telusplanet.net [firebird-support] wrote: > is there a way i can write a StoredProcedure or trigger to have the "code" in > the database > return that value i want for the existing column and not just return the > table data for > that column? Create a new table, pump

Re: [firebird-support] 64 bit UDF DLL problem on Windows

28.03.2017 13:26, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > Do you have ideas why it cannot find my UDFs? First of all, check that your DLL exports 'sum' without mangling. -- WBR, SD.

Re: [firebird-support] 64 bit UDF DLL problem on Windows

28.03.2017 15:14, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > That's all. A nd it wo rks fine in linux. > > How should i modify it? STFW how to export functions from C++ DLLs. -- WBR, SD.

Re: [firebird-support] 64 bit UDF DLL problem on Windows

30.03.2017 14:17, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > the keyword was > > extern "C" > > Now the compiler stopped mangling the function names and Firebird can see > them correctly. Only C++ compilers mangle names but you insisted that you use plain C...

Re: [firebird-support] Question about an error during Create/Drop tables.

22.03.2017 10:11, amiya_s_hos...@yahoo.com [firebird-support] wrote: > Is there any tips for the phenomenon? > I'd appreciate if anyone could give me a resolution for that. Do not ever do anything like that. Or at least put commit after drop statement. -- WBR, SD.

Re: [firebird-support] Migrate interbase xe

16.03.2017 18:16, julio brzezinski juliobrzezin...@gmail.com [firebird-support] wrote: > i possible to do that with buckup/restore or exists any tool to help with this It is not possible with backup and restore. Create new database from scratch and pump data with IBDataPump or any other

Re: [firebird-support] reset sysdba password without loose existing users

23.03.2017 17:27, startx252...@yahoo.fr [firebird-support] wrote: > Anybody can help me to reset SYSDBA without loose all existing users in > Firebird Attach in embedded mode with SYSDBA name and you can change the password with ALTER USER command. -- WBR, SD.

Re: [firebird-support] 64 bit UDF DLL problem on Windows

29.03.2017 0:27, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > I have wasted a lot of time but succes yet to come. void foo() #ifdef __WIN32__ __declspec(dllexport); #else __attribute__((visibility ("default"))); #endif // __WIN32__ -- WBR, SD.

Re: [firebird-support] between operator on a varchar field

31.03.2017 9:51, 'support' f...@princess.hu [firebird-support] wrote: > Am I missing something? Yes: value 'AHH00141/2016', for example, is bigger than 'AHH00095/2017' and smaller that 'AHH00141/2017'. -- WBR, SD.

Re: [firebird-support] Basic Start

14.03.2017 18:32, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > 2) Can I create a Firebird database file? ... as I did with SQLite ... No. Firebird is a client-server DBMS, closer to Oracle than file-server like SQLite. Read Firebird Quick Start Guide. -- WBR, SD.

Re: [firebird-support] Multiple firebird servers accessing the same database

05.04.2017 21:27, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > Is this possible, even in some unorthodox way? No. The only way is to replicate copies of the database to every server. -- WBR, SD.

Re: [firebird-support] Firebird 1.5.6 not work with locla protocol

21.04.2017 12:29, blumy2...@yahoo.com [firebird-support] wrote: > Where is the problem?? The problem is that you try to run 15 years old Firebird on modern OS. It has higher security measures that prevent using of old IPC protocol between ordinary user application and a service run under

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

14.04.2017 8:22, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > How can I improve remote speed? Increase value of "TcpRemoteBufferSize" parameter in firebird.conf to max. -- WBR, SD.

Re: [firebird-support] Does any Delphi component exist to access a FB database without DLLs?

13.03.2017 12:33, Andrea Raimondi andrea.raimo...@gmail.com [firebird-support] wrote: > if I manage to keep the size small enough, it may be doable. With Delphi - no. > I know, only one copy is placed in memory, but you still need 1 copy per > application on disk. No, you don't need to

Re: [firebird-support] Re: Interbase vs Firebird

10.03.2017 13:59, lis...@warmboot.com.br [firebird-support] wrote: > If you are speaking about Change Views feature, I understand its main > purpose is to help mobile applications to update local copies of > (changed) data easily. Yes, this is the main purpose of Change View (sorry, I messed

Re: [firebird-support] Interbase vs Firebird

10.03.2017 9:39, 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] wrote: > But there is some performance/scaling problem showed and i am interested > about your opinion It is funny that they think that their Changes Tracking API can be used for replication of

Re: [firebird-support] Re: firebird 3.0 ten times slower than 2.5 ?

08.03.2017 12:20, Michal Kurczabinski michk...@gmail.com [firebird-support] wrote: > is still difference between 2.5 and 3.0:for select first 100 * > (now over 100% of time fb 2.5) Show "gstat -h" from both databases. -- WBR, SD.

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

14.04.2017 21:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > select count(*) remote is fast > Total execution time: 0.386s If you use isql instead of Flame Robin/IBExpert does it make any difference? -- WBR, SD.

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

14.04.2017 21:27, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I don't think Just try. -- WBR, SD. ++ Visit

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

14.04.2017 22:01, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > this is just firebird specific? No, Oracle is the same. -- WBR, SD.

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

14.04.2017 20:50, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > on another table,same db, with 7 records and 12 columns takes * 2.362s* Is result the same if query is executed from server or if count(*) is requested instead of whole data set? -- WBR, SD.

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

14.04.2017 21:40, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > indeed is faster Working with Firebird via high latency network require very careful application design and development. You, literally, must count every round trip to server and every received byte. -- WBR,

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

02.08.2017 15:20, Jorge Gonçalves projo...@gmail.com [firebird-support] wrote: > Any idea how to prevent this problem to appear again in the future ? > > FB Version : 2.5.2.26539 Restore your database from backup and never use nbackup with this bugged FB version any more. -- WBR, SD.

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

03.08.2017 11:00, Jorge Gonçalves projo...@gmail.com [firebird-support] wrote: > From which version is safe to use nbackup ? Always use the latest release. For 2.5 it is 2.5.7. But even with this it is not guaranteed to work. Check list of nbackup-related bugs in tracker:

Re: [firebird-support] Firebird slowdown.

15.08.2017 18:50, anderphil...@hotmail.com [firebird-support] wrote: > 4x Intel(R) Xeon(R) CPU X5650 @ 2.67GHz > > physical memory: 4096 MB > 7gb disk free > > Firebird 2.5.3 x64 super server > Windows 2008 R2

Re: [firebird-support] Automation tools?

15.08.2017 15:36, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > We're in need of a tool where we can author sequences of SQL queries against > FB and non-DB > commands like file operations etc. I'd like to call them "batch runs" to > perform recurring > tasks. >

Re: [firebird-support] udf with paramters problem

11.08.2017 11:09, keith prosser prosse...@yahoo.com [firebird-support] wrote: > I'm fairy sure its to with pointers and data. No, it is about calling conventions. UDFs use cdecl, not stdcall. -- WBR, SD.

Re: [firebird-support] permissions nbackup

14.08.2017 17:21, Nick Upson n...@telensa.com [firebird-support] wrote: > if I do nbackup . it fails, telling me I cannot access the security2.fdb > (as a normal > user) Why can't you use su to change current user to root or firebird? -- WBR, SD.

Re: [firebird-support] permissions nbackup

14.08.2017 17:44, Nick Upson n...@telensa.com [firebird-support] wrote: > because this is from cron, so key-based auth is out and I don't want to put > passwords / > keys on the server According to google you don't need password for cron jobs:

Re: [firebird-support] permissions nbackup

14.08.2017 18:00, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > I manage a couple of databases > located on servers I don't have root accounts on, and it's possible, > although more complicated. If you have sysdba permissions, you can do nbackup via services.

Re: [firebird-support] Re: Automatic Firing of Query.

17.08.2017 11:32, anshuman.na...@airtelmail.in [firebird-support] wrote: > These queries are getting fired on its own even when there is no action taken > in the > system at a particular time interval. Not only that, these queries are > getting fired > even at the time when there are only

Re: [firebird-support] Re: How can one rename a table in Firebird 3.0

13.07.2017 11:08, dam...@wxs.nl [firebird-support] wrote: > Does it mean that the old method is blocked in Firebird 3.0 and later? Creating of a view is an old method. Firebird 3 just prohibit hacks with direct changes of system tables. -- WBR, SD.

Re: [firebird-support] How can one rename a table in Firebird 3.0

12.07.2017 18:13, dam...@wxs.nl [firebird-support] wrote: > my question is does someone know a method in Firebird 3.0. CREATE VIEW new_name AS SELECT * FROM old_name -- WBR, SD.

Re: [firebird-support] Firebird Connection String

22.07.2017 19:28, ajc4pyilyfqeryixt3gvm2tqmwze4i33cooea...@yahoo.com [firebird-support] wrote: > Any suggestions??? Read Firebird Quick Start Guide. Everything you do is completely wrong. -- WBR, SD.

Re: [firebird-support] Re: witch vresion of Firebird to choose for Delphi 7 and IBX 7.09

28.06.2017 19:44, safirh...@yahoo.fr [firebird-support] wrote: > is there any conflict betwene interbase gds32.dll , and firebird gds32.dll > .? Yes. They are quite different and Firebird client won't work with Interbase server good. Contrary is true as well: Interbase client will have

Re: [firebird-support] Error writing data to the connection OR Error reading data from the connection

26.04.2017 13:42, Roland Turcan k...@rotursoft.sk [firebird-support] wrote: > Firebird.log file shows only lines with 10054 and nothing else. Is it server log or client log? > How can I find out the reason why a user is kicked off from > connection? If it was server log, the reason is

Re: [firebird-support] Error writing data to the connection OR Error reading data from the connection

26.04.2017 15:15, Roland Turcan k...@rotursoft.sk [firebird-support] wrote: > Customer reports that it happens in heavy work too therefore I think > it must be something else than power saving on card. > > It is also true, that this started to appear after some Windows 10 > Update. Time

Re: [firebird-support] Error writing data to the connection OR Error reading data from the connection

26.04.2017 14:51, Roland Turcan k...@rotursoft.sk [firebird-support] wrote: > What else can I check? Network cards, cable, commutators and firewall/antivirus between this server and 192.168.0.222. Make sure that network cards has "enable to turn off this device to save power" setting

Re: [firebird-support] Performing bulk update taking time.

27.04.2017 9:03, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Is there a way through which this query can be further optimised as this > query taking time > for completion more than 3 -4 hours. Could I use batch based update in this > qu ery…? Query in FOR SELECT does not

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

04.08.2017 20:37, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > Unfortunately, in your later post you suggested that nbackup is never safe to > use. Sure, as any other software it may have destructive bugs. Every software license has words like "this software is

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

04.08.2017 18:52, Jesus Garcia jeg...@gmail.com [firebird-support] wrote: > As I understood he was saying to not use nbackup, and if one person involved > in any way to > firebird says not to use it, then what make him think to others? There is a difference between "do not use it" and "do

Re: [firebird-support] Table Size

11.05.2017 1:56, dres...@tbinc.com [firebird-support] wrote: > The results are pretty raw data--something like a pie chart would be nice. IIRC, IBSurgeon have a graphical tool for that. Look at www.ibsurgeon.com. -- WBR, SD.

Re: [firebird-support] Table Size

09.05.2017 21:59, dres...@tbinc.com [firebird-support] wrote: > Does anyone have any tools that they can recommend that could help me easily > manage this? gstat -- WBR, SD.

Re: [firebird-support] Why backlash do not raise parser error

20.06.2017 12:42, 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] wrote: > Why backslash does not raise parser :error? It does: > Database: S_TEST, User: SD > SQL> Select * from rdb$relations\ R > CON> Inner join rdb$relation_fields rf on rf.rdb$relation_name =

Re: [firebird-support] Can anyone advise the difference between Firebird 2.5 32 bit vs Firebird 3 32 bit?

23.06.2017 11:15, 'Vonica Tng (Madsoft)' vonica@madsoft.com.sg [firebird-support] wrote: > Can anyone advise the difference between Firebird 2.5 32 bit vs Firebird 3 > 32 bit? Read Releas Notes. -- WBR, SD.

Re: [firebird-support] Installing Firebird during the installation of my product

19.05.2017 14:15, 'stwizard' stwiz...@att.net [firebird-support] wrote: > Is there any way to install firebird silently as part of my installation app? > > Any documentation on how to do this for a single computer? And possibly > later how to do > it for a server and client install? RTFM

Re: [firebird-support] Ask : firebird 1.5 to firebird 2.5

02.06.2017 8:54, 'Vonica Tng (Madsoft)' vonica@madsoft.com.sg [firebird-support] wrote: > What is the size of the database that we can test to show the speed > significance between > Firebird 1.5 and Firebird 2.5? One terabyte should be enough. But what's the point to migrate to 2.5

Re: [firebird-support] Ask : firebird 1.5 to firebird 2.5

01.06.2017 4:20, 'Vonica Tng (Madsoft)' vonica@madsoft.com.sg [firebird-support] wrote: > If our software running on firebird 1.5 and now going to move over to > firebird 2.5, > > technical-wise, what are the points we can convince people to change over? Firebird 1.5 is not supported by

Re: [firebird-support] Firebird Server 64 Bit With 32 Bit Clients on Remote Machines

15.06.2017 4:40, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > Is it correct to have Windows 32 clients on remote machines connecting to 64 > Bit > Firebird-3.0.2.32703_0_x64. It does not matter. Any Firebird client can work with any Firebird server. -- WBR, SD.

Re: [firebird-support] remote connection disconnection

31.05.2017 15:48, James mallee@gmail.com [firebird-support] wrote: > Or this issue is caused from Ubuntu ddclient DDNS service? Usually this issue is caused by provider's hardware. Cisco routers have by default connection inactivity timeout turned on. Try to set DummyPacketInterval to

Re: [firebird-support] error 10054

20.09.2017 14:24, 'Sabbagh, Nariman' nariman.sabb...@delta.com [firebird-support] wrote: > Ames keeps hanging and it is because of firebird giving error 10054. Actually, it is contrary: Ames (whatever it is) hangs, get killed that that end up in error 10054. You should test your network

Re: [firebird-support] Explicit Login with Windows Domain username

20.09.2017 16:40, 'Nikolaus Kern' parzival1...@gmx.at [firebird-support] wrote: > How do I format the username that it will work? No way to make it work. -- WBR, SD.

Re: [firebird-support] Connected databases to the Server

07.10.2017 22:57, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] wrote: > Which databases are connected, right now? Use MON$ATTACHMENTS with SYSDBA rights. -- WBR, SD.

Re: [firebird-support] Service restore from stdin

04.10.2017 11:42, Pavel Cisar pci...@ibphoenix.cz [firebird-support] wrote: > Until stdin is fully transmited service may need another > chunk, but reply to application is blocked until stdout buffer (eof > request) is full, so everything gets stuck (service will not ask for > further input

Re: [firebird-support] Service restore from stdin

04.10.2017 16:24, Dimitry Sibiryakov wrote: >   I.e. server just wasting network throughput requesting no data from client > as if > request timeout is by default set to zero instead of infinity. Oops, I was wrong: even explicitly set timeout don't make service to wait before sending

Re: [firebird-support] Service restore from stdin

04.10.2017 11:42, Pavel Cisar pci...@ibphoenix.cz [firebird-support] wrote: > You can't use isc_info_svc_line for sending backup file to the service. But that's what fbsvcmgr does. > The right token is isc_info_svc_stdin. No, it is only for getting buffer size from server. I have no idea

Re: [firebird-support] Service restore from stdin

04.10.2017 18:28, Pavel Cisar pci...@ibphoenix.cz [firebird-support] wrote: > Nope, without requesting isc_info_svc_line output you can't know when > service actually finished, so you may close the service at will. If you > close it *after* its finished then everything is ok, but if not, you >

Re: [firebird-support] Backup Firebird 3.0.2 database using Service Manager

09.10.2017 16:08, pierr...@gmail.com [firebird-support] wrote: > If I try to use a remote connection to service_mgr RTFM -expected_db. -- WBR, SD.

Re: [firebird-support] FreeAdhocUDF and Firebird 3 not working

08.09.2017 1:10, ke...@dojitraders.com [firebird-support] wrote: > I thought it better to mention the FreeAdhocUDF issue otherwise it would be > my fault that > my own UDF does not work! The authors of FreeAdhocUDF can make mistakes different from you. You must not take conclusion that

Re: [firebird-support] Any 'run as' in SQL/PSQL in FB3 ?

30.08.2017 17:58, hamacker sirhamac...@gmail.com [firebird-support] wrote: > To run, I need to know user and password and I don´t. No, you don't. If you provide role name only, current user will be used. -- WBR, SD.

Re: [firebird-support] Any 'run as' in SQL/PSQL in FB3 ?

30.08.2017 21:15, hamacker sirhamac...@gmail.com [firebird-support] wrote: > Here in fb3, to put role name in execute, Its mandatory put username and > password too. I was wrong a little, but still you should read the documentation: > - if ON EXTERNAL DATA SOURCE clause is omitted then >

Re: [firebird-support] Problem with linked table

07.09.2017 19:48, Adriano Novelli adrianonove...@yahoo.it [firebird-support] wrote: > What should I do to read data from the tables linked from every pc and not > just that with > which I linked the tables? Learn more about client-server technologies. You must install Firebird server on

Re: [firebird-support] Embedded FB3 was killed?

28.09.2017 12:25, Matthias Hanft m...@hanft.de [firebird-support] wrote: > As far as I understand that, I just call "fbclient.dll" as usual, > and if the database path is a local file, "fbclient.dll" automagically > calls "engine12.dll" (or whatever it needs) for the use as a local/ > embedded

Re: [firebird-support] embedded database with Chinese path

03.10.2017 11:05, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Forgive me for butting in, but... Perhaps it's high time to change FB > then? Unicode is "everywhere" these days, and FB should keep up. It is a lot of work, so the path

Re: [firebird-support] embedded database with Chinese path

03.10.2017 2:25, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > Any ideas? Give up. Firebird does not support unicode characters in database name and path. Only ANSI. -- WBR, SD.

Re: [Graymail] [firebird-support] Service restore from stdin

03.10.2017 16:43, 'Sabbagh, Nariman' nariman.sabb...@delta.com [firebird-support] wrote: > Does anybody know what the server name is I used 'localhost' but AFAIU it should be irrelevant. -- WBR, SD.

[firebird-support] Service restore from stdin

Hello. When I use isc_info_svc_line for sending a piece of backup to server, everything works well. But when I use just replace isc_info_svc_line with isc_info_svc_to_eof, no errors is produced, but database is not restored. Do I something wrong or it is a bug (incomplete

Re: [firebird-support] Transaction Management Failing?

26.09.2017 12:10, 'Robert Harris' rob...@zzyzxl.com [firebird-support] wrote: > The logic is that straightforward. The InsertMyData inserts lines of an > invoice or any > other customer transaction into ledgers, each identified by a transaction > number. The > problem is that when the issue

Re: [firebird-support] Cast as domain in view - wrong datatype

24.08.2017 14:49, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > View GTIN field is "exported" as varchar(20), instead of decimal(14,0). > Am I doing domething wrong or could be a bug? Because of your "else '' end as GTIN" server has no choice. Result of whole CASE

Re: [firebird-support] UDF or/and maybe Charset problem

24.08.2017 15:07, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > is there any problems if I just declare all UDF's with FREE IT? Yes, server will have problems trying to free memory that wasn't allocated. -- WBR, SD.

Re: [firebird-support]

24.08.2017 20:00, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > It´s "fixable"? First, make versions of client library and message file match server. Second, you cannot create primary key on nullable field. -- WBR, SD.

Re: [firebird-support] Spatial extensions...

26.08.2017 18:01, prosse...@yahoo.com [firebird-support] wrote: > I'm bored and need a challenge... I'd really like to add spatial support to > firebird so > how do I sign up?   I've been programming in C, C++ and Delphi for 30 years > and now I can > write what I want to write! Fork your

Re: [firebird-support] UDF or/and maybe Charset problem

24.08.2017 11:37, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > result = (char*)calloc(j, sizeof(char)); You must use ib_util_malloc() to allocate memory in UDF and don't forget FREE_IT in declaration to avoid memory leak. -- WBR, SD.

Re: [firebird-support] UDF or/and maybe Charset problem

24.08.2017 12:00, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > out = (char*)calloc(strlen(str), sizeof(char)); > result = (char*)calloc(j, sizeof(char)); Besides, here and there you forgot about space for terminating null char. -- WBR, SD.

Re: [firebird-support] Firebird Database to MYSQL Database conversion

28.08.2017 12:43, vamsi sagiraju vamsi...@gmail.com [firebird-support] wrote: > I am alien to Firebird database, having no idea about it, But we have to > migrate it to > MySQL database(Have good idea about it). So could any one please let me know > how to > convert the Firebird database to MY

Re: [firebird-support] Connect to FB database through VPN

01.09.2017 11:28, sntpywhl3bfbefeaicfmgdnmn3pewm6576tee...@yahoo.com [firebird-support] wrote: > Is there something different I should be doing to connect to a FB database > through a VPN? No. Media is irrelevant for TCP. -- WBR, SD.

Re: [firebird-support] Implicit path for Database

01.09.2017 23:35, Neagu nea...@gmail.com [firebird-support] wrote: > Will be good also a way to specify the path where the databses are store > if I not specify a path in connect string. In firebird.conf set DatabaseAccess to Restrict. Databases will be created in the first directory in

Re: [firebird-support] Any 'run as' in SQL/PSQL in FB3 ?

30.08.2017 14:16, hamacker sirhamac...@gmail.com [firebird-support] wrote: > I am looking for an instruction to execute SQL block with elevate permitions. > I would like to know if exists how to execute pSQL as another role (or user) > or SQL > update/insert/delete. RTFM Execute Statement on

Re: [firebird-support] "Invalid Cursor State"

17.10.2017 20:12, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > What am I doing wrong? You cannot fetch from non-select query. -- WBR, SD.

Re: [firebird-support] Trouble establishing a connection to Firebird database files.

27.11.2017 11:35, Justis Root justis.r...@gmail.com [firebird-support] wrote: > What should I be checking first? First of all, carefully read error message. It usually contain a reason of failure. > What info am I missing from this description in order to make assisting me > easier? The

Re: [firebird-support] Re: query with no result

24.11.2017 11:22, alauren...@gmail.com [firebird-support] wrote: > Because of that matter, I manufacture that query :) Remove TEMPSUB from FROM clause. -- WBR, SD.

Re: [firebird-support] Deadlock error from firebird during midnight

30.11.2017 14:31, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Interesting part is this error occurs only at midnight from 12 to 2 AM. > Thereafter, > everything goes smoothly without any error. I tried replicating this on my > test machine > but no success. > > On analysing

Re: [firebird-support] Re: Deadlock error from firebird during midnight

14.12.2017 11:25, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > I need to keep my deployed application running, and would happily trade off > connection > pooling/SMP etc for robust connection. Any suggestions please ? First of all, look into firebird.log. Perhaps,

Re: [firebird-support] Re: Deadlock error from firebird during midnight

14.12.2017 11:34, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: >  INET/inet_error: read errno = 10054, client host = RajivPC, address = > 192.168.42.134/52754 , user = rdsc1 If these data match your .NET application, then you have problem with

Re: [firebird-support] Re: Deadlock error from firebird during midnight

14.12.2017 12:03, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 1. Here server and client both are on the same machine, RajivPC. It does not matter. Still there is software (and may be even hardware) between server and your application. > 2. Execution of only one stored

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

Re: [firebird-support] Lock Conflict

15.12.2017 12:04, OB1 oldbasf...@googlemail.com [firebird-support] wrote: > Yes. A pre-insert on both that checks the data and assigns a PK from a > generator if one's > not assigned. Also checks valid data has been assigned and sets NEW.blah.  No > interaction > with other tables in anyway.

Re: [firebird-support] Re: Deadlock error from firebird during midnight

14.12.2017 9:00, hv...@users.sourceforge.net [firebird-support] wrote: >> 1. The PID remains same: 4212, before and after the exception is caught. > >   I.e. there was no crash of Firebird, very good. But still Firebird that just dropping connection instead of returning a proper error is

Re: [firebird-support] Re: Deadlock error from firebird during midnight

14.12.2017 12:27, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 1. No, I did not. How do I do this? Google is your friend. For example: https://stackoverflow.com/questions/41980813/firebird-net-provider-and-embedded-server-3/41981523#41981523 -- WBR, SD.

<    1   2   3   4   5   6   7   8   >