The datafield is integer, the getproperty should return that number as text,
then I can convert it back to integer
My question is, isn't it supposed to return the text value of that column
even if it's integer?
Bernie
----- Original Message -----
From: "David M. Blocker" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, June 22, 2005 9:36 PM
Subject: [RBG7-L] - Re: getproperty question
But what data type is it?
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 9:29 PM
Subject: [RBG7-L] - Re: getproperty question
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
>> >
>> >
>>
>>
>>
>
>
