Simple editable maintenance form

[Scott.Pearce]

I have the plugin successfully writing a record to the GL_Segments table but as soon as I save, I get this error.

Check your collection Read() function. I suspect there is a reference to “RecID” when it should be “GLSegmentID”.

[SBarnes]

This will do it

Code: Select all

public override void Read()
   {
      string Sql = null;
      SqlDataReader SQLReader = null;
      bool oldReading = Reading;

      try {
         Reading = true;
         Clear();

         var db = Manager.Database;

         Sql = @"SELECT GLSegmentID, SegContents, SegContentsDesc
               FROM GL_Segments WHERE SegmentNo = 1
               ORDER BY SegContents ";

         using (SqlCommand SQLCmd = new SqlCommand(Sql, db.SQLConnection, db.SQLTransaction)) {
            SQLCmd.CommandTimeout = Manager.Database.DefaultCommandTimeout;

            SQLReader = SQLCmd.ExecuteReader();

            while (SQLReader.Read() == true) {
               //GLSegment GLSegment = new GLSegment();
                 GLSegment GLSegment = Manager.CollectionItemFactory.CreateCollectionItem<GLSegment>();

               GLSegment.RecID = db.Sanitise(SQLReader, "GLSegmentID").ToString();
               GLSegment.SegContents = db.Sanitise(SQLReader, "SegContents").ToString();
               GLSegment.SegContentsDesc = db.Sanitise(SQLReader, "SegContentsDesc").ToString();

               Add(GLSegment);
            }

            SQLReader.Close();
         }

         base.OnRead();

      } finally {
         Reading = oldReading;

         if ((SQLReader != null)) {
            SQLReader.Close();
         }
      }
   }



[DannyC]

And for those playing along at home, the final plugin.

BTW, it only deals with the first segment. I'm forcing SegmentNo to INSERT as 1.

Appreciate the assistance peeps.

[SBarnes]

Whilst still playing at home

change

Code: Select all

GLSegment GLSegment = new GLSegment();


in the read to use the factory as I think if you update a line you'll get an issue