Am 08.06.2012 02:51, schrieb ehaerim:
SQL select substring(data_feed_name from 1 for 10) dfn from test;
[...]
I want the = to be shortened to 15 so that it
looks like
DFN
===
InvestWare
Strange request.
Anyway, you could use cast to shorten the
Magnus Titho schrieb am 08.06.2012 um 08:24 (+0200):
Am 08.06.2012 02:51, schrieb ehaerim:
SQL select substring(data_feed_name from 1 for 10) dfn from test;
[...]
I want the = to be shortened to 15 so
that it looks like
DFN
===
InvestWare
Alec,
Thomas, the index used to exist but for some reason it was lost, probably
because of the lack of disk space during index rebuild. Firebird should not
leave the database in a bad state like this if ALTER INDEX ACTIVATE fails
because of lack of disk space!
What can you expect if Firebird
ma_golyo wrote:
a. This is plan B.
b. It's very creative, but ugly... :)
How about:
c. Modify Firebird source code, before it tries to create the database
file, check for directory existence, and then create it. It seems
exactly what you need and any decent C/C++ programmer should be able to
Hello, ma_golyo!
Thursday, June 7, 2012, 5:32:10 PM, you wrote:
m That is why I want/expect to create missing directory with
m Firebird/gbak. It can create file but not a directory? It's strange to me.
because directories for databases, etc, must be created by
administator. It is not strange.
After installation access right can be set up for Firebird. But directories
needed not after the installation but in the future.
--- In firebird-support@yahoogroups.com, Milan Babuskov milanb@... wrote:
ma_golyo wrote:
what if Firebird on Linux is run under special account (as it usually
You created that schema, don't want to change it, and want Firebird
be changed for your needs?
Yep, that is the case. ;)
Really, as it was said, creating db anywhere at the filesystem
is dangerous, and violates lot of administrative and security rules.
I cannot create DB anywhere, because OS
thanks for the answer.
Set width works.
However it still does not work when alias is used.
For example,
long_field_name varchar(30);
Set width long_field_name 10;
select long_field_name from test; // = display 10 char
Set width long_field_name 10;
select long_field_name lfn from test; // =
On 08/06/12 10:29, ehaerim wrote:
Is it also possible the latter case print 10 chars only?
Yes:
Set width LFN 10;
select long_field_name LFN from test; // = display 30 char
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
Sorry typo,
Set width LFN 10;
select long_field_name LFN from test; // = display 10 chars
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
Hi,
Please remind me, is it the case that you can only have a single active
transaction per connection?
But you can have any number of commands/queries open for that single
transaction and connection?
This is in .Net and I'm using the FB provider version 2.6 or 2.7 I think.
Kjell
--
Hi all,
I'm trying to create a Foreign Key Constraint and I'm getting the following
error:
violation of FOREIGN KEY constraint FK_LOG_ITEM_LOG on table LOG_ITEM
Foreign key reference target does not exist
However, both tables LOG (master) and LOG_ITEM (detail) are empty!
Statement:
On Fri, 8 Jun 2012 11:45:01 +0200, Kjell Rilbe kjell.ri...@datadia.se
wrote:
Hi,
Please remind me, is it the case that you can only have a single active
transaction per connection?
Technically Firebird allows you to use multiple, concurrent transaction on
a single connection, however not
On Fri, 8 Jun 2012 11:53:01 +0200, Martijn Tonies m.ton...@upscene.com
wrote:
Hi all,
I'm trying to create a Foreign Key Constraint and I'm getting the
following
error:
violation of FOREIGN KEY constraint FK_LOG_ITEM_LOG on table
LOG_ITEM
Foreign key reference target does not exist
At 09:45 PM 8/06/2012, Kjell Rilbe wrote:
Hi,
Please remind me, is it the case that you can only have a single active
transaction per connection?
Absolutely not the case!
But you can have any number of commands/queries open for that single
transaction and connection?
You can have any number
Hello Mark,
I'm trying to create a Foreign Key Constraint and I'm getting the
following
error:
violation of FOREIGN KEY constraint FK_LOG_ITEM_LOG on table
LOG_ITEM
Foreign key reference target does not exist
However, both tables LOG (master) and LOG_ITEM (detail) are empty!
I'm trying to create a Foreign Key Constraint and I'm getting the
following
error:
violation of FOREIGN KEY constraint FK_LOG_ITEM_LOG on table
LOG_ITEM
Foreign key reference target does not exist
However, both tables LOG (master) and LOG_ITEM (detail) are empty!
Statement:
ALTER
That is, more or less.
I restarted Firebird, problem is gone.
Even though I already did a sweep and everything, it sounds like there
was some kind of left over transaction or something?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for
Den 2012-06-08 12:04 skrev Helen Borrie såhär:
your question is for the firebird-net-provider list. I'd be extremely
surprised if, this far on in its life, the .net provider didn't fully
support the Firebird API.
Well, it actually does seem like concurrent transactions are NOT
supported,
Dear List
Please help me understand where I am going wrong with creating the following
procedure:
SET TERM ^ ;
CREATE PROCEDURE TestProc
( CatName CHAR(15) )
AS
BEGIN
select cast('Now' as time) as TIME from rdb$database;
END^
SET TERM ; ^
Engine Code: 335544569
Engine Message :
Dear List
Please help me understand where I am going wrong with creating the following
procedure:
...
CREATE PROCEDURE TestProc
...
select cast('Now' as time) as TIME from rdb$database;
...
Token unknown - line 7, column 57
;
What should Firebird do with TIME? You simply need an INTO clause
Hi,
Please help me understand where I am going wrong with creating the
following procedure:
SET TERM ^ ;
CREATE PROCEDURE TestProc
( CatName CHAR(15) )
AS
BEGIN
select cast('Now' as time) as TIME from rdb$database;
END^
SET TERM ; ^
Engine Code: 335544569
Engine Message :
On Fri, Jun 8, 2012 at 7:37 AM, ktadimeti tadimetikes...@yahoo.com wrote:
**
Dear List
Please help me understand where I am going wrong with creating the
following procedure:
SET TERM ^ ;
CREATE PROCEDURE TestProc
( CatName CHAR(15) )
AS
BEGIN
select cast('Now' as time) as TIME from
--- In firebird-support@yahoogroups.com, Michael Vilhelmsen wrote:
Ah - you are right :)
Its the amount of start/commit I was referring to. My bad.
Statistics are as of now:
Database E:\DB\OCCeasyPos.Fdb
Database header page information:
Flags 0
--- In firebird-support@yahoogroups.com, ktadimeti tadimetikeshav@... wrote:
Dear List
Please help me understand where I am going wrong with creating the following
procedure:
SET TERM ^ ;
CREATE PROCEDURE TestProc
( CatName CHAR(15) )
AS
BEGIN
select cast('Now' as time) as
Thanks Thomas!
--- In firebird-support@yahoogroups.com, Thomas Clarke thomas.p.clarke@...
wrote:
On Fri, Jun 8, 2012 at 7:37 AM, ktadimeti tadimetikeshav@... wrote:
**
Dear List
Please help me understand where I am going wrong with creating the
following procedure:
SET TERM ^
On Fri, Jun 8, 2012 at 7:46 AM, Michael Ludwig mil...@gmx.de wrote:
Kjell Rilbe schrieb am 08.06.2012 um 13:06 (+0200):
Den 2012-06-08 12:04 skrev Helen Borrie såhär:
the .net provider [
] the Firebird API.
Well, it actually does seem like concurrent transactions are NOT
supported, as
Thomas,
What can you expect if Firebird needs temporary disk space which isn't
available to create/activate an index?
I expect the statement to fail but but not corrupt the state of the
database. Similarly to how a query with a large sort would fail if there is
not enough disk space for the
Thanks Vlad, but this is too complicated to give as a guidance to our
customers. However, it sounds like rebuilding an index cannot require more
space that the database size itself, right?
On Fri, Jun 8, 2012 at 7:22 AM, hvlad hv...@users.sourceforge.net wrote:
**
--- In
On Fri, Jun 8, 2012 at 11:24 AM, Alec Swan alecs...@gmail.com wrote:
Thanks Vlad, but this is too complicated to give as a guidance to our
customers. However, it sounds like rebuilding an index cannot require more
space that the database size itself, right?
On a bad day, yes it could. To
Alex,
However, it sounds like rebuilding an index cannot require more
space that the database size itself, right?
Correct, in order to build the index, the engine must build and sort a
projection of the index values.
So, if you build an index on a string [say varchar(100)] column which is
thx it works again!
but when it comes to INTEGER or SMALLINT type, it won't work again.
for example,
ii INTEGER Not Null;
si SMALLINT Not Null;
set width ii 4;
set width si 2;
select ii, si from test;
ii si
== ===
1001 1
ii and si displays 10 chars and 7
32 matches
Mail list logo