SQLite Interface Plugin - A plugin that allows SMath Studio to interface the SQLite relational database engine - Messages
#42 Posted: 5/18/2021 12:30:27 PM
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.


Thanks,
Jason
Thanks,
Jason
Jason McCool
Robbins Engineering
Little Rock, AR, USA
#44 Posted: 5/18/2021 3:57:45 PM
Thank you! That worked great. You rock!
Jason

Jason
Jason McCool
Robbins Engineering
Little Rock, AR, USA
-
New Posts
-
No New Posts