Sir, you are right and I am agreed with you I am also seen 1st time this. Actually this file exported from Time Machine. There is one field when I given command display structure displayed structure numeric type when I brows data the data is stored Alphabets. If you want I can attached this file. Regards Naushad On Apr 14, 2014 5:16 PM, "Dave Crozier" <[email protected]> wrote:
> Naushad, > Numeric data by definition does NOT include alphabetic characters only > numbers and decimal points so you can't have what you call "numeric data". > > As Gerard said so well, we are here to help with people who have problems > or misunderstandings with VFP ad everyone os more than happy to help out > where possible. However we are NOT here as a "primary learning" facility > for the product. You seem not to understand VFP or the basic programming > principles underlying any programming language and as such I recommend > reading the help documentation as well as one of the many programming > tutorials on anything from VFP6 onwards as the basics are exactly the same. > > Also, if you are a total beginner then please say so in order that we can > direct you to appropriate resources for you to learn. > > We are all very approachable in the group as long as you really are > struggling on something that you have tried exhaustively to fix but I > repeat - we are not a teaching organisation. > > Dave > > > > -----Original Message----- > From: ProFox [mailto:[email protected]] On Behalf Of Naushad Ali > Ali > Sent: 14 April 2014 15:04 > To: [email protected] > Subject: RE: A DBF file that file have field is numeric and data String. > > 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/cal3vune-0lp+2tyq-wsjmequ9q71j6+htyoypwkzunhvyyn...@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.
