On my Windows 7 64 bit PC, firebird 2.5.1.26351 is currently installed.
I used to open a database file using isql command in previous firebird version
2.1.3. It works well.
However, the latest 2.5.1 version gives me a weird HY000 error.
isql -u sysdba -p masterkey c:\Temp\Databases\FBPORTFOLIO
No one can resolve this issue in this forum?
Please help
Sean
It was my typo when posting this issue, but it was not the problem of incorrect
database path.
I can send you the problematic database file for your checking if yo can write
me an empty email to ehae...@gmail.com.
thx
--- In firebird-support@yahoogroups.com, "Leyne, Sean" wrote:
>
>
>
On my Windows 7 64 bit PC, 64 bit FB 2.5.1.26351 is installed.
And I needed to run isql to access a database created by FB 2.1.5.
Then I got
Statement failed, SQLSTATE = HY000
file C:\\DATABASES\FBPORTFOLIO.GDB is not a valid database
Use CONNECT or CREATE DATABASE to specify a database
How do
ehae...@gmail.com and I will attach databases.
They are small ones.
thx
HaeRim
--- In firebird-support@yahoogroups.com, Dmitry Yemanov wrote:
>
> 07.11.2012 13:33, ehaerim wrote:
> >
> > Firebird 2.5.1.26351
> > ODS 11.1
>
> It should work fine with any bitness, some
Firebird 2.5.1.26351
ODS 11.1
There is an application which has both 32/64 bit versions.
Each version has its own databases created.
The installed firebird is 64 bit version.
To access 32 bit databases, I ran fbserver.exe -a from DOS prompt with Admin
privilege.
When running isql to access 32 bit databases, I got an error:
St
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 char
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; // =>
When I use the following isql statement,
SQL> select substring(data_feed_name from 1 for 10) dfn from test;
DFN
===
InvestWare
I want the = to be shortened to 15 so that it looks
like
DFN
===
InvestWare
Please let me know how
I am trying to get used to FB and ran
fb_inet_server -a -m
from DOS prompt.
I see it running in the task manager.
I would like to know how to stop it.
Do I have to kill it forcefully or is there any command to stop it?
Is it also stop fb_inet_server running as service? How?
thx
HR
set term ^ ;
create procedure INS_INST_YMD(INST varchar(32), YMD date, TB integer, MB
integer, DB integer)
as
declare variable ID integer;
declare variable ID2 integer;
begin
ID = 0;
select ID from I where INST = :INST into :ID;
if (ID > 0) then
begi
> you must have FB2.5 to do this from one statement
> look at "execute statement" extension in FB2.5 release notes
thx for the hint.
I've read and tried to get to know of it, but as I am a novice in sql,
I wish you could write me a sample for [1] in the original post.
HR
There are two databases: A.fdb and B.fdb.
You can think of A.fdb as the whole history database up to yesterday and B.fdb
as today's database.
I need to merge B.fdb into A.fdb.
[1] Update or insert records from B.fdb's I2 into A.fdb's I2
[2] Update or insert records from B.fdb's A2 into A.fdb's A2
>
> SELECT A2.ID FROM A2 JOIN I2 ON A2.ID = I2.ID WHERE A2.ALI = 'a0002'; /*
> returns 2 from A2*/
>
> SELECT D2.ID, D2.YMD, D2.TB, D2.MB, D2.DB FROM D2 WHERE D2.ID = A2.ID AND
> D2.YMD = '2011-12-21'; /* return 2 from D2 */
>
> SELECT D2.ID, D2.YMD, D2.TB, D2.MB, D2.DB FROM D2 JOIN I2 ON D2
create table I2 ( /* main table */
ID integer not null primary key,
INST varchar(32) not null unique
);
create table A2 ( /* alias table */
ALI varchar(32) not null unique,
ID integer not null references I2(ID) on update cascade on delete cascade
);
create table D2 ( /* data table */
ID integer n
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 make sense in o
--- In firebird-support@yahoogroups.com, Aage Johansen >
> Maybe two tables will be better?
> create table DAILYMAIN (
>ID integer not null primary key,
>SYMB varchar(20) not null,
>YMDdate not null
> );
> create table DAILYBLOB (
>ID integer not nu
I have posted a few times and had several replies which made me to change the
design of a database. So, I would like to ask advices/comments again because I
am a novice in database and not sure if I am doing properly.
The previous database design was
- multiple yearly databases
- three tables
-
CREATE TABLE TEST(ITEM VARCHAR(20) NOT NULL PRIMARY KEY, VAL BLOB SUB_TYPE
BINARY);
SELECT VAL FROM TEST WHERE ITEM = '...';
INSERT INTO TEST(ITEM, VAL) VALUES('...', ...);
SELECT FIRST 1 RIGHT(ITEM, 8) FROM TEST WHERE LEFT(ITEM, 8) = '...' ORDER BY
ITEM DESC;
These are sql statements that I
Hello Helen
thx for your kind answer.
Do you by any chance use IBPP api?
I am asking this because I will use it to access databases.
So, if you use IBPP api, it would be much eaiser for me ask your help.
For your reference, I posted a more detail about what I want to do in the link
below.
http
[1] Reasons why I split into yearly databases
> Also, though it seems unrelated to the current question, there is
> no need to have a separate database for every year.
I am worried in two respects:
- a single database for all the past years would grow every year
- and it will affect the performance
I would like to start over my question again with detail description of my
goals to achieve.
There are 3000 symbols and each symbol creates 3 blobs data everyday.
Symbols are named for example, S001 - S0003000.
Blobs are named as TB, MB, and DB. For example, tb01_20110101 -
tb01_201
I found a typo.
ex) (s_1004, b1004_20110728)
should be
ex) (s1004_20110728, b1004_20110728)
[PS] I don't see how to edit this post, and wrote this Reply.
Anyone knowing how to edit a post, let me know.
--- In firebird-support@yahoogroups.com, "ehaerim" wrote:
>
> I have
I have 3000 symbols and each symbol will have a blob data everyday.
In one year, there will be 3000*365 blob records.
And I will insert these records per yearly database. ex)db_2011.fdb
I am thinking of creating a table having (symbol_date, blob) structure.
So, the records will look like
(s0001_20
A table was created like
create table Test(ITEM varchar(20) not null primary key, VAL
varchar(20));
It is filled by records like
(aaa_20111215, ...)
(aaa_20111215, ...)
(aaa_20111201, ...)
...
My question is how to select the record having the latest date for ITEM?
The answer for the above re
26 matches
Mail list logo