Any function runs into a single transaction so you don't need to worry
about rolling back on exceptions - this is the standard behavior. If there
is an exception while running any statement inside the function it's
rolls back automatically.
On Tue, 05 Dec 2006 17:25:31 +0200, Marian
if;
...
and in this way vNrBon is correct one ... I will try to use oly
execute on insert,update and select on temp table MagMaxNrBon
(o_gen_calc_nr_doc is the get_me_next_number function)
thank you,
Adria Din
On Mon, 04 Jul 2005 17:27:20 +0200, Zac [EMAIL PROTECTED] wrote:
Din Adrian wrote:
Yes
I am sorry but:
the table is TEMPORARY ... I don't need to do any lock on it
(eventualy I should do a lock on the table where I want to insert the
documents - the MagMaxNrBon is only a temp table used for storing the max
document nr for each user's setings in this transaction - I did
Hello,
I have a 'big' problem:
I am trying to run from a procedure a function witch generate a new
document number (max from table +1 ) and after to insert a document with
this number, but the function returns me the same number each time because
the tranzaction is not finished and the
Yes , I know what sequence is, but our procedure for generating doc
numbers is v. big and has manny (4) parameters and we did'nt use sequence
in it for this reason
any other advice ?
thak you,
Adi
On Mon, 04 Jul 2005 14:47:16 +0200, Zac [EMAIL PROTECTED] wrote:
Din Adrian wrote
An example(found it some time ago somewhere ?! :) ):
/*
drop view a_and_b cascade;
drop table tbla cascade;
drop table tblb cascade;
*/
CREATE TABLE tbla
(
id int4 NOT NULL,
a int4,
b varchar(12),
CONSTRAINT tbla_pk PRIMARY KEY (id)
)
--WITHOUT OIDS
;
CREATE TABLE tblb
(
id int4 NOT NULL,
] wrote:
So you installed psqlodbc 8 on the client machine with Delphi installed,
correct? What problems did you have with cursors? Any other
suggestions?
Thanks a lot for the help!
J
Din Adrian wrote:
we are using postgresql8 +psqlodbc8+ delphi7 ... the only problem is
the server side cursor
We tested also (pgExpress Driver) - is faster then psqlodbc but we have a
problem with it:
it does requery (or refresh? - I don't remember exactly) after every post
in database.(for us this is a problem - if you have more then 10.000 in
current dataset loaded when you add a new record and
. What we did was include one refresh button and inserted
one configuration that after x seconds the component refresh the screen
(query).
If you find a better solution, please inform me.
Regards,
Rodrigo
Din Adrian wrote:
We tested also (pgExpress Driver) - is faster then psqlodbc but we have
the round sintax is
round(numeric,int)
not
round (double,int)
you must cast the value into numeric:
ex: round (cast(doublecolumn as numeric),2) should work ok
Adrian Din,
Om Computer SoftWare
On Sun, 27 Feb 2005 15:26:07 -0800, TJ O'Donnell [EMAIL PROTECTED] wrote:
I received the following error
to me, so that others
can help too.
Din Adrian wrote:
On Thu, 03 Feb 2005 13:56:50 +, Richard Huxton dev@archonet.com
wrote:
Please CC the mailing list as well as replying to me, so that others
can help too.
b) in docs say that after 7.2 seting this to false does'n turn off
Hello,
I am want to use a private table in postgresql(every client to see his own
data).
Is this possible? How can I do it!
Thank you,
Adrian Din
--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
---(end of broadcast)---
TIP
Hello,
I have a little problem
I want to declare a type record for later use like that
create type record_structure1 as (id int2, nume text);
that is ok!
next in a function I want to use something like that:
select * from table as record_structure1 ?
instead of writing
select * from table as t1(id
Hello,
I have a 'big problem' :
I have to show some data from two identical databases so I need to run a
querry (view, ..etc) on both databases and show the united result ...
Any ideea how to obtain this result ?
Thank You,
Adrian Din
--
Using Opera's revolutionary e-mail client:
14 matches
Mail list logo