SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[10.0.187 Pro] - Saving table data changes throws error

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[10.0.187 Pro] - Saving table data changes throws error
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 1592

Post [10.0.187 Pro] - Saving table data changes throws error Reply with quote
I ctrl+clicked a table name to show its contents. I pressed F2 to enter edit mode, selected two cells from a column and pressed Del to set them to NULL. So far, so good. But then I selected Save Changes from the context menu and instead of saving changes I got the following error message in the Messages pane:

Quote:

SqlCommand.Prepare method requires all parameters to have an explicitly set type.
The command(s) completed with errors (15.13 ms).

Sat Nov 10, 2018 5:21 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6950

Post Reply with quote
Would you please describe the connection context, type of the database server and connection type?

Looking at the error I think this is an ADO.NET connection, but cannot tell the type of server because it's a driver side error.
Sat Nov 10, 2018 10:55 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1592

Post Reply with quote
Certainly. The connection type is ADO.NET indeed, made to an SQL Server 2016 SP1 Standard Edition, using Windows Authentication. The data provider is System.Data.SqlClient.

Setting the connection type to ODBC does not throw any errors, however, it only saves the changes made to only one row. Even if I set one arbitrarily chosen column to NULL for several rows, after selecting Save Changes the result pane is updated and it shows that only the last row has been changed. The rest of the changes are undone.

Check this short video >>here<<.

On the other hand, it properly saves the change statements as a script.
Mon Nov 12, 2018 4:52 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6950

Post Reply with quote
Thanks a lot. We are debugging that issue.
Tue Nov 13, 2018 9:54 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.