Search:
Type: Posts; User: szlamany
Search:
Search took 4.34 seconds.
-
All business in the front, party in the back!
-
@jmc - thanks - that explains it nicely. LINQ is no longer in the realm of "regex" to me!
-
If you have multiple instances of SQL on some of these servers, then "locally" they are immediately found, but "remotely" they are listening on dynamically assigned ports unless you specifically bind...
-
I'm attempting to learn a little LINQ. And do it with a simple structure.
So far what I dislike about the LINQ syntax is how bloated it is compared to hiding a loop on that list in a function...
-
@dday - thanks for that.
I might put more items in the list - it might not be just two.
Is there also a LINQ attack that would get to the "row" of data?
-
I'm a LINQ newbie...seen lots of code examples here but have no clue how to do it.
Let's say I've got this list(of string)...
BookAbbrList = New List(Of List(Of String)) From {
...
-
Ok - hopefully you have some kind of query editor window that you can place this in and run it. I've got MS SQL and SQL Server Management Studio to play with here.
The example queries below build...
-
What type of SQL are you using? MS SQL? MySQL?
Do you dislike making VIEW's?
Are you comfortable working with sub-queries and deeply nested queries?
Answer those three questions for me...
-
This can be done with a single query - here are the "steps". I would do it in a SPROC, with a temp table or table variable so it's easier to read.
If that is not possible then each "step" either...
-
1980 - that was my first year coding - PDP-11 mini computers. We had a dozen schools in CT - East Windsor was one of them (I can't remember the IT directors name - yikes!). Driving my 1969 Chevelle...
-
Interesting for me as well, as that city in my matching home state of CT was a past client of mine as well! If you all went to HS in the 1990's I might have your data on some old PC somewhere in my...
-
@fd
Fill factors will get you better performance if page splits occur...
https://www.brentozar.com/archive/2013/04/five-things-about-fillfactor/
"In other words, if you set a 90% fillfactor...
-
In general,I dislike surrogate keys.
And I really like the use of CLUSTERED COMPOUND in this case, if these are "lines" of the "order" (which I'm guessing this is basically the business model we...
-
That was a great video - nice to see MS showing off like that.
I was never a big VB6 person - came late to the game, but isn't targeting multiple frameworks like that and specifying windows...
-
This definitely fits the bill for compound primary key with both those fields.
If you have an additional "business" requirement for the BOX to be contiguously sequential that could rest in the...
-
Lol! Didn't expect specific response on the Codd mention!
I'm old school mainframe guy from the 80's - we grew our own databases - creating whole paradigms for table relations. Tuning indexes was...
-
-
If you consider that Pooh is just a figment of Christopher Robins imagination, then what Pooh and Piglet made for tracks were woozling directed at him. He properly rejects it - always the teacher.
...
-
To kind of close this thread out. I use a GoDaddy server for my web hosting. I've added a web firewall "product" that GoDaddy offers and that product forces a re-direct to port 443. It is no...
-
Event Sourcing - there is a name for it...
I wrote an app back when pocket PC's were popular (about 6 months, lol!)...
I took an abbreviated form of the "data" onto the PPC. I kept a log of...
-
Anyone know of a good source for free INDEX.HTML templates that have nice boilerplate SEO capability?
TIA!
Steve
-
@dil - was that directed at me? All that heading and sub heading and page control is handled nicely in my API...
-
Would you use an API that returned a PDF looking like the attached (screen shot below - I got really close to what you asked for with little effort). Shown with % of gray-scale backgrounds - color...
-
That's an easy google search...
onCreate, onStart (onRestart if user navigated to), onResume, ACTIVITY RUNNING, onPause, onStop, onDestroy. You can see all these states in live action on your...
-
I know someone who broke a SP2 while using it on their lap, when the type cover decided to disconnect from the tablet unexpectedly. I like how sturdy the new SP7 to type cover "magnetic connection"...
-
I'm actually doing the same thing - I've got 3 different versions of SQL running on the SP2 - and I'm going to leave that as my database server.
-
180486
New MS Surface Pro 7+ on the right!
11th Gen Intel Core i7, 16 GB RAM, 256 GB, Platinum
So far I've installed VS 2012, VS 2017 and MS SQL 2016 Developers Edition!
Machine is super...
-
Seems that API uses tokens similar BirdDogHR - here is a class I recently wrote (still a bit in development - URL is hard coded, JSON cleanup for "viewing" is brute force)
Private Class...
-
I've done lots of API work - I can show sample code that is not related to Ameritrade if that would help.
Is there a token you need to get first, before making a data call? JSON or XML?
-
Yes - using older VS and sticking with older versions of .Net. I keep all my clients running the exact same backend code base and some of the web servers they are using can be quite old and...
-
With MyBase.,Close() compile gets this error - did I screw up earlier and hurt this code
Error 149 'MyBase' cannot be used with method 'Public MustOverride Sub Close()' because it is declared...
-
There is no BASE CLOSE method - I tried that in testing as well - MyBase.Close() does not exist to call...
And I did not call the DISPOSE from CLOSE - I was just testing test to see what it would...
-
I'm not sure I'm proud to be in the top 20 - I'll never get that time back again, lol!
-
And testing here has proven that out to be quite true!
All I need is just to OVERRIDE the CLOSE() - as shown below. MyBase.Dispose() or MyBase.Dispose(true) were both tried (at the bottom -...
-
This article is very clear
https://docs.microsoft.com/en-us/dotnet/standard/garbage-collection/implementing-dispose
and I am following the section titled "Implement the dispose pattern for a...
-
@jmc - thanks - that makes a whole lot more sense. I was fighting to OVERLOAD the DISPOSE method, when the base DISPOSE method was setup to call my OVERRIDES CLOSE method.
But to clarify - in...
-
@shaggy - one post-hurricane huge flood event, the good lord decided I needed someones old metal boat. It took a good beating getting as far as it did - I think the most likely spot it came from has...
-
"Holy Heisenberg" Batman!
Now we got Schrodinger's Crayfish!
That's for certain! Or not?
-
Shaggy - I know I marked this resolved - but quick question...
It made me use OVERLOADS because the base class had a Dispose() method. What would the base method know about what to dispose...
-
About to market my report writer as an API call. I'll support lots of different data transmission methods. I've got a "mark up" language that goes along with it, for Crystal Reports-like...
|
Click Here to Expand Forum to Full Width
|