Word "occup" is deleted from sql insert command ????

Scriptcase 7 Bugs
#1

Hello ,

This command works :

$requete = "SELECT date,bloctype_1,grattype_1,typech_1, … FROM occup " ;

But this not ???

$requete = "INSERT INTO occup (date,bloctype_1,grattype_1,typech_1, … ";
sc_exec_sql($requete);

When I’m looking the sql command in run, the word “oocup” was deleted from my code" , this is the code in form_…_apl.php

$requete = “INSERT INTO$this->occup (date,bloctype_1,grattype_1,typech_1,…”;

Anybody know what happen ???

Thanks

#2

Please, show your complete sql command for INSERT INTO … and the sql output when you set the debug modus = on.

#3

Hi Reinhard

I change table name from “occup” to “woccup” and it’s work without changing anything else !!!

Is “occup” and reserved word ??? , are there a reserved word list ??

Thanks

#4

No idea …

#5

It’s not a reserved word in php nor mySQL. So curious…

#6

Hello,

Issue reported to our bugs team.

regards,
Bernhard Bernsmann

#7

Are you able to use that work if you put `` around it?

#8

Hello Nacyil,

Our support team was unable to simulate the problem. Perhaps it is something specific to your application.

Have you tried to create a new form (without performing any modifications) to see if the issue happens?

regards,
Bernhard Bernsmann