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 POPE
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 that
e
update MagMaxNrBon set maxnrbon=vNrBon where magazie =
dsgroup.magazie_implicita_lansare;
end 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_n
t;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 know what sequence is, but our procedure for generating doc
numbers is v. big and has manny (4) parameters and we did'nt use
se
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 A
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 inser
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,
TECTED]> wrote:
Hi Adrian,
You're right. 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
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 pos
<[EMAIL PROTECTED]> 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 pr
we are using postgresql8 +psqlodbc8+ delphi7 ... the only problem is the
server side cursor = doesn't work properly ... so we are using client side
for datasets :)
On Wed, 15 Jun 2005 23:49:29 -0400, Postgres Admin
<[EMAIL PROTECTED]> wrote:
I have a client who wants to use Delphi
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 err
that others
can help too.
Din Adrian wrote:
On Thu, 03 Feb 2005 13:56:50 +, Richard Huxton
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
the wall ...!? wich o
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 9:
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: http://www.oper
16 matches
Mail list logo
