Comments by Ender157 (Top 2 by date)

Ender157 24-Aug-23 12:36pm View

I got it to work, the issue wound up in the Select statement in the calling code.

Ender157 24-Aug-23 9:52am View

thank you for all the good info. interestingly it seems to not like reading from the VAriable. if i hard code the entries it works.

 Comm.Parameters.AddWithValue("@IDNumber", "1.1.1") 'WRAtts.IDNumber)
        Comm.Parameters.AddWithValue("@Description", "Description") ' WRAtts.Description)
        Comm.Parameters.AddWithValue("@QTY", "test") 'WRAtts.QTY)
        Comm.Parameters.AddWithValue("@Tag_Type", "test") 'WRAtts.Tag_Type)
        Comm.Parameters.AddWithValue("@DWG_Number", "test") ' WRAtts.Dwg_Number)
        Comm.Parameters.AddWithValue("@Project_Number", "test") ' WRAtts.Project_Number)
        Comm.Parameters.AddWithValue("@Job_Number", "test") ' WRAtts.Job_Number)
        Comm.Parameters.AddWithValue("@system", "test") 'WRAtts.system)
        Comm.Parameters.AddWithValue("@Crate", "test") 'WRAtts.Crate)
        Comm.Parameters.AddWithValue("@RA_Company", "test") ' WRAtts.RA_Company)
        Comm.Parameters.AddWithValue("@Company1", "test") ' WRAtts.Company1)

I do see an issue with at least 1 the WRAtts.Description contains " with in the string. this i will look into. but setting just that one to a literal string it fails to write.