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
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 Sean@... wrote:
...@gmail.com and I will attach databases.
They are small ones.
thx
HaeRim
--- In firebird-support@yahoogroups.com, Dmitry Yemanov dimitr@... wrote:
07.11.2012 13:33, ehaerim wrote:
Firebird 2.5.1.26351
ODS 11.1
It should work fine with any bitness, something it wrong on your side.
Did you
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:
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; // =
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
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
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
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
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.ID =
--- In firebird-support@yahoogroups.com, Aage Johansen aagjohan@...
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
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
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.
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
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
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 ehaerim@... wrote:
I have 3000 symbols
[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
21 matches
Mail list logo