Database syntax error

Help
1

SnipImage
SnipImage1366×768 126 KB
hiiii I’m just working on database and I’m looking it add data into my existing database file, it’d showing that syntax error is wrong in insert into statement. Plz let me know how to resolve this.

1 Like
2

Actually its correct, kindly try that once in your db itself and check whether its inserting or not buddy… @venkatmalla6

Cheers

3

yes buddy gotcha, the names in column has space in it, while in db you cannot have space between columns, like first name, last name

Remove that space and check with column names in db and enter them in same order here as well

@venkatmalla6

4

thanks buddy,let me check it and i get back to you.

5

Great, kindly let know if it works buddy @venkatmalla6 or lets sort this out

Cheers

6

screenshot2
screenshot21366×768 131 KB
no buddy its not working same error is showing,have a look my database file.

7

Sequence1.xaml (5.2 KB)
this is my xaml file.

1 Like
8

Buddy did you try to execute that query in the db manually…is that inserting buddy @venkatmalla6

9

yeah i tried it’s taking manually.

1 Like
10

great, try to mention the db column name like this
insert into database ( [first name],[last name],[hr],[status]) values(…)

The reason is first and last are keywords in access db buddy, and we should not mention the db keywords as table columnname. i think thats the issue, it will work buddy this time

Cheers…
Kindly let know buddy whether this works or not @venkatmalla6

11

let me check it and one more thing if the connections are not good is there any possibility to get these type of error.

12

No Buddy connection wont show error with syntax, and it has no count on it, it would rather show error with connectionstrings only…this must be the issue, the keywords been used…
@venkatmalla6

13

ok,i don’t know why still it is showing same error.

14

xaml buddy…

16

Sequence1.xaml (5.2 KB)
look at this.

1 Like
17

this one also buddy
insert into [database] ( [first name],[last name],[hr],[status]) values(…)
Sorry i missed it @venkatmalla6

18

Still buddy…? @venkatmalla6

19

thanks buddy,now it works,made my day

20

Fantastic,
Cheers buddy @venkatmalla6

21

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.