Hi, On Tue, 9 Oct 2001, Emiliano wrote: > > > The sitegroup field in the sitegroup table... if we do use this field, > > > is there any valid situation where it would be != id?
The sitegroup field in the sitegroup table was added so that the Nadmin interface could show the sitegroups/companies on the login screen. The sitegroup field defaults to '0' and is actually always set to '0'. setting the sitegroup field to a non-zero value will result in that sitegroup not showing in the login company dropdown box of Nadmin. > > IIRC, the sitegroup field must be equal to the id field for repligard > to replicate correctly, but maybe this has changed... > > Not sure about this, I haven't tested it. > If it isn't actually used anywhere, wouldn't a short-term solution be > to do > UPDATE sitegroup SET sitegroup=id > when repligard starts up? > Not a fix, but at least a workaround. See above, you should then at least do UPDATE sitegroup SET sitegroup=0 afterwards in order to leave a working database behind (working from Nadmin point of view). I do not favour this workaround as it will make it impossible to login to Nadmin for the duration off the export. wkr, -- Envida http://www.envida.net/ Armand A. Verstappen Graadt van Roggenweg 328 [EMAIL PROTECTED] 3531 AH Utrecht tel: +31 (0)30 298 2255 Postbus 19127 fax: +31 (0)30 298 2111 3501 DC Utrecht --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
