That's not the problem David,
tSqNo is returned as either blank or some strange text number
For example, the sequence no is 27 but is returned as 1879062322
----- Original Message -----
From: "David M. Blocker" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, June 22, 2005 9:24 PM
Subject: [RBG7-L] - Re: getproperty question
Bernie
Varaible tSqNo must be datatype TEXT
If you want the answer returned as an integer
SET VAR iSqNo INTEGER = NULL
SET VAR tSqNo TEXT = NULL
getproperty vseqno textvalue 'tSqNo'
SET VAR iSqNo = (INT(.tSqNo))
David
David Blocker
[EMAIL PROTECTED]
781-784-1919
Fax: 781-784-1860
Cell: 339-206-0261
----- Original Message -----
From: "Bernard Lis" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, June 22, 2005 8:51 PM
Subject: [RBG7-L] - Re: getproperty question
I put a sequence no (autonumbered) into the contact table in Concomp.
in the OneToManyScrolling form, I located this sequence no.
set a component id vSeqNo
getproperty vseqno textvalue 'tSqNo'
I get an erroneous number when I display tSqNo
Is it proper to use this getproperty on an integer number field? Or must
the field be text in order to retrieve it?
Bernie Lis
----- Original Message -----
From: "Bernard Lis" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, June 22, 2005 6:16 PM
Subject: [RBG7-L] - getproperty question
> in a temporary table, I have an autonum sequence No. (integer No.)
> initially, 20 rows are generated that contain the order no. and the seq
> no.
> in the first row in the (edit using) form, in an eep, I do
>
> getproperty vSeqNo textvalue 'tSqNo'
>
> The value returned in tSqNo is blank
> Is it because it's a temp table? or what could I be doing wrong?
>
> Bernie Lis
>
>
