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


> 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