Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Tom,
Firstly, If your variable is called SuperId, you can not query the type in this way. It has to be braced in quotes:
thisform.text1.value = type('superid')
alternatively you can use:
thisform.text1.value = vartype(superid).
Still, i don't see what this achieves to help you achieve what you were doing in your earlier example. In that example it was clear that SuperId would be a string. The problem is that thisform.text1.value is not a string or your field was not of type string.
To fix it, you have two choices.
1. Either cast the values of thisform.text1 and your field into strings using transform or
2. Type the variable SuperId correctly.
Let me know how you get on.
Mace
>Thanx Guy
>
>I have tried using transform, but still not working for some reason. I even tried to use something like
>
>superid = transform(superid)
>thisform.text1.value = type(superid)
>
>it still returns a U and my program does work ahhh
>is there a reason why it locks down?
>
>Tom
Précédent
Suivant
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