General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi again,
You don't have a field called superid do you? Or perhaps another object or something?
Try renaming the superid variable.
local mysuperid, act
act = 'search'
mysuperid = 'IW/NP/MR 2002/7 '
if act = 'search'
locate for alltrim(TRANSFORM(casema.caseid)) = alltrim(mysuperid)
endif
if act = 'search'
locate for alltrim(TRANSFORM(casema.caseid)) = alltrim(mysuperid)
endif
>hey Macer,
>
>
>I did exactly that, so I copied and pasted what you have given me, but it still returns datatype mismatch...
>this simple code is just want I putted in
>***********************************************
>local superid, act
>act = 'search'
>superid = 'IW/NP/MR 2002/7 '
>
>
>if act = 'search'
> locate for alltrim(TRANSFORM(casema.caseid)) = alltrim(superid)
>endif
>************************************************
>my casema.caseid field is a character field, so I don't know why is it doing that.
>the vartype stuff is just to see what kinda field was I getting...
>.... really want to know why ahh...
>this stuff works, but just prompts me with that message... you know how I can just display error popups?
>
>Thanx
>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