Search:

Type: Posts; User: szlamany

Page 1 of 13 1 2 3 4

Search: Search took 3.71 seconds.

  1. Replies
    6
    Views
    171

    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...
  2. Replies
    6
    Views
    171

    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?
  3. 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...
  4. 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...
  5. 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...
  6. Thread: Post Race!

    by szlamany
    Replies
    65,109
    Views
    6,606,788

    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!
  7. 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 -...
  8. 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...
  9. 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...
  10. Thread: Post Race!

    by szlamany
    Replies
    65,109
    Views
    6,606,788

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

    by szlamany
    Replies
    65,109
    Views
    6,606,788

    Re: Post Race!

    "Holy Heisenberg" Batman!

    Now we got Schrodinger's Crayfish!

    That's for certain! Or not?
  12. 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...
  13. 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...
  14. VS 2012 Re: Want to hijack a SqlDataReader class so it can be sourced from multiple places

    Shaggy and JMC - thank you both! This is coming along very nicely!

    Is just calling the SQLDataReader .CLOSE method enough to clean up or are there any other disposal requirements?

    My...
  15. VS 2012 Re: Want to hijack a SqlDataReader class so it can be sourced from multiple places

    nvm - just needed to make a SUB NEW() of my own - moving along now!
  16. VS 2012 Re: Want to hijack a SqlDataReader class so it can be sourced from multiple places

    Ok - off to a slow start. Added a PUBLIC CLASS acsDataReader and much to my surprise when I typed INHERITS DbDataReader all of those METHODS and PROPERTIES appeared automatically. Nice job VS!
    ...
  17. VS 2012 Re: Want to hijack a SqlDataReader class so it can be sourced from multiple places

    @jmc - thank you so much - I'll dig into DbDataReader tomorrow AM!
  18. VS 2012 Re: Want to hijack a SqlDataReader class so it can be sourced from multiple places

    I read a row, then save the row, then advance to the next. Then see if we still have rows... That's a standard "report writer" engine trick to pre-evaluate break logic conditions.

    Like I said in...
  19. VS 2012 Re: What to hijack a SqlDataReader class so it can be sourced from multiple places

    The "..." indicates lots of code - I picked a bad spot to cut code out, lol!
  20. Re: Stored Procedure Stepping on Itself

    Sometimes inner errors cancel other transactions in ways we do not expect. Those two links that sapator gave go into the details - but it too general and hard to apply to your own use case, imo.
  21. VS 2012 Re: What to hijack a SqlDataReader class so it can be sourced from multiple places

    Seems IDataReader is missing .HasRows - oddly enough.

    Why can't I just hide the SqlDataReader in a class that I make has the methods and other stubs that I need?

    Way outside my wheelhouse here!
  22. VS 2012 [RESOLVED] Want to hijack a SqlDataReader class so it can be sourced from multiple places

    Ok - I'm using a simple SqlDataReader like this:


    Using rsPrint As SqlDataReader = cmd.ExecuteReader

    ReDim strRS(0 To rsPrint.FieldCount - 1, 0 To 2)
    .
    .
    .
    If rsPrint.HasRows Then
  23. Re: Stored Procedure Stepping on Itself

    Here is a wild guess.

    Are you running a SPROC from within this SPROC that is doing it's own BEGIN TRAN/COMMIT/ROLLBACK?

    Regardless, if you are getting this error about having no transaction,...
  24. Thread: Post Race!

    by szlamany
    Replies
    65,109
    Views
    6,606,788

    Re: Post Race!

    True dat!
  25. Thread: Post Race!

    by szlamany
    Replies
    65,109
    Views
    6,606,788

    Re: Post Race!

    Shaggy after an all night bender!
  26. Thread: Post Race!

    by szlamany
    Replies
    65,109
    Views
    6,606,788

    Re: Post Race!

    I'm starting to understand the phrase "back in the day" much better!
  27. Replies
    6
    Views
    187

    Re: jQuery .each() on a regular array

    Could you please move it? Thanks!
  28. Thread: Lupin ?

    by szlamany
    Replies
    14
    Views
    317

    Re: Lupin ?

    "We burn lupins, we even wear the bloody things!"

    https://getyarn.io/yarn-clip/059c29a9-452a-44cc-accc-0454314611a3
  29. Replies
    6
    Views
    187

    Re: jQuery .each() on a regular array

    Do we have a code bank for jQuery?
  30. Thread: Post Race!

    by szlamany
    Replies
    65,109
    Views
    6,606,788

    Re: Post Race!

    Yes - my back yard - thanks! About an hour out of NYC, if you can believe that! My father purchased this house 50 years ago, and I am keeping it in the family!

    About a mile upstream is a dam...
  31. Thread: Post Race!

    by szlamany
    Replies
    65,109
    Views
    6,606,788

    Re: Post Race!

    I've always wanted to put a Davinci bridge across this brook. Moved here from NYC in 72. Was a shock to say the least!
  32. Thread: Post Race!

    by szlamany
    Replies
    65,109
    Views
    6,606,788

    Re: Post Race!

    @funky lately I've found value in FB groups for things that interest me. I have a Camaro - so I'm in a Camaro group. We post pics of our cars, pick on Mustangs - really mature stuff!

    I live in...
  33. Replies
    6
    Views
    187

    Re: jQuery .each() on a regular array

    And here is what that "report writer syntax" produces for output, for those interested. Lots of text redacted...
  34. Replies
    6
    Views
    187

    Re: jQuery .each() on a regular array

    Here is the result string in that errorMessage() popup function.
  35. Replies
    6
    Views
    187

    [jQuery] .each() on a regular array

    jQuery is so powerful when you work the DOM - the methods available do so much, once you get fully versed in them.

    The .each() method is meant to work an array of "wrapped-elements" - DOM elements...
  36. Re: Need help with this complicated query

    I had that exact same post and then deleted it because it appears he wants to delete one at a time from the client (is that ADO?)
  37. Re: Stored Procedure Stepping on Itself

    Create a log table in your DB and write to that with an IDENTITY value key and a GETDATE() transaction date. You can log several of these in one call of the SPROC - get a GUID at the top of the...
  38. Replies
    31
    Views
    885

    Re: Getting a new machine

    @jmc- I'm going to get one from a client for kind of work in trade.
  39. Replies
    31
    Views
    885

    Re: Getting a new machine

    Thanks for the link.

    The 7+ is a nice machine - I think this one has all that I need

    11th Gen Intel Core i7, 16 GB RAM, 256 GB, Platinum/Black

    I'm going to explore options for getting my...
  40. Replies
    31
    Views
    885

    Re: Getting a new machine

    @dil - yup, there is a 6 that the 7 did not rise much above. And as JMC mentioned there is a 7+.

    As far as 6, 7 and 7+, it's all about the chip. I might not care so much about that, it might...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width