🔒 Closed Pa help about dito sa already exist java

[PHC-Cathy]

baka pwede pa help
code ng checking ng value sa database

pangit kasi pag insert ko tapos may pareha na palang lrn

gusto ko pag existing na yung lrn is mag lalabas siya ng warning na already exist na

 

[PHC_Jayvee]

gawin mong unique yung lrn

ang alam mag throw ng error yun pag nag enter ka ng same

 

[PHC-Cathy]

gawin mong unique yung lrn

ang alam mag throw ng error yun pag nag enter ka ng same

Nag aadd lng ulit

 

[vhin le]

before you perform insert, perform select first so that you could check if the LRN or other data are existing or not in your database..

 

[PHC-Cathy]

before you perform insert, perform select first so that you could check if the LRN or other data are existing or not in your database..

How po

 

[vhin le]

Try mo mag execute ng select query. Sa criteria lagay mo yung mga data na gusto mo e-insert. If the query returns 1 or more than 0 results, then the record you are trying to add already exists. Paste mo dito select query na ginagawa mo madala sa java.