Try vartype(<fieldname>). The field() function returns a character field name - always type "C." Lew
-----Original Message----- From: Sytze de Boer <[email protected]> Sender: [email protected] Date: Thu, 16 Jun 2011 07:31:26 To: <[email protected]> Reply-To: [email protected] Subject: Re: Field type Here's what I find Field 74 is a logical field in the table ?type(field(74)) returns L ?vartype(field74)) returns C Thank you all for your help S On Thu, Jun 16, 2011 at 3:24 AM, Lew <[email protected]> wrote: > What's wrong with just vartype()? > Lew > > -----Original Message----- > From: Garrett Fitzgerald <[email protected]> > Sender: [email protected] > Date: Wed, 15 Jun 2011 10:55:03 > To: <[email protected]> > Reply-To: ProFox Email List <[email protected]> > Subject: Re: Field type > > On Wed, Jun 15, 2011 at 01:59, Sytze de Boer <[email protected]> wrote: > > Old age or what > > > > I need to know if the field in a table is logical or character > > Something like > > If fieldtype(16)="L" > > blah > > endif > > AFIELDS(laFList) > IF laFList(16, 2) = "L" > blah > ENDIF > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/[email protected] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1906592064-1308166562-cardhu_decombobulator_blackberry.rim.net-1011281453-@b17.c12.bise6.blackberry ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
