Yippee, I think I got it I found that my form allows for a search string of 30 chars (lcSearch) After closing the form, my module said lcSearch is upper(alltrim(lcSearch)) The field on which the SEEK was done is C(15)
Seek lcSearch returned recno(0) as 0 But, if I say lcSearch is upper(left(lcSearch,15)), the seek returns the nearest find in recno(0) Sietse (I have difficulty spelling that name), would you confirm my findings ? Thanks for the help On Wed, Jun 25, 2008 at 8:04 PM, Sietse Wijnker < [EMAIL PROTECTED]> wrote: > I've tested it and can reproduce your results in two ways: > 1. The table is empty > 2. The SEEKed valus exceeds the values in the table. F.i. the range in the > table goes from 1 to 99, and the seek tries to find the value 100 > > HTH. Regards, > Sietse > SW-Software > > > -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Namens Sytze de Boer > Verzonden: woensdag 25 juni 2008 0:52 > Aan: [EMAIL PROTECTED] > Onderwerp: VFP9 and Recno(0) > > I don't know what I've done but I've upset my system where an unsuccessful > SEEK does not give me a recno(9) > i.e. recno(0)=0 > > my test code goes > If !found() > mf1=recno(0) > mf2=recno() > endif > > It returns mf1 with 0 > > -- > Regards > Sytze de Boer > Kiss Systems > Ph: 64-7-8391670, Mob:021 937611, Skype: kissman2 > www.kiss.co.nz > > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
