firebird-test — Firebird engine testing, test flight/suite discussion/information

RE: [Firebird-test] Minus Plus Minus = ???

[Leyne, S. <Se...@br...>]

Peter,

> Ammount =3D 0
> M_mut=3D-3 (negative)
> Update  stock  set  ammount=3D ammount- M_mut where  Art_no=3D1050
>=20
> In Firebird 1.5-7    result =3D> ammount =3D -3

I just tried this on v1.5 RC8 and I got the correct result (+3)


> in InterBase         result =3D> ammount =3D +3
>=20
> With
>=20
> Update  stock  set  ammount=3D ammount- (M_mut) where  Art_no=3D1050
>=20
> I get the proper result (-3).

The correct result is always (+3), regardless of the parentheses!


Sean

[Firebird-test] Minus Plus Minus = ???

[Peter <pvh...@ro...>]

I came up the follwing abnormallity:

Ammount = 0
M_mut=-3 (negative)
Update  stock  set  ammount= ammount- M_mut where  Art_no=1050

In Firebird 1.5-7    result => ammount = -3

in InterBase         result => ammount = +3

With

Update  stock  set  ammount= ammount- (M_mut) where  Art_no=1050

I get the proper result (-3).

Is this a known bug?

Thanks,



Peter

[Firebird-test] More mac problems.

[dale s. <da...@mi...>]

Hi guys!
I first have to say a BIG thanks to John Bellardo, for his help 
with getting Firebird on to a mac!

Now that i have it installed i have ran into issues with getting 
PHP 4.3.4 to use the '--with-interbase' function in the configure 
script.

i have gathered all of the '.dylib' files from the lib directory
and placed them in a directory in '/Library/Frameworks/Firebird.framework",
which is what i used in the '--prefix=' function when i configured Firebird
and i get the error bellow:

ld: /usr/local/software/firebird_install/lib/libib_util.dylib is input for
the dynamic link editor, is not
relocatable by the static link editor again
ld: warning prebinding disabled because dependent library: /usr/lib/system
libmathCommon.A.dylib can't be
searched

Is there a way to create DSO's for the required modules? Can i do this
manualy any way so that i can compile PHP?

If anyone has any thing regarding this info that would be great?

Cheers and thank-you fro your time,
Dale Stirling
-- 
'hell didily ding dong crap'
        --Ned Flanders

Re: [Firebird-test] Install on OSx

[John B. <bel...@cs...>]

Dale,

On Jan 13, 2004, at 3:44 PM, ackmie wrote:

> Hi,
>
> I am trying to istall source of firebidr onto OSX 10.3 and am doing an
> install using the boot install. When i go to do an install i get the
> following error:
>
> make: *** No rule to make target `include_darwin', needed by 
> `includes'.
> Stop.
>
> can you help?

I've never done a boot build on Darwin, and I don't have the time to 
play with it right now, so unfortunately I can't help you.  I'd suggest 
a normal 1.0 build, or perhaps a 1.5 build (which doesn't require an 
installed engine).

-John

[Firebird-test] Install on OSx

[ackmie <ack...@ho...>]

Hi,

I am trying to istall source of firebidr onto OSX 10.3 and am doing an
install using the boot install. When i go to do an install i get the 
following error:

make: *** No rule to make target `include_darwin', needed by `includes'. 
Stop.

can you help?

Thanking you in advance!
Dale
-- 
'hell didily ding dong crap'
        --Ned Flanders

[Firebird-test] UNICODE_FSS ---> ODBC ---> OpenOffice.org

[Alejandro M. <ol...@te...>]

This combinatión crash when i have to get a register with characters of this
type: ñ, á, é, í etc,......
The column has UNICODE_FSS charset.

Where is de problem?
    In UNICODE_FSS charset of the column?
    In ODBC firebird driver?
    Or is a OpenOffice.org problem?

Re: [Firebird-test] IBEvents

[Ertan K. <er...@oz...>]

On Sun, 23 Feb 2003 07:38:35 +0000 (UTC), "Larry Baddock"  =

<ba...@te...> wrote:

>> Hi,
>> I'm doing a test progam that use IBEvents with a Firebird Server. I'v=
e
>> two servers on the same network, a Windows 2000 Server and a Linux  =

>> Red-Hat
> 8.0
>> server. Both are running Firebird 1.02 - Bd-914.
>> The problem is that I can't register events on the Linux server, but =
I  =

>> can
>> with the Windows server, with the same application.
> I had this problem myself, and it took a while to figure it out.
> Basically, you need to have a look at your /etc/hosts file, and make 1=
00%
> SURE that it is correct.
> For some obscure reason, the box that I set up to play with that had t=
his
> problem had the actual hostname listed in the /etc/hosts file, against=
  =

> the
> loopback address!!! (Yes, it's bizarre, but it's fixed now). make SURE=
  =

> you
> don't have an incorrect entry here.
> The entry should look like this:
> "127.0.0.1    localhost     localhost.localdomain"
>
> If you do have this misconfigured, what seems to happen is :
> 1) the client software asks the server to register an event
> 2) the server looks up the interface relating to the host name, and  =

> manages
> to come back with it's own loopback (127.0.0.1) address, instead of th=
e  =

> ip
> address associated with the interface that the request came in on
> 3) The server opens a port on it's loopback address, for event deliver=
y
> 4) The server tells the client to speak to ip 127.0.0.1, on the port  =

> number
> that it opened in step 3 (Which on the client happens to be on the LOC=
AL
> machine!)
> 5) All hell breaks loose, coz the server has an open port that never g=
ets
> connected to, and the process (in classic server, at least) goes bye b=
ye,
> waiting for someone to talk to it. The client tries to connect to  =

> itself, on
> the specified port, and more than likely gets told that the connection=

> attempt was rejected. At this point, some internal state in GDS32.dll =
on  =

> the
> client seems to get messed up, and after this, NOTHING works as it  =

> should.
>
> I don't know if this is 100% correct, as I haven't had time to check  =

> against
> the sources. It sure looks to me like this is what is happening, thoug=
h.  =

> (If
> someone could verify this, and If I'm correct, please fill out a bug f=
ix
> request form).
>
> Hope this helps
> Larry
>

In my case my related /etc/hosts line is as follows:
127.0.0.1       localhost.com localhost

So, I do not think that is the source of the problem.
Regards,

-- =

Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

Re: [Firebird-test] IBEvents

[Ertan K. <er...@oz...>]

Problem exists on FreeBSD version also. 1.5RC7 classic server.
Be informed...


On Thu, 13 Feb 2003 13:22:09 +0000 (UTC), Fabiano Bonin  =

<fa...@pe...> wrote:

> When i had this problem i could not solve it too, but in that time i  =

> didn't try to disable DHCP.
> So, i had to disable the events in my app, and i didn't enabled them  =

> anymore. Maybe the problem is still there.
>
> I think the support guys should take a look in that, because it's the =
 =

> 3rd or 4th time (including me) i see somebody relating this problem in=
  =

> the newsgroup.
> The problem is that it's dificult to reproduce this problem.
>
> SurSSe escreveu:
>
>> Hi,
>> I didn't use DHCP. I always used fixed IP, but it didn't run. I think=
  =

>> it's a problem with linux configuration,
>> but I've disabled firewall, and Firebird could use the ports it need,=
  =

>> but It doesn't run. When I register event,
>> firebird hangs.
>>
>> On Wed, 12 Feb 2003 07:52:12 +0000 (UTC) fa...@pe... =
 =

>> (Fabiano Bonin) wrote:
>>
>>
>>> Hi, i saw in the NG that it could be some problem related to the  =

>>> server IP being assigned via DHCP.
>>> I had this problem some time ago, in a Linux box with dinamic IP.
>>> Try to fix the IP and try again to see if it works.
>>>
>>> SurSSe escreveu:
>>>
>>>
>>>> Hi,
>>>> I'm doing a test progam that use IBEvents with a Firebird Server.  =

>>>> I've two servers on the same network, a Windows 2000 Server and a  =

>>>> Linux Red-Hat
>> 8.0
>>>> server. Both are running Firebird 1.02 - Bd-914.
>>>>
>>>> Both servers run well, that is, I've Delphi client/server applicati=
ons
>> running
>>>> OK.
>>>>
>>>> The problem is that I can't register events on the Linux server, bu=
t  =

>>>> I can with the Windows server, with the same application. Linux  =

>>>> server report me than it was impossible to make another conection t=
o  =

>>>> the server, because it
>> was
>>>> rejected. But with Windows Server, I can do it without problem.
>>>>
>>>> What could it be?
>>>>
>>>>
>>>> -------------------------------------------------------
>>>> This SF.NET email is sponsored by:
>>>> SourceForge Enterprise Edition + IBM + LinuxWorld =3D Something 2 S=
ee!
>>>> http://www.vasoftware.com
>>>> _______________________________________________
>>>> Firebird-test mailing list
>>>> Fir...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/firebird-test
>>>>
>>>>
>>>
>>> -------------------------------------------------------
>>> This SF.NET email is sponsored by:
>>> SourceForge Enterprise Edition + IBM + LinuxWorld =3D Something 2 Se=
e!
>>> http://www.vasoftware.com
>>> _______________________________________________
>>> Firebird-test mailing list
>>> Fir...@li...
>>> https://lists.sourceforge.net/lists/listinfo/firebird-test
>>>
>>>
>>>
>>
>>
>> -------------------------------------------------------
>> This SF.NET email is sponsored by: FREE  SSL Guide from Thawte
>> are you planning your Web Server Security? Click here to get a FREE
>> Thawte SSL guide and find the answers to all your  SSL security issue=
s.
>> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en
>> _______________________________________________
>> Firebird-test mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-test
>>
>>
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: FREE  SSL Guide from Thawte
> are you planning your Web Server Security? Click here to get a FREE
> Thawte SSL guide and find the answers to all your  SSL security issues=
.
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>



-- =

Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

Re: [Firebird-test] Cache update

[PD <pd...@ho...>]

As far as I recall, you should doubleclick on your IBTransaction an select
something like "read comitted" (or maybe it was one of the other settings).
That should do the trick when you refresh.

Kind regards
Poul Dige



""IsabelVeiga"" <pau...@ne...> skrev i en meddelelse
news:bqv4jv$jtm$1...@ne......
> I'm creating an aplication, using Delphi native Interbase objects
> (TIBDataBase ,TIBTransaction,TDatasource and TIBtable)
> If I run two instances of aplication, and I create one record from one
> aplication I cannot see that record on second Instance of Aplication.
>
> But if I run IBconsole I see that record in the table.
>
> After I do a update I force a commit and a refresh.
>
> But in the second Instance of aplication I cannot see nothing, and i do a
> refresh.
>
> I only see the new records in the second aplication if I get out of
program
> and running it again.
>
>
> Can you help me?
>
> Thanks
> Paulo.
>
>
>
>
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?  SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>

[Firebird-test] What is embedded option

[IsabelVeiga <pau...@ne...>]

How do I know if I have firbird as client+server or embedded?.

I already have interbase 6 and after I put version 7 and now I use Firebird
because of License.

Can you help me?.

Sorry for my English and

[Firebird-test] Cache update

[IsabelVeiga <pau...@ne...>]

I'm creating an aplication, using Delphi native Interbase objects
(TIBDataBase ,TIBTransaction,TDatasource and TIBtable)
If I run two instances of aplication, and I create one record from one
aplication I cannot see that record on second Instance of Aplication.

But if I run IBconsole I see that record in the table.

After I do a update I force a commit and a refresh.

But in the second Instance of aplication I cannot see nothing, and i do a
refresh.

I only see the new records in the second aplication if I get out of program
and running it again.


Can you help me?

Thanks
Paulo.

Re: [Firebird-test] RC7 Alias/gstat issue

[Pavel C. <pc...@us...>]

Hi,

On 27 Nov 2003 at 15:22, Eric Thorniley wrote:

> I fear I have found a little bug:
> 
> Tests were with RC7 Windows super server.
> 
> If I try to use an alias as the database name in gstat or when calling for
> statistics through the services API, it tells me that the file is not found.

Not really a bug, just not fully implemented feature (aliases), thought. 
gstat is a little bit different from other tools, because it physically 
read database files, bypassing the server. hence the need for physical db 
location.

You should raise this issue in firebird-devel to get developer's 
attention.

Best regards
Pavel Cisar (ICQ: 89017288)
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information

[Firebird-test] RC7 Alias/gstat issue

[Eric T. <eri...@co...>]

I fear I have found a little bug:

Tests were with RC7 Windows super server.

If I try to use an alias as the database name in gstat or when calling =
for
statistics through the services API, it tells me that the file is not =
found.


If I set the conf option "DatabaseAccess =3D None" then, of course, if I =
use
the full database path I am told that the administrator has restricted =
the
rights.

This means that "DatabaseAccess =3D None" option makes it difficult to =
use
gstat or the related service functions.

There is a work-around by declaring an alias with the same name as the
database path and using it for any access to statistics. In aliases.conf =
I
add two lines for each database:

MyAlias =3D D:\Data\MyDB.fdb
D:\Data\MyDB.fdb =3D D:\Data\MyDB.fdb

This fixes both gstat and the service API access.

Even if this is confirmed as a bug, my vote would be for releasing the
current code and just noting this as a known issue rather than delaying =
for
another RC.=20


Regards

Eric Thorniley=20

Re: [Firebird-test] QMTest runs against fb1.5

[Pavel C. <pc...@us...>]

Mark,

On 24 Nov 2003 at 11:46, Mark O'Donohue wrote:

> But while Im here, where are the test output filters configured?

firebird.py
class FirebirdISQLTestBase
function RunProgram

or simply look for "SQL>" or "stdout_stripped"

Best regards
Pavel Cisar (ICQ: 89017288)
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information

Re: [Firebird-test] QMTest runs against fb1.5

[Mark O'D. <mar...@fi...>]

Thanks for that Pavel.

I'll have some more questions in the next day or so, when I try again to 
validate my linux build through your process.

More of the 'Fails' are the bugs,

And from my checking a lot of the errors are correct just different 
output to the fb1.0 results that are stored (for example select of 
avaliable character sets returns different but correct for fb1.5  results).

But more when I try to save outcomes and try and edit them for my 
linux-fb1.5 results.


But while Im here, where are the test output filters configured?


Cheers

Mark


Pavel Cisar wrote:
> Mark,
> 
> On 23 Nov 2003 at 19:25, Mark O'Donohue wrote:
> 
> 
>>The first run I get:
>>
>>Error: 	314
> 
> 
> Those are for sure bug tests (bugs.qms test-suite). Those are not yet 
> implemented, just a stubs with problem/bug description. Do not run those, 
> only isql.qms test-suite is ready right now.
> 
> 
>>Fail: 	28
>>Pass: 	199
>>
>>Total: 	542
>>
>>It's a first run, and most of the errors, will not be errors as such,
>>but differences from expected outcomes.
>>
>>So a few questions.
>>
>>1) In QMTest can it store multiple configurations for results?.
>>I obviously would like to create a fb1.5-linux expected output database,
>>but don't want to muck up your current ones?
> 
> 
> Of course, you can save expectation/outcomes under any name and load it 
> later.
> 
> 
>>2) When I review a test run, and verify that the 'new' results are ok,
>>how do I accept them so they replace the current expected output?
> 
> 
> Not by one click, but quite simple. Copy *stripped* stdout (or stderr) 
> from outcome details of failed test (best done in gui mode), enter the 
> edit mode for test and replace the stdout (stderr) text with new one. Re-
> run the test for verification. 
> 
> NOTE: Stripped output is the output with internally defined "ignore 
> patterns" filtered out (i.e. isql prompts etc.)
> 
> Some more notes:
> 
> 1) If the difference is only in particular FB version (i.e. 1.5, but 
> correct in 1.0), then we should duplicate that test as new one in 1.5 
> specific test-suite. There are no such version specific test-suite, so we 
> have to create one for 1.0 and 1.5 (new1.0 and new15 suites have 
> different purpose!) and move the old test to spec10.qms and new one into 
> spec15.qms.
> 
> 2) If the difference come from isql or configuration (file path etc.), 
> it's better to define "replace" regular expression for test with empty 
> replacement (stands for ignore). For more "common"
>  differences it's better to filter them out in extension class (like isql 
> prompts are removed).
> 
> Best regards
> Pavel Cisar (ICQ: 89017288)
> http://www.ibphoenix.com
> For all your upto date Firebird and
> InterBase information
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?  SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
> 
> 

Re: [Firebird-test] QMTest runs against fb1.5

[Pavel C. <pc...@us...>]

Mark,

On 23 Nov 2003 at 19:25, Mark O'Donohue wrote:

> The first run I get:
> 
> Error: 	314

Those are for sure bug tests (bugs.qms test-suite). Those are not yet 
implemented, just a stubs with problem/bug description. Do not run those, 
only isql.qms test-suite is ready right now.

> Fail: 	28
> Pass: 	199
> 
> Total: 	542
> 
> It's a first run, and most of the errors, will not be errors as such,
> but differences from expected outcomes.
> 
> So a few questions.
> 
> 1) In QMTest can it store multiple configurations for results?.
> I obviously would like to create a fb1.5-linux expected output database,
> but don't want to muck up your current ones?

Of course, you can save expectation/outcomes under any name and load it 
later.

> 2) When I review a test run, and verify that the 'new' results are ok,
> how do I accept them so they replace the current expected output?

Not by one click, but quite simple. Copy *stripped* stdout (or stderr) 
from outcome details of failed test (best done in gui mode), enter the 
edit mode for test and replace the stdout (stderr) text with new one. Re-
run the test for verification. 

NOTE: Stripped output is the output with internally defined "ignore 
patterns" filtered out (i.e. isql prompts etc.)

Some more notes:

1) If the difference is only in particular FB version (i.e. 1.5, but 
correct in 1.0), then we should duplicate that test as new one in 1.5 
specific test-suite. There are no such version specific test-suite, so we 
have to create one for 1.0 and 1.5 (new1.0 and new15 suites have 
different purpose!) and move the old test to spec10.qms and new one into 
spec15.qms.

2) If the difference come from isql or configuration (file path etc.), 
it's better to define "replace" regular expression for test with empty 
replacement (stands for ignore). For more "common"
 differences it's better to filter them out in extension class (like isql 
prompts are removed).

Best regards
Pavel Cisar (ICQ: 89017288)
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information

[Firebird-test] QMTest runs against fb1.5

[Mark O'D. <mar...@fi...>]

Hi Pavel


I've now got qmtest to run against my fb1.5 install.

The first run I get:

Error: 	314
Fail: 	28
Pass: 	199

Total: 	542



It's a first run, and most of the errors, will not be errors as such,
but differences from expected outcomes.

So a few questions.

1) In QMTest can it store multiple configurations for results?.
I obviously would like to create a fb1.5-linux expected output database,
but don't want to muck up your current ones?


2) When I review a test run, and verify that the 'new' results are ok,
how do I accept them so they replace the current expected output?


Cheers

Mark

[Firebird-test] QMTest runs against fb1.5

[Mark O'D. <mar...@fi...>]

Hi Pavel


I've now got qmtest to run against my fb1.5 install.

The first run I get:

Error: 	314
Fail: 	28
Pass: 	199

Total: 	542



It's a first run, and most of the errors, will not be errors as such, 
but differences from expected outcomes.

So a few questions.

1) In QMTest can it store multiple configurations for results?.
I obviously would like to create a fb1.5-linux expected output database, 
but don't want to muck up your current ones?


2) When I review a test run, and verify that the 'new' results are ok, 
how do I accept them so they replace the current expected output?


Cheers

Mark

Re: [Firebird-test] Mixed case object names

[Aage J. <aag...@on...>]

On Sat, 25 Oct 2003 07:06:12 +0000 (UTC), André Parnelöv wrote:

> I'm really sure if this is a bug or design.
>
> I have problem with objects name in mixed case. When I run a query for my
> object I just get an error telling me that either the table or column
> doesn't exist.
>
> I run Firebird 1.5 rc6, with both IBExpert and Firebird.net-provider. The
> errors I get is similar in both interfaces.
>
> Example.
> The table tbl_Test has the columns mKey and mValue. I'm trying to insert
> values into the table with:
>
> INSERT INTO "tbl_Test" (mKey,  mValue) VALUES ('andre',12);
>
> And the error I get is;
> Dynamic SQL Error
> SQL error code = -206
> Column Unkown.
> MKEY
> At line 1, column 25
>
> But if I create a new table with only uppercase object names there is no
> problem running a query in mixed case.
>
> I really like to have mixed case object names.


Well, I you really like to punish yourself ...
Try to use "mKey" and "mValue".

I find it most convenient to use UPPERCASE names (with no " quotes) when 
defining objects.  I can then use AnyCase in my Delphi programs.


-- 
Aage J.

[Firebird-test] Mixed case object names

[<an...@pa...>]

I'm really sure if this is a bug or design.

I have problem with objects name in mixed case. When I run a query for my
object I just get an error telling me that either the table or column
doesn't exist.

I run Firebird 1.5 rc6, with both IBExpert and Firebird.net-provider. The
errors I get is similar in both interfaces.

Example.
The table tbl_Test has the columns mKey and mValue. I'm trying to insert
values into the table with:

INSERT INTO "tbl_Test" (mKey,  mValue) VALUES ('andre',12);

And the error I get is;
Dynamic SQL Error
SQL error code = -206
Column Unkown.
MKEY
At line 1, column 25

But if I create a new table with only uppercase object names there is no
problem running a query in mixed case.

I really like to have mixed case object names.

[Firebird-test] Mixed case object names

[<an...@pa...>]

I'm really sure if this is a bug or design.

I have problem with objects name in mixed case. When I run a query for my
object I just get an error telling me that either the table or column
doesn't exist.

I run Firebird 1.5 rc6, with both IBExpert and Firebird.net-provider. The
errors I get is similar in both interfaces.

Example.
The table tbl_Test has the columns mKey and mValue. I'm trying to insert
values into the table with:

INSERT INTO "tbl_Test" (mKey,  mValue) VALUES ('andre',12);

And the error I get is;
Dynamic SQL Error
SQL error code = -206
Column Unkown.
MKEY
At line 1, column 25

But if I create a new table with only uppercase object names there is no
problem running a query in mixed case.

I really like to have mixed case object names.

[Firebird-test] D7+Firebird+SqlClientDataset

[Marc P. <ie...@ie...>]

Wenn I post a record in a Firebird database, can you do it with this code :

With ClientDatset1 do
begin
        Append;
        FieldByName('Name').AsString := 'AICO';
        Post;
        ApplyUpDates(-1);
end;

How cann I do it with the Sql-Code? ( Insert Into  ........ )

Re: [Firebird-test] Escape Sequence

[Artur A. <ar...@ar...>]

use "OR" - Insert into "OR" bla bla bla

You are on the wrong list. Next time use fb-support on yahoo groups:

http://groups.yahoo.com/group/firebird-support/

Cya,

Artur

> Good day.
> 
> I have been working on a project that uses firebird
> for database. I encountered problems when I used the
> "INSERT INTO OR VALUES (...)" statement. It treats the
> OR table as a keyword. What should I do for the SQL
> statement to accept OR as a table name?
> 
> Thanks a lot.

[Firebird-test] Escape Sequence

[alex y. <xyr...@ya...>]

Good day.

I have been working on a project that uses firebird
for database. I encountered problems when I used the
"INSERT INTO OR VALUES (...)" statement. It treats the
OR table as a keyword. What should I do for the SQL
statement to accept OR as a table name?

Thanks a lot.

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

[Firebird-test] count in procedure

[Pawels <p_s...@po...>]

1. Firebird 1.5.rc5
2. There is table in the database

CREATE TABLE NRDANYCH (
    NR_ID       INTEGER NOT NULL,
    NRTYP       varchar(3),
    NRSYMBOL    VARCHAR(6),
    NRROK       INTEGER,
    NRGRUPAMAT  SMALLINT,
    NRDNOWY     INTEGER
);

3. There is one record in the table
(1,'ZLC',null,2003,null,1)

4. Query from console (ibexpert):
  SELECT COUNT(nrtyp)
  FROM NRDANYCH
  WHERE NRTYP=:ITYP AND NRSYMBOL=:ISYMBOL AND NRROK=:IROK AND NRGRUPAMAT
=:IGRUPA
with parameters ='ZLC', isymbol=null, irok=2003, igrupa=null
returns 1

5. The same query inserted into procedure
  SELECT COUNT(nrtyp)
  FROM NRDANYCH
  WHERE NRTYP=:ITYP AND NRSYMBOL=:ISYMBOL AND NRROK=:IROK AND NRGRUPAMAT
=:IGRUPA
  INTO :NUMER;
with identical parameters ityp='ZLC', isymbol=null, irok=2003, igrupa=null
returns 0 (sic!) independent of real number of records in the table

Czy kto¶ mo¿ wyja¶niæ dlaczego tak siê dzieje?

6. Wszystko dzia³a ok, je¿eli w rekordzie s± zapisy zamiast null-i (np.
wpisane zera) i parametry zapytania s±
    analogicznie ustawione.
6. There is no problem (the query returns real number of records) if there
is no null values
in the record and parameters (for example set as 0)
7. The same behaviour observed in FB 1.0
Regards
Pawel Swierzko