Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to use delimiters in ControlSource?
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01303280
Message ID:
01303300
Vues:
13
>>>I have a field name LEVEL which is a reserved work in SQL Server. So I need to enclose it in delimiters "[]" in the ControlSource of a textbox. I tried the following:
>>>
>>>[MyCursor.level]
>>>
>>>MyCursor.[level]
>>>
>>>But none of it works.
>>>
>>>Is there a way to use the delimiters in ControlSource?
>>
>>What ControlSource of a textbox has to do with a SQL Server?
>>
>>MyCursor.level
>>
>
>I am not sure I understood your question. I have a textbox on a form bound to a cursor MyCursor received from SQL Server. And then when setting form property .BindControls to .T., I get an error. And then I get a message that the textbox is left unbound. Therefore, I thought I need to use delimiters in the ControlSource.

This error you're getting is not connected with the reserved word in SQL Server. It's something completely different. You can use thisform.textbox1.ControlSource = [myCursor.Level] (if in code) with no problems.
If it's not broken, fix it until it is.


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

Click here to load this message in the networking platform