Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>I have just discovered that if I create a cursor with a name beginning with a number, I get a syntax error, i.e
>>>
>>>CREATE CURSOR 123457 (tField c(10) )
>>>
>>>returns a syntax error but
>>>
>>>CREATE CURSOR abcdef (tField c(10) )
>>>
>>>does not.
>>>
>>>Is this new, or merely something I have not run across before?
>>>
>>>Regards,
>>
>>Not sure if it's anything new or not. I *think* it's always been there. And that you've just not run into it before. :)
>
>Fred,
>
>You are probably right. But I wonder having used SYS(2015) all these years to get unique cursor names, why I have not run into this before -- especially since file names beginning with a mumeral became legal in DOS 5 ( or 6? ).
>
>Regards,
A cursor named FOO does not equate to a file named FOO.DBF. It equates to an alias named FOO with a file named ????????.TMP. To find out what and where it is on your machine, just
?DBF('FOO').
The following is copied from the VFP6SP3 HELP on the USE command...
In Visual FoxPro, an alias can contain up to 254 letters, digits or underscores and must begin with a letter or an underscore. In other FoxPro versions, an alias can contain up to 10 letters, digits or underscores and must begin with a letter or an underscore.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement