dmm14
09-18-2005, 11:42 PM
Hello Everyone!
I need help with my coding in ASP.net(VB) and MYSQL database. I am using an auto increment memberID in my member table. That I need to pass on to my 2 other tables. I've tried using the Last_Insert_ID() but it didn't work ... I'm not sure if I used it right I guess??? :confused: I am also getting this error "ERROR [HYT00] Cannot add or update a child row: a foreign key constraint fails " because I used memberID as my primary and foreign key on my 2 other tables. Would really appreciate it, if anyone could help me on this.
Thanks!,
dmm14 :)
I need help with my coding in ASP.net(VB) and MYSQL database. I am using an auto increment memberID in my member table. That I need to pass on to my 2 other tables. I've tried using the Last_Insert_ID() but it didn't work ... I'm not sure if I used it right I guess??? :confused: I am also getting this error "ERROR [HYT00] Cannot add or update a child row: a foreign key constraint fails " because I used memberID as my primary and foreign key on my 2 other tables. Would really appreciate it, if anyone could help me on this.
Thanks!,
dmm14 :)