Thanks, Troy, that's an idea and I'll check it - as I will Razzak's suggestions - thanks, Razzak.
At the moment, I'm tending to lean towards thinking that it has something to do with either the table being based on a view or having more than one page/area... It's a fairly simple form so I'll either take it to bits and test each change then rebuild it or try a new one altogether. I'll post any results when/if I get them. Regards, Alastair. ----- Original Message ----- From: "Troy Sosamon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 12, 2002 11:50 PM Subject: RE: Strange behaviour with BROWSE USING as opposed to EDIT USING - Razzak's Reply > Alastair, > > Remember that R:base multi table forms automatically link on ALL common > columns. > Maybee your form is linking on some columns that you are not expecting it to > causing this problem. > > Troy > > ===== Original Message from [EMAIL PROTECTED] at 3/12/02 12:29 pm > >Hello Razzak, thanks for your response. > > > >I've tried as you suggested and it works as you say - and as it does in my > >database for multiple records. > > > >However, when I add "and Empfname = 'mary' " (which is the equivalent of > >selecting one row as I was doing in my database) I get one record in concomp > >and pressing either [F7] or [F8] does nothing - as it should. > > > >Conclusion: it's me/my database. > > > >Any ideas why this might be happening? The form is edit only with no EEPs > >and simply for viewing data. > > > >Thanks & regards, > >Alastair. > > > > > > > >----- Original Message ----- > >From: "A. Razzak Memon" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Monday, March 11, 2002 2:29 PM > >Subject: Re: Strange behaviour with BROWSE USING as opposed to EDIT USING - > >Razzak's Reply > > > > > >> > >> At 03:33 PM 3/10/02 -0000, Alastair Burr wrote: > >> > > >> >If I use EDIT USING a form with a where clause that picks > >> >up only one row I can then press [F7] or [F8] and nothing > >> >happens - as expected, there is no other row to go to. > >> > > >> >However if I use BROWSE USING and EXACTLY the same form > >> >and selection criteria if I press [F8] only (not with [F7]) > >> >I get a blank form - fields with no data. If [F7] then went > >> >back to the data it would not be so bad but I can then not > >> >do anything other than [Esc]. > >> > >> Alastair, > >> > >> Could you try the same scenario using CONCOMP database and > >> see what happens? > >> > >> Example: > >> > >> CONNECT CONCOMP > >> > >> EDIT USING Employee WHERE EmpCity = 'Seattle' > >> > >> . Keep pressing [F8] key and you should see at least five > >> records! > >> > >> Now, try the same using: > >> > >> BROWSE USING Employee WHERE EmpCity = 'Seattle' > >> > >> . Keep pressing [F8] key and you should see at least five > >> records! > >> > >> Let us know. > >> > >> Very Best Regards, > >> > >> Razzak. > >> > >> ===================================-============================ > >> Official R:BASE List Server: mailto:[EMAIL PROTECTED] > >> RBTI Events/Training: http://www.rbase2000.com/events > >> R:DCC Members: http://www.rbase2000.com/rdcc > >> ================================================================ > >> R:BASE, Oterro & R:Tango are registered trademarks of RBTI. > >> ==================================-============================= > >> > >> ================================================ > >> TO SEE MESSAGE POSTING GUIDELINES: > >> Send a plain text email to [EMAIL PROTECTED] > >> In the message body, put just two words: INTRO rbase-l > >> ================================================ > >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >> In the message body, put just two words: UNSUBSCRIBE rbase-l > >> ================================================ > >> TO SEARCH ARCHIVES: > >> http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: INTRO rbase-l > >================================================ > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: UNSUBSCRIBE rbase-l > >================================================ > >TO SEARCH ARCHIVES: > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
