I'm porting an application from FB1.5 to 2.x and a query that worked on 1.5
doesn't work on 2.0 or 2.1 (I haven't tried 2.5)
The query is:
SELECT u.Id, u.Name, u.Email FROM Punter u
WHERE u.ALIVE = 1
/* and they haven't blacklisted this issue */
AND u.Id not IN (SELECT bl.UserId
Hi Paul!
I'm porting an application from FB1.5 to 2.x and a query that worked on 1.5
doesn't work on 2.0 or 2.1 (I haven't tried 2.5)
The query is:
SELECT u.Id, u.Name, u.Email FROM Punter u
WHERE u.ALIVE = 1
/* and they haven't blacklisted this issue */
AND u.Id not IN (SELECT
Hi All,
How to Identify the Modified and Created Date of Tables or Stored
Procedure in Firebird.
Expecting early reply on this.
Thanks,
Mahesh Pratihari
Sonata Software Limited
Phone : +91 80 3097 1570
Mobile : +91 99808 37446
www.sonata-software.com
Please don't print
Hello, Mahesh!
Monday, October 31, 2011, 12:02:24 PM, you wrote:
MP How to Identify the Modified and Created Date of Tables or Stored
MP Procedure in Firebird.
this information is not stored in db anywhere.
MP Expecting early reply on this.
you could look by yourself into rdb$procedures,
We had a client running fb 2.51 on CentoOS 5.6 over the weekend end up
corrupted and we had to restore from backup. No power loss to the server or
anything, but noticed it when starting firebird server after our backup
routine. Saw the following:
usr/lib/firebird/bin/gfix -user sysdba -pass
Tupy... nambá wrote:
I´m experiencing problems trying to import a date column to a Firebird db.
I used many possibilities, but with none of them I got to import this column.
Import from what? Text file, CSV file, XML file, sql file?
What does your input look like?
I also tried FBExport but
dsaunders1971 wrote:
I have tried this sort of syntax but just get a dynamic sql error
SET TRANSACTION READ ONLY;
select * from Booking
AFAIK, this is not available in DSQL.
What's the full and proper format for this?
It depends on the library you use to access Firebird?
For example, in
Once again I am struggling with the syntax of a trigger. When I run the
following I get the error:
Error at line 3: Dynamic SQL ErrorSQL error code = -104Token unknown -
line 19, column 25;
There isn't even a semi-colon on line 19!
Any advice gratefully received.
Neil
SET TERM ^ ;
/* Triggers only
On Mon, 31 Oct 2011 15:19:30 -, grip_2ls li...@2ls.com wrote:
Once again I am struggling with the syntax of a trigger. When I run the
following I get the error:
Error at line 3: Dynamic SQL ErrorSQL error code = -104Token unknown -
line 19, column 25;
There isn't even a semi-colon on line
Hi,
I have recently started using nbackup and have a system where, at the
end of an attempt to do a level 0 I got
Fatal lock manager error: invalid lock id (158048), errno: 22
--Invalid argument
attempts to do subsequent level 1 backups produced:
unsuccessful metadata update
-Database is
Mark
For some reason I cannot get the pre/code html tags to work so I have put the
code here:
http://pastebin.com/p3kt7bud
Line 19/25 is the second character of the smtp server.
Thanks for pointing out my lack of security - I will change that now.
Thanks
N
--- In
On Mon, 31 Oct 2011 15:57:27 -, grip_2ls li...@2ls.com wrote:
Mark
For some reason I cannot get the pre/code html tags to work so I have
put
the code here:
http://pastebin.com/p3kt7bud
I am a bit rusty in my PSQL and trigger code, but as far as I know you can
do SELECT without INTO
On Mon, 31 Oct 2011 17:06:34 +0100, Mark Rotteveel m...@lawinegevaar.nl
wrote:
I am a bit rusty in my PSQL and trigger code, but as far as I know you
can
do SELECT without INTO like you are doing when calling that SendEmail
function (or procedure?).
Uhm, that should have been '.. you can't do
Hi Mark
Thanks for the advise but I don't think that is the issue. If you remove the
second select statement it compiles and runs fine.
N
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote:
On Mon, 31 Oct 2011 17:06:34 +0100, Mark Rotteveel mark@...
wrote:
I am a bit
Thanks for the advise but I don't think that is the issue. If you remove the
second select statement it compiles and runs fine.
Actually, that is the issue.
It is the 2nd SELECT which is the problem, so by removing it, you removed the
problem.
To invoke the SendMail UDF, you should
Hello Nick,
It seems like you have database corruption.
What is Firebird version?
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
Hi,
I have recently started using nbackup and have a system where, at the
end of an attempt to do a level 0 I got
Fatal lock manager error: invalid lock
I have been having database corruption problems with a Firebird 2.0.5 database
on Windows 2008 32-bit. I checked the forced writes setting and forced writes
were disabled. I says to myself I says, AHA this is the problem. So I use
gfix to enabled forced writes. I check that there were
I have been having database corruption problems with a Firebird 2.0.5
database on Windows 2008 32-bit. I checked the forced writes setting and
forced writes were disabled. I says to myself I says, AHA this is the
problem. So I use gfix to enabled forced writes. I check that there were
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote:
What access layer do you use? For example, IBObjects has a forced writes
property at TIB_Connection level, if not set to default, it allows you
to set forced writes on/off.
THANK YOU! I had forgotten about
The following script works on FB1.5 but not FB 2.0+
I'm not sure if I can attach a file so I'll also embed the sql script in
the email. I run the script using isql. The script creates the database so
the ods should be correct for each ver of FB.
cheers
Paul
/**Script Start ***/
At 07:56 AM 1/11/2011, you wrote:
On 31-10-2011 17:46, grip_2ls wrote:
Hi Mark
Thanks for the advise but I don't think that is the issue. If you remove the
second select statement it compiles and runs fine.
That was exactly the issue I was pointing out. You are using SELECT
without INTO to
Hi Milan,
I use Win 7 64, 8GB RAM
Incendio
--- In firebird-support@yahoogroups.com, Milan Babuskov milanb@... wrote:
trskopo wrote:
I just doing a little experiment to find out database performance on RAM vs
on Disk.
Which operating system do you use?
--
Milan Babuskov
On 10/20/2011 11:28 AM, gastrocus wrote:
--- In firebird-support@yahoogroups.com
mailto:firebird-support%40yahoogroups.com, Helen Borrie
helebor@... wrote:
What is the analogous way to achieve this in Firebird (2.5) ?
INSERT INTO emp (fruits) values ('mango')
where not exists
23 matches
Mail list logo