INtools Forum

Forum Home

Aggregated

FAQ

Loop Drawing

loop drawing na...

Re: loop drawing name

10/26/2007 8:25:18 AM

admin

177 posts

Re: loop drawing name

fba_sen57 wrote

Or like below:

Alter table drawing disable all triggers;

Update drawing set dwg_name = < 'NEW Dwg_name'> where dwg_id IN (all the Dwg_ID with comma for each dwg_id >;

eg Update drawing set dwg_name = 'your new drawing name' where dwg_id in (1234, 4567, 7890 etc);

Alter table drawing enable all triggers;

- This SQl is a little risky you can use it where you add in the "dwg_name = 'XX' || dwg_name" otherwise all the drawing will the same for all the dwg_id in the list.

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com

10/26/2007 9:48:43 AM

fba_sen57

73 posts

www.shell.com

Re: loop drawing name

Ilan, I thought that was the intention. I agree with you, the risk is high if not careful therefore it has to be done by the expert. Otherwise he can use the browser module by adding new view under the Loop browser group then open view and copy a record into the buffer then paste into the selected datas.

Page 2 of 2

Aggregated

FAQ

Loop Drawing

loop drawing na...