Announcement

Collapse
No announcement yet.

SHOW TABLES From DB in a grid

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

  • SHOW TABLES From DB in a grid

    Hello all,

    Has anyone done this? I am trying to use MySQL SHOW TABLES and display results into a grid so content can be selected from a form text field using Link - Capture.
    This is for database change logging.
    I am able to pull database tables info into a blank form, but it needs to be in a grid.

  • #2
    I have not ever used it, but couldn't you just create a view with the select statement and use that as the grid source fr the SQL?

    Comment


    • #3
      Or make use of tempory table to store the intermediate result and work from there. Show tables into temptable then sc_redir to regular module using this table.
      Albert Drent
      aducom software netherlands
      scriptcase partner, reseller, support and (turn-key) development
      www.scriptcase.eu / www.scriptcase.nl

      Comment


      • #4
        Hi,
        what you need is the following statement for your grid:

        SELECT table_name FROM INFORMATION_SCHEMA.TABLES
        WHERE table_schema = 'name_of_your_database'

        that should do it. You can of course select all the other information you need as well.

        Hope that helps
        jsb

        Comment

        Working...
        X