SqlDbx
You are not logged in.
Everybody generally enters SELECT statements in proper syntactical order. By doing so, however, intellisense cannot know which table we're selecting from unless we alias it first.
We can currently enter a statement starting with the FROM clause (kind of link you do in LINQ queries) like this:
FROM tblTable1 Select<space>
...at which point intellisense pops up with the list of fields for this table (but it is only doing so for the first field; you must press <ctrl-space> to get the intellisense field list for subsequent fields. Can you fix this for additional fields?)
Could you then, upon pressing return at the end of the row, re-order the SELECT statement so that it is in correct syntactical order for execution? (ie reorder "FROM tblTable1 SELECT Field1, Field2" to "SELECT Field1, Field2 FROM tblTable1"?
Rgds,
Allen
I see IBM's z/OS IS available. ???
When generating a select or update statement, how about adding a WHERE clause for every field that is included in a UNIQUE index setup for that table? You could leave zero-length strings for the values. So if, for instance, you have a table which has City and State as fields in a UNIQUE index, append:
WHERE City='' AND State=''
You could get fancy, and provide a zero (without quotes, of course) if it is an integer field.
I'd leave off any Primary Keys that are integer-based, but that's me...