Tx. Troy, I'm using 6.5++ R:base and I run the process with R:time. I was using Load command, when we have separate DB for each user. We had changed to a unic DB and began the problems. Like it's in only this process where the locks appears, I supose was Load who do it, but I was wrong. The reason to do changes on the structure is because each user controls an area of our country and whe have separated num. of invoices, salesman codes and son on. And additionally, the files to be loaded haven different data structure.
When I do changes on DB Structure, R:Base locks the entire DB? and which instruccions I have to take care with locks? On Thu, 18 Sep 2003 14:00:44 -0600 "Troy Sosamon" <[EMAIL PROTECTED]> wrote: > You are getting the message from the project when multiple users are trying > to build temp tables at the same time. What version of R:base are you > using. Maybee you should use a perminant temporary table with an additional > field to identify the user and this way you don't have to make the structure > changes. Personally I would use the load command and get away from gateway. > > Troy > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, September 18, 2003 1:26 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - more about locks > > > More with my huge problem.... > > during the execution the next code: > > set date seq yyyymmdd > set date for yyyymmdd > cle v vcha > set v vcha text > sel fichero into vcha fro &traspa where fichero contains '.13' + > and limit = 1 > if sqlcode = 0 then > set v vcha = (.v8dir + .vcha) > drop tab &t1dv > PROJECT TEMPORARY &t1dv from &tdv using + > tv_id tdv_ar tdv_com tdv_q tdv_up tdv_c1 where limit = 0 > GATEWAY IMPORT CSV &vcha REPLACE &t1dv date3 > > Before Gateway instruccion, my "favorite" message appears: "waiting to > access to a > ..bla, bla, bla.". All the &xxxx are temporary tables, differents for > each user. This code is executed by 4 PC's at time. My question is, wich > is the instruccion who locks? As far as I know, I think all it's ok. Im > bored changing the code to obtain the same result. Anybody have a idea? > > > Best regards > > Ramon Guardiola > fermatic Three system > Barcelona (Spain) > Saludos, Ramon Guardiola fermatic Three system Barcelona (Spain)
