Good morning,
SQL Prompt 2.0.0.26 currently running on XP Pro SP2
Nice to haves:
1. Some form of feedback after I have cleared the cache that the metadata will have to be pulled again and from where it will be pulled.
2. Ability to see full table name from the list, when table name is fully qualified window is not wide enough to be able to view full table name.
3. A cache control whereby I can either completely wipe it, wipe the portion(s) for specific databases, or refresh it so that it will not take nearly as long to build the metadata.
4. When changes are made to the Candidates tab, refresh metadata automatically.
Suspected bugs:
1. Drop down list appears after space is pressed and by clicking anywhere except on the slider causes the popup to close, does this all the time until the slider indicator is selected or page down is pressed, then is works normally, sort of, see next point.
2. Actually grabbing the slider and moving it to the very bottom of the list causes the window to close when slider is released.
3. Intellisense list is identical whether or not “Tables joined by a matching column name†is selected in the Candidates tab, a full list of all of the tables. I did try using different casing for this as well. Currently in the process of upgrading ERP and when it is completed there will be over 800 tables in the schema. If I include all objects, eg. views, stored procs, etc. well over 1000 items to choose from, way too many to bother selecting from a drop down list.
4. When I backspace in query analyzer the list disappears until I remove all the code until I get back to the FROM and then enter Space again. This could get a little tedious.
5. Query analyzer currently connected to PSLTest database and when performing a call to another database using a fully qualified name, window pops up telling me that metadata is being pulled. Wait for 15 to 20 minutes. I enter SELECT Currency_ID FROM “, here the drop down list appears, enter “PSL.â€, now I see is a list of users, enter “dbo.â€, and…..nothing.
6. I have no problem waiting for the metadata to be pulled, just tell me that it will be few minutes as compared to a few seconds.
SQL Prompt 2.0.0.26 currently running on XP Pro SP2
Nice to haves:
1. Some form of feedback after I have cleared the cache that the metadata will have to be pulled again and from where it will be pulled.
2. Ability to see full table name from the list, when table name is fully qualified window is not wide enough to be able to view full table name.
3. A cache control whereby I can either completely wipe it, wipe the portion(s) for specific databases, or refresh it so that it will not take nearly as long to build the metadata.
4. When changes are made to the Candidates tab, refresh metadata automatically.
Suspected bugs:
1. Drop down list appears after space is pressed and by clicking anywhere except on the slider causes the popup to close, does this all the time until the slider indicator is selected or page down is pressed, then is works normally, sort of, see next point.
2. Actually grabbing the slider and moving it to the very bottom of the list causes the window to close when slider is released.
3. Intellisense list is identical whether or not “Tables joined by a matching column name†is selected in the Candidates tab, a full list of all of the tables. I did try using different casing for this as well. Currently in the process of upgrading ERP and when it is completed there will be over 800 tables in the schema. If I include all objects, eg. views, stored procs, etc. well over 1000 items to choose from, way too many to bother selecting from a drop down list.
4. When I backspace in query analyzer the list disappears until I remove all the code until I get back to the FROM and then enter Space again. This could get a little tedious.
5. Query analyzer currently connected to PSLTest database and when performing a call to another database using a fully qualified name, window pops up telling me that metadata is being pulled. Wait for 15 to 20 minutes. I enter SELECT Currency_ID FROM “, here the drop down list appears, enter “PSL.â€, now I see is a list of users, enter “dbo.â€, and…..nothing.
6. I have no problem waiting for the metadata to be pulled, just tell me that it will be few minutes as compared to a few seconds.