Search:

Type: Posts; User: szlamany

Page 1 of 13 1 2 3 4

Search: Search took 4.34 seconds.

  1. Thread: Post Race!

    by szlamany
    Replies
    65,197
    Views
    6,845,319

    Re: Post Race!

    All business in the front, party in the back!
  2. Thread: LINQ question

    by szlamany
    Replies
    9
    Views
    277

    VS 2017 Re: LINQ question

    @jmc - thanks - that explains it nicely. LINQ is no longer in the realm of "regex" to me!
  3. Replies
    37
    Views
    2,270

    Re: Can't Find SQL Server-REVIVED

    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...
  4. Thread: LINQ question

    by szlamany
    Replies
    9
    Views
    277

    VS 2017 Re: LINQ question

    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...
  5. Thread: LINQ question

    by szlamany
    Replies
    9
    Views
    277

    VS 2017 Re: LINQ question

    @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?
  6. Thread: LINQ question

    by szlamany
    Replies
    9
    Views
    277

    VS 2017 LINQ question

    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 {
    ...
  7. Replies
    40
    Views
    1,091

    Re: Very complicated but perhaps possible!

    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...
  8. Replies
    40
    Views
    1,091

    Re: Very complicated but perhaps possible!

    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...
  9. Replies
    40
    Views
    1,091

    Re: Very complicated but perhaps possible!

    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...
  10. Re: Constraint within primary key - sql server database

    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...
  11. Re: Constraint within primary key - sql server database

    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...
  12. Re: Constraint within primary key - sql server database

    @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...
  13. Re: Constraint within primary key - sql server database

    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...
  14. Replies
    9
    Views
    312

    Re: let's give our support

    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...
  15. Re: Constraint within primary key - sql server database

    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...
  16. Replies
    11
    Views
    378

    Re: Woozle Effect in Programming?

    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...
  17. Replies
    11
    Views
    378

    Re: Woozle Effect in Programming?

    Or maybe it is a woozle!
  18. Replies
    11
    Views
    378

    Re: Woozle Effect in Programming?

    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.
    ...
  19. Re: Do you all worry about obfuscating a password in an AJAX POSt over SSL?

    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...
  20. Replies
    9
    Views
    524

    Re: Offline Support for Database Operations

    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...
  21. Looking for good, free INDEX.HTML templates that have SEO capability

    Anyone know of a good source for free INDEX.HTML templates that have nice boilerplate SEO capability?

    TIA!

    Steve
  22. Re: Possible to create report/spreadsheet by injecting data into a LibreOffice templa

    @dil - was that directed at me? All that heading and sub heading and page control is handled nicely in my API...
  23. Re: Possible to create report/spreadsheet by injecting data into a LibreOffice templa

    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...
  24. Re: What are the states of Android App lifecycle ?

    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...
  25. Replies
    43
    Views
    1,864

    Re: Getting a new machine

    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"...
  26. Replies
    43
    Views
    1,864

    Re: Getting a new machine

    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.
  27. Replies
    43
    Views
    1,864

    Re: Getting a new machine

    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...
  28. Replies
    6
    Views
    371

    VS 2019 Re: TD Ameritrade API

    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...
  29. Replies
    6
    Views
    371

    VS 2019 Re: TD Ameritrade API

    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?
  30. VS 2012 Re: [RESOLVED] Want to hijack a SqlDataReader class so it can be sourced from multipl

    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...
  31. VS 2012 Re: [RESOLVED] Want to hijack a SqlDataReader class so it can be sourced from multipl

    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...
  32. VS 2012 Re: [RESOLVED] Want to hijack a SqlDataReader class so it can be sourced from multipl

    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...
  33. Thread: Post Race!

    by szlamany
    Replies
    65,197
    Views
    6,845,319

    Re: Post Race!

    I'm not sure I'm proud to be in the top 20 - I'll never get that time back again, lol!
  34. VS 2012 Re: [RESOLVED] Want to hijack a SqlDataReader class so it can be sourced from multipl

    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 -...
  35. VS 2012 Re: [RESOLVED] Want to hijack a SqlDataReader class so it can be sourced from multipl

    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...
  36. VS 2012 Re: [RESOLVED] Want to hijack a SqlDataReader class so it can be sourced from multipl

    @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...
  37. Thread: Post Race!

    by szlamany
    Replies
    65,197
    Views
    6,845,319

    Re: Post Race!

    @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...
  38. Thread: Post Race!

    by szlamany
    Replies
    65,197
    Views
    6,845,319

    Re: Post Race!

    "Holy Heisenberg" Batman!

    Now we got Schrodinger's Crayfish!

    That's for certain! Or not?
  39. VS 2012 Re: [RESOLVED] Want to hijack a SqlDataReader class so it can be sourced from multipl

    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...
  40. VS 2012 Re: [RESOLVED] Want to hijack a SqlDataReader class so it can be sourced from multipl

    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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width