Tweet
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.
-
-
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! -
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 sourceComment
-
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 MorrisComment
Comment