Hi,
I have just started looking into using the Open Access ORM and currently have the following set-up on my form.
This works ok if i'm just updating a value in the table but if i add a new row or delete a row i get the following Excpetion:
Insert of '1361221285-' failed: Telerik.OpenAccess.RT.sql.SQLException: Invalid column name 'ColumnA2'.
Invalid column name 'ColumnB2'.
Invalid column name 'ColumnC2'.
Invalid column name 'ColumnD2'.
Invalid column name 'ColumnE2'.
Invalid column name 'ColumnF2'.
Statement(s) could not be prepared.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()
at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)
INSERT INTO [T001_Table] ([ColumnA], [ColumnB], [ColumnC], [ColumnD], [ColumnE], [ColumnF], [ColumnG], [ColumnH], [ColumnI], [ColumnJ], [ColumnK], [ColumnL], [ColumnN], [ColumnO], [ColumnP], [ColumnQ], [ColumnR], [ColumnS], [ColumnT], [UColumn], [ColumnA2], [ColumnB2], [ColumnC2], [ColumnD2], [ColumnE2], [ColumnF2], [ColumnU], [ColumnV], [ColumnW], [ColumnX], [ColumnY], [ColumnZ]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
select scope_identity()
(set event logging to all to see parameter values) Telerik.OpenAccess.RT.sql.SQLException: Invalid column name 'ColumnA2'.
Invalid column name 'ColumnB2'.
Invalid column name 'ColumnC2'.
Invalid column name 'ColumnD2'.
Invalid column name 'ColumnE2'.
Invalid column name 'ColumnF2'.
Statement(s) could not be prepared.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()
at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)
I seems to have duplicated some of my Columns. Could this be something to do with my Foreign Keys?
Thanks