I connected SQLite using DB Connection, Importing data from SQLite data is working but exporting showing error like there is no such columns. but those columns are there in Table.
Error Message in System console: exception: Exception thrown in database export: Error Message in Compiler console: Reference to Order could not be resolved to a valid column. Parsing halted. Could not resolve column references in query: SELECT Priority, Section, Order QTY, Die_Availability, Die_Life FROM $1
Hi @Vinay S, was one of Jason Lightfoot's or Kavika F's answers helpful? If so, please click the "Accept" button at the bottom of the one that best answers your question. Or if you still have questions, add a comment and we'll continue the conversation.
If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.
Both answers won't solve the problem, It can't be a solution. As @Jordan Johnson said, need to consider this in dev list.
FlexSim doesn't automatically interpret column names that included spaces, so put [Order Qty] in your sql statement.
Hey @Vinay S, based on line 4 of the error message, it looks like there's a missing comma after Order if you're also looking for a column named QTY. I don't think there's a SQL keyword "QTY".
'Order QTY' is the name of the column in DB.
I didn't wrote this query. I used Export option in DataBase Connector.
In this case when column name is 'Order QTY' Flexsim should automatically consider it as [Order QTY] in query.
As a user of programs I don’t think it is FlexSim that should implement automatism for irregular names rather than users to consider creating names that better fits into programmer landscapes. Why it is so difficult to replace a space character by an underscore? Each new feature must be maintained in each new version. I’d like to have features that enhance a program by improvements for models. And I don’t like features that supports just a laziness of users. It is more important to find a documentation of all features in one place.
15 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.
