Thanks for the confirmation David,
I was just putting it together when I received this response.
----- Original Message -----
From: "David M. Blocker" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, June 22, 2005 11:29 PM
Subject: [RBG7-L] - Re: getproperty question
Yes it should. I suggest you file this as a boo boo!
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:39 PM
Subject: [RBG7-L] - Re: getproperty question
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
>> >> >
>> >> >
>> >>
>> >>
>> >>
>> >
>> >
>>
>>
>>
>
>
