I am writing a code on MySQL and it’s giving me errors. This is my code and it’s giving me the error – “Error Code: 1826. Duplicate foreign key constraint name ‘menu_ibfk_1’ ” When I give a different constraint name, it give me the error – “Error Code: 1822. Failed to add the foreign key constraint. Missing index for constraint
Tag: compiler-errors
how to create pl sql function to Checking if data exists in database or not
I am trying to create a function that tells whether data exist in database or not. Trying to solve this using cursor if data exist then data will be fetched from database and value of temp will be TRUE otherwise data would not be fetched from DB and it will set value of temp to false. But when I compile
Undefined variable at ‘Incdntno.Value’
I am having trouble getting this to compile, it keeps giving an undefined variable error during compile at ‘Incdntno.Value’. I tried to Dim Incdntno as Integer but then was getting Invalid qualifier. I have a similar code that works (see second code block). I didn’t need a lot of what was going in the working code part so I removed