Dear Frnds,
I have developed one web application Screen connected with mySql database. i got error at run time.
MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int)),0)+1 FROM MED_MASTER' at line 1
Any function not supported in this function:
SELECT isnull(Max(cast(substring(Medcode,charindex('',Medcode)+1,len(Medcode)) as int)),0)+1 FROM MED_MASTER
with Regards,
Vno