susannanam
Member
hello all,
i have a form where i add into repeated groups. the "problem-field" is a databasejoin field, type is varchar 11, i checked the source table as well as the table from the repeated group, it is correct in both. nevertheless, when i try to add a new record, this message comes up and the apostrophe is missing. what must i do to have it right please?
SELECT DISTINCT(`sh2m8_student`.`student_id`) AS value, `last_name` AS text FROM `sh2m8_student` AS `sh2m8_student` WHERE `sh2m8_student`.`student_id` IN (A05011) ORDER BY text ASC
A05011 is the student-number (varchar,11) and needs to be in apostrophe
thanks for any hint
susanna
i have a form where i add into repeated groups. the "problem-field" is a databasejoin field, type is varchar 11, i checked the source table as well as the table from the repeated group, it is correct in both. nevertheless, when i try to add a new record, this message comes up and the apostrophe is missing. what must i do to have it right please?
SELECT DISTINCT(`sh2m8_student`.`student_id`) AS value, `last_name` AS text FROM `sh2m8_student` AS `sh2m8_student` WHERE `sh2m8_student`.`student_id` IN (A05011) ORDER BY text ASC
A05011 is the student-number (varchar,11) and needs to be in apostrophe
thanks for any hint
susanna