Sign in to follow this  
Followers 0
gimx

SQLite error

3 posts in this topic

Hello,

I have this error but i don't know why :P

Thx for help :D

_SQLite_Exec(-1, "Insert into partant values(" & $numero & "," & $cheval & "," & $chevalmus & "," & $driver & "," & $drivermus & "," & $trainer & "," & $trainermus & ");")

--> Function: _SQLite_Exec
--> Query:  Insert into partant values(101,Quelia du Buisson,0m(07)2m2m6mDa2a,M.N. Henry,0a1m7m8mDm0mDm2m,B. Desmontils,[0a0a]8m0m0mDm2aDm);
--> Error:  near "du": syntax error

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

You don't have quotes in your actual string. SQLite needs quotes around each entry in the string itself.

_SQLite_Exec(-1, "Insert into partant values('" & $numero & "','" & $cheval & "','" & $chevalmus & "','" & $driver & "','" & $drivermus & "','" & $trainer & "','" & $trainermus & "');")

This should work as long as none of your values have single quotes in them. The only time that it doesn't require quotes is when the data value has been declared as an integer. This is probably the case and why it didn't error out at $numero. If it is declared as an integer, it should still work with quotes around it.

- The Kandie Man ;-)

Edited by The Kandie Man

"So man has sown the wind and reaped the world. Perhaps in the next few hours there will no remembrance of the past and no hope for the future that might have been." & _"All the works of man will be consumed in the great fire after which he was created." & _"And if there is a future for man, insensitive as he is, proud and defiant in his pursuit of power, let him resolve to live it lovingly, for he knows well how to do so." & _"Then he may say once more, 'Truly the light is sweet, and what a pleasant thing it is for the eyes to see the sun.'" - The Day the Earth Caught Fire

Share this post


Link to post
Share on other sites

Yes it's an integer.

Thx :D

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0