Author: Naushad Ali Ali
Posted: 2014-04-14 07:40:43 Link
Dears
I have a dbf file that file contain field is numeric and data has string
(Character). How to Handle for view, variable and print.
REGARDS
ALI
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
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/CAL3Vund0SXBKetJrv0nr00h6L4iQV7jD9oqirRe4WP_pHYVTpw@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.
Author: Dave Crozier
Posted: 2014-04-14 07:42:05 Link
Please start a new thread and at least give us some information as to EXACTLY what you want to do.
Dave
-----Original Message-----
From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Naushad Ali Ali
Sent: 14 April 2014 13:41
To: profox@leafe.com
Subject: file contain field is numeric and data has string (Character).
Dears
I have a dbf file that file contain field is numeric and data has string (Character). How to Handle for view, variable and print.
REGARDS
ALI
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
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/18725B8CD2D5D247873A2BAF401D4AB22A4E2B7E@EX2010-A-FPL.FPL.LOCAL
** 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.
Author: Naushad Ali Ali
Posted: 2014-04-14 07:46:45 Link
I WANT TO MAKE A VARIABLE, SO I CAN REPLACE IN OTHER FILE. THANKS
On Apr 14, 2014 3:42 PM, "Dave Crozier" <DaveC@flexipol.co.uk> wrote:
> Please start a new thread and at least give us some information as to
> EXACTLY what you want to do.
>
> Dave
>
> -----Original Message-----
> From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Naushad Ali
> Ali
> Sent: 14 April 2014 13:41
> To: profox@leafe.com
> Subject: file contain field is numeric and data has string (Character).
>
> Dears
>
> I have a dbf file that file contain field is numeric and data has string
> (Character). How to Handle for view, variable and print.
>
> REGARDS
> ALI
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
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/CAL3Vunf9BXWrZmvTuaVH7y-+A4OiNPKytAyK8h+THEnH68S4HA@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.
Author: Gérard Lochon
Posted: 2014-04-14 08:57:02 Link
----- Original Message -----
From: "Naushad Ali Ali" <naushadmail@gmail.com>
To: <profox@leafe.com>
Sent: Monday, April 14, 2014 2:46 PM
Subject: RE: file contain field is numeric and data has string (Character).
>I WANT TO MAKE A VARIABLE, SO I CAN REPLACE IN OTHER FILE. THANKS
You know, Naushad, here is a lot of people, with high skills, greeting and willing
to waste their private and free time to respond to many people, and try to make an
opportunity for the community to improve itself, all around VFP and data centrics.
BUT, and this is essential for me, and i feel, for all of us, don't treat us like a
customer who has a problem with a maintenance service.
None of us is willing to tolerate your agacement due to an answer you think
it is not what you attempted, even if there is no response.
In short, first, start with adopting the newsgroup rules, in particular
DO NOT SHOUT (this using capital letters, without a special meaning).
Second, please, tell us what are your skills about VFP;
an the version of it you are using.
The question you issued sems to demonstrate you don't really know
a programming language like VFP.
So, the first would be to "read the documentation", and, after, ask us
about what were the gimmicks you didn't understand.
But i'll not let you go like a pigeon in the desert ...
As far as i can understand yous question,
i'll traduce it as :
"I have a value, and i want to populate a table field with this value"
this can is made using :
[VFP]
SELECT MyTable
REPLACE Myfield WITH Myvalue ALL
[/VFP]
If that is NOT the real meaning of your question,
please tell us more about the problem you have.
In fact, i more suspect it is another problem, like
getting a value from a field from table 'A', and having to replace
within table B some other field.
Could you tell us what is the exact problem, assuming
giving us the data structure and what you really want
obtain as a result ?
Gérard.
_______________________________________________
Post Messages to: ProFox@leafe.com
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/135F286AFC0E42C4B4F84E7F03A70C00@MuriellePC
** 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.
Author: Dan Covill
Posted: 2014-04-14 11:02:57 Link
OK, Ali, is this what your problem is?
create table SAMPLE ( CharField C(8), NumField N(8,2))
Chardata = "225.50" && Character data, but really a number
insert into SAMPLE values (Chardata, VAL(Chardata))
*------------------
For the CharField, we just enter it directly.
For the NumField, the VAL() function converts the characters to a number.
Dan Covill
> Date: Mon, 14 Apr 2014 15:40:43 +0300
> Subject: file contain field is numeric and data has string (Character).
> From: naushadmail@gmail.com
> To: profoxtech@leafe.com
>
> Dears
>
> I have a dbf file that file contain field is numeric and data has string
> (Character). How to Handle for view, variable and print.
>
> REGARDS
> ALI
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
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/BAY169-W686D1F5AA38F8B268FE67D90510@phx.gbl
** 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.