But Sir numeric field data contain Alphabets. I tried your 1st one example and result got Zero. On Apr 14, 2014 4:13 PM, "Dave Crozier" <[email protected]> wrote:
> OK, Try the following, > > * Gives a string whatever the format of numericfield > MyBranch=transform(numericfield) > > or > * This gives max length and 2 x decimal places > MyBranch=transform(numericfield, "@rl 999,999.999") > > or > > * Using Str() function to convert from number to a string > nLength = 10 > nDP=2 > MyBranch=Alltrim(Str(numericfield,nLength, nDP) > > There are lots of other ways also but these are the most common ones. > > Dave > > -----Original Message----- > From: ProFox [mailto:[email protected]] On Behalf Of Naushad Ali > Ali > Sent: 14 April 2014 14:08 > To: [email protected] > Subject: RE: A DBF file that file have field is numeric and data String. > > Memory variable Like MyBranch=numericfield, and variable should be string > (character). > On Apr 14, 2014 3:59 PM, "Dave Crozier" <[email protected]> wrote: > > > We need to know what you want to do in more detail.i.e where & what do > > you want to transfer data. Please be more specific. Do you need to > > transfer to memory variables, report bariables, VFP created object > properties etc. etc. > > > > Once you tell us this then we can help. At the moment your request is > > more of a statement and NOT a request. > > > > Dave > > > > > > -----Original Message----- > > From: ProFox [mailto:[email protected]] On Behalf Of Naushad > > Ali Ali > > Sent: 14 April 2014 13:56 > > To: [email protected] > > Subject: A DBF file that file have field is numeric and data String. > > > > Dears > > > > I have a DBF file that file have field is numeric and data contain > > string (Character). How to Handle for variable. > > Regards > > Ali. > > > > > > --- StripMime Report -- processed MIME parts --- multipart/alternative > > text/plain (text body -- kept) > > text/html > > --- > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAL3VundRZ+eUaQG9ZM+M3eo1c=9+zwcc8jydzs1gg7w2jxp...@mail.gmail.com ** 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.
