SQLite Interface Plugin

SQLite Interface Plugin - A plugin that allows SMath Studio to interface the SQLite relational database engine - Сообщения

#41 Опубликовано: 17.09.2020 13:45:37
Вячеслав Мезенцев

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

1402 сообщений из 1708 понравились пользователям.

Группа: 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 пользователям понравился этот пост
Davide Carpi 18.09.2020 09:43:00
#42 Опубликовано: 18.05.2021 12:30:27
Jason McCool

Jason McCool

9 сообщений из 78 понравились пользователям.

Группа: 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 Опубликовано: 18.05.2021 13:47:04
Вячеслав Мезенцев

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

1402 сообщений из 1708 понравились пользователям.

Группа: 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 пользователям понравился этот пост
sergio 18.05.2021 14:08:00, Jason McCool 18.05.2021 15:50:00
#44 Опубликовано: 18.05.2021 15:57:45
Jason McCool

Jason McCool

9 сообщений из 78 понравились пользователям.

Группа: User

Thank you! That worked great. You rock!
Jason
Jason McCool Robbins Engineering Little Rock, AR, USA
  • Новые сообщения Новые сообщения
  • Нет новых сообщений Нет новых сообщений