Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

3 Pages<123
Options
Go to last post Go to first unread
Offline uni  
#41 Posted : 17 September 2020 19:45:37(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,546
Man
Russian Federation

Was thanked: 1307 time(s) in 766 post(s)
Example

Updated.

Changes:

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

SQLite Steel Properties Look-up.png

Edited by user 06 November 2020 12:48:55(UTC)  | Reason: Not specified

Russia ☭ forever
Viacheslav N. Mezentsev
thanks 1 user thanked uni for this useful post.
on 18/09/2020(UTC)
Offline Jason McCool  
#42 Posted : 18 May 2021 18:30:27(UTC)
Jason McCool


Rank: Advanced Member

Groups: Registered
Joined: 27/05/2016(UTC)
Posts: 77
Man
United States
Location: Little Rock, Arkansas

Was thanked: 9 time(s) in 7 post(s)
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
Offline uni  
#43 Posted : 18 May 2021 19:47:04(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,546
Man
Russian Federation

Was thanked: 1307 time(s) in 766 post(s)
SMath Studio compatibility

Plugin updated. Please try.

Changes:

- plug-in corrected to respect latest SMath Studio API changes.
Russia ☭ forever
Viacheslav N. Mezentsev
thanks 2 users thanked uni for this useful post.
on 18/05/2021(UTC),  on 18/05/2021(UTC)
Offline Jason McCool  
#44 Posted : 18 May 2021 21:57:45(UTC)
Jason McCool


Rank: Advanced Member

Groups: Registered
Joined: 27/05/2016(UTC)
Posts: 77
Man
United States
Location: Little Rock, Arkansas

Was thanked: 9 time(s) in 7 post(s)
Thank you! That worked great. You rock! Clap
Jason
Jason McCool
Robbins Engineering
Little Rock, AR, USA
Users browsing this topic
3 Pages<123
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.