Which is returned depends upon which window I selected the field from. In my example I only wanted the first field from the file, so I select it and when I press Enter my SQL statement is updated.Ībove I have two SQL statements the first using the "SQL Name" for the first field, and the second uses the "System Name" of the field.
To exit any of the "Content Assist" windows just press the Esc key. When I press F4 or Ctrl+Space the syntax proposals are displayed. The available option is what I put a green box around, "Switch to Syntax Proposals". In a DDS file the only time I would see a long name is if a field had been defined with an alias. You can switch between the two by pressing F11. The available fields can be displayed in one of two ways either by their "SQL names", long name, or their "System names". To get a list of the fields I can select I move the cursor next to the asterisk ( * ) and press F4. I just move the cursor to the file I want and press Enter, and the file name is inserted into my SQL statement. I would type in the most basic Select statement, and if I could not remember the name of the file I could just use the "Content Assist" to generate a list of files that start with the letter "T". I want to create a Select the list only the first field in the DDS file TESTFILE. One good improvement is that I can also use F4 to enter the "Content Assist", as well as using Ctrl+Space.
But if you are a brand new install of 1.1.8.5 you will have to have some SQL experience to know the type of statement you want to create. If I had 1.1.8.4, and then installed the new release what I have described above may still work, as it is residual functionality from the older release.
I was discouraged to find that with the new release this functionality was removed. All I had to do was press Ctrl+Space and a list of possible statements would be displayed.įrom a list I could just select the statement I wanted to build…Īnd when I pressed Enter the example SQL statement would be inserted into my "Run SQL Scripts" window. I was first introduced to the "Content Assist" as part of the "Run SQL Scripts" in the last release of ACS, 1.1.8.4, and have been sharing it with people learning SQL as a way to get help started. Or there is an icon for it on the line below the menu. I will find the option to start it in the "Actions" menu. The most common way is from the 5250 emulation display. There are several ways to start "Run SQL Scripts". Something that is hard to do using the STRSQL interface. It is my favorite part of ACS, as I often start with a simple SQL statement, and then copy that to make it ever more complex until I have the final form of the statement I want to use. I use "Run SQL Scripts" so much I leave it open all day. I have had the latest version of Access Client Solutions, ACS, 1.1.8.5 for just over a week.