Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: mohammed qasem
  Where is mohammed qasem?
 amman
 Jordan
 mohammed qasem
 To: Mustapha Bihmouten
  Where is Mustapha Bihmouten?
 Casablanca
 Morocco
 Mustapha Bihmouten
 Tags
Subject: RE: Instead of
Thread ID: 289393 Message ID: 289404 # Views: 23 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Friday, December 31, 2010 3:10:12 PM         
   


thank you,
error message Alias text6 is not found
Select column5, column6,;
CAST(Icase(;
column7 >= val(thisform.text6.value) And column7 <= val(thisform.text6.value),val(thisform.text1.value), ;
.....

> > thank you for reply
> > error message
> > Function argument value, type, or count is invalid
> >
>
>
> Sorry Mohammed, sleepy mind today
>
> the trouble is here :
And Val(column7) In ((thisform.text6.value),(thisform.text7.value),(thisform.text8.value),...

> You converted thisform.text8, thisform.text9 and thisform.text10 to numeric with val() : good point
> but thisform.text6.value is Character and thisform.text7.value is Character
>
> try :
And Val(column7) In (val( thisform.text6.value),val( thisform.text7.value), ...

>
> and ignore previous post
>
> Regards
> Mustapha Bihmouten

ENTIRE THREAD

Instead of Posted by mohammed qasem @ 12/31/2010 1:28:29 PM
RE: Instead of Posted by Mustapha Bihmouten @ 12/31/2010 2:00:56 PM
RE: Instead of Posted by mohammed qasem @ 12/31/2010 2:24:44 PM
RE: Instead of Posted by Mustapha Bihmouten @ 12/31/2010 2:58:47 PM
RE: Instead of Posted by mohammed qasem @ 12/31/2010 3:10:12 PM
RE: Instead of Posted by Mustapha Bihmouten @ 12/31/2010 3:53:36 PM
RE: Instead of Posted by mohammed qasem @ 12/31/2010 4:19:45 PM
RE: Instead of Posted by Anders Altberg @ 12/31/2010 3:09:05 PM
RE: Instead of Posted by Mustapha Bihmouten @ 12/31/2010 3:17:16 PM