I try to import from database(thisistest.db) to GlobalTable1, the connection is successed, but couldn't import from database. I also tried to export globaltable content, it also display "unknown table list. Try testing the connection."
Did I miss anything so that it doesn't work? Since I have succeed with the same method before.
Your database file doesn't have any tables in it. It is a blank file.
Am I misunderstanding something? What did you expect it to do? What do you mean "[you] have succeeded with the same method before"? I don't understand.
If you want to import or export to a table, you need to actually have a table in the database. Try creating one:
Edit: now I see that your zip file has a sql query in it. If I run that query to create a table in a database file, then it imports and exports just fine:
I'm confused as to what you are doing and what you expected to happen. (Perhaps because your attached images aren't working in the original question.)
@Phil BoBo Thanks for the reply. This was my first few times testing how to connect to database. It was myself unfamiliar with it, so that sometimes it worked, sometimes didn't. , I've tried using code to import and export as well, it's working well.
16 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
