|
Updated system, cleaned system, rebooted, installed Enterprise trial.
Open a WinForm app that's doing fine in VS 2017:
1. fonts and window settings changed; line numbers showing.
2. I click on a tab for a WinForm code view and VS 2019 hangs; unable to close it without using the Task Manager to kill the process.
3. repeat starting VS 2019: try to build, try to open a design view, etc, : VS 2019 hangs as in #2.
«Where is the Life we have lost in living? Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information?» T. S. Elliot
|
|
|
|
|
While I had no problem with VS2019 for the last 3 weeks (starting with RC1), I am dismayed to learn that.
And curious as to how it will (likely) improve (over some time...)...
|
|
|
|
|
That's a bitch, I just fired it up, the web api (core 2) works fine ant the wpf app runs perfectly. I'm about to adventure into Razor pages with core 2.2
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Mycroft Holmes wrote: I'm about to adventure into Razor pages with core 2.2
I tried that twice, and it ain't ready for prime time. I predict that you'll decide that your adventure was a huge waste of time.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
#realJSOP wrote: a huge waste of time
It won't be the first time 
As this is unlikely to go to production any time soon Razor may have matured by then.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
You have my thanks for being a factor in making the decision whether I should move to VS2019 or not. 
|
|
|
|
|
It looks like MS is finally taking proactive steps to get people to stop developing winforms apps.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
What's wrong with WinForms? They are great if you need to build a quick utility. I like WPF if i'm working on a large project, but WinForms are just too quick & easy.
|
|
|
|
|
83. Support church melody (5)
|
|
|
|
|
|
yup
|
|
|
|
|
Hmmmm,
If this became a drive-through service you could serve 240 customers per day. 
Best Wishes,
-David Delaune
|
|
|
|
|
Yeah, but wouldn't be worth it for ten yup 's an hour...
|
|
|
|
|
|
|
Ya
|
|
|
|
|
Car on wheels does this (5)
|
|
|
|
|
|
ya
modified 5-Apr-19 1:01am.
|
|
|
|
|
Hi all. I have two tables in access (VB6): SupplierInvoices & Sales. They both have 3 common field names: Date, Code & Qty. I need to query both tables via SQL query by a specific date range as follows (I know this is wrong, but just to give you an idea):
rs.Open "Select distinct format(SupplierInvoices.Date, 'dd-MMM-yyyy') as tDate, Sum(SupplierInvoices.QTY) as tTotal from SupplierInvoices, format(Sales.Date, 'dd-MMM-yyyy') as sDate, Sum(Sales.QTY) as sTotal from Sales where PLU = '" & lblPLU.Caption & "' and Date Between #" & StartTime & "# and #" & EndTime & "# Group by format(SupplierInvoices.Date, 'dd-MMM-yyyy');", cn, adOpenKeyset, adLockOptimistic
The result needs to return from both tables the sum of the qty fields for that date range. I can't get it right! Please help.
modified 5-Apr-19 0:46am.
|
|
|
|
|
|
|
I don't have any experience with Access, but from what I know from SQL server, I think when you have group by you are allowed to have in the select the aggregate and the group by field. The problem is that you have a group by from one of the tables and put other fields in the select. I think you have to use Union and get it in separate set of rows. And from that set you can try to select in an outer select. Not sure if this is possible in Access.
modified 20-Oct-19 21:02pm.
|
|
|
|
|
I have tried this but get Group by error:
rs2.Open "Select distinct format(SupplierInvoices.Date, 'dd-MMM-yyyy') as tDate, Sum(SupplierInvoices.QTY) as lTotal from SupplierInvoices where PLU = '" & lblPLU.Caption & "' and Date Between #" & StartTime & "# and #" & EndTime & "# Union Select distinct format(Sales.Date, 'dd-MMM-yyyy') as tDate, Sum(Sales.QTY) as sTotal from Sales where PLU = '" & lblPLU.Caption & "' and Date Between #" & StartTime & "# and #" & EndTime & "#;", cn, adOpenKeyset, adLockOptimistic
|
|
|
|
|
I mean something like:
select SupplierInvoices.Date as tDate, Sum(SupplierInvoices.QTY) as lTotal, 'supplier' as tablename
group by tdate,tablename
Union
select other table same thing
I can't test it, but I would try something like that
modified 20-Oct-19 21:02pm.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
