On 10/24/2011 03:15 PM, Grigore Dolghin wrote:
> You could REPLACE them with {}, 0, "", and so on, after getting the result
> cursor.
>
> However, I would suggest to keep the nulls, they have meaning. Why you want
> to get rid of them?
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On
> Behalf Of Jeff Johnson
> Sent: Tuesday, October 25, 2011 12:54 AM
> To: [email protected]
> Subject: Access to VFP
>
> I am creating a dbf from Access data. The Access data has nulls in it.
> When I do a copy to dbf from the Access cursor is there any way to get rid
> of the nulls?
>
Grigore: They are in every field where there is no data such as address
and phone number. I want spaces in those type fields instead of nulls.
Thanks,
Jeff
---------------
Jeff Johnson
[email protected]
(623) 582-0323
www.san-dc.com
_______________________________________________
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.
