I have a drawing from which I want to extract objects that meet a certain criteria into a new drawing. I am looking at something like the SELECT INTO statement but applied to drawings instead of tables , someting like
SELECT * INTO [New Drawing] from [Drawing] WHERE [Column] ="Criteria"
Considering the Drawing has 2 columns Label and Class, I have also tried to first create the new drawing with
CREATE DRAWING New Drawing ([Label] VARCHAR),([Class] VARCHAR)
and then insert the data into the New Drawing table like this
INSERT INTO [New Drawing] SELECT [ID],[Label], [Class] FROM [Drawing] WHERE [Class] ="Criteria"
but does not work with an error message "Different number of columns SELECT".
Thanks in advance for your help
BiciMapas Mexico GPS Maps & GIS Data www.bicimapas.com.mx