Why do I receive an error that a parameter not found when attempting to update my NexusDB database?

Data Abstract
1

Hello,

I am using the following tools:
VisualStudio 2008, c#, .NET 3.5
RemObjects DataAbstract 6.0.55.957
NexusDB Server 2.0706
NexusDB ADO Connector build 86

When I call the Fill command the COMPANIES table fills properly. However, when I try to apply changes back to the server I receive an error message:

A problem occurred while editing a record in table ‘COMPANIES’, record ‘COMPANIES:1’.
Error: Error: Parameter ‘REFNUM’ not found

I’ve tried adding the update / delete commands to the schema but that made no difference.

The project files are included as well as an empty set of data tables.

Any help would be appreciated.

Thank you,
Brian Wheatley

2

Hello.

The first I saw is that commands in your schema doesn’t affect the update process in any way because you don’t have businessprocessor in your data service that is binded to insert/update/delete commands. As well, you don’t have schema table properties InsertCommandName, UpdateCommandName, DeleteCommandName filled with corresponded names of you commands. (see more details here)

But, anyway you don’t need to use commands for update in your case. All should be working by using of auto generated sql statements.

I cannot reproduce the situation with your project and database so far. Can you please catch the error in debug mode and send us a stack trace. It can help us to find the source of a problem quicker.

Also, I’ve attached the sample based on our 2-Tier template that can load and updata data to COMPANIES table. Please, try to make insert/update/delete actions and let me know if problem occurs on your side using this sample.