I encounter this error while trying to load data from a subscription
Subscription's articles:
Error:
Translation:
In table SINHVIEN(Student) there are columns include MASV(student ID), HO(last name), TEN(first name), MALOP(Class ID, Foreign Key), DANGHIHOC(Dropped out)
Columns: PHAI(sex), DIACHI(address), NGAYSINH(date of birth), PASSWORD from subscription database aren't exist due to replication.
How can I solve this error? I think i should add a new Dataset from subscription but is there any better method?
CodePudding user response：
Since you don't have some columns you have to try to change the select statement
Try this
SELECT MASV, HO, TEN, MALOP, DANGHIHOC FROM SINHVIEN