General information
Category:
Coding, syntax & commands
Title:
INSERT INTO Statement
thisform.page1 is the data entry page with textboxes and combo boxes and a save button that contains the following statement :
INSERT INTO course (cid, c_title, semester, year)
VALUES (thisform.page1.cid, thisform.page1.c_title, thisform.page1.semester, thisform.page1.year)
Everytime I run it, it will tell me "Property CID not found". cid is the primary key for my course table and there is a textbox on the form named "cid". I just want to insert that value on the textbox to the table.
Why is CID not found? Any idea?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only