ESdat Forums
»
Forums
»
ESdat
»
Error Code '16364 Invalid SQL statement'
 Rank: Newbie
Groups: Registered
Posts: 1
|
Hi, I have been trying to upload new data, specifically new environmental standards, to an older database created in 2012 and there is a recuring msg box that appears when i am clicking various buttons when uploading the standards (and lab files) from the excell file to the database. The message reads "16364 Invalid SQL statement; expected 'DELETE, 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'." The files seem to upload fine (i.e. they are highlighted in green) but when i am in ESdat itself none of the guidelines show up in the reference tables or appear as a selection when i try to help. I have had no issues with other databases, just this one. I have tried copying the file, and re-installing ESdat/updating to no avail. The licence is for a single computer so i cant try it on another computer and it doesnt work with someone else logged on to the computer. Help anyone?
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498  Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
We analysed a copy of the databases, and this was resolved through support. The issue was that some environmental standards didn't have an "ActionLevelSource" (ie the name of the guideline). Once these Environmental Standards were removed then the problem was resolved. Environmental Standards that have this problem can be seen under Data Tables - zRef_Environmental_Standards and filtering for "ActionLevelSource Is Null " We are looking into how this could have happened for a future update. Warwick
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Error Code '16364 Invalid SQL statement'
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.