Runtime Error '3075': Syntax error in the string in the query expression [SQL]

Runtime Error '3075': Syntax error in the string in the query expression "", ").
This error gives time to save a name in the register.

Please Login or Register  to view this content.

Please use code tags when posting code --Moderator

The string you are building ends like this, which I think is giving you the error. You have a null value that SQL is not expecting:

'TextObsValue','')"

Change your last two lines of code from this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Your lines are putting ' before and after sql, so you have too many ' because every string will be ''value',''value' etc. Also your second last sql = should not add "','" because there is no value after it...

Please Login or Register  to view this content.

should be:

Please Login or Register  to view this content.

Based on the above comments:

Please Login or Register  to view this content.

@6StringJazzer thanks for the rep Very kind of you.

Originally Posted by Arkadi

@6StringJazzer thanks for the rep Very kind of you.

Well deserved! I caught the problem at the end but not the one in every other line!

Com prazer please remember to mark the thread as solved leegrj

Originally Posted by leegrj

Valeu.. Deu certo, Muito obrigado.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.