Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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.
    Best regards: - Reinhard -

    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

    Comment


    • #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

      Comment


      • #4
        Originally posted by nacyil View Post
        Is "occup" and reserved word ??? , are there a reserved word list ??
        No idea ...
        Best regards: - Reinhard -

        I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

        Comment


        • #5
          It's not a reserved word in php nor mySQL. So curious...
          Albert Drent
          aducom software netherlands
          scriptcase partner, reseller, support and (turn-key) development
          www.scriptcase.eu / www.scriptcase.nl

          Comment


          • #6
            Hello,

            Issue reported to our bugs team.

            regards,
            Bernhard Bernsmann

            Comment


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

              Comment


              • #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

                Comment

                Working...
                X