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