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)
