aDeviKreates
New member
Using a formview to view, edit, and insert data to an Oracle database, but I keep getting an error: ORA-01036: illegal variable name/number
Here is my update statement:
UPDATE AIRPORTS SET AIRPORT_CODE='TES',AIRPORT_NAME='New Airport Today' WHERE AIRPORT_CODE='TTT'
My insert statement works perfectly!
Any thoughts and/or resolutions will be much appreciated.
I can use the same statement in Toad and it updates as it should.
Here is my update statement:
UPDATE AIRPORTS SET AIRPORT_CODE='TES',AIRPORT_NAME='New Airport Today' WHERE AIRPORT_CODE='TTT'
My insert statement works perfectly!
Any thoughts and/or resolutions will be much appreciated.
I can use the same statement in Toad and it updates as it should.