All, I found the problem. Will report back later.
Jan -----Original Message----- From: "jan johansen" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 22 Feb 2008 09:54:29 -0800 Subject: [RBASE-L] - Re: Variable Lookup ComboBox Albert, Thanks for the reply. PACK dbname ALL -- no change RELOAD abc -- no change This only seems to affect all of the variable lookups in 7.6. The users connect with 6.5 can lookup information just fine. I'm perplexed. Jan -----Original Message----- From: Albert Berry <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 22 Feb 2008 10:35:59 -0700 Subject: [RBASE-L] - Re: Variable Lookup ComboBox You need to pack your indexes and keys, Jan. Better yet, reload the database. Albert jan johansen wrote: > Boy, > > This one just gets weirder. > I created a very simple form with one > variable lookup combo box that > looks up the customer name from > the customer table into vCustNo. > > If I issue EDIT USING testcust from the R> > I get the error (no rows found - 2059). > > But if I run it from the form designer > it works fine. > > The problem appears global as none of the lookups > work anymore so I'm thinking some sort of setting > but when I compare the settings available from SHOW > they all compare against the copy of the database > that works. > > Jan > > > >

