Using Word 2019 (for Mac) Need to set a word's color

I have a word that repeats hundreds of times and in dozens of point sizes. But I need to make every instance of that word the same color.

What kind of automation is there for that?

Thanks.

Hi,
I am using VS2017 with TFS. I can see files in my local repository but they do not display in Solution Explorer,
see below
any guidance appreciated,
thanks

Hello Experts

I am trying Use wildcards (or other method) to Unzip a file in C# where the file name can be found based on first part of text only. So far am unable to accomplish this.

For example I have the following code:

string targetDirectory = @"C:\TestDirectory";
                    string zipFile = @"C:\TestDirectory\Test_09/20/2019.ZIP";
                    ICSharpCode.SharpZipLib.Zip.FastZip fz = new ICSharpCode.SharpZipLib.Zip.FastZip();
                    fz.ExtractZip(zipFile, targetDirectory, "");


This code works fine to unzip files as long as the exact zipped file name is listed...

I want to be able to use wild cards or other method to unzip a file called Test_09/20/2019.ZIP without the program having to know about the _09/20/2019 part of the file.

In other words I would like to unzip a Test_"Any date or other text".ZIP file by only knowing about Test.ZIP a the file name.

I tried Test*.ZIP in the above code but the * was an unrecognized character.

Does anyone know how to do this?

Thanks!

I have C# program that has multiple classes. how can I create a really global variable that can be accessed by any class and change the value before passing it to another class.

I re-organized my UWP app. I created a set of folders in the solution explorer and moved the XAML files around accordingly.
I go to recreate my menu items and i run into a trouble where it doesn't recognize some of the new folders and some of the new files.
Is there a way to clean out the old references to make way for a new one? see pictures for details

Hi EE,

This question is more of a query looking for approaches to resolve the following issue:

The user has an SSRS 2016 report and filters the datasets efficiently with filters they have been given.

However, the user wants to save specific rows within the report to key the data into another system e.g Desktop application. Exporting initial the result set data to XML result is a simple task. My question is can you have a button on the SSRS which launches a subform that asks what rows /columns specifically do you want to save from the resultset in XML format.  Completing the necessary criteria on the subform, SSRS exports the data to the user via a download.  

Is this possible in SSRS if so are there examples out there?

Any links or tips, advice are welcome.

Thank you.

THis is a duplicate question that i asked on a reddit subforum.
but without much response.
https://www.reddit.com/r/UWP/comments/cth82z/is_it_just_me_or_is_there_not_1_single_good_guide/

Iv been looking for weeks to find a comparable guide on using a UWP app with SQLite. All the guides i find are either out of date or using nugget packages that no longer exist. or provide super complex methods.

Im using VS 2019 Community

with this: https://www.nuget.org/packages/Microsoft.EntityFrameworkCore.Sqlite/

Trying to connect to a local .DB file

Maybe i am just not googling the correct words?

Does anyone know of a good resource that demonstrates how to connect to a local .DB file submit entry's and retrieve entry's?

Hello all,
I am writing a DLL (in windows), with a function that needs a lot of stack size.
The problem is that I am not creating the thread.
So is there a way to change the stack size while the thread is running ?
Alternatively, is there a way to "catch" thread creation, and vrify that the stack size is big enough ?


Thanks
zmau

Hi EE,

For the following function borrowed from the following site: http://www.kodyaz.com/articles/fuzzy-string-matching-using-levenshtein-distance-sql-server.aspx

CREATE FUNCTION edit_distance(@s1 nvarchar(3999), @s2 nvarchar(3999))
RETURNS int
AS
BEGIN
 DECLARE @s1_len int, @s2_len int
 DECLARE @i int, @j int, @s1_char nchar, @c int, @c_temp int
 DECLARE @cv0 varbinary(8000), @cv1 varbinary(8000)

 SELECT
  @s1_len = LEN(@s1),
  @s2_len = LEN(@s2),
  @cv1 = 0x0000,
  @j = 1, @i = 1, @c = 0

 WHILE @j <= @s2_len
  SELECT @cv1 = @cv1 + CAST(@j AS binary(2)), @j = @j + 1

 WHILE @i <= @s1_len
 BEGIN
  SELECT
   @s1_char = SUBSTRING(@s1, @i, 1),
   @c = @i,
   @cv0 = CAST(@i AS binary(2)),
   @j = 1

  WHILE @j <= @s2_len
  BEGIN
   SET @c = @c + 1
   SET @c_temp = CAST(SUBSTRING(@cv1, @j+@j-1, 2) AS int) +
    CASE WHEN @s1_char = SUBSTRING(@s2, @j, 1) THEN 0 ELSE 1 END
   IF @c > @c_temp SET @c = @c_temp
   SET @c_temp = CAST(SUBSTRING(@cv1, @j+@j+1, 2) AS int)+1
   IF @c > @c_temp SET @c = @c_temp
   SELECT @cv0 = @cv0 + CAST(@c AS binary(2)), @j = @j + 1
 END

 SELECT @cv1 = @cv0, @i = @i + 1
 END

 RETURN @c
END

Select all Open in new window

How do I convert this so it reads a column of values pseudo code example:

DECLARE @TableCOLUMN VARCHAR(200);
 

SET @TableCOLUMN='ContainerID';

with cte AS; (select TrackingID
from table 1
where var1 = 'ASDF1234' and var2 ='LKJH9786')

-- This Returns a Single TrackingID.

select * dbo.edit_distance(CTE, @COLUMN) any values in the column 'ContainerID' that have distance of more than 2 as compared with CTE.


I hope this makes sense.


Any assistance is welcome.

Thank you

Debugging UWP code.
following this guide to develop a slide show.
https://www.c-sharpcorner.com/UploadFile/5439e6/image-slideshow-using-dispatchtimer-in-windows-store-apps/

the MainPage.xaml

<Page

    x:Class="TimerInWindowsStoreApps.ImageSlideShow"

    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

    xmlns:local="using:TimerInWindowsStoreApps"

    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"

    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"

    mc:Ignorable="d">



    <Grid x:Name="LayoutRoot" Background="LightBlue">

        <Grid Margin="0,50">

            <Grid.RowDefinitions>

                <RowDefinition Height="410"/>

                <RowDefinition Height="*"/>

            </Grid.RowDefinitions>

            <StackPanel Grid.Row="0">

                <Border BorderBrush="Black" Grid.Row="0" BorderThickness="1" Width="700">

                    <Image x:Name="ImageSource" AutomationProperties.Name="ImageSource" VerticalAlignment="Top" Stretch="Fill" Height="380" Width="700">

                    </Image>

                </Border>

            </StackPanel>

            <Grid x:Name="Input" Grid.Row="1" Margin="0,10,0,0" VerticalAlignment="Top" HorizontalAlignment="Center">

                <StackPanel Orientation="Horizontal">

                    <Button x:Name="playSlideshow" Grid.Row="1"  Margin="0,0,10,0" 

Select all Open in new window

…

Hi EE,

I have the following query that shows the status of queries running on my SQL Server.

SELECT
	r.session_id
,	r.start_time
,	TotalElapsedTime_ms = r.total_elapsed_time
,	r.[status]
,	r.command
,	DatabaseName = DB_Name(r.database_id)
,	r.wait_type
,	r.last_wait_type
,	r.wait_resource
,	r.cpu_time
,	r.reads
,	r.writes
,	r.logical_reads
,	t.[text] AS [executing batch]
,	SUBSTRING(
				t.[text], r.statement_start_offset / 2, 
				(	CASE WHEN r.statement_end_offset = -1 THEN DATALENGTH (t.[text]) 
						 ELSE r.statement_end_offset 
					END - r.statement_start_offset ) / 2 
			 ) AS [executing statement] 
,	p.query_plan
FROM
	sys.dm_exec_requests r
CROSS APPLY
	sys.dm_exec_sql_text(r.sql_handle) AS t
CROSS APPLY	
	sys.dm_exec_query_plan(r.plan_handle) AS p
ORDER BY 
	r.total_elapsed_time DESC;

Select all Open in new window

Under executing batch I get the following text:

(@P1 varchar(11),@P2 varchar(1))select  distinct o.order_id, o.enddate, lb.value lookback, hb.billinv_id hasbilling   from ordcalc oc   inner join ordcalc pri on (pri.order_id = @P1 )   inner join orders prio on (pri.order_id = prio.order_id)   inner join orders o on (oc.order_id = o.order_id and prio.client_id = o.client_id)   inner join funddept fd on (o.funder_id = fd.funder_id and o.dept_id = fd.dept_id and fd.invformat = 'COMBOSTAT')   inner join funderrefs fr on (o.funder_id = fr.funder_id and fr.name = 'Combine Invoice Code' and fr.textval = isnull(@P2, fr.textval))   outer apply (select XMLData.value('data(/PropBag/Prop[@Name = "Lookback Period"]/@Value)[1]', 'varchar(200)') value   from (   select convert(xml, REFDATA) as XmlData from funderrefs   where NAME = 'Combo Statement Settings'   and funder_id = o.funder_id   ) as t1) as lb   outer apply (select top 1 billinv_id from billinv bi where   o.client_id=bi.client_id and o.order_id=bi.order_id and bi.invoutamt > 0 ) as hb   

Select all Open in new window

For the parameters @P1 and @P2 how do I determine what stored procedure this came from?

Any assistance is appreciated.

Thank you.

Hi everyone,
So, I need to find out a couple things about Visual Studio. I thought it was included in the SQL Server install. But I'm not sure.
On my computer, Visual Studio 2008 is installed and I think it came with SQL SSMS 2008. In Control Panel, All SSMS components were installed on 8/3/2015, Same date shows for Visual Studio. So it appears Visual Studio was part of the SSMS 2008 installation.
So, I just now installed SSMS 2017 on a different computer. And there is NO Visual Studio. There are Visual Studio Tools, Shell, etc., but no actual standalone program.
So, how does Visual Studio get installed now? Do I have to buy an individual copy? I'm OK with that, I just want to know.
Anyone know about this?
Thanks,
...Dave

I need to be a quick study in Docker

I am trying to digest Azure, Containers, Docker, Kubernetes, etc.

and quickly.

I am rebuilding my Mac OS environment to contain:

- a Windows 10 VM on Parallels
- a LINUX VM on Parallels
- Visual Studio 2019 Community Edition
- access to Azure Cloud

So, My first hands on practice could be to learn about Docker.

What kind of work-along tutorial can you suggest?  Or video training?

Thanks