No announcement yet.

Table Sync Missing?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Table Sync Missing?

    I am on the most current version of SC7 and I think my table sync option is missing.

    Or am I confused?

    This is why I am looking to use it.

    The field used to be numeric but now I'm storing the actual value, like West, East, but when then grid executes, it doesn't put quotes around the value so it gets an error.

    For example, it will say
    "where region = West"
    which gives a mysql error.
    Last edited by asawyer13; 04-27-2013, 07:52 AM.

  • #2

    Grids do not have a SYNC option as FORMS do.

    Go to SQL on your left tab and change your SQL Statement.

    Also on the example you gave, you should pass 'West' as a string with quotation marks.

    Bernhard Bernsmann


    • #3
      The query selects region which is a varchar field. The West is in the search query because I select it from a drop down select in the search form. I don't create the sql statement sc7 does.


      • #4
        I think since ScriptCase thinks the field is an integer, it doesn't bother putting the quotes around the field when it creates the "where" clause.
        I am going to try removing the field totally from the app and add it back in and see if that fixes it.