R raneem New Member Oct 5, 2019 #1 I’m trying to insert data to my database but i got syntax error what i’ve to do?
OliverA Expert Licensed User Longtime User Oct 5, 2019 #2 You have a comma missing. ?)”, Array( Note: Next time post the text of the code you have issues with. Upvote 0
You have a comma missing. ?)”, Array( Note: Next time post the text of the code you have issues with.
M Mahares Expert Licensed User Longtime User Oct 5, 2019 #3 Your other mistake is: VALUE should be VALUES Upvote 0
Shelby Well-Known Member Licensed User Oct 5, 2019 #4 To insert your code, click the flag looking icon above the field where you enter your text. Upvote 0
R rosippc64a Active Member Licensed User Longtime User Oct 5, 2019 #5 Where is the field list? insert into anime (field1, field2, field2) values (?,?,?) ... Upvote 0
M Mahares Expert Licensed User Longtime User Oct 5, 2019 #6 rosippc64a said: Where is the field list? insert into anime (field1, field2, field2) values (?,?,?) . Click to expand... You do not need the field list if you are inserting in all fields. Upvote 0
rosippc64a said: Where is the field list? insert into anime (field1, field2, field2) values (?,?,?) . Click to expand... You do not need the field list if you are inserting in all fields.
R rosippc64a Active Member Licensed User Longtime User Oct 7, 2019 #7 You are right. I don't like using sql commands without fields list, can cause problems in the future if structure change. Upvote 0
You are right. I don't like using sql commands without fields list, can cause problems in the future if structure change.