String builder

[CookieNZ]

I want to use a string builder rather than creating the massive string as below.

sqlscript = "INSERT INTO Supportcall(ID,Contact,Description,Status,operator,customer,[date],rework,source,module)" & " VALUES('" & txtcallnumber.Text & "','" & txtcallcontact.Text & "','" & txtcalldescription.Text & "','" & cmbstatus.Text & "','" & txtoperator.Text & "','" & cmbcustomer.Text & "','" & txtdate.Text & "','" & txtrework.Text & "','" & cmbsource.Text & "','" & cmbmodule.Text & "')"

What is the syntax?

 

[link9]

faq855-1882


paul

 

[JohnYingling]

You will need
Imports System.Text
before the Class statement
or
or use fullname As System.Text.StringBuilder

Dim sb As New System.Text.StringBuilder

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript