Eric,
Yes, the optimizer can use an index with a WHERE on a VIEW, but only when the
view is local, not when using EXECUTE STATEMENT on an external database.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
From: Eric Guéguiniat eric.gueguin...@gmail.com [firebird
I wonder, Lucas, what will you be publishing then? :)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
-Original Message-
Am
Triggers don't
have
code.
Hope this helps.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
On 07.11.2018 19:27, 'Martijn Tonies (Upscene Productions)'
m.ton...@upscene.com [firebird-support] wrote:
> Yes, it's true and it's rather annoying when, for example,
r stored procedure with wrong list of
>parameters, and it will give error only at the execution time?
I'll let you know.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Regards,
Alexey
On 07.11.2018 19:27, 'Martijn Tonies (Upscene Productions)'
m.ton...@upscene.com [fi
Yes, it's true and it's rather annoying when, for example, developing an
interactive database development tool ;)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase
Hi all,
Could this be related to:
https://blog.mertech.com/windows-10-version-1803-breaks-some-shared-folder-applications
"This means that applications started from these environments can’t open a
connection to a database server."
With regards,
Martijn Tonies
Upscene Produc
mean? How to parse it, or how to get it?
>>
>> How to get it, without using isql.
>
>Vlad already answered that:
>
> > Pass isc_info_sql_explain_plan (value 26) into isc_dsql_info()
>instead of isc_info_sql_get_plan (value 22)
I missed that, thanks.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
>On 23-2-2018 11:58, 'Martijn Tonies (Upscene Productions)'
>m.ton...@upscene.com [firebird-support] wrote:
>> I wonder, how can applications use this feature
>> https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-dml-planoutput.html
>
>What d
Hello Mark,
How to get it, without using isql.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
-Original Message-
From: Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
Sent: Friday, February 23, 2018 1:03 PM
To: firebird-support@yahoogroups.com
Subject
Hi,
I wonder, how can applications use this feature
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-dml-planoutput.html
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server
Hi,
Remove the VALUES(( part
There’s no need for a VALUES keyword if you use a SELECT to insert rows.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB
Hello Michał,
Firebird 3 uses the following syntax:
COMMENT ON IS 'value'
COMMENT ON COLUMN . IS 'value'
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB
Hello Dmitry,
>28.03.2017 10:06, Martijn Tonies wrote:
>>
>> So the first 'fetch' operation on a position that's invalid returns
>> "rowcount=0",
>> any additional fetch (which includes a move) returns an exception?
>
>Yes. Moving cursor from
Hello Dmitry,
So the first 'fetch' operation on a position that's invalid returns
"rowcount=0",
any additional fetch (which includes a move) returns an exception?
That seems to be the case.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
-Origin
use:
fetch absolute 11 from c into :p_out1;
I wonder, should the first fetch next that returns no data, return row_count=0,
or also the ‘fetch past record stream’ error?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, M
Hello Aldo,
Generators are NOT influenced by transactions, so yes, that is correct.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird
Hello Dimitry,
>05.01.2017 12:17, 'Martijn Tonies (Upscene Productions)'
>m.ton...@upscene.com
>[firebird-support] wrote:
>> Any idea what this error code means?
>
> "Default values for parameters are allowed only in declaration of
> packaged function @1.@2"
Hi all,
Any idea what this error code means?
RECREATE PACKAGE BODY PCK_TEST failed
unknown ISC error 336068898
while executing:
RECREATE PACKAGE BODY PCK_TEST AS
begin
... code
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool
on to preserving case, is to use double quotes around the
object names.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
Hello Nico,
If you want the case preserved, you have to use double quotes, always.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
We want
a host name to this command line.
Ah, that's what I tried at first, but failed with the -se option included.
I tried a connection string with host, but without -se now, and that works
as well.
Seems there's multiple ways of doing things. ;)
With regards,
Martijn Tonies
Upscene Productions
>22.06.2016 12:14, 'Martijn Tonies (Upscene Productions)'
>m.ton...@upscene.com
>[firebird-support] wrote:
>> When connected to the database from another application, here:
>> C:\Program Files\Firebird\Firebird_3_0>gbak -b -m -t -v
>> -user sysdba -pas
hus without
>quotes)?
No, cause the database name contains spaces ;) And it works fine using the
services API (via a Delphi component).
Could that be the cause of the multiple sources/destinations error? If so,
I'll
take it this is a parsing error in gbak?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
le would be nice. ;)
With regards,
Martijn Tonies
Upscene Productions
switch. But I can’t get it working, any clue?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
old
>row),
>would then always have a single row assigned to be the default and avoids
>the recursive trigger.
Alternatively, make this part of the trigger only fire when ISDEFAULT = T,
then you can safely set ISDEFAULT to 'F' from within the trigger.
With regards,
Martijn Tonies
U
single row assigned to be the default and avoids
the recursive trigger.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Hi,
First question: why do you have an UPDATE in a BEFORE UPDATE
trigger on ?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Hi All,
I have a BEFORE
.
In the SQL Editor, you can actively start a transaction by yourself and the
commit/rollback
buttons will always be enabled.
Hope this helps, if not, feel free to write to me personally.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS
... )
values (:myassid, ... other columns ... )
/* other inserts */
insert into ...
end
or
insert into assignments(... other columns ... )
values ( ... )
returning_values assid into :myassid;
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle
view, if you want to modify data,
update it.
Something else doesn't make sense.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
nversion supported,
but an other, that looks the same to the user, fails?
This is counter intuitive.
(and yes, I do read between the lines you don't feel compelled to change it)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
do the same.
That's confusing.
Why would an external function require a field name as the "blob value"? It
expects a blob value. From the user point of view, I see no reason why this
can't be a temporary blob, or a just-converted-blob, like the SQL INSERT
statement can.
Wi
MP_BLOBS PRIMARY KEY (ID)
);
insert into BMP_BLOBS
values (-1, X'101010', 'test')
How is the declared function any different?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
are not supported for
conversion operation “
But as far as I can see, X’10’ returns a binary string, a blob?
Firebird 2.5.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB
Hello Vishal,
Is there any tool available which would show the relationship/linking
between tables for Firebird database ?
Our Database Workbench tool does that.
http://www.upscene.com/documentation/dbw5/dia_pdm_reverse_engineering.htm
With regards,
Martijn Tonies
Upscene Productions
http
(
T T L NATURAL
),
L INDEX (TICKETLABELID)
)
And how about the final INDEX specifier?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
values
by 1)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
If there's some code which says if there isn't an EXXON then create
one, and there's
.
Or extract a script for all procedures that does these
create-with-empty-body-and-then-alter-cycle.
Hope this helps.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB
Hi,
Text values go inside single quotes:
WHERE mycol = ‘value’
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
I am having trouble writing a query
Hi,
Looks like ISQL is right and EMS SQL Manager is wrong.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: mailto:firebird-support@yahoogroups.com
that the presentation of the same data (= varchar with special
characters) would change in isql if I switch charset.
What application is show ö and what isn't? And is that valid?
With regards,
Martijn Tonies
Upscene Productions
Von: firebird-support@yahoogroups.com
[mailto:firebird-support
qryUpdateManifestBLOB.ExecSQL;
which Firebird did not like because LoadToFile is an unknown function.
See above.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
When executing the procedure, UTF8/WIN1251/WIN1250 connected, I get:
exception 1 TEST 1ТЕСТ ÐРБЪЛГÐРСКИ At procedure 'TEST' line:
4, col: 3
This -could- be my error, but how do I verify?
When I try in isql, I get the same.
With regards,
Martijn Tonies
Upscene Productions
http
Hello Dmitry,
I'm still puzzled.
29.01.2015 19:15, Martijn Tonies wrote:
2) Create SP with EXCEPTION ERROR 'some Cyrillic string';
Done. In the source, I see the following:
begin
exception test _utf8
X'31D0A2D095D0A1D0A220D09DD09020D091D0AAD09BD093D090D0A0D0A1D09AD098';
end
You
this won't work either? Or at least, not in my test?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
string.
But this doesn't seem to work either?
Does this work at all with Exceptions?
AFAIU, your trick (exception parameter) should work.
Hmm, I'm puzzled then, cause it doesn't seem to work at first sight.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download
with Exceptions?
AFAIU, your trick (exception parameter) should work.
Hmm, I'm puzzled then, cause it doesn't seem to work at first sight.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL
idea how to do this?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
string here';
When I look at RDB$PROCEDURES.RDB$PROCEDURE_SOURCE I can see
the text is inserted as a hex string.
But this doesn't seem to work either?
Does this work at all with Exceptions?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench
Hello Christoph,
Database Workbench supports some of the new features in Firebird 3 – for
example, the packages.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB
Hello Dmitry,
12.12.2014 23:08, 'Martijn Tonies wrote:
But using ROWS instead of FIRST makes using a parameter possible
FIRST (:CNT) does the trick as well.
Oh, good one, let's see if I can remember. ;)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download
‘;
But using ROWS instead of FIRST makes using a parameter possible, so it seems:
IN (SELECT ... FROM ... ROWS :CNT)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB
$GET_CONTEXT
message. What am I doing wrong?
Well, I'm getting:
Invalid namespace name system passed to RDB$GET_CONTEXT
But at least the function works.
In Database Workbench, if you expand the UDFs node after establishing a
database connection, is RDB$GET_CONTEXT listed?
With regards,
Martijn
Hello Dixon,
Is this using the ROWS on your UPDATE or on your SELECT?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: mailto:firebird-support
, is this the same when you create a new
database?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: mailto:firebird-support@yahoogroups.com
Sent: Friday
Create a backup with Firebird 1.5, restore it with 2.5.
Make sure to keep a copy.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: mailto:firebird
select count(case_number) as counted, case_number
from ACCT_CASE_COURT
group by case_number
?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From
Hello Mike,
select
count(CASE_NUMBER), CASE_NUMBER
from
ACCT_CASE_COURT
group by CASE_NUMBER
having count(CASE_NUMBER) 1
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase
Good morning SET. ;)
I thought of the concatenation trick, but found it ugly as a solution, your
second query
is cleaner, I think.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL
Hello Mike,
In the second query, you’re counting records and then do the DISTINCT, so the
result is 32, and if you “distinct” that result, there’s only 1 record, with a
value
of 32.
What you seem to want, is to COUNT(DISTINCT(...))
With regards,
Martijn Tonies
Upscene Productions
http
?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
- Original Message -
From: mailto:m.ton...@upscene.com [firebird-support]
To: firebird-support
table, but these are available in Firebird 2
onward.
The alternative is to create a VIEW for the DISTINCT query and COUNT on that.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase
of these or what combination are unique with
regard to each
ACCT_CASE?
If none, you would need a derived table, but these are available in Firebird
2 onward.
The alternative is to create a VIEW for the DISTINCT query and COUNT on that.
With regards,
Martijn Tonies
Upscene
”,
the problem goes away.
Is it safe to always use “wait” on such transactions?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
!
I’ve verified this in Database Workbench, BLOB Editor for hex values, returned
is:
3634
And using f_blobsize function in FreeAdhocUDF, which returns a size of “2”.
Any clue why this happens?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench
Wouldn’t leaving out the “temp trigger” and “foo” and simply doing:
update sometable set id = gen_id(some_table_id_gen, 1);
have the same result?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere
I think this needs a
GROUP BY a.Project_PK
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: mailto:firebird-support@yahoogroups.com
Sent: Tuesday
It did, but my fingers were quicker.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: mailto:firebird-support@yahoogroups.com
Sent: Tuesday
Hello Patrick,
Yes, that is correct, meta data changes need to be committed as well.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From
Hello Alan,
The domain check constraint is available, however, it is a custom
written check constraint, like for example:
CREATE DOMAIN ...
CHECK (
VALUE IN ('Y', 'N')
)
This source can be found in the system tables, table RDB$FIELDS
column RDB$VALIDATION_SOURCE
With regards,
Martijn Tonies
Hello Wolfgang,
ALTER TABLE tablename DROP CONSTRAINT INTEG_485
That should do the trick.
Or find the constraint and simply click Drop in Database Workbench. ;)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server
Hello Maxi,
Check constraints are table based, not column based.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: mailto:firebird-support
this issue with recent versions of Database
Workbench?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Hello Tim,
Hmm, if Firebird allows you to store such characters, I would expect
Database Workbench
to support it. ;)
If you can find a reproducible case, let me know.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL
Hi,
This might help:
http://www.connectionstrings.com/firebird/
On the client, you need to install the Firebird client, on the server, you need
to have Firebird running.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL
Hi,
If you have the Firebird installer, it has an option to install the client only,
this is all the client machine requires.
With regard to the server, either superserver/classic (which is an architecture
thingy), both are fine.
With regards,
Martijn Tonies
Upscene Productions
http
Hi,
I know next to nothing about VB. So, what type of driver are you using?
And don’t forget, “didn’t work” tells us exactly nothing.
Any error message?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
a copy of Database Workbench ( www.upscene.com/go/?go=dbw )
so you can access both Firebird and MS SQL Server and use it to transfer the
data (and/or
meta data).
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server
(ORDERID)
);
As you can see, the COMPUTED BY clause has a double set of parenthesis,
allowing you to use the procedure.
Hope this helps.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL
Hi,
Use the “double pipe”: ||
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: dres...@tbinc.com
Sent: Thursday, March 20, 2014 6:51 PM
Hi,
I’ve got a database from a customer with a timestamp value
with a time part of 24:00:00..
It this supposed to be possible on Firebird 2.5.2?
isql reports an error when selecting the value:
“ value exceeds the range for valid timestamps “
Any clue?
With regards,
Martijn Tonies
Upscene
incorrect.
This query returns the value as 24:00:
select
T_DATACZAS, cast(T_DATACZAS as char(24))
from
BATCH_DOBOWE where D_IDPOMIARU=97
The results:
DATACZAS CAST
2014-01-04 2014-01-03 24:00:00.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database
supports:
- Borland InterBase ( 6.x and up )
- Firebird ( 1.x and up )
- MS SQL Server/MSDE ( 7 and up )
- MySQL 4.x and up
- Oracle Database ( 8i and up )
- Sybase SQL Anywhere ( 9 and up )
- NexusDB ( 3.0 and up )
Thank you for your support,
Martijn Tonies
Database Workbench - the database
is safe (as long as you follow thread per attachment rule).
Hope it is clear now,
Thanks, also calls to Services API and so on follow the same rules?
Getting database info (pages/pagesize/etc)?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database
Hi all,
Can someone let me know if the following is thread-safe:
- a client library from Firebird version 1, 1.5, 2 or 2.1
- using a connection per thread
- executing calls via multiple threads
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database
cannot be done while another
thread is already waiting for the API to return, right?
Regards,
Vlad
PS v2.5 client should be free from the limitations above, you surely know
it :)
Yes.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench
to do that ?
Hm, that is surprising.
Newer versions of Firebird support altering the COMPUTED BY clause.
What version of Firebird are you using?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL
');
// drop temporary computed field
ALTER TABLE DML_TEST1 DROP DBW$$TEMP;
If this doesn't help for you, I'd be interested in a copy of the database to
see what's going on. ;)
Hope this helps.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench
the computed by field
and it will generate the required statements for you.
Note: it's tricky, but has been proven as working.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB
Hello Michael,
I'll send you one of my old presentations about the system tables.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
I have found the way
Hi,
Use RDB$DEFAULT_SOURCE
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
the
default value.
ALTER DOMAIN domainname DROP CONSTRAINT;
ALTER DOMAIN domainname ADD CONSTRAINT CHECK (...);
Or use a GUI tool like Database Workbench that does this for you. ;)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL
:-)
Of course, but you could see the result without having to check the
documentation. ;)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
when I must recompile of PROC_A because
something in body of PROC_B has changed.
Correct.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
the problem? It becomes un-quoted...
Try:
WHERE D.CREATE_DATE = ''' || tsEndDate ||
INTO ...
Where ''' = ' ' ' (with no spaces) and = ' ' ' ' (with no spaces)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server
I need to make a sync app to do the move?
You can download a trial of Database Workbench at www.upscene.com
and use the DataPump to do this, see:
http://upscene.com/documentation/dbw4/tools_datapump.htm
Hope this helps.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
.
As I said, Walter, with Database Workbench you can insert an image
by using a user interface.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
column you still want to use as text?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
the content and
then to save it in the new format. But depending on the choice of the way
to go, this could be irrelevant.
You are modifying the blob to BINARY, that doesn't sound right.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench
1 - 100 of 122 matches
Mail list logo