Anton -
Here is the log from Relativity:
5/7/2018 11:47:29 AM|||=====================================================
5/7/2018 11:47:29 AM|||SELECT "t0"."Description", "t0"."Filler", "t0"."OtherComments", "t0"."PostDateTime", "t0"."PubName", "t0"."PubNumber", "t0"."ReconID", "t0"."StartDateTime", "t0"."User" FROM "aprecon" "t0" WHERE ("t0"."ReconID" = 1749)
5/7/2018 11:47:30 AM|||+++++++++++++++++++++++++++++++++++++++++++++++++++++
5/7/2018 11:47:30 AM|||UPDATE "aprecon"
SET
"ReconID"=?,
"Description"=?,
"PubNumber"=?,
"PubName"=?,
"User"=?,
"StartDateTime"=?,
"PostDateTime"=?,
"OtherComments"=?,
"Filler"=?
WHERE
("ReconID"=?)
5/7/2018 11:47:30 AM|||Parameters:
5/7/2018 11:47:30 AM|||@OLD_ReconID|Int64|
5/7/2018 11:47:30 AM|||@Filler|String|
5/7/2018 11:47:30 AM|||@OtherComments|String|
5/7/2018 11:47:30 AM|||@PostDateTime|Double|
5/7/2018 11:47:30 AM|||@StartDateTime|Double|
5/7/2018 11:47:30 AM|||@User|String|
5/7/2018 11:47:30 AM|||@PubName|String|
5/7/2018 11:47:30 AM|||@PubNumber|String|
5/7/2018 11:47:30 AM|||@Description|String|
5/7/2018 11:47:30 AM|||@ReconID|Int64|
5/7/2018 11:47:30 AM|||*****************************************************
5/7/2018 11:47:30 AM|||UPDATE "aprecon"
SET
"ReconID"=?,
"Description"=?,
"PubNumber"=?,
"PubName"=?,
"User"=?,
"StartDateTime"=?,
"PostDateTime"=?,
"OtherComments"=?,
"Filler"=?
WHERE
("ReconID"=?)
5/7/2018 11:47:30 AM|||Parameters:
5/7/2018 11:47:30 AM|||@OLD_ReconID|Int64|1749
5/7/2018 11:47:30 AM|||@Filler|String|
5/7/2018 11:47:30 AM|||@OtherComments|String|This is a test
5/7/2018 11:47:30 AM|||@PostDateTime|Double|42755.5068215162
5/7/2018 11:47:30 AM|||@StartDateTime|Double|42746.551073831
5/7/2018 11:47:30 AM|||@User|String|mgangadeen
5/7/2018 11:47:30 AM|||@PubName|String|EMERGENCY PHYSICIANS MONTHLY
5/7/2018 11:47:30 AM|||@PubNumber|String|6737
5/7/2018 11:47:30 AM|||@Description|String|mgangadeen 1/11/2017
5/7/2018 11:47:30 AM|||@ReconID|Int64|1749
This is from a console test app. Using DALINQ, I do a simple query, and then update a single record. The query SQL appears fine, as does the update sql. But, this is the error i’m getting from my client console app:
Unhandled Exception: RemObjects.DataAbstract.DAUpdatesFailedException: One or more updates failed to apply on the server.
1749: ERROR [22018] [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Error converting to numeric type: Parameter #6.
ERROR [01004] [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Data truncated column: PubNumber.
at RemObjects.DataAbstract.Linq.LinqDataAdapter.ThrowFailures(List`1 changes, String failureMessage)
at RemObjects.DataAbstract.Linq.LinqDataAdapter.ThrowExceptionForFailedChangeDeltas(Delta[] deltas)
at RemObjects.DataAbstract.Linq.LinqDataAdapter.ProcessPendingChangeDeltas(Delta[] serverDeltas, IDictionary`2 originalDeltaChangeIds)
at RemObjects.DataAbstract.Linq.LinqDataAdapter.ApplyChanges()
at RelativityTest.Program.Main(String[] args) in D:\dev\miller\RelativityTest\Program.pas:line 45
Am I correct in my assumption that the parameters are zero-based? If so, which parameter is this failing on?
Also, OLD_ReconID is a parameter, but it not in the parameter list. I assume this is used by DA?