Hello Alan,
Im using now the extract function an there is 0 = Sunday, 1 = Monday I think.
It’s Friday here today:
select f_dayofweek(current_timestamp) from rdb$database
returns 6
On 8/29/19 4:45 AM, m.djo...@gmail.com [firebird-support] wrote:
>
> In binary representation of the values maybe 4.72 is the closest, but
> we are talking about mathematic.
> This is from the description of the ROUND function in the documentation:
> Rounds a number to the nearest integer. If th
Hello Kjell,
then I have to do the mapping between Monday = 1, Tuesday = 2, Sunday = 0. But
I can only select the value with an execute statement.
I will test it, thank you. 😊
WHEN F_DAYOFWEEK(J.COMMDATE)=1 /* Sunday */
??
Alan McDonald
>> DummyPacketInterval = 0 (but this should be irrelevant for this type
>> of issue)
>Try to change it. This _is_ relevant for this type of issue.
That did the trick. Thanks, Dimitry!
Regards
Stefan
What did you change it to?
Alan
Posted by: Stefa
>> that does not work - Unknown Column error -206
>
> RTFM Language Reference. In SQL queries PSQL variables must be used with
> colon.
Please mind your tone: you could have phrased that a little bit more friendly
and less hostile.
Mark
--
Mark Rotteveel
+2
>>I use Firebird primarily with Delphi and have had no problems with using and
>>displaying dates >>(suitable for my country - UK.)
You can use this in your select statements for php:
f_dayofmonth(CREATEDATE)||'.'||f_month(CREATEDATE)||'.'||f_year(CREATEDATE)
CREATEDATE
format the PHP as
.
Better to co-host your own serer somewhere than use Azure. That was my decision.
Alan McDonald
0413 657 427
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, 21 June 2017 8:09 PM
To: firebird-support@yahoogroups.com
Subject
formatted text so it may not be suitable for your
needs
Alan McDonald
0413 657 427
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, 9 March 2017 9:48 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] ezSQL
/ALTER/DROP, but I still don't know if in Firebird 3.0 it will be
possible to enumerate/list the users (for any of the 3 security models).
I cannot speak for FB3 – not done any work there yet
Thanks again,
David
On Tuesday, February 21, 2017 4:19 PM, "'Alan McDo
"0S0DAVIESS";
GRANT RDB$ADMIN TO "0S0META";
GRANT RDB$ADMIN TO "0S0SLEGER";
GRANT RDB$ADMIN TO "0S0WARDK";
GRANT SELECT, INSERT,
UPDATE(FIRST_NAME,GID,GROUP_NAME,LAST_NAME,MIDDLE_NAME,PASSWD,UID), DELETE ON
USERS TO PUBLIC;
/* Privileges of views */
GRA
In a production environment using Firebird v2.5, we need to delegate authority
of USER CRUD operations to more than one person without these admins sharing
the SYSDBA user and password.
These admins have been created as users with ADMIN ROLE, and are logged in
under the RDB$ADMIN ROLE (eg in
Hi,
I am facing a DB corruption issue on firebird database. Everytime my
application tries to open connection or perform any DML activities, randomly i
get the following error.
ERR::I/O error during "CreateFile (open)" operation for file "database"
Error while trying to open file; FirebirdSql.Da
Hi
Is it possible to temporarily disable a FK constraint? I have found a couple
of requests for this feature dated 2009 but these still show as open. Did this
functionality ever get implemented ?
It would save me a lot of work :)
Thanks
Rob
It's easy enough to drop them all then re-create
I can reproduce this 'stalling' behavior. At the moment, the application is
importing records without delay. CPU consumption remains very low.
To stall FB, I will now run a query that will scan several thousands of records
that have just been INSERTed and UPDATEd. Before I run this query, her
Hi guys,
Since Zebedee for Java is a beta ver. and not maintain again, are there any
alternative to this program?
Thanks in advance.
Regards,
Anto
Linux or pc?
Hello Alan,
Thank you for your answer. I will download the FB Replicator try it and see if
it will work for me.
That part with the triggers i've already done. I have after I, U, D triggers
for every table and they insert into my replication log table. The problem is
that I used to put the sql
I am writing a two way server - client Firebird replication with a C# app and I
am facing the following problem. I have a log table with the table name pk of
the record and type of the query executet on it. For example if in the sales
table there has been inserted a line with primery key of 4 th
on
Is this intended behaviour? Why doesn't it respond from the gsec command
prompt?
Regards
Alan McDonald
Engine Code :335544721
Engine Message:
Unable to complete network request to host "localhost"
Failed to establish connection.
That means you are trying to use the TCP stack.
Alan
I have tried both fullpath (D:\my_app\myapp.FDB) and just filename (myapp.FDB)
and in both cases cannot connect.
Adam
And you are using cpLocal?
Alan
The database path I am using in both my app and IB_SQL.exe is simply the
atabase name "myapp.FDB".
When fb_inet_server.exe is running as a background process on the machine both
my app and IB_SQL.exe connect to the server and the app runs as I would expect.
Adam
_
I've only just recently installed the latest version of Firebird and developed
a small test application and associated fdb on a Windows 8 desktop. I've copied
the following Firebird files to the same folder as the exe but cannot connect
to an embedded Firebird:
icudt30.dll
icuin30.dll
icuu
Okey, thanks for clarifying, i'm having the same problem but with
FreeUDFLib, and i see in the FreeAdHocLib, it use the FreeUDFLib core file
to improve it. I thought it migth related.
You do need the intl folder and contents and you do need ib_util
Alan
Try to put gds32.dll in the system32 folder, AFAIK, FreeAdHocUDF depend on
FreeUDFLib which depend on GDS3.dll in the system folder
On Wed, Apr 16, 2014 at 4:58 AM, Thomas Beckmann
wrote:
That's not correct - I distribute embedded with FreeAdHocUDF and I never
place gds32, or any
Hi,
It's missed BLOBs, good that you have this, not critical errors.
Perform backup and restore.
Regards,
Alexey Kovyazin
www.ibsurgeon.com
What's a 'missed' BLOB?
Alan
Hi all,
i have this error repeated about 20 times when backing up my database:
gbak:error accessing BLOB
Hello Group,
Is it possible to take a backup of a 2.5 database whilst it is running in
embedded mode (Windows) and whilst that application is otherwise connected to
the database using the services manager (just like you can on the full server)?
I am presently getting an exception that the datab
Cast the result of the extract as a date or timestamp.
On 12/02/2014 6:20 AM, "Mark Rotteveel" wrote:
> On 11-2-2014 16:06, Virna Constantin wrote:
> >
> >
> > EXTRACT()
> > http://www.firebirdsql.org/refdocs/langrefupd25-intfunc-extract.html
>
> Extract is not the same as PostgreSQL date_trunc.
Now I know the values in the field in question are unique - I have only 3
records.
But when I delete all the records from the table, I still get the above
message.
Are there other active connections? Have they committed all
transactions?
FB Indexes contain information for **all activ
es not already exist?
Regards
Alan McDonald
Something was being cached - it needed a server restart. Disconnecting and
re-connecting to the database did not clear the cache. Doesn't seem right to
me
Even isql returned the same error message.
Alan
es not already exist?
Regards
Alan McDonald
>
> In general, moving Firebird database files is a definite no-no. You copy
or
> move Firebird databases by gbak'ing them and restoring them at the new
> location.
>
What? Is there more to knowing that if you stop the fbserver, it's safe to
copy an .fdb file than there is to know how to manipul
> Hello, Paul, Alan!
>
> PV> "Windows Embedded now contains a SuperClassic instead of a
> SuperServer engine.
> PV> File locks are shared, so a database can be accessed by one or more
> PV> Embedded servers and a regular Classic or SuperClassic server at the
> same time.
> PV> Consult the Fireb
> Hi Alan,
>
> > I notice that it is now possible to connect to a database via the
> > embedded server and simultaneously connect via other embedded
> > processes to the same database file. This was not possible in previous
> > version - the second process would be locked out.
> >
> > Can someone
file being written to somewhere that I can't find?
(WIN32) V2.5
Regards
Alan McDonald
> 04.01.2014 11:51, Alan McDonald wrote:
>
> > Users with RDB$ADMIN granted to them have the ability to creates users.
> >
> > They can, of course, also grant other roles to users.
> >
> > But they cannot revoke roles already granted to a user by another
&
allow all RDB$ADMIN role users, the permissions to
allow granting and revoking of roles granted by other users?
Regards
Alan McDonald
Sorry about the wtf, but this really really bugs me.
Scenario, in a single connection I do this:
1. Start transaction.
2. Create table.
3. Commit.
4. Start transaction.
5. Insert rows.
6. Select using join with other tables.
7. Commit.
8. Start transaction.
9. Drop table.
---> ERROR: Object is
I seem to remember some time ago someone worked out that it was possible to
run embedded firebird on apache (i.e. on a shared unix environment). Does
anyone know if this is possible and how?
Regards
Alan McDonald
> > Now it's a task to find the user who actually granted the role
> >
> > SYSDBA does not overwrite this either. SYSDBA logged as any role
> > including RD B$ADMIN does not give me the ability to revoke the role.
> > It must be the user (not just the RDB$ADMIN role) who granted the role.
>
> It m
anted the role.
So is this the way it's meant to happen?
Can anyone tell me which system table gives me a clue as to who granted the
role so I can get that person to login and revoke it?
Regards
Alan McDonald
Vlad,
Sorry if you (and someone else) have to google what File-Based Write Filter
means.
Firebird runs in WES and WES7 like in any Windows computer.
I have use it several years.
(WES, Windows Embedded Standard is XP and WES7 is Windows 7).
Now I have situation that I must use FBWF.
When I have
As long as the transaction is committed, the data is replicated. That's
better than forced writes on.
Alan
On 29/09/2013 11:40 PM, "Carlos H. Cantu" wrote:
> AM> I would use neither. But I'm a replicator by nature. Another cheap box
> just
> AM> next to the production box and you get high perform
> Question is:
>
> What would be safer:
>
> Keep FW OFF and Journaling ON
> or
> Keep FW ON and Journaling OFF
> ?
>
I would use neither. But I'm a replicator by nature. Another cheap box just
next to the production box and you get high performance and also safety and
the ability to hotswap.
Al
+++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++
> Yahoo! Groups Links
>
>
>
>
--
regards
Alan McDonald
#x27;);
>> >
>> > because the length of EMP_NOMBRE is greater than 20, but:
>> >
>> > Why is not a row inserted into the table ERRORES?
>>
>> The statement probably never gets executed at all because it already
>> fails when the parameter values are checked and deemed too long.
>>
>> Mark
>> --
>> Mark Rotteveel
>>
>>
>
>
>
>
--
regards
Alan McDonald
that with what appears to be very limited resources and
commitment? And what magic might they have pulled off to move the server
into this arena? Is this not as difficult as we currently think? For
Firebird?
Regards
Alan McDonald
Check the page size of the restored vs previous db
Alan
On 24/07/2013 8:19 PM, "SysAdm" wrote:
> Hello,
> I have this strange problem on gbak. Usually every night I was doing a
> full backup of a database and a subsequent restore order to remove the
> garbage and optimize the database. But when I
Not fool proof at all really. DB needs to be off line from the second the
backup starts until the restored file is renamed.
You need a better way
Alan
On 01/06/2013 4:22 PM, "sir_wally_lewis" wrote:
> current practice is.
>
> - backup database
> - restore to new name.
> - rename old database ( c
If you set garbage collection to zero. Installed a scheduled sweep when you
know its a good time to do it and then do your back up well away from this
sweep. Wouldn't you avoid this whole issue?
Alan
On 26/04/2013 7:54 AM, "Robert martin" wrote:
> Hi
>
> We have a need to ensure garbage collectio
> Hi Alan,
>
> > I know in the past that the grantor must be the one who revokes that
role.
> >
> > But now we have RDB$ADMIN a user with role RDB$ADMIN can create,
> edit
> > and delete users and grant a role to another user.
> >
> > I would have thought SYSDBA or indeed any other RDB$ADMIN user
2.5.2 - this is not the case. I get an exception
unsuccessful metadata update SYSDBA is not grantor of Role on MANAGER to
0S0ASDFASDF.
Surely this is not intended?
Regards
Alan McDonald
[Non-text portions of this message have been removed]
>
>
> You are right, I am not sure how it was working but it should have been
> "SELECT COUNT(*) FROM SURFACE"
>
> SELECT FIRST n FROM only reads the first "n" records I want to read the
> last
> "n" records to the end of the DB
>
>
> FYI, I am a newbie to SQL so I don't know the command syntax ver
On Tue, Jan 22, 2013 at 4:18 AM, Nicolas Timmers - TCS Sistemas <
nico...@tcssistemas.com.br> wrote:
> Hello Everyone !
>
> Until the new functionalyty of firebird doesn't came out, that is possible
> to have per database user's
>
> What's my alternatives ?
>
> I am having real problem of users fr
ater.
I also save the username of the user who succeeds so I can tell the other
person who it is that actually has the record in an edit state.
Alan
>
>
>
>
> On Mon, Jan 7, 2013 at 6:32 PM, Alan McDonald wrote:
>
> > **
> >
> >
> > If 526 commits,
t; ++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++
uld read again the row, getting now the updated version from
> 526?
>
> Greetings.
>
> Walter.
>
>
>
> On Sun, Jan 6, 2013 at 8:44 PM, Alan McDonald wrote:
>
> > **
> >
> >
> > But 535 will need to re acquire the row before it can update.
> >
But 535 will need to re acquire the row before it can update.
Alan
On 07/01/2013 11:34 AM, "W O" wrote:
> Hello everybody
>
> - Transaction 510 inserts a new row
> - Transaction 510 commit
> - Transaction 526 start
> - Transaction 526 updates the row inserted by transaction 510
> - Transaction 53
If 526 commits then 535 can retry.
Alan
On 07/01/2013 11:34 AM, "W O" wrote:
> Hello everybody
>
> - Transaction 510 inserts a new row
> - Transaction 510 commit
> - Transaction 526 start
> - Transaction 526 updates the row inserted by transaction 510
> - Transaction 535 start
> - Transaction 535
Your query needs an aggregate field. Count.
Alan
On Oct 24, 2012 1:49 PM, "sir_wally_lewis" wrote:
> Hi,
>
> We use Firebird 2.5.1 on Linux 64 bit
>
> Firebird fails to restore because of a unique constraint( see below ).
> However when interrogating the data, no duplicate is found. ( see below
>
(top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++
> Yahoo! Groups Links
>
>
>
>
--
regards
Alan McDonald
[Non-text portions of this message have been removed]
> Yep, that looks exactly like my case. Unfortunately, I'm not able to re-create
> users by hand because of the scale of the problem (and because I don't
> know their passwords, and resetting them means me looking for another job
> ;) ).
>
You can pump the data to another database shell without t
how to
> list the tables that depends on a specific column from one origin table .
> I have to say that origins of corruption are not from Firebird but more
> from hardware problems .
> regards,
>
> Le 31/07/2012 00:18, Alan McDonald a écrit :
> >
> > You're imp
++++++
> Yahoo! Groups Links
>
>
>
>
--
regards
Alan McDonald
[Non-text portions of this message have been removed]
> Ok, thanks. This is well known.
>
> Then I ask = restoring the db will put the generators in the updated
status ?
>
> --- On Thu, 5/31/12, Mark Rotteveel wrote:
>
Is your database set with FORCED WRITES=ON?
Alan
w line of code and it's
can add great feature to firebird !
>
Fascinating Pull it apart so you can put it together again....
--
regards
Alan McDonald
[Non-text portions of this message have been removed]
Search and replace all the reserved words in your application with a non
reserved alternative. Then change all the reserved filenames in yr DB
Alan
Alan McDonald
On 12/03/2012 7:11 PM, "talshapira" wrote:
> Hi all,
>
> I'm new to firebird.
> I have a legacy applicat
menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++
> Yahoo! Groups Links
>
>
>
>
--
regards
Alan McDonald
[Non-text portions of this message have been removed]
> Thanks for all people kindly answering my questions.
>
> Regarding storing blobs in a separate table, Aage => could be better
because
> that way a page can hold more records Milan => no need to split blobs into
> separate table because FB engine is internally doing this job.
>
> Both seem to ma
68 matches
Mail list logo