19.12.2017 4:32, FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support]
wrote:
> Wireshark traces show that the server is sending all the data from the query,
> but the
> client is not recognising it and waits forever
So, you, actually, should ask Embarcadero why their client cannot
11.11.2017 13:15, m_brahi...@yahoo.fr [firebird-support] wrote:
> All fields contained in the PK are updated is that mean by operations
> affected ?
No. Operations are: select, insert, update, delete. Update may change PK
values or not,
select can do index scan or full scan. All this are
21.11.2017 10:01, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> How can I copy all records of a table to another table in different database.
> The tables
> having same design.
Use "execute statement on external datasource".
--
WBR, SD.
21.11.2017 15:52, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> Please see if the under mentioned procedure is good enough:
I would do the contrary: select on external source and local insert. It is
better for
performance. But if your SP work for you, it is good.
--
16.11.2017 12:20, michael.vilhelm...@microcom.dk [firebird-support] wrote:
> I do know, that its a onetime thing, but if Ihave to wait for it to finish
> all I want to
> change, I will not do it.
Run script in evening, get results in morning.
--
WBR, SD.
15.11.2017 7:49, Anto Edin Charley antoedinchar...@gmail.com [firebird-support]
wrote:
> For every Level 2 Backup it takes more than 30 Minutes to complete. Is there
> anything i
> need to Check/Improve
1) Try switch -d. NBackup should work at disk's speed.
2) You can migrate to Firebird 3
11.11.2017 11:13, m_brahi...@yahoo.fr [firebird-support] wrote:
> I need to know please if it is allowed that a primary key has multiple
> integer fields ?
Yes, but usually it is a sign of a bad database design.
> a PK that has seven integer fields will it decrease the performance table ?
05.12.2017 10:07, Marcel Brink mbr...@xploration.onmicrosoft.com
[firebird-support] wrote:
> Does anyone have an idea why this happens only after around 20 minutes and
> not every time ?
You should, probably, turn performance counters output in trace as well. May
be in
these 20 minutes
08.12.2017 11:56, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> I don't agree with this. The string literal is in the connection
> character set, but the value should be converted to the target character
> set (of the column) for the comparison
No. Imagine connection charset
08.12.2017 12:07, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> It should return no results. If it can't transliterate, it means that
> the character definitely does not exist in the target column, so the
> comparison is false.
When character is transliterated into charset
07.12.2017 18:46, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> Why does the connection charset count?
Because you are sending queries in connection charset. And string literals
in them are
in connection charset. Because of that your 'x' cannot have COLLATE PXW_HUNDC.
--
12.12.2017 7:32, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> “Error reading data from the connection” has again surfaced
This is a server crash. This instruction may be useful for you to help
developers fix
it: http://ibphoenix.com/resources/documents/development/doc_35
12.12.2017 13:28, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> 1. I have generated DMP files for :
> (a) The Firebird server - size 62,028 KB and
> (b) My .NET Application - size 2,65,968 KB
>
> 2. Please let me know how do I share these DMP files.
If your database does not
01.12.2017 17:32, j...@codework-solutions.com [firebird-support] wrote:
> I got this errors only during midnight. Thereafter it's working fine.
It may pretend to work fine, but using default transaction isolation level
in .NET
provider is just a disaster waiting to happen. It is the reason
31.10.2017 20:44, m_brahi...@yahoo.fr [firebird-support] wrote:
> Is there a document which explains that ?
https://en.wikipedia.org/wiki/Ephemeral_port
--
WBR, SD.
04.05.2018 18:13, Steve Naidamast blackfalconsoftw...@outlook.com
[firebird-support] wrote:
> If you look at my procedure below, you will note that there is only a single
> "SUSPEND"
> statement.
If you look a little more, you'll see that it is called in a loop.
--
WBR, SD.
04.05.2018 20:10, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> Nonetheless, I have worked with Oracle, Sybase, MySQL, and a little
> PostgreSQL and SQLite.
I can't believe that you never looked at Oracle's FOR LOOP syntax in
pipelined
functions which difference from Firebird
07.05.2018 12:19, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> A simple example: SELECT ''='' SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM
> RDB$DATABASE
>
> Why is the result true?
Your expression is actually calculated as "CAST(''='' as CHAR(5)) SIMILAR TO
07.05.2018 7:43, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I'm looking for a way to run a simple update on couple tables without calling
> triggers
Modify your trigger to check some context variable and skip actions. Then do
something
like that:
EXECUTE BLOCK AS
declare
07.05.2018 13:57, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> So I see what you say. But result of
>
> SELECT CAST(''='' AS CHAR(5)) SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM
> RDB$DATABASE;
>
> is
>
> ===
>
Perhaps, it must be CHAR(4) or VARCHAR. I'm not sure in type of
04.05.2018 4:55, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote:
> what other regular maintenance actions does Firebird need in order to
> function properly?
It may be a good idea to recalculate index statistics from time to time.
--
WBR, SD.
04.05.2018 11:42, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote:
> the single badly designed query with many page fetches can "improve" this
> parameter a lot,
> without any real improvement in the performance, of course.
The question was about cache effectiveness which is always
08.05.2018 16:28, ymak1...@yahoo.com [firebird-support] wrote:
> Any ideas?
Do not use CHAR_TO_UUID(). Store and use GUIDs in binary form using
parametrized queries.
--
WBR, SD.
14.05.2018 22:18, 'livius' liviusliv...@poczta.onet.pl [firebird-support] wrote:
> maybe this is wrong?
> GenIntOutMessage = record
> result: Integer;
> resultNull: WordBool;
> ss: PAnsiChar;
> ssNull: WordBool;
> end;
Yes, this is wrong. Buffer must
10.05.2018 8:47, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
wrote:
> Thank you for the suggestion. We will consider RAM disc uses but first we
> must be sure how
> big it should be to catch all cases.
It, actually, doesn't matter. If you configure several temporary
10.05.2018 15:12, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
wrote:
> We have no way of debugging every single one of the applications being run,
> and there is no single obvious operation that could justify this high cpu
> usage.
>
> Is there a way to monitor queries not only
10.05.2018 13:19, OAZEZ Software - José Eduardo joseedua...@oazez.com.br
[firebird-support] wrote:
> 5) alter database encrypt with "cryptdb.dll";
Name of the plugin is "cryptDb", not "cryptdb.dll".
--
WBR, SD.
13.05.2018 19:21, B?lint Nagy bali...@hotmail.com [firebird-support] wrote:
> Any ideas?
The error is not related to connect. Something is wrong with some query
parameters.
--
WBR, SD.
04.05.2018 14:04, antoedinchar...@gmail.com [firebird-support] wrote:
> Is there any way we could create a table in Firebird using the query?
No. Firebird cursors (implicit and explicit) are more powerful than MS SQL's
ones and
let developers avoid local temporary tables completely.
--
16.05.2018 4:48, fabia...@itbizolutions.com.au [firebird-support] wrote:
> Does anyone have experience with bulk updates via isql? Would it be X times
> faster than using a normal application inserting the records inside a begin
> transaction and commit at the end?
No, because it is exactly
19.05.2018 17:12, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
wrote:
> I have below table requirement, where the data should be subtracted for each
> record in the
> row. For each group subtraction should be separate.
It looks like you need something like "SUM(In_Val-Out_Val)
15.05.2018 6:54, 'livius' liviusliv...@poczta.onet.pl [firebird-support] wrote:
> what kind of buffer?
It depends on information in IMessageMetadata.
> I have tried:
> ss: Array[0..199] of Char;
> ss: Array[0..199] of Byte;
> ss: Array[0..199] of AnsiChar;
This is a right declaration for
09.06.2018 13:52, Norbert Saint Georges n...@tetrasys.eu [firebird-support]
wrote:
> so he must miss something but what?
Whole chapter "Database information request buffer and result buffer" in
Interbase API
Guide. Don't let chapter name to confuse you: buffer formats are the same for
all
07.06.2018 13:43, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
wrote:
> Partition and Order BY is not useful to get the expected result as discussed
> in previous mail.
On contrary, partition AND order by is exactly what you need. Read
documentation that
Vlad suggested.
--
07.06.2018 11:14, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
wrote:
> Attached snap, since it is not displaying in message body.
It is useless: no attachments in this list allowed.
You must cooperate with DBA and system administrator to analyze performance
problems.
It is
13.06.2018 9:54, meanbe...@yahoo.com [firebird-support] wrote:
> On some servers we encounter a sudden reboot after FB install. Version is
> 2.5.7.27050 64
> bit. It's happening on a variety of operating systems, even just a client
> install. The
> reboot happens suddenly without asking any
13.06.2018 8:47, Mourad Hedfi mou...@bilog.fr [firebird-support] wrote:
> "You must use "wait" transaction for metadata changes. " ==> What command I
> must add for
> that ?
https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-transacs-statements.html
12.06.2018 16:38, Mourad Hedfi mou...@bilog.fr [firebird-support] wrote:
> Yes, the problem is reproduced on EMS but not with Flamerobin.
The difference between them is in transaction parameters. Transaction with
"nowait"
flag can get "object in use" error even of the object is not really in
Hello, All.
After call fb_cancel_operation(fb_cancel_abort) is it needed to call
isc_detach_database() to free attachment handle?
Can the isc_detach_database() call be successful or I must ignore any
returned error?
--
WBR, SD.
30.05.2018 10:45, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
wrote:
> it redirect info to the file but errors are not redirected - why?
You forgot ">" before "%FB_RESTORE%\rest.security3.rep".
--
WBR, SD.
31.05.2018 18:14, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> However, maybe Firebird 3.x.x does NOT allow this as Carlos' manual
> suggests...
I've just trued:
SQL> show version;
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-V3.0.2.32703 Firebird
04.06.2018 8:22, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote:
> So even after trying as you suggested, can't able to get the result as shown
> below:
What exactly you tried and what you got?
--
WBR, SD.
02.06.2018 21:27, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> Does anyone have any idea what is going on here???
32 bit applications cannot use 64 bits libraries and vice versa. That's how
modern
computers work.
--
WBR, SD.
27.05.2018 18:03, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote:
> In addtion to Mark Rotteveel’s description of the system tables, you might
> want to look at
> the code in isql which supports the -x command. It should include everything
> to create a
> complete DDL script
26.06.2018 15:05, Miguel Rozsas mig...@apice.com.br [firebird-support] wrote:
> echo "show tables;" | /usr/bin/isql-fb -user whatever -pas whatever
> machine:dbalias
>
> The problem with the above is the connection is not closed and the end of
> sql statement and it is still waiting a quit which
03.05.2018 7:56, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote:
> Firebird ver 2.5.7.27050 64 bits
> Windows Server 2012R2
>
> ¿Is there a way to calculate the effectiveness of incrementing the page cache
> buffer ?
select cast(mon$page_reads as double
01.05.2018 9:19, Brian Dunstan brian.duns...@health.telstra.com
[firebird-support] wrote:
> If we move to dialect 3, does the TID become 64 bits?
It is 48 bits in Firebird 3.
--
WBR, SD.
01.05.2018 7:57, 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support]
wrote:
> If you're implementing your own plugin, you can implement whatever you need.
Oh, really? How server plugin can affect what client utility does?
--
WBR, SD.
03.05.2018 16:11, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote:
> 1. When I need to copy my Firebird database: Do I need to shutdown the
> Firebird instance
> first? and If y es, what is the proper way to shutdown and startup it?
You may shut it down or use nbackup or use
03.05.2018 23:04, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> However, I though only the issuance one "SUSPEND" was enough to flush the
> entire buffer of
> all records...
No. One SUSPEND - one record in result set. Two SUSPENDs - two records and
so on.
Watch this in
19.10.2017 18:11, Tomasz Tyrakowski t.tyrakow...@sol-system.pl
[firebird-support] wrote:
> The real nightmare of a programmer is not when the program doesn't work
> and she/he doesn't know why; it's when the program does work and she/he
> doesn't know why :)
20.10.2017 5:45, gn7s...@gmail.com [firebird-support] wrote:
> I want to know whether the following index is picked by the optimizer.
You can know that if you run (or just prepare) the query in isql with "SET
PLAN ON".
--
WBR, SD.
05.01.2018 18:09, HuI HaO huihaoc...@hotmail.com [firebird-support] wrote:
> currently i have an application at client side runing a timer 5s keep do the
> select sql
> read the Table as status on server DB. after few day run the fb service hang
> up and slow
> respond the DB file size also
06.01.2018 15:19, m_brahi...@yahoo.fr [firebird-support] wrote:
> Heres is a sample code of the SP
There is no point in such SP. You'll get only bad performance and no
advantages.
--
WBR, SD.
08.01.2018 23:09, fredf...@hotmail.com [firebird-support] wrote:
> No exception raised but indexes ar e not ac tivated! What is wrong? How can I
> activate all
> indexes correctly?
1. Indexes are activated on commit.
2. You don't need to use script component in Delphi, "execute block" is a
11.01.2018 13:21, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> My understanding is that mend can not and it should not cause any troubles.
Your understanding is wrong. This switch is intended to save at least some
data from a
dead database with gbak. After you used it, database is
11.01.2018 9:14, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> Are there any ideas what happens and how to prevent it?
Do you run gbak with -g switch?
--
WBR, SD.
11.01.2018 11:29, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> No, we don't use -g.
You should.
> We are doing immedate restore anyway after each backup.
It is very doubtful practice. Immediate restore into different place is good
for many
reasons, but need in replacing
04.01.2018 17:13, Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
wrote:
> if I select between 01/01/2018 and 31/12/2018 I not have results! this
> because there are no rows in DT between 01/01/2018 and 31/12/2018.
That's right. No rows - no result. If you want this result, add
04.01.2018 16:55, Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
wrote:
> As you see:
> - if I select between 01/01/2018 and 31/12/2018 the are not rows in DT
> - if I select between 01/01/2017 and 31/12/2017 works fine because the
> are at least 1 row in DT
So, where is the
26.01.2018 13:37, daniel.acherm...@logismos.com [firebird-support] wrote:
> One of our customer is interested in the Firebird 3 feature of a "over the
> wire"
> connection encryption. This customer however prefers the AES-protocol instead
> of the
> default plug in with arc4.
AES can
26.01.2018 16:17, Salim Naufal s.nau...@softnet.me [firebird-support] wrote:
> I am not familiar with the details of the SQL standard, is this the proper
> was to round
> and calculate numeric values in SQL?
Yes. In your first examples you don't use floating point numbers, but exact
11.02.2018 22:03, iorip...@sina.com [firebird-support] wrote:
> How to find out witch tables and fields include this Value?
Dump whole database into text file(s) with IBexpert then grep.
--
WBR, SD.
09.02.2018 13:54, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> Are such values for max version dangerous? What can I do and what should I do
> not to avoid
> such large max version values?
They are not dangerous, but very unpleasant because make your database slow.
You must
10.02.2018 16:32, Aldo Caruso aldo.car...@argencasas.com [firebird-support]
wrote:
> I discovered that when a field is added to a table with a NOT NULL
> constraint and a default value, it is automatically filled with that
> default value.
No, it isn't. It would be too slow.
Default value
20.02.2018 0:31, Eduardo guse...@gmail.com [firebird-support] wrote:
> If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
> If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable database".
> If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable database".
>
> If I
22.02.2018 11:15, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
wrote:
> How to add permission to login into security3.fdb?
Locally you don't need any special permission. Remotely you must edit
databases.conf to
enable that.
--
WBR, SD.
22.02.2018 6:22, Alexander Tabakov a.taba...@eklektica.com [firebird-support]
wrote:
> So, generally speaking are there any benefits of embedding the credentials
> into the
> database - performance, security, other ?
You don't need to backup/replicate two databases, one is enough.
--
20.02.2018 16:36, dco...@sympatico.ca [firebird-support] wrote:
> I've Googled a lot about this and that -FIX_FSS_DATA option seems to only
> really be
> relevant when restoring DBs from much earlier versions of FB - but this is
> from the same
> version!
Version of engine doesn't matter
22.02.2018 20:07, Alexandre Vinhaes - Tecnico - Tecnologia
alexandre.vinh...@cipa.com.br
[firebird-support] wrote:
> I need to have a read only login (read all views and tables) for specifc
> application
> connection. Some those views executes procedures internally. So, in this
> case, select
21.02.2018 13:46, Alexander Tabakov a.taba...@eklektica.com [firebird-support]
wrote:
>
> What happens in case 3 (stored in the same database) when we move the
> database on a
> different server. Shall credentials stored in place take precedence over the
> other
> server's configuration?
03.01.2018 21:38, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> > Use isc_dpb_config hack.
>
> Which is? Please do not just drop vague hints, but actually provide an
> answer if you know it. Documentation and examples of the new API barely
> exist (or at least, I'm not aware of
03.01.2018 11:51, Mauricio Junqueira mau...@gmail.com [firebird-support] wrote:
> Is there a way to change WireCrypt and AuthServer in the Database Params
> Buffer?
Use isc_dpb_config hack.
--
WBR, SD.
04.01.2018 12:36, Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
wrote:
> The following query works fine but returns*all nulls* if no rows
> between :DaData and :AData
Are you sure that your query really returns all nulls and this is not a
visual bug in
the tool you run this
30.07.2018 12:01, wobble...@yahoo.co.uk [firebird-support] wrote:
> is there a good and up to date official source of documentation on
> firebird.conf and other
> admin?
Description of firebird.conf is inside of it.
--
WBR, SD.
27.07.2018 17:20, wobble...@yahoo.co.uk [firebird-support] wrote:
> Setting the optional size argument on "TempDirectories" in firebird.conf
> doesn't seem to
> work.
Description of TempDirectories in firebird.conf does not mention any
optional size
argument.
--
WBR, SD.
04.08.2018 11:44, Chuck Belanger phytot...@lanset.com [firebird-support] wrote:
> As far as I know NONE or OCTET is the closest thing to rawbyte, but as I
> mentioned (and
> another responded) the string is being truncated at the first #0.
Yes, that's the case for charset NONE. OCTETS must
27.07.2018 21:41, Helen Borrie hele...@iinet.net.au [firebird-support] wrote:
> I don't know where you got the idea that you could specify the size of
> a temp directory.
It is an Interbase feature.
--
WBR, SD.
27.07.2018 18:41, mailinglist.int.it.firebird.supp...@principledgroup.com
[firebird-support] wrote:
> client Fri Jul 27 11:15:30 2018
> /usr/sbin/fbguard: guardian starting /usr/sbin/firebird
>
> client Fri Jul 27 11:15:31 2018
> /usr/sbin/fbguard: /usr/sbin/firebird terminated due to startup
>
04.08.2018 0:49, Chuck Belanger phytot...@lanset.com [firebird-support] wrote:
> The above string is created and
> stored in a string just as you see it, but how do I store it in Firebird
> , preferably as-is in a table field?
Use field (VAR)CHAR CHARACTER SET OCTETS. Then "just store" your
07.08.2018 9:35, bieten2...@yahoo.de [firebird-support] wrote:
> it would be great if I where to receive an answer to this question :-)
> I am unsure whether the issue is so easy to answer that everyone thinks it is
> self explanatory
Sort files are created when you issue queries with plan
20.08.2018 22:07, Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]
wrote:
> Any other solution that will work?
It depends on what kind of cluster and for what purpose is needed. Simple
master-slave
failover is included into HQBird.
--
WBR, SD.
20.07.2018 10:27, 'Jelich, Michael' michael.jel...@commscope.com
[firebird-support] wrote:
> We currently use FireBird 2.5.7 with a ‘self-made’ UDF-dll. It contains
> (beyond others)
> the following functions
Does the library contain also line "IsMultithreaded := true" in
initialization
17.07.2018 14:21, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
wrote:
> the questions:
ANSI standard compliance is the answer for all questions.
--
WBR, SD.
18.07.2018 15:42, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
wrote:
> Yes, but as local_time and local_timestamp was forwarded to FB3 it is
> important to know if
> we need also Local_date as replacement to Current_date in FB3. Then we must
> know FB4 TZ
> configuration
24.07.2018 9:42, eric.gueguin...@gmail.com [firebird-support] wrote:
> Could you explain why the result of this queryis not the same with FB3 and
> FB25 ?
Because Firebird 2.5 has i18n module mostly broken.
--
WBR, SD.
23.07.2018 8:54, 'Jelich, Michael' michael.jel...@commscope.com
[firebird-support] wrote:
> Yes, it does. The dpr code is as follows:
>
> begin
> System.IsMultiThread := true;
> Randomize;
> end.
Did you check that this code is really executed? I'm sure about execution of
initialization
19.07.2018 1:31, Chuck Belanger phytot...@lanset.com [firebird-support] wrote:
> Does anyone have any ideas on what I need to do to keep connected to the
> remote (VPS) Firebird server?
Best of all you must find the router (most likely it is CISCO) that has
"drop inactive
TCP connections"
16.07.2018 15:56, Issam Boughanmi amigof...@gmail.com [firebird-support] wrote:
> is it possible to set custom path for the lock and temp files in firebird 3
> embedded via
> config file or anything else ?
Yes, temp files directory are configured in firebird.conf or FIREBIRD_TMP
environment
24.07.2018 13:46, eric.gueguin...@gmail.com [firebird-support] wrote:
> In fact I wanted the result of FB25 (without accents)
> It is possible to remove accents by using charset with FB3 in the select
> clause ?
No.
But why do you want that? Accent-insensitive comparison and sort is
24.07.2018 14:31, eric.gueguin...@gmail.com [firebird-support] wrote:
> By example how to do that :
>
> SELECT IDSYSCONFGROUP FROM SYS_CONF_GROUP
> WHERE UPPER(CAST(SYSGROUP_NAME AS VARCHAR(100) CHARACTER SET ISO8859_1)
> COLLATE
> FR_FR_CI_AI) = 'CAMERA'
>
> SYSGROUP_NAME can be written
08.07.2018 16:31, 'Chris LeFebvre' lefebv...@comcast.net [firebird-support]
wrote:
> So what am I doing wrong and how can I remove this column?
Error 336068795 is "field is referenced in index". So, you missed one index
while removing.
--
WBR, SD.
06.07.2018 10:45, 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]
wrote:
>> With GCC "-fvisibility=internal" can be used to suppress exporting of
>> all symbols.
> We currently use -fvisibility-inlines-hidden and -fvisibility=hidden for
> clang...
But still framework somehow
06.07.2018 2:34, Hamish Moffatt ham...@risingsoftware.com [firebird-support]
wrote:
> Here are a couple of example traces. As you can see neither of these involve
> our
> application code, they are pure macOS framework threads, except that fbintl
> is in the trace.
It looks like fbintl
08.03.2018 12:44, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> Just wanted to know if there is available free (of charge) C++/C compiler for
> Firebird 3
> UDFs on Windows - 32 bit and 64 bit?
GCC (MinGW).
--
WBR, SD.
13.03.2018 9:30, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> and in Firebird 3 when using the old API (most applications use
> the old API).
Actually 64k limit is applied to statement in ISC API only if length of
statement is
indicated explicitly and function declarations
03.04.2018 7:19, 'Joje' j...@codework-solutions.com [firebird-support] wrote:
> _Trigger that calls generator is fired on insertion:_
Try to add some logging into this trigger to detect cases when record is
inserted with
application-provided _ID and thus generator is not used.
--
WBR,
06.04.2018 13:57, atuncce...@duzen.com.tr [firebird-support] wrote:
> Is the IP expression in the logs show the IP of the client? If yes, how do I
> decode it? :)
It shows IP register of CPU at the moment of crash.
You can track the crashes using core dump as described in
10.04.2018 22:16, j...@firstduews.com [firebird-support] wrote:
> I am trying to migrate my IB database to FB. When I do the backup/restore
> process It
> errors on on a table.
You cannot migrate database between Interbase and Firebird using
backup-restore. They
are different DBMS now.
18.04.2018 12:24, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
wrote:
> I want to use TSQL in Firebird
Give up. Firebird supports standard SQL to some extend. T-SQL supports
standard SQL to
some extend. Firebird has no support for T-SQL.
--
WBR, SD.
301 - 400 of 701 matches
Mail list logo