ATTENTION

This FlexSim Community Forum is read-only. Please post any new questions, ideas, or discussions to our new community (we call it Answers) at https://answers.flexsim.com/. Our new Question & Answer site brings a modern, mobile-friendly interface and more focus on getting answers quickly. There are a few differences between how our new Q&A community works vs. a classic, threaded-conversation-style forum like the one below, so be sure to read our Answers Best Practices.


flexsim.com

Go Back   FlexSim Community Forum > FlexSim Software > Q&A
Downloads

Q&A Using Flexsim and building models

  #1  
Old 04-03-2008
Martin Saler's Avatar
Martin Saler Martin Saler is offline
V-Research, Flexsim Distributor, Austria
 
Join Date: Aug 2007
Location: Dornbirn, AUSTRIA
Posts: 5
Downloads: 0
Uploads: 0
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Martin Saler is on a distinguished road
Post Problem with Flexsim 4.1 and Access DB

HI @all!

We have a problem with Flexsim 4.1 and Microsoft Access Database.

In the model TestDB.fsm (see attachment) we use a source, a transporter and a sink. In the source there is a DB connection to the access database FlexsimTestDB.mdb via the ODBC driver AccessFlexsimDB.

In the source (OnExit-Trigger) there is the following flexscript:

string ODBCname = "AccessFlexsimDB";
string query = "";

dbopen(ODBCname,"SELECT * from DBTable",0);
query = concat("INSERT INTO DBTable ([ID]) VALUES (4)");
dbsqlquery(query);



If we will change/open the code dialog - after running the model once - Flexsim will freeze or crash when we close the dialog again.

We tried different changes (try/catch block, other computers, …) but there is nothing what fit. The problem may is the INSERT-Statement. It’s not possible to upgrade Flexsim to 4.3!

Does anyone have a clue or a work around? It’s really important for our customer!

Thanks a lot and best wishes
Martin
Attached Files
File Type: zip FlexsimTestDB.zip (50.9 KB, 364 views)


Thread Thread Starter Forum Replies Last Post
Flexsim CT Verson 1.5 prerelease problem qin tian Container Terminal (CT) Library 2 03-24-2008 09:31 AM
Access to the tree variables Iulian Marin Ion Q&A 2 02-06-2008 09:15 AM
Can we still access old Flexsim Community Forum? AlanZhang Q&A 5 01-02-2008 10:50 AM


All times are GMT -6.
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Copyright 1993-2018 FlexSim Software Products, Inc.