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