Announcement

Collapse
No announcement yet.

Help, refresh grid when altering database

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

  • Help, refresh grid when altering database

    Hi,
    I tried to add field with BLOB type to quick search, but couldn't see it in the option. (I have called the field in the sql)
    Then I decided to alter the table in database, I alter the field from TEXT to VARCHAR.
    But the existing grid is still showing that the field has BLOB type.

    I really need to refresh the grid, without having to remake it from scratch.
    I understand that in form, we just have to synchronize it. But how does it work in grid?

  • #2
    Originally posted by anjellz View Post
    Hi,
    I tried to add field with BLOB type to quick search, but couldn't see it in the option. (I have called the field in the sql)
    Then I decided to alter the table in database, I alter the field from TEXT to VARCHAR.
    But the existing grid is still showing that the field has BLOB type.

    I really need to refresh the grid, without having to remake it from scratch.
    I understand that in form, we just have to synchronize it. But how does it work in grid?
    You can synchronize forms but on grids you have to modify your sql. So go to the sql section, add your new field and press save. Then go to the lay-out sections to put your new field on your form or block.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      The problem is, I didn't add more fields. I just alter the field type from TEXT to VARCHAR.
      TEXT field type is read BLOB in scriptcase, and I couldn't find any way to select it for quick search.

      So I can't see how changing the sql would help, because I don't have to call more fields.
      I tried to generate it many times. But the field still doesn't show at quick search list, and still read as BLOB.

      Comment

      Working...
      X