>Hello All,
>I've come across some unusual behavior in VFP6 and if anyone has an explanation it sure would help!
>I'm receiving excel spreadsheets that I'm changing into dbfs and cleaning them up, etc. for reporting purposes. I don't want to rename them for obvious reasons but a lot of them have dashes in their names. sheet-1 ofr instance.
>I am able to create the table sheet-1 with the command
>"CREATE TABLE sheet-1 FREE FROM ARRAY myarry"
>but when I open the data session window I find that the table
>sheet_1 is open. I cannot select sheet-1 or close sheet-1 whereas I can do both with shet_1.
>
>Why is VFP6 renaming the table alias??
>
>Thanks
>
>Sandy
Hi Sandy,
Alias names are subject to various rules as to what characters they may contain. For example, aliases cannot begin with digits. I think that the hyphen isn't allowed either and VFP is substituting the underscore for you.
George
Ubi caritas et amor, deus ibi est