• Home
 · 
• VB function enhancement
 · 
• Creating SQL Query Automatic Insert/Update query

Creating SQL Query Automatic Insert/Update query

Creating Insert/Update queries automatically, Date, Text, Number fields handled, Very useful. download it
https://www.ixwebhosting.com/templates/ix/v2/affiliate/clickthru.cgi?id=mahvisions"> border="0" alt="" src="https://www.ixwebhosting.com/templates/ix/v2/images/banners/88x31-unlimitedwin.gif" />

API Declarations
Dim SQLInsert As New SqlQuery
Private Sub Command1_Click()
SQLInsert.ClearString
SQLInsert.InsertSQL "Name", CharacterField, "My Textbox Value"
SQLInsert.InsertSQL "Address", CharacterField, "My Textbox Value"
SQLInsert.InsertSQL "PIN", CharacterField, "My Textbox Value"
SQLInsert.InsertSQL "Age", NumericField, 25
SQLInsert.InsertSQL "DateofBirth", DateField, Date
SQLInsert.SQLBuild "Customer", InsertData
Text1.Text = SQLInsert.GetSQL_String
End Sub
Private Sub Command2_Click()
SQLInsert.ClearString
SQLInsert.UpdateSQL "Name", CharacterField, "My Textbox Value"
SQLInsert.UpdateSQL "Address", CharacterField, "My Textbox Value"
SQLInsert.UpdateSQL "PIN", CharacterField, "My Textbox Value"
SQLInsert.UpdateSQL "Age", NumericField, 25
SQLInsert.UpdateSQL "DateofBirth", DateField, Date
SQLInsert.UpdateSQLWhere "Age", NumericField, 20
SQLInsert.SQLBuild "Customer", UpdateData
Text2.Text = SQLInsert.GetSQL_String
End Sub


Rate Creating SQL Query Automatic Insert/Update query

• 1
• 2
• 3
• 4
• 5

(3(3 Vote))

Download Creating SQL Query Automatic Insert/Update query