question

Vinay S avatar image
0 Likes"
Vinay S asked Jordan Johnson answered

SQLite exporting error in DB connector

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
FlexSim 23.0.0
export datasqlite
· 2
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Carter Walch avatar image Carter Walch ♦ commented ·

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.

0 Likes 0 ·
Vinay S avatar image Vinay S Carter Walch ♦ commented ·

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

0 Likes 0 ·
Jordan Johnson avatar image
3 Likes"
Jordan Johnson answered
I will add this suggestion to the dev list.
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image
2 Likes"
Jason Lightfoot answered

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

5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Kavika F avatar image
0 Likes"
Kavika F answered Julie Weller converted comment to answer

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

· 2
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Vinay S avatar image Vinay S commented ·

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

0 Likes 0 ·
Joerg Vogel avatar image Joerg Vogel Vinay S commented ·

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.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.