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