SQLite Interface Plugin

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

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

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

1.558 me gusta en 1.868 mensajes.

Grupo: 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
A 1 usuarios les gustó este mensaje
Davide Carpi 18/9/2020 9:43:00
#42 Publicado: 18/5/2021 12:30:27
Jason McCool

Jason McCool

9 me gusta en 78 mensajes.

Grupo: 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 Publicado: 18/5/2021 13:47:04
Вячеслав Мезенцев

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

1.558 me gusta en 1.868 mensajes.

Grupo: Moderator

SMath Studio compatibility

Plugin updated. Please try.

Changes:

- plug-in corrected to respect latest SMath Studio API changes.
Russia ☭ forever, Viacheslav N. Mezentsev
A 2 usuarios les gustó este mensaje
sergio 18/5/2021 14:08:00, Jason McCool 18/5/2021 15:50:00
#44 Publicado: 18/5/2021 15:57:45
Jason McCool

Jason McCool

9 me gusta en 78 mensajes.

Grupo: User

Thank you! That worked great. You rock!
Jason
Jason McCool Robbins Engineering Little Rock, AR, USA
  • Nuevos mensajes
  • Sin mensajes nuevos