Hi
i need alter one table , for each field caracter , if want if this field is empty then this field = "-"
i think that , i can use ALTER TABLE ... DEFAULT ,
but i don´t know how use this .
Can you help me ?
Example : i have this table Table1
Field1 Field2
Peter
Brazil
i want this
Field1 Field2
Peter -
- Brazil
yes , i know that i can make a lot of replaces ...
but i think is more easy if i make
FOR gnCount = 1 TO FCOUNT( )
IF Type(FIELD(gnCount) ) = "C"
ALTER TABLE TEMP ;
ALTER COLUMN FIELD(gnCount) DEFAULT "-"
ENDIF
NEXT
Thanks
Pedro Silva
world is wonderful with your help .