question

Steven Chen avatar image
0 Likes"
Steven Chen asked Sam Stubbs answered

ODBC dbsettablenum() Error

Hello,

When I use dbsettablenum function to modify cell value, an error message show up with ODBC code 23000 and Flexsim code : 23 - SQLSetPos.

My OS is 64bit, setup ODBC datasource with 64bit and connect to Access database(*.accdb).

It's fine to dbopen(). In View>Current Database Table can see the whole table loaded.

Error occurred when using dbsettablenum().

Successful if using SQL query.

FlexSim 16.2.1
database
009.png (5.0 KiB)
007.png (3.3 KiB)
008.png (3.9 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

·
Sam Stubbs avatar image
0 Likes"
Sam Stubbs answered

(*This is an older post that never received a posted answer)

The issue seems to be on the database end. I would do a search of ODBC Error Code 23000. Here is another forum that has a discussion around this issue:

https://www.experts-exchange.com/questions/27727574/ODBC-Error-Code-23000-Integrity-constraint-violation.html

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.