SQLite Interface Plugin

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

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

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

1,532 likes in 1,838 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 2020/9/18 09:43:00
#42 Posted: 2021/5/18 12:30:27
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: 2021/5/18 13:47:04
Вячеслав Мезенцев

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

1,532 likes in 1,838 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 2021/5/18 14:08:00, Jason McCool 2021/5/18 15:50:00
#44 Posted: 2021/5/18 15:57:45
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
  • No New Posts