Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace field with blank (space)
Message
From
27/03/2007 10:13:37
 
 
To
27/03/2007 10:01:40
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01208793
Message ID:
01208810
Views:
23
yes,
i convert this table to excel sheet, i found many records have zeroze...

>You cannot fill space to numeric field. Maybe you want to show blank on screen when table field value is zero?
>
>>thank you for reply,
>>i mean i have many fileds at mytable this field have numbers or sero,
>>i want to replace space(blank) for zero
>>thanks
>>>>hi all,
>>>>i need to replace space to my table where i found zero?
>>>>
>>>>USE mytable
>>>>SCAN FOR FIELDS=0
>>>>REPLACE ALL FIELDS WITH SPACE()
>>>>ENDSCAN
>>>>
>>>>thanks
>>>
>>>What means Fields=0 ?
>>>Anyway, you should look at BLANK command.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform