Hi Folks,
Is it recommended to recompile all DDL after an ODS upgrade?
Could the resulting BLR hold improvement? Or does a backup from
the database in the older ODS format and restore to the newer
ODS format take care of this automatically ?
Best Regards
Hans
Using the SQL CASE in your update statement may work.
Best Regards
Hans
Sent from my iWatuski
On 2012-07-01, at 9:17 AM, "Ahmad F. Sarhan" wrote:
Hey everyone,
I need your help in one of 2 questions please,
1st.
i need to update my table with multi values , each value h
Isn't it possible to write one SQL procedure
for all the 'Rules'. Should be much faster
than shipping data from the database,
apply some 'Rule' and shipping it back
to the database. If anything fails in
the SQL procedure or a data error was
detected by some 'Rule' and exception
rolls everything bac
Maybe use a generator instead of count(*)+1
-
Like gen-I'd
Sent by iPhone
On 2012-07-10, at 6:51 PM, "firebirdsql" wrote:
When I run the below query as a stored procedure asynchronously 1000 times, it
results in duplicate numbers:
select count(id) from test_table into :number;
insert into te
This maybe close to what you wanted to achieve
or may give you some ideas how to approach it.
Created Table t1
CREATE TABLE T1 (
SD INTEGER
, ID INTEGER
, RE INTEGER
, PAYINTEGER
, CASH INTEGER
)
//Get records from database
$result = mysql_query("SELECT * FROM people;");
//Add all records to an array
$rows = array();
while($row = mysql_fetch_array($result))
{
$rows[] = $row;
}
=
http://ibexpert.net/ibe/index.php?n=Doc.Array
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of jb...@ymail.com
Sent: Sunday, December 30, 2012 9:10 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Declare an
Maybe a Temporary table will do it. Something like:
CREATE GLOBAL TEMPORARY TABLE SESSION_VARS
(
USER_UNIQUENUM integer NOT NULL,
TICKET_UNIQUENUM integer NOT NULL
)
ON COMMIT PRESERVE ROWS; (More options available here)
It is unique for each connection and lasts as long as the connection l
Why dig yourself in deeper?
Doubt anyone offers much support for out-of-date versions
>- thanks for the fast response.
>- That could be an option, unfortunately GTTs were added only in 2.1 (I'm
running on 2.0.6):
Best Regards
Hans
Thank you Scott.
I didn't expect that expected behaviour.
Simply wrote a little program to check
my SQL DDL source for that condition
and found another occurrence, but
harmless one :)
Best Regards
Hans
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-su
11 matches
Mail list logo