Good morning all, Razzak, please would you try this code:
conn concomp READ clear all var set var vSelID text = 'Mary' BROWSE USING Employee WHERE empfname = .vSelID + order by empfname return Then try it without the read only connection; Then try it without the order by clause - both read and write modes. I think you will see what I am getting with READ ONLY and ORDER BY in the file when you press [F8] in the form. Regards, Alastair. ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 11:50 PM Subject: Re: Strange behaviour with BROWSE USING as opposed to EDIT USING - Razzak's Reply > 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/ ================================================ 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/
