Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Big bad silly bug
Message
From
10/07/2002 11:01:02
 
 
To
10/07/2002 10:56:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00676954
Message ID:
00677075
Views:
25
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
Map
View

Click here to load this message in the networking platform