What am I missing? Insert into

General
1

I can’t seem to see what the problem is. I am saving data to a table and I am using the exact same format I always use without error and now all of a sudden I can’t save?

Here is the error message:

frmReports.mthSaveReads, line 42
There is more than one method with this name but this does not match any of the available signatures.
dbJobLogSp.AddRow( “tblMeterReadHistory”, dbSave )

Here is the code:

// Variables defined here...
Var rsReview As RowSet = dbJobLogSp.SelectSQL( "SELECT * FROM tblReiewReads" )
Var rsMeter As RowSet
Var dbSave As RowSet // Save read history into tblReadHistory...

// Where the magic happens... or breaks...
For Each dbRow As DatabaseRow In rsReview
  rsMeter = dbJobLogSp.SelectSQL( "SELECT * FROM tblMeterReads WHERE rNum=?", rsReview.Column( "readRnum" ).StringValue )
  
  dbSave.Column( "seqNum" ).StringValue = rsMeter.Column( "seqNum" ).StringValue
  dbSave.Column( "seqAlpha" ).StringValue = rsMeter.Column( "seqAlpha" ).StringValue
  dbSave.Column( "acctNum" ).StringValue = rsReview.Column( "acctNum" ).StringValue
  dbSave.Column( "subNum" ).StringValue = rsMeter.Column( "subNum" ).StringValue
  dbSave.Column( "serNum" ).StringValue = rsReview.Column( "serNum" ).StringValue
  dbSave.Column( "address" ).StringValue = rsReview.Column( "address" ).StringValue
  dbSave.Column( "unitTank" ).StringValue = rsReview.Column( "unitTank" ).StringValue
  dbSave.Column( "lastRead" ).StringValue = rsReview.Column( "lastRead" ).StringValue
  dbSave.Column( "currRead" ).StringValue = rsReview.Column( "currRead" ).StringValue
  dbSave.Column( "multiplier" ).StringValue = rsReview.Column( "multiplier" ).StringValue
  dbSave.Column( "useCalc" ).StringValue = rsReview.Column( "useCalc" ).StringValue
  dbSave.Column( "status" ).StringValue = "C"
  dbSave.Column( "notes" ).StringValue = rsReview.Column( "notes" ).StringValue
  dbSave.Column( "readDate" ).StringValue = rsReview.Column( "readDate" ).StringValue
  dbSave.Column( "readTime" ).StringValue = rsReview.Column( "readTime" ).StringValue
  dbSave.Column( "lockedOff" ).StringValue = rsReview.Column( "lockedOff" ).StringValue
  dbSave.Column( "houseEmpty" ).StringValue = rsReview.Column( "houseEmpty" ).StringValue
  dbSave.Column( "meterDamage" ).StringValue = rsReview.Column( "meterDamage" ).StringValue
  dbSave.Column( "archDate" ).StringValue = modSystem.mthDate( )
  dbSave.Column( "archTime" ).StringValue = modSystem.mthTime( )
  dbSave.Column( "statusOf" ).StringValue = "Working this out..."
  
  Try
    'dbJobLogSp.AddRow( "tblJobLog", dbSave ) // This works in another area just fine
    dbJobLogSp.AddRow( "tblMeterReadHistory", dbSave ) // I don't see the issue here... and yet the compiler says there is an issue?
    'MessageBox( "Enter success message here." ) // Uncomment when wanted or needed...
  Catch e As DatabaseException
    MessageBox e.Message
  End Try
Next
2

According to what I found in the documentation:

you defined dbSave as RowSet and it should be DatabaseRow.

Note: this is only a guess.

3

oh… I feel like a ding a ling… yeah, that was it. Guess I need to take a break.