By the way, thanks shaft...for not wanting to fork out the bucks for SQL Server right away.
Inline SQL = blargh
CommandText = "INSERT INTO Insureds (GroupID, InsuredLicense, InsuredLastName, InsuredFirstName, InsuredMI, "
CommandText &= "InsuredSuffix, InsuredTitle, InsuredGender, InsuredDOB, InsuredCorporateName, "
CommandText &= "InsuredAddress1, InsuredAddress2, InsuredCity, InsuredState, InsuredZip, InsuredCounty, "
CommandText &= "MailingAddress1, MailingAddress2, MailingCity, MailingState, MailingZip, "
CommandText &= "HomeAddress1, HomeAddress2, HomeCity, HomeState, HomeZip, "
CommandText &= "BillingAddress1, BillingAddress2, BillingCity, BillingState, BillingZip) "
CommandText &= "VALUES('" & GroupID & "','" & FLLicenseNumber & "','" & LastName & "','"
CommandText &= FirstName & "','" & MiddleInitial & "','" & Suffix & "','" & MedicalType & "','"
CommandText &= Gender & "','" & DOBDate & "','" & CorporateName & "','"
CommandText &= InsuredAddress1 & "','" & InsuredAddress2 & "','" & InsuredCity & "','" & InsuredState & "','" & InsuredZip & "','" & InsuredCounty & "','"
CommandText &= MailingAddress1 & "','" & MailingAddress2 & "','" & MailingCity & "','" & MailingState & "','" & MailingZip& "','"
CommandText &= HomeAddress1 & "','" & HomeAddress2 & "','" & HomeCity & "','" & HomeState & "','" & HomeZip & "','"
CommandText &= BillingAddress1 & "','" & BillingAddress2 & "','" & BillingCity & "','" & BillingState & "','" & BillingZip & '")
Posted at 20.11.47 by prøphet :: link :: Comments (0)
Warning Label Generator
Posted at 09.25.17 by prøphet :: link :: Comments (0)
