Manuel, FWIW: In Dos v6.0a and previous versions back to when the Layout command was created - as far as I know from my experience - the command always worked like this: If you opened the browser either from the R:Base menu or by selecting "all" (*) with layout OFF you got the default layout. If you set layout ON beforehand then you got the saved layout. If you then subsequently changed the layout that was saved and replaced the previous saved layout. If you then selected a specific group of columns from that table with layout ON you got a message saying "using default layout" (or words to that effect) If you then used all the columns again you got the saved layout. I think that the difference was that you could/can "hide" columns after selecting all (*) so that you got the view that you wanted but with R:Base internally selecting all but displaying only what you wanted to see. >From what I have seen of this thread nothing appears to have changed. The only other comment that I would make is that I have sometimes had to delete rows from the SYS_LAYOUTS table in order to get a layout saved. If you look at the table it appears to save rows for each user and table combination. For some reason that has become corrupted on databases of mine on occasions. It's never been a problem as the solution was easy (delete the row & re-create). I doubt it's your problem but you could try clearing all data from sys_layouts and then creating your saved layouts again - maybe it would help. Regards, Alastair. Manuel de Aguiar <[EMAIL PROTECTED]>@sonetmail.com on 22/05/2001 18:27:11 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Fax to: Subject: Re: Can anyoune try this - CONCLUSION Hello Everyone, In my posting I also mention I had tried it with table contact in database ConComp supplied by RBase with the same results.
��� Upon further investigation the final conclusion is: For LAYOUT to work the key work ALL must be used.� If you type: EDIT ALL FROM Contact Layout works as described HOWEVER it does not work if on the same table you type: EDIT CustID,ContFName,ContPhone,ContInfo FROM Contact or partial columns: EDIT CustID,ContFName FROM Contact The explanation in: �������������������������������� http://www.RSyntax.com/Syntax.htm is correct since they mention that it only works with EDIT/BROWSE� ALL the problem is that for programmers that have been using RBase for years it is a change in behavior for the command under Windows. The same test is performed with RBase for DOS and it behaves� the way it always has behaved where it does not matter if you use the word ALL or if you list one column or if you list all columns in the table. So the final conclusion is that the SET LAYOUT command has two distinct behaviors depending if you are using the DOS or the Windows version.� The explanation given in ����������������������� http://www.RSyntax.com/Syntax.htm is limited to the way that both DOS and Windows versions behaves and it does not state that under DOS it retained the way the environmental setting use to work. Since there is only one on-line Syntax documentation it should show any existing differences between the RBase products offered.� This will get even more complicated when RBase for Linux is borne. I understand how difficult is can be to retain all features under different operating environments.� I feel RBase Technologies has done an incredible job in obtaining a degree of compatibility that has no match in the industry.� I am extremely grateful for their effort and for a product that provides me with a great deal of fun and financial rewards. Knowing in detail the behavior of commands and setting is my job and knowing the subtle difference is what I get paid for.� The intention of my posting is to learn and understand. Thank you, Manuel
