<div>
That i didn't think of that.<br />
<br />
Thanks for the quick response.
</div>


That i didn't think of that.

Thanks for the quick response.

<div>
<div class="content wysiwyg-content">
I use the following Query &quot;INSERT INTO errrequired (drawing) SELECT drawing FROM border_att&quot;. Now i want to fill another field in the &quot;errrequired&quot; table at the same time with a text value. Something like &quot;INSERT INTO errrequired (drawing, attribute) SELECT drawing FROM border_att VALUES 'Drawingnr'&quot;. I don't want to loop trough every record to set the value.
</div>
</div>


I use the following Query "INSERT INTO errrequired (drawing) SELECT drawing FROM border_att". Now i want to fill another field in the "errrequired" table at the same time with a text value. Something like "INSERT INTO errrequired (drawing, attribute) SELECT drawing FROM border_att VALUES 'Drawingnr'". I don't want to loop trough every record to set the value.

How to set the same value for every record

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.