SV: QTP rollback & commit
Jari.S.Kaljunen@telia.se
Jari.S.Kaljunen@telia.se
Fri, 18 May 2001 17:08:00 +0200
Try this : first make it krach at final
source test.qts:
acc frontline
choose flkod "JAR"
def a char*1 = parm prompt "shall we ?"
def b int*1 = nconv(a) if a = "N"
output frontline update
item bkod final "AJK"
sub e at final inc b
go
acc frontline
choose flkod "JAR"
def a char*1 = parm prompt "shall we ?"
def b int*1 = nconv(a) if a = "N"
output frontline update
item bkod final "AJK"
sub e at final inc b
go
results:
Q T P (7.10.G)
Copyright 1998 COGNOS INC. (ALPHA)
Licensed PH-AXP-RUNTIME for customer: 8200290001 Sergel Kredttjanster
AB axp
QTP> use test
QTP> acc frontline
QTP>
QTP> choose flkod "JAR"
Choose viaindex FRONTLINE_FLKOD_IX.
QTP>
QTP> def a char*1 = parm prompt "shall we ?"
QTP>
QTP> def b int*1 = nconv(a) if a = "N"
QTP>
QTP> output frontline update
QTP> item bkod final "AJK"
QTP>
QTP> sub e at final inc b
QTP>
QTP> go
Executing request 1 ...
shall we ?N
------------------------------------------------------------------------
-------
Data conversion error.
[1]
Item: B
File: E
Action Taken: Run terminated.
------------------------------------------------------------------------
-------
Records read:
FRONTLINE 1
Transactions processed: 1
Records processed: Added Updated Unchanged
Deleted
FRONTLINE 0 1 0
0
E 0 0 0
0
Finished.
------------------------------------------------------------------------
-------
Changes made since the last commit have been rolled back to a stable
state.
Therefore, statistics reported may be incorrect.
------------------------------------------------------------------------
-------
QTP> use test
QTP> acc frontline
QTP>
QTP> choose flkod "JAR"
Choose viaindex FRONTLINE_FLKOD_IX.
QTP>
QTP> def a char*1 = parm prompt "shall we ?"
QTP>
QTP> def b int*1 = nconv(a) if a = "N"
QTP>
QTP> output frontline update
QTP> item bkod final "AJK"
QTP>
QTP> sub e at final inc b
A temporary subfile with the same name already exists. Ok to delete?y
QTP>
QTP> go
Executing request 1 ...
shall we ?J
Records read:
FRONTLINE 1
Transactions processed: 1
Records processed: Added Updated Unchanged
Deleted
FRONTLINE 0 1 0
0
E 1 0 0
0
Finished.
QTP>
-----Ursprungligt meddelande-----
Från: GGrimm@pcc-structurals.com [SMTP:GGrimm@pcc-structurals.com]
Skickat: den 17 maj 2001 23:36
Till: powerh-l@lists.swau.edu
Ämne: QTP rollback & commit
I'm looking for a way to easily do a commit or a rollback in a
dynamically run QTP based on a visual review of the run statistics
for
"reasonableness". Anybody have an idea how? I have seen QTP do a
rollback when "badness" happens so know there is a way:=) I've
tried a
COMMIT at RUN and then done a Ctrl Y which sometimes causes an
abort
but nothing much happened.
(PowerHouse 8.13.D3)/Oracle 8.0.5.0.0/HP-UX B.11.00
See my simple code:
> access *TA_one link to TIME_ATTEND link to TIME_ATTEND_2
Access TIME_ATTEND viaindex TIME_ATTEND_EMPLOYEENO_1.
Access TIME_ATTEND_2 viaindex TIME_ATTEND_2_PK.
> output TIME_ATTEND delete
> output TIME_ATTEND_2 delete
> go
Executing request 1 ...
Records read:
TA_ONE 1
TIME_ATTEND 134
TIME_ATTEND_2 134
Transactions processed: 134
Records processed: Added Updated Unchanged Deleted
TIME_ATTEND 0 0 0 134
TIME_ATTEND_2 0 0 0 134
Finished.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
<<Fil: QTP rollback & commit.TXT>>