Anybody using 2.5 and trusted authentication and having problem authenticating
users?
--- In firebird-support@yahoogroups.com, marto94114 wrote:
Hi guys,
I `ve read all support docs included in firebird 2.5 installation together
with several internet articals but I could not find a
My English is pretty bad and I think I've explained badly. Simplifying the
table is:
create table PRICES {
START_DATE date default current_date not null,
ITEM varchar(10) default '' not null,
PRICE double precision default 0 not null
};
alter table PRICES add constraint PK_PRICES
Just in case, reboot. It often help under MacOsX.
you should have after :
$ ps aux | grep fb
root99059 0,0 0,0 2477544540 ?? S11:43
0:00.00 /Library/Frameworks/Firebird.framework/Resources/bin/fbguard
-daemon -forever
root99060 0,0 0,0 2485856 5088
Hi
I have found the way to retrieve fieldnames to a table via SQL.
Like this:
select
RDB$FIELD_NAME
from
RDB$RELATION_FIELDS
Where
RDB$Relation_Name='MYTABLE'
But I could use the SQL to ALSO retrieve the field type, but I am not sure
where to find this information
COuld
Hello Michael,
I'll send you one of my old presentations about the system tables.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
I have found the way
thank you Martijn
--- In firebird-support@yahoogroups.com, Martijn Tonies wrote:
Hello Michael,
I'll send you one of my old presentations about the system tables.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS
In order to guarantee a 'live' DB is backed up in a consistant state, we need
to make sure it is quiesced at backup time.
We need to configure the Storagecraft ShadowProtect backup job to run a
pre-snapshot script that quiesces the Firebird Database, followed by a
post-snapshot script that
I believe that the basic assumption that you have to put the database into
a quiescent state to get a consistent backup is incorrect. I always
thought that Firebird backups ran in a single long transaction meaning that
nothing committed after the backup starts can be seen by the backup.
Louis
Anybody using 2.5 and trusted authentication and having problem
authenticating users?
I guess the reason for that is that in 2.1, members of the
administrators group were automatically mapped to SYSDBA by default.
This isn't the case in 2.5 anymore.
It should work fine if you add the users
In order to guarantee a 'live' DB is backed up in a consistant state, we need
to
make sure it is quiesced at backup time.
We need to configure the Storagecraft ShadowProtect backup job to run a
pre-snapshot script that quiesces the Firebird Database, followed by a post-
snapshot script
Martijn, can you send that presentation to me, too?
I'm very interested.
Greetings.
Walter.
On Thu, Feb 14, 2013 at 8:19 AM, Martijn Tonies m.ton...@upscene.comwrote:
**
Hello Michael,
I'll send you one of my old presentations about the system tables.
With regards,
Martijn Tonies
Here are some other userful views that we use to get internal data (mostly we
build edit forms from these information) :
list all domains with type length
CREATE OR ALTER VIEW OBJ_DOMAINS(
DOMAIN_NAME,
FIELD_LENGTH,
FIELD_CHARLENGTH,
FIELD_TYPE)
AS
SELECT f.rdb$field_name,
Excellent Nagy, thank you very much.
Greetings.
Walter.
On Thu, Feb 14, 2013 at 4:42 PM, Nagy Szilveszter
nagy_szilvesz...@yahoo.com wrote:
**
Here are some other userful views that we use to get internal data
(mostly we build edit forms from these information) :
list all domains
Hello everybody
Do you know what is the cause of this error message and how resolve it?
After a ROLLBACK the message:
'OLE IDispatch 0 de ibeole.TIBOLECommand: violation of FOREIGN KEY
constraint FK_HISTORICOFAC_1 on table HISTORICOFAC number of
transactions per sweep required.'
is showed.
We
Do you know what is the cause of this error message and how resolve it?
After a ROLLBACK the message:
'OLE IDispatch 0 de ibeole.TIBOLECommand: violation of FOREIGN KEY
constraint FK_HISTORICOFAC_1 on table HISTORICOFAC number of
transactions per sweep required.'
is showed.
We know about
Do you know what is the cause of this error message and how resolve it?
After a ROLLBACK the message:
'OLE IDispatch 0 de ibeole.TIBOLECommand: violation of FOREIGN KEY
constraint FK_HISTORICOFAC_1 on table HISTORICOFAC number of
transactions per sweep required.'
is showed.
We know
16 matches
Mail list logo
