Hi Richard,

The best way is to build a custom function something like

Function ConvertToBrush() as object
Dim oTempObj as object
    oTempObj = tablename.obj

    DO BRUSH Change here using alter object

    ConvertToBrush = otempobj
End function

Then you can in your main routine call the function using the update
statement

Update tablename set obj = ConverttoBrush()

you will find this much quicker than fetch each row - getting the object -
changing the style and then updating that row.

Don't forget the Error trapping.

Regards

Martin Hodder







----- Original Message ----- 
From: "Richard Greenleaf" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 02, 2003 10:07 PM
Subject: MI-L Changing brush style of objects


>
>
>  I'd very much appreciate some help with this.
>
>  I simply want to permanently change the brush style of all the objects in
a
> table, within MB.   I have tried following the help file, but whatever I
do
> I get error messages when compiling.  It seems to say that you have to
> select individual objects and change them, but I can't get it to work.
> Doing this manually is of course very easy, but I can't replicate it in MB
> code.
>
> All I want to do is:
>   - select all from (tablename)
>   - change brush style to (brush)
>   - save it
>
>  How do I do this please?
>
>  - Richard
>
>
>
>
> ---------------------------------------------------------------------
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> Message number: 8606
>
>


---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 8619

Reply via email to