SQLite Interface Plugin

SQLite Interface Plugin - A plugin that allows SMath Studio to interface the SQLite relational database engine - Messages

#41 Posted: 9/17/2020 1:45:37 PM
Вячеслав Мезенцев

Вячеслав Мезенцев

1402 likes in 1708 posts.

Group: Moderator

Example

Updated.

Changes:

- now a scalar is returned for a matrix with one element;
- example changed;
- small improvements.

SQLite Steel Properties Look-up.png
Russia ☭ forever, Viacheslav N. Mezentsev
1 users liked this post
Davide Carpi 9/18/2020 9:43:00 AM
#42 Posted: 5/18/2021 12:30:27 PM
Jason McCool

Jason McCool

9 likes in 78 posts.

Group: User

I don't know if this is the right place to post this, but I think the issue I'm seeing is with the SQLite plugin. I compose a query based on some user input via combo boxes, concatenate all the parts together into a string, and then use the SQLiteQuery function to query the AISC Table database. This normally works well. Now, I get an error indicating that a "\" symbol is interfering. The database file location has that symbol, but I don't think that is the issue. When I look at the resulting string in SMath, it looks like correct syntax. But when I copy it into DB Browser, it shows all of the spaces and single quote marks in the query string translated as \0020\ and \0027\ respectively. If I manually replace those in DB Browser, the query runs as anticipated. Is there any way to get that corrected? I'm using SMath version 0.99.7786.

2021-05-18_SMath SQLite Issue 1.png
2021-05-18_SMath SQLite Issue 2.png

Thanks,
Jason
Jason McCool Robbins Engineering Little Rock, AR, USA
#43 Posted: 5/18/2021 1:47:04 PM
Вячеслав Мезенцев

Вячеслав Мезенцев

1402 likes in 1708 posts.

Group: Moderator

SMath Studio compatibility

Plugin updated. Please try.

Changes:

- plug-in corrected to respect latest SMath Studio API changes.
Russia ☭ forever, Viacheslav N. Mezentsev
2 users liked this post
sergio 5/18/2021 2:08:00 PM, Jason McCool 5/18/2021 3:50:00 PM
#44 Posted: 5/18/2021 3:57:45 PM
Jason McCool

Jason McCool

9 likes in 78 posts.

Group: User

Thank you! That worked great. You rock!
Jason
Jason McCool Robbins Engineering Little Rock, AR, USA
  • New Posts New Posts
  • No New Posts No New Posts