Doug I would only put those in the cfg file. I would set the NAME in RBASE.DAT like this
SET VAR vUserName = (CVAL(‘NETUSER’)) SET NAME &vUserName I would then make sure the RBASE.DAT AND rbase CFG file were located in same folder as the rbase EXE Make sure there aren’t any other RBASE.DAT and rbase CFG file located anywhere. Buddy From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Doug Hamilton Sent: Sunday, January 30, 2022 10:32 PM To: R:Base List <rbase-l@googlegroups.com> Subject: [RBASE-L] - Multi-User commands Best Practices In the recent R:Base Multi-User Guide, the recommended sequence for Multi-User Concurrency Settings in a startup file, e.g. RBASE.DAT, is: DISCONNECT SET MULTI ON SET STATICDB ON SET FASTLOCK ON SET PAGELOCK OFF SET ROWLOCKS ON SET VERIFY COLUMN SET WAIT 4 SET INTERVAL 5 The same settings are found in the .CFG file, e.g. RBENGINEX5E.CFG MULTI ON STATICDB ON FASTLOCK ON PAGELOCK OFF ROWLOCKS ON VERIFY COLUMN WAIT 4 INTERVAL 5 Is it correct that: 1) the CFG file is processed before the startup DAT file? 2) The order of the commands in the CFG should be the same as in the DAT file? 3) The SET commands in the DAT file are redundant and are not really necessary in the DAT file unless settings need to be changed for special circumstances? Note that the user Guide states: "The settings may be set within the R:BASE configuration file. However, the settings are best set in a startup file before connecting to the database. For example: ..." Why are the settings best set in a startup file? Shouldn't default settings be established in the CFG file and modified only if necessary? TIA, Doug _____ <https://www.avast.com/antivirus> This email has been checked for viruses by Avast antivirus software. www.avast.com <https://www.avast.com/antivirus> -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/f09f7740-a3a9-aebf-5c8d-963075b275c6%40wi.rr.com <https://groups.google.com/d/msgid/rbase-l/f09f7740-a3a9-aebf-5c8d-963075b275c6%40wi.rr.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/004901d8169c%24ad391c20%2407ab5460%24%40comcast.net.