I've two tables "Medication" and "Allergy"

Medication table has cols: MedCardID,alg1,alg2,alg3,alg4,alg5

and

Allergy table has cols : CardID,allergey

After inserting the values into allergy table and Medication table.I want to update the allergies...

Insert into Y(id,allergy1,allergy2,allergy3) values(?,?,?)

ODBC Driver Error:

Invalid length parameter passed to the substring function.

If we remove the delete statement we are not getting any error.

no i'm trying this but while deleting i'm getting error.

I'll explain my actual scenario , my third party interfave inserting values to my tables "X" and "Y". I want to...