Hi Pedro,
Alter Table Table1 ;
Alter Column Field1 Set Default "-";
Alter Column Field2 Set Default "-"
Liam
>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
Liam O'Hagan
MCP VFP Desktop Apps