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 12-05-2011
Pablo Concha Pablo Concha is offline
Flexsim User
 
Join Date: Aug 2007
Posts: 104
Downloads: 100
Uploads: 1
Thanks: 103
Thanked 52 Times in 37 Posts
Rep Power: 232
Pablo Concha is just really nicePablo Concha is just really nicePablo Concha is just really nicePablo Concha is just really nice
Default Access db.. how to?..

Hi,

first time trying to read/write data to tables on an Access database and i'm not having much luck... what are the steps to do this?.

regards

Pablo Concha
  #2  
Old 12-05-2011
Steven Hamoen's Avatar
Steven Hamoen Steven Hamoen is offline
Talumis, Flexsim Distributor, The Netherlands
 
Join Date: Aug 2007
Location: Soest, NL
Posts: 854
Downloads: 43
Uploads: 0
Thanks: 391
Thanked 661 Times in 379 Posts
Rep Power: 684
Steven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond repute
Default

Basically the steps are:

1. Create an ODBC Connection (eg MyDB )to your database, selecting the right driver.
2. Create that ODBC name in your dbopen statement (eg. dbopen( MyDB, "SELECT * FROM MYTABLE", 0, 0) )
3. Then use the dbgettablenum and dbgettablestr commands to retrieve your data
4. Use dbsql to make new or update queries


Maybe you can describe the steps you have tried?
The Following User Says Thank You to Steven Hamoen For This Useful Post:
Pablo Concha (12-06-2011)
  #3  
Old 12-06-2011
Pablo Concha Pablo Concha is offline
Flexsim User
 
Join Date: Aug 2007
Posts: 104
Downloads: 100
Uploads: 1
Thanks: 103
Thanked 52 Times in 37 Posts
Rep Power: 232
Pablo Concha is just really nicePablo Concha is just really nicePablo Concha is just really nicePablo Concha is just really nice
Default

Thanks Steven... i was missing something when creating the connection... now is working.

regards

Pablo Concha


Thread Thread Starter Forum Replies Last Post
Access to PC-Speaker from Flexsim Eike Schulz Q&A 3 06-15-2011 12:51 PM
Modifying Access MDB files… without Access (and free) Jorge Toucet Tips and Tricks 1 11-21-2008 05:13 AM
Sample Access Database Brandon Peterson Tips and Tricks 1 07-09-2008 12:15 PM
Problem with Flexsim 4.1 and Access DB Martin Saler Q&A 0 04-03-2008 05:16 AM
Access to the tree variables Iulian Marin Ion Q&A 2 02-06-2008 09:15 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.