Is it possible to convert the following in to SQL syntax?
what i mean is that it should use a 'query'.
VB Code:
With Adodc1.Recordset .AddNew .Fields("FirstName") = UCase(txtFName.Text) .Fields("LastName") = UCase(txtLName.Text) .Fields("Claim") = txtClaim.Text .Fields("MCO") = UCase(txtMCO.Text) .Fields("AuthStart") = txtAuthStart.Text .Fields("AuthEnd") = txtAuthEnd.Text .Fields("Provider") = UCase(txtProvider.Text) .Fields("Sessions") = txtSessions.Text .Update End With




Reply With Quote