Some database request won't work, some will

[Cyrille]

Hi there,

I'm using ProjectMaker 7.4.0.0 and trying to run sql database requests.

• I managed to connect to the database
• When i run a "SELECT * FROM" request, i get a result
• When i run a "INSERT INTO" request, i get an error saying "Executing the Db of Failed to work with the database"

I tried both No answer, Scalar and Normal mode. I also tried to run the request directly on my server (same ID) and it worked perfectly so it doesn't seem to be a syntax error.

Any idea how to solve this ?

Thanks a lot for your help !

C.

 

[Cyrille]

Ok, I dug a bit further and realized after disconnecting and reconnecting to my server that request were actually passing even if getting an error in PM.

Here is how it looks

The matter is now : how can I make sure my request correctly worked and how to deal with other potential errors ?