This question is locked. New answers and comments are not allowed.
So I was put on this project to try and fix some issues. What i'm having a issue with is an invalid column name error being thrown. Issue first appeared as 'ParameterName2' so just to get through that section of code I added a ParameterName2 column to the table, then the error moved to ParameterName3 and so on down the line. I cannot find anywhere in the code where it would add a # to the end of the column based on the previous number so I don't know why it is doing this. Any help would be greatly appreciated. Below is the stack: [SQLException: Invalid column name 'ParameterName4'. Invalid column name 'ParameterName4'. Statement(s) could not be prepared.] Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery() +267 OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery() +53 OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute() +62 [DataStoreException: Error executing query: Telerik.OpenAccess.RT.sql.SQLException: Invalid column name 'ParameterName4'. Invalid column name 'ParameterName4'. Statement(s) could not be prepared. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery() at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery() at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute() SQL: SELECT a.[ParameterName4] AS COL1, b.[ParameterName] AS COL2, b.[Description] AS COL3, b.[Display] AS COL4, b.[HasDisplayValues] AS COL5, b.[HasMarkers] AS COL6 FROM [AssetPositionInfo] a LEFT JOIN [ParameterDefinitions] AS b ON (a.[ParameterName4] = b.[ParameterName]) WHERE a.[AssetPositionInfoId] = ? Telerik.OpenAccess.RT.sql.SQLException: Invalid column name 'ParameterName4'. Invalid column name 'ParameterName4'. Statement(s) could not be prepared.