thanks john and dave u always help me.
On Feb 11, 2008 2:13 AM, John Weller <[EMAIL PROTECTED]> wrote: > Hi Tanvir, > > As Dave said earlier you must use > > APPEND FROM (tfile1) TYPE sdf > > if the file name has a space instead of > > APPEND FROM &tfile1 TYPE sdf > > Good luck > > John Weller > 01380 723235 > 07976 393631 > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of tanvir ahmad > > Sent: 11 February 2008 10:03 > > To: [EMAIL PROTECTED] > > Subject: Re: tabs > > > > > > i m also using vfp9 sp2 > > > > i m importing data from a text file, for storing .txt file name i > > use a Text > > Box > > > > in the Textbox1.click event > > tfile = GETFILE() > > this.Value = tfile > > > > after select file name, a command button click event > > > > tfile1 = TRIM(ThisForm.Text1.Value) > > > > SELECT timp1 > > APPEND FROM &tfile1 TYPE sdf > > > > at append command show error if selected file name has any blank space. > > > > > > > > > > > > > > On Feb 11, 2008 1:47 AM, Dave Crozier <[EMAIL PROTECTED]> wrote: > > > > > Tanvir, > > > Don't really know what you mean here and as per John, it works fine. > > > > > > If you are taking the returned file name and using it as a parameter > > > within > > > a VFP expression you need to enclose it in brackets. > > > > > > Example > > > > > > cName=getfile(...) > > > > > > use &cName. > > > > > > This won't work, however > > > > > > Use (cName) will > > > > > > This is the only thing I can think of that you may be getting the > error > > > from > > > > > > Dave Crozier > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf > > > Of tanvir ahmad > > > Sent: 11 February 2008 05:14 > > > To: ProFox Email List > > > Subject: Re: tabs > > > > > > hi > > > i am using getfile() , but if give file name with blanck space lick > > > "c:\drgb data\mn sep08.txt" i'ts give message "command contains > > > unrecognized phrase/keyword" any solution about it. > > > > > > On Feb 8, 2008 4:49 AM, Dave Crozier <[EMAIL PROTECTED]> wrote: > > > > > > > Correct! > > > > > > > > Dave Crozier > > > > > > > > -----Original Message----- > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > > Behalf > > > > Of Allen > > > > Sent: 08 February 2008 10:50 > > > > To: [email protected] > > > > Subject: RE: tabs > > > > > > > > hhmm there something I didnt know. well one other thing. > > > > Do you know if that also clears spaces as well or just the chars > > > > mentioned. > > > > I suppose you could do alltrim(exp,chr(9)," ") > > > > Allen > > > > > > > > > > > > -----Original Message----- > > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > > > On > > > Behalf Of Dave Crozier > > > Sent: 08 February 2008 11:48 > > > To: [EMAIL PROTECTED] > > > Subject: RE: tabs > > > > > > Correct, > > > But Alltrim(<<Expression>>,chr(9)) does > > > > > > Dave Crozier > > > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf > > > Of Al > > > Sent: 08 February 2008 10:05 > > > To: [email protected] > > > Subject: tabs > > > > > > Hi foxgang. > > > I never realised this. Might put a new light on the tabs v spaces :) > Not > > > really. > > > alltrim does not clear tabs. yikes. > > > Allen > > > > > > No virus found in this outgoing message. > > > Checked by AVG Free Edition. > > > Version: 7.5.516 / Virus Database: 269.19.21/1265 - Release Date: > > > 07/02/2008 > > > 11:17 > > > > > > > > > > > > [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.
