Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table names
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00604532
Message ID:
00604621
Vues:
25
Thanks. Too bad, we haven't switched yet... (in a rhyme...)

>To get a list of reserved words, use the ALANGUAGE() function in VFP7. You'll have to call it four times (passing 1, 2, 3, and 4 in the second parameter position) and check all of the resulting arrays. Also note that, depending on what parameter you pass, the results may or may not come back in upper case, so you'll want to use UPPER() when you test against them.
>
>I don't know a way to accomplish this prior to VFP 7.
>zahid
>
>>>>I am going to create a program where a user can create their own tables, but I want to make sure that they don't name their table something that won't work. Is there a list of characters that can't be used in the names of tables? I am not using a database container, so do the tablenames have to be ten characters or less?
>>>>
>>>>Thanks in advance
>>>
>>>Scott;
>>>
>>>I think I would also avoid reserved words - like Append, Delete, Insert, etc.
>>>
>>>Tom
>>
>>Tom,
>>
>>How can you get a list of all reserved words in a table? Mike H has Words table, but I have no idea, how this table was created and it should be updated for VFP7.0 anyway.
>>
>>I also think, that it's much better to restrict user's input to letters, digits and _
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform