Honestly - sounds to me like a DATA CORRUPTION! Similar to what I have
seen in the past.
Others agree with me???
FYI - you can NOT Attach files in this forum - its not possible to do so!
-K-
On 4/14/2014 12:38 PM, Naushad Ali Ali wrote:
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/[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.
