Thanks Steve, that worked -- I just talked to the developer that created that column name and reminded him of our no embedded space rule for column names or variable names.
v/r //SIGNED// Stephen S. Wolfe, YA2, DAF 6th MDG Data Services Manager 6th MDG Information System Security Officer Comm (813) 827-9994 DSN 651-9994 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Russell Sent: Monday, October 27, 2008 3:26 PM To: ProFox Email List Subject: Re: VFP8: How-To and building a remote view, one little question On Mon, Oct 27, 2008 at 12:36 PM, Wolfe, Stephen S Civ USAF AMC 6 MDSS/SGSI <[EMAIL PROTECTED]> wrote: > I have run across a column name in our HCIA database which is named > Birth Date, in all over our other tables this is called DOB, anyway, the > remote view builder puts quotes around the Birth Date like this "Birth > Date", but when I test the query it comes back and says it doesn't like > the exp -- I assume this is the expression. > > Without changing the column name in the SQL table how do I get the fox > to like it? ------------------------- [ ] should work. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 [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.
