You may imagine that your "X", (where underline is a form of quoting to avoid further confusion here), is a string literal. , you are comparing a column, "endpoint", from one of the tables named in your SELECT, (which being impossible to guess), with another column, "X", also of mystery origin. There is a lingering possibility I have not covered, being too lazy to explore all the ways it could be causing you trouble. There is nothing wrong with your "original form" which would produce a syntax error as long as all the columns named in it exist in the referenced table.įor convenience of others who may try to help you, here is a schema:ĬREATE TABLE wRoutes(posX real, posY real, drNum int, page int, endpoint, id, tfFeedPt) ĬREATE TABLE xyposFitt(posX real, posY real, drNum int, page int, wid)
#SQLITESTUDIO ZIP CODES UPDATE#
The result is the same: SQLiteStudio OK, my code: 'near "FROM": syntax error'.Ĭould somebody tell, what is wrong with my UPDATE command? "FROM wRoutes wr" and "FROM wRoutes AS wr". I tried the table name aliases with and without using "AS".Į.g. It worked again in SQLiteStudio, but not in my code. To use the WITH UPDATE form, so I tried this version too: WITH fitt AS I searched in Google a lot, and found a tip which seemed to be promising. It's perferct in SQLiteStudio, but throws the mentioned exception from my code. ON wr.posX = tf.posX AND wr.posY = tf.posYĪND wr.drNum = tf.drNum AND wr.page = tf.page (SELECT wr.id AS wid, tf.id AS tid FROM wRoutes wr The original form of my UPDATE is: UPDATE wRoutes SET tfFeedPt = fitt.tid FROM February 2021.)īut this time I have no idea, what can be the problem. (Unfortunately I don't know any exact version number, but the 32bit version is digitally signed by Idera Inc. parenthesis is accepted or not) earlier in the function of the two versions, but there was always a solution to avoid the problem. I found already some little differences (e.g.
#SQLITESTUDIO ZIP CODES CODE#
There is a difference in the sqlite3.dlls, because SQLiteStudio uses a 64bit one, my code is a 32bit Windows application, so it uses a 32bit dll. When I execute the same in my program, it throws a syntax error. My problem is, that I wrote an update, checked it in SQLiteStudio, it works fine.
0 kommentar(er)
