I'm trying to make a even script that uses the Insert function, I declare the function and then cut and paste the help file examples. I press F9 to check syntax and its fine, so I save it and test run it, when my CLICK event runs it brings up the debugger window saying " SYS1000 Error Loading Program "INSERT"."
I tried to look in the "Stored Procedure Executables" Area of the repository but I can't find the entry. What gives?
Any thoughts will be greatly appreciated!
INSERT is an opcode and thus doesn't need to be declared. When you declare it the system looks for a routine called INSERT and doesn't find it and thus fails. Simply use INSERT like any other intrinsic function and don't declare it.
amcauley@sprezzatura.com
World Leaders in all things RevSoft