General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
What I do in this situations is add a property to the form set it to "" or just (None) in design mode and bind the textbox to it, in code I reference the property not the textbox, works for me.
Also make sure the Value property for the textbox is not set to something that's not a character expression.
>Hi All,
> Something really silly, probably have to do with type casting( which I dont know how to do in foxpro). I have put the follwing code in my init script of a form, but when it executes this script, it errors me on 9, which is datafield miss match, I cannot string it or type cast it... Can someone help me out?
>
>***************************************************************************************
>local superid, act
>act = 'search'
>superid = 'IW/NP/MR 2002/7 '
>
>if act = 'search'
> locate for alltrim(thisform.text1.value) = alltrim(superid)
>endif
>
>
>if act = 'search'
> locate for alltrim(casema.caseid) = alltrim(superid)
>endif
>***************************************************************************************
>
>Thx
>
>Tom
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only