QTP and SYSDATE

[george.j.wen@us.abb.com]

--0__=0yiIN9jvmTHNDdjCEjEtBNBI27FKxI4hNA2VtpIlu20WVc5pRYGiwRgk
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline



Mhhh!  The line of code below works fine on my system (6.07 on AS/400).  Try a
move of
SYSDATE to a numeric and then do the update.  The update of YMDTRANS should
respond
to an update from the numeric field.  I did the following in QTP:
temp aa freeform*8
temp bb numeric*8
item bb = sysdate
item aa = bb
I then generated a subfile of aa and bb values and they were correct:
    AA         BB

 20011016   20011016
 20011016   20011016




|------------->
|(Embedded    |
|image moved  |
|to file:     |
|pic20151.pcx)|
|             |
|------------->
  >------------------------------------------------------------------------|
  |"Richard S. French" <rfrench@axiom-systems.com>                         |
  |10/16/2001 03:14 PM                                                     |
  >------------------------------------------------------------------------|



To:   powerh-l@lists.swau.edu
cc:    (bcc: George J. Wen/NB/USFAC/ABB)
Subject:  RE: QTP and SYSDATE

Security Level:?         Internal




Thanks, but I can't get this to work.
DEFINE TEM-DATE CHAR*8 = ASCII(SYSDATE,8)
I get this message. *E* Type of TEMP-DATE incompatible with expected type.
If I access the dataset and show items the YMDTRANS field shows as NUM,
although the source for the dictionary has it as freeform.

 -----Original Message-----
From:     Ron Olenic [mailto:ROlenic@spectra-inc.com]
Sent:     Tuesday, October 16, 2001 12:59 PM
To:  'Richard S. French'; powerh-l@lists.swau.edu
Subject:  RE: QTP and SYSDATE

My guess would be that the sysdate is being returned in binary format.  The
freeform data type is essentially a character field.  Do an ASCII conversion
of the sysdate, and populate the field using the ASCII value of the date
field.  Insure that you force an 8 character output for consistency.

ascii(sysdate,8)

Ron Olenic

>  -----Original Message-----
> From:   Richard S. French [mailto:rfrench@axiom-systems.com]
> Sent:   Tuesday, October 16, 2001 12:17 PM
> To:     powerh-l@lists.swau.edu
> Subject:     QTP and SYSDATE
>
> Help! I am using QTP version 5.09.02 and trying to update a field in a
> dataset called YMDTRANS. This field is FREEFORM 8 per the dictionary. How
> can I use SYSDATE to return today's date to this field such as 20011016? I
> keep getting 1011016 or 218. Thanks.
>
> Richard S. French
> Professional, Academy for Healthcare Management
>
> Axiom Systems, Inc.
> 'The Managed Care Systems Experts'
> 20300 Century Blvd - Suite 120
> Germantown, MD 20874-1110
>
> 301-840-9165 x 224 Direct
> 707-598-3983           E-Fax
> 301-840-3861           Main
> 301-840-3873           Fax
>
>
> mailto:rfrench@axiom-systems.com
> http://www.axiom-systems.com/
>
>
>


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.




--0__=0yiIN9jvmTHNDdjCEjEtBNBI27FKxI4hNA2VtpIlu20WVc5pRYGiwRgk
Content-type: application/octet-stream; 
	name="pic20151.pcx"
Content-Disposition: attachment; filename="pic20151.pcx"
Content-transfer-encoding: base64

CgUBCAAAAABBADEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAABQgABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAA=

--0__=0yiIN9jvmTHNDdjCEjEtBNBI27FKxI4hNA2VtpIlu20WVc5pRYGiwRgk--