If you're comparing TYPE vs. VARTYPE, TYPE is the way to go when you want to check a data type in a table or cursor. VARTYPE will throw an error if the field doesn't exist.
-- rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Lew Sent: Wednesday, June 15, 2011 3:36 PM To: [email protected] Subject: Re: Field type 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 _______________________________________________ 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/DF1EEF11E586A64FB54A97F22A8BD044192AF5D29A@ACKBWDDQH1.artfact.local ** 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.
