Activity overview
Latest activity by KarlB
Hi Keith, This is a strange one, I've completed some testing my side and once I save my .xlsx to my OneDrive for the first time the Autosave function kicks straight in and switches on at the top left. I did spot an option within Excel that controls this, could you take a look at the following please: - Open Excel - Click on 'File' - Click on 'Options' - Click into the 'Save' tab from the left menu. - Check the AutoSave by default is enabled, screen shot below shows exact location and option; [image] If I have this un-ticked I can replicate the same behavior you reported, with this ticked it looks to be working a treat and sames time and additional clicks. Please let me know how you get on with this. / comments
Hi Keith,This is a strange one, I've completed some testing my side and once I save my .xlsx to my OneDrive for the first time the Autosave function kicks straight in and switches on at the top lef...
Hi Zac, It's not currently possible with the tool however I can see where you are coming from with it. Whilst Microsoft do not offer or support this theme it does make it trickier for the developers to dedicate time on the enhancement, if the goal posts don't sit still. Can I ask you to lend your support to our User Voice towards this, I've located where this has come up previously and the greater the support the more chance of our developers keeping it in mind. User Voice for this particular item can be found here / comments
Hi Zac,It's not currently possible with the tool however I can see where you are coming from with it.Whilst Microsoft do not offer or support this theme it does make it trickier for the developers ...
Glad it's sorted things for you Adman! / comments
Glad it's sorted things for you Adman!
Hi both, My apologies I may have led you astray! Whilst SQL Search is installed you will need to run the tool from the URL to uninstall and this will allow it to remove any odd registry items fully. One completed you can then reinstall as normal. Apologies again and please do let me know how you get on. / comments
Hi both,My apologies I may have led you astray!Whilst SQL Search is installed you will need to run the tool from the URL to uninstall and this will allow it to remove any odd registry items fully.O...
Hi there, Sorry to see you are having issues with SQL Search tool. I can confirm we have come across this issue before and the fix is to clear out lingering registry keys. Please uninstall and then follow the instructions on the link below: https://support.microsoft.com/en-gb/help/17588/windows-fix-problems-that-block-programs-being-installed-or-removed Once completed you can reinstall, fingers crossed all works as planned then. Let me know how you get on and shout if you have any issues! / comments
Hi there,Sorry to see you are having issues with SQL Search tool. I can confirm we have come across this issue before and the fix is to clear out lingering registry keys.Please uninstall and then f...
Hi Jean, Sorry to hear you are experiencing issues with SQL Search over VPN recently. I've double checked and no new releases for our product have taken place since before Christmas, which would rule out a change in the way the tool works since you last used it remotely. In order to dig into this further could you please share your recent log file with me. It can be located by using the 'Help' menu in SQL Search, then click on 'Logging' and finally 'Locate log files' It's possible that your internet provider could have altered something on their service however reviewing the logs recorded may point us in the right direction. / comments
Hi Jean,Sorry to hear you are experiencing issues with SQL Search over VPN recently.I've double checked and no new releases for our product have taken place since before Christmas, which would rule...
Hello, Thanks for raising this with us, it is a little strange! Can you confirm which version on SQL Prompt you are using? It would also be helpful to investigations if you are able to share your SQL Prompt settings, you can share them by using the 'Export' function within the options menu. / comments
Hello,Thanks for raising this with us, it is a little strange! Can you confirm which version on SQL Prompt you are using? It would also be helpful to investigations if you are able to share your SQ...
Hi Ron, Ah OK, understood. I've spent further time using the function you are utilizing, 'Open in Excel' and can replicate the same behavior as you. This is due to how Excel treats no values and unfortunately there isn't currently any setting in Prompt that when exporting into Excel would replace values, or no values. Ironically we had the opposing idea raised previously which is why it currently exports as no value. It has been raised on our User Voice for it to be a toggle option - I would recommend lending your support to it here as the greater the demand the higher chance of development getting reviewed! Click Here / comments
Hi Ron,Ah OK, understood. I've spent further time using the function you are utilizing, 'Open in Excel' and can replicate the same behavior as you. This is due to how Excel treats no values and unf...
Hello, Currently the 'Search field' within SQL Search only allows for 1 word to be used at a time. You can use Wildcards and a few other functions in this field to help narrow the results - Click Here to see the documentation on available search criteria. You can also filter down on Stored Procedures object types specifically, using the filter options along the top ribbon bar, however I appreciate this won't drill down to exactly what you want with regards to a 'double search'. / comments
Hello,Currently the 'Search field' within SQL Search only allows for 1 word to be used at a time. You can use Wildcards and a few other functions in this field to help narrow the results - Click He...
Hi Ron, I've attempted to recreate this and can see 2 types of behavior when copying and pasting into Excel. NULL Where NULL is the value within the table, copying this into Excel the behavior pastes NULL into the Excel fields. Blank Where the value in the table is blank, ie no value, coping this into Excel the behavior pastes no data into the cell. This is the expected behavior of Excel and how it handles blank data. Do you have further detail about the example you are using and any screen shot which may help, in case I am looking into the wrong area and misunderstanding your query. / comments
Hi Ron,I've attempted to recreate this and can see 2 types of behavior when copying and pasting into Excel.NULLWhere NULL is the value within the table, copying this into Excel the behavior pastes ...