ul:
http://www.firebirdfaq.org/
And Helen Borrie's Firebird Book is a great manual which also includes
chapter(s) on SP's, triggers and PSQL. It's not free though! You'll find
it here:
https://www.ibphoenix.com/
(You may need to scroll down a bit.)
Hope this helps!
Cheers,
Paul Vinkenoog
44569
> Engine Message :
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 1, column 23
> update
My fault! If forgot the trigger name. It should be:
create trigger MyTrigger before update on Table_Name ...
Instead of MyTrigger, you choose a more meaningful name of course.
Cheers,
Paul Vinkenoog
begin
if (new.col3 is distinct from old.col3)
then new.col5 = current_timestamp;
end#
set term ;#
If col3 is non-nullable you can simply use "new.col3 <> old.col3" in the
test.
Mind you, an explicit update that re-enters the existing value in col3
won't cause col5 to be updated!
HTH,
Paul Vinkenoog
o when it's strictly about German, AI collations seem
useless, except for catching certain foreign words and names likes
Gérard/Gerard, or misspellings of Kekulé.
Cheers,
Paul Vinkenoog
ae sind gleich
ö und oe sind gleich
ü und ue sind gleich
ß und ss sind gleich
If you do want to treat them as different letters, you need a German
collation that does just that. However, this collation will not work
correctly with words in some other languages containing ä, ö and ü.
Cheers,
Paul Vinkenoog
, col2 from table
HTH,
Paul Vinkenoog
to do is determine the most recent backup before the chosen
point in time. If that is a level N, you need N+1 files for the restore
(levels 0-N, each one being the most recent file of that level before
time 'T').
Cheers,
Paul Vinkenoog
on the situation.
Kind regards,
Paul Vinkenoog
.
Hope this helps,
Paul Vinkenoog
:: ALTER TABLE. That's the basis.
The document Thomas pointed you to contains the updates since Firebird was
forked from the IB sources.
Good luck,
Paul Vinkenoog
in the past, but maybe that's just me: back then I had much more time,
so I contributed more to Firebird, followed all the newsgroups, etc.
Cheers,
Paul Vinkenoog
and up you can do a full shutdown, if necessary
in combination with -force.
Paul Vinkenoog
, simply because this
is *always* safe.
Paul Vinkenoog
as
well.
You mean the FishBowl docs? Or the Firebird docs? BTW, this nbackup scheme you
used: did it come with Fishbowl or did you set it up yourself?
Paul Vinkenoog
would be to
always use gbak?
If in any doubt, use gbak. But as you can tell from Sean's post, there are
situations where a straight file copy/move is just as safe. Just make sure you
know what you are doing.
Cheers,
Paul Vinkenoog
to propose changes to a manual, the preferred way is to
submit them to the firebird-docs list (to subscribe, mail to
firebird-docs-requ...@lists.sourceforge.net)
People who write or update documentation regularly can get CVS access.
Kind regards,
Paul Vinkenoog
Classic or SuperClassic server at the same time.
Consult the Firebird 2.5 Release Notes for full details.
Cheers,
Paul Vinkenoog
Notes for full details.
Yes - but where is this global lock table? It doesn't tell me if it's a file
somewhere or in the memory of the first server loaded?
Iirc, it's a lock file in ProgramData\Firebird.
Paul Vinkenoog
absolutely no other option.
In the situation you described, the logical thing to do would have been ALTER
DATABASE END BACKUP (or nbackup -N) on the original machine (once you found out
the right credentials, which I believe you did).
Cheers,
Paul Vinkenoog
? After
all, *someone* should know the SYSDBA password, shouldn't they? And how
about the scripts that executed nbackup until they went broken last May?
Do you have read access to them? What authentication method did they
use? And if you can't access those scripts, who can?
Kind regards,
Paul
that the system's Scheduler
function, without any warning or errors, stopped making these nbackups
last May.
Cheers,
Paul Vinkenoog
SYSDBA password.
Kind regards,
Paul Vinkenoog
, straight
file copies are *guaranteed* not to work.
Cheers,
Paul Vinkenoog
a where a.fk = b.target)
Kind regards,
Paul Vinkenoog
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search
that, with the number of
rows as a parameter.
Or use EXECUTE BLOCK.
Cheers,
Paul Vinkenoog
the PRIMARY KEY or UNIQUE.
Kind regards,
Paul Vinkenoog
the PRIMARY KEY or UNIQUE.
Notice that since Firebird 1.5, a unique key constraint does allow multiple
null instances in the column.
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-ddl-table.html#langrefupd25-ct-unique-keys
Cheers,
Paul
Olaf wrote:
great, exactly what I was looking for. Only 1 and 0 is possible.
Then you can also do
Var2 = 1 - Var1
The outcome is the same, but perhaps this is more obvious than bitwise XORing
with 1. And it might execute a wee little faster.
Cheers,
Paul Vinkenoog
.
Firebird 2.5.2 - this is not the case. I get an exception
unsuccessful metadata update SYSDBA is not grantor of Role on MANAGER to
0S0ASDFASDF.
You have to use GRANTED BY here:
revoke manager from 0S0ASDFASDF granted by rdb$admin
Paul Vinkenoog
with a searched delete statement on RDB$USER_PRIVILEGES. Which is a hack of
course, like any direct manipulation of metadata.
It would be better if this were possible in SQL, e.g. by implementing CASCADE
for REVOKE statements (like PostgreSQL has done).
Cheers,
Paul Vinkenoog
,
etc. in a script without generating an error of the object isn't found?
In a pure SQL script, I wouldn't know.
But your application could check if the UDF name exists in RDB$FUNCTIONS and if
so, execute DROP EXTERNAL FUNCTION.
Cheers,
Paul Vinkenoog
that in the tracker for the doc subproject.
Paul Vinkenoog
without
opening your eyes.
You could have someone whisper it in your ear ;-)
Anyway, you can get that information from the Services Manager without opening
a _database_ connection. With JDBC it turns out to be not that simple, but Mark
Rotteveel posted a solution in Firebird-Java.
Cheers,
Paul
it for JDBC).
Cheers,
Paul Vinkenoog
or higher on the client machine.
Hope this helps,
Paul Vinkenoog
a start! ;-)
HTH,
Paul Vinkenoog
/reference_manuals/reference_material/html/langrefupd25-intfunc-datediff.html
Cheers,
Paul Vinkenoog
or with a program the prior line show me just one row.
Why that? And how can I get all the rows?
Since this is a selectable stored procedure, you should retrieve its output (a
dataset) like this:
select identi, name from test
HTH,
Paul Vinkenoog
MySQL supports
(var)chars up to 64K.
Cheers,
Paul Vinkenoog
to the existing
clause).
Good luck,
Paul Vinkenoog
Hi Ed,
merge
into emp
using (select 'mango' fruits from rdb$database) src
on emp.fruits = src.fruits
when not matched then insert (fruits) values ('mango')
Nice trick! That seems to work.
Just realized you can make it even easier:
merge
into emp
using
;-)
Frankly, I never noticed that the optional [AS] for table aliases was missing
from the IB6 docs. Now that I know, I'll mention it in the next revision of the
LangRef Update.
Kind regards,
Paul Vinkenoog
42 matches
Mail list logo