Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

SQL Program

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

  • SQL Program

    You cannot run any Sql Stmt in this manner IF it returns any data. You can do things like create table, create index, delete table or insert data. It can't return data because there is no place to return it.

  • #2
    SQL Program

    Thanks. I was just wanting it to bring a screen up. I do understand and Thank you for answering me. Have a Good Christmas!

    Comment


    • #3
      SQL Program

      To whom it may concern: I placed an SQL statement in a TXT file and now it will not run. I received the below message. Please help. Thanks in advance. Select LgInv#, Count(*) From rmfiles/viinwrk Group by Lginv# Having Count(*) > 1 * * * * * E N D O F S O U R C E 010525 Run SQL Statements . 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... CORD TEXT 1 Position 10 SQL statement not allowed. Message Summary Warning Error Severe Terminal 0 0 1 0 ty errors found in source

      Comment


      • #4
        SQL Program

        Derek, You might try searching this site for QMQRY. With a Query Management Queary, you can run saved select statements and direct the output to the display. To check it out on your system use: GO CMDQRY David Morris

        Comment

        Working...
        X