By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Votes Received: 0
AugSQL
3
Posts
2
Users
0
Reactions
57
Views
July 6, 2023 4:41 pm
If your SQL query gives you an error, you'll see the error like this:
CREATE VIEW MyView AS SELECT * FROM BAccount ORDER BY AcctCD
2 Replies
July 6, 2023 4:47 pm
To eliminate error add
TOP (9223372036854775807)
between Select & * on 2nd line
July 9, 2023 11:49 pm
Great point Henry. I was trying something that would illustrate an error message, but you showed a great example of how creative you can get with SQL.
I tried this and it did not return an error (1,000,000 is just a random "big" number that I chose):
CREATE VIEW MyView AS SELECT TOP 1000000 * FROM BAccount ORDER BY AcctCD
Maybe this is a better example of an error message showing that AugSQL does indeed return SQL error messages:
SELECT AcctCD, AcctName, BadColumnName FROM BAccount