topic Re: SQLite exporting error in DB connector in FlexSim Forum

SQLite exporting error in DB connector

Vinay_S_Jindal — Fri, 19 May 2023 06:50:17 GMT

[ FlexSim 23.0.0 ]

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

Re: SQLite exporting error in DB connector

kavika_faleumu — Fri, 19 May 2023 17:00:36 GMT

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".

Re: SQLite exporting error in DB connector

Vinay_S_Jindal — Sat, 20 May 2023 03:45:43 GMT

'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.

Re: SQLite exporting error in DB connector

jason_lightfoot_adsk — Mon, 22 May 2023 11:43:33 GMT

FlexSim doesn't automatically interpret column names that included spaces, so put [Order Qty] in your sql statement.

Re: SQLite exporting error in DB connector

carter-walch — Thu, 25 May 2023 17:10:12 GMT

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.

Re: SQLite exporting error in DB connector

JordanLJohnson — Thu, 25 May 2023 19:48:48 GMT

I will add this suggestion to the dev list.

Re: SQLite exporting error in DB connector

Vinay_S_Jindal — Fri, 26 May 2023 03:46:37 GMT

Both answers won't solve the problem, It can't be a solution. As @Jordan Johnson said, need to consider this in dev list.

Re: SQLite exporting error in DB connector

joerg_vogel_HsH — Fri, 26 May 2023 05:08:38 GMT

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.