This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C15C83.4B376FC0 Content-Type: text/plain; charset="iso-8859-1" you could try the following, create an oracle stored procedure to process the sequence and return the current value of the sequence, and then call the stored procedure from within Quick as in the example below. stored procedure syntax is below, create or replace procedure x (kount out number) as begin select (seq_order.currval) into kount from dual; insert into mytable (table_index_field) values (seq_order.nextval); commit; end; / below is the procedural code to call the oracle stored procedure which includes an info to display the sequence value returned to the temp item, screen myscr stuff ... temp kount numeric stuff ... proc internal joe3 ; could be a designer begin sql in mydb call x(kount out) info = ascii( kount ) now response end -----Original Message----- From: Maclary, David [mailto:dmaclary@wellington.com] Sent: 24 October 2001 12:49 To: powerh-l@lists.swau.edu Subject: Accessing an Oracle sequence from a Quick screen Does anyone know how to access an Oracle sequence from a Quick screen? If so...how ??? Regards, David Maclary = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list: powerh-l@lists.swau.edu Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu Unsubscribe: "unsubscribe" in message body to powerh-l-request@lists.swau.edu http://lists.swau.edu/mailman/listinfo/powerh-l This list is closed, thus to post to the list you must be a subscriber. This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you. ------_=_NextPart_001_01C15C83.4B376FC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">RE: Accessing an Oracle sequence from a Quick screen you could try the following,
create an oracle stored procedure to process the = sequence and return the current value of the sequence, and then call = the stored procedure from within Quick as in the example = below.
stored procedure syntax is below,
create or replace procedure x (kount out number) = as
begin
select (seq_order.currval) into kount from = dual;
insert into mytable (table_index_field) values = (seq_order.nextval);
commit;
end;
/
below is the procedural code to call the oracle = stored procedure which includes an info to display the sequence value = returned to the temp item,
screen myscr
stuff ...
temp kount numeric
stuff ...
proc internal joe3 ; could be a = designer
beginsql in mydb call x(kount out)
info =3D ascii( kount ) now responseend
-----Original Message-----
From: Maclary, David [mailto:dmaclary@wellington.com]
Sent: 24 October 2001 12:49
To: powerh-l@lists.swau.edu
Subject: Accessing an Oracle sequence from a Quick = screen
Does anyone know how to access an Oracle sequence = from a Quick screen? If
so...how ???Regards,
David Maclary=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to = powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body = to powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you = must be a subscriber.This message may contain privileged and/or = confidential information. If you have received this e-mail in = error or are not the intended recipient, you may not use, copy, = disseminate or distribute it; do not open any attachments, delete it = immediately from your system and notify the sender promptly by e-mail = that you have done so. Thank you.
------_=_NextPart_001_01C15C83.4B376FC0--