Search:

Type: Posts; User: szlamany

Page 1 of 13 1 2 3 4

Search: Search took 1.68 seconds.

  1. 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!
  2. 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...
  3. 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!
  4. 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.
  5. 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!
  6. VS 2012 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
  7. 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,...
  8. Thread: Post Race!

    by szlamany
    Replies
    65,079
    Views
    6,543,236

    Re: Post Race!

    True dat!
  9. Thread: Post Race!

    by szlamany
    Replies
    65,079
    Views
    6,543,236

    Re: Post Race!

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

    by szlamany
    Replies
    65,079
    Views
    6,543,236

    Re: Post Race!

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

    Re: jQuery .each() on a regular array

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

    by szlamany
    Replies
    14
    Views
    280

    Re: Lupin ?

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

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

    Re: jQuery .each() on a regular array

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

    by szlamany
    Replies
    65,079
    Views
    6,543,236

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

    by szlamany
    Replies
    65,079
    Views
    6,543,236

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

    by szlamany
    Replies
    65,079
    Views
    6,543,236

    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...
  17. Replies
    6
    Views
    173

    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...
  18. Replies
    6
    Views
    173

    Re: jQuery .each() on a regular array

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

    [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...
  20. 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?)
  21. 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...
  22. Replies
    31
    Views
    769

    Re: Getting a new machine

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

    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...
  24. Replies
    31
    Views
    769

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

    by szlamany
    Replies
    65,079
    Views
    6,543,236

    Re: Post Race!

    The actual worse part is when I found out that the insurance carrier was able to negotiate it down to just $1 million. What is the real cost of care?
  26. Replies
    31
    Views
    769

    Re: Getting a new machine

    I had an actual server - that's been turned off for years.

    I had a desktop for doing video editing with specialized board and all. That machine died a slow death.

    I have a Windows 7 big old...
  27. Thread: Post Race!

    by szlamany
    Replies
    65,079
    Views
    6,543,236

    Re: Post Race!

    One of my clients is a health insurance provider. They recently got a $20 million dollar claim on a patient.
  28. Replies
    31
    Views
    769

    Re: Getting a new machine

    @dil - thanks for the counter points. Always makes it easier to plot a course when all options brought up. The MS SP series has nice docking stations to make lots of those issues go away. One of...
  29. Replies
    31
    Views
    769

    Re: Getting a new machine

    @lord orwell

    Not the Surface Pro X (which is ARM). Looking at a Surface Pro 7...
  30. Replies
    31
    Views
    769

    Getting a new machine

    I'm thinking of getting a new machine and was consider a MS Surface Pro.

    I have had a Surface Pro 2 for a long, long time - been a great machine.

    Am I nuts to consider this in today's hardware...
  31. Re: Getting the ball rolling. Which VB6 projects are you working on?

    @dragokas, I've asked everyone that same question so far. Taking an impartial poll.
  32. Re: Getting the ball rolling. Which VB6 projects are you working on?

    @dragokas - I see this is open source. Does you have commercial clients that pay a fee for use?
  33. Replies
    46
    Views
    1,006

    Re: join three tables to get Sum

    Pay attention to my queries more carefully. The UNION ALL query is simply putting your fields into different columns - NO SUM() in that part of the query.

    The SUM() happens in the SELECT from...
  34. Replies
    46
    Views
    1,006

    Re: join three tables to get Sum

    You must name the FIELDS in the FIRST select of a UNION ALL - sorry that I did not make that clear.

    You moved my name to the second select - that broke it. Plus I simply named it "Recette" - if...
  35. Replies
    46
    Views
    1,006

    Re: join three tables to get Sum

    Try this instead



    Select PersonID, Tarif, Cast(0 as money) "Recette", MyDate from MTbl
    Union All
    Select PersonID, Cast(0 as money), Recette, MyDate from Act_Tbl

    Which will allow you to do...
  36. Replies
    46
    Views
    1,006

    Re: join three tables to get Sum

    I believe what you are trying to tell me, is that, if there are two or more on the same DATE for a PersonID, you want the SUM that activity.

    Please confirm this.
  37. Replies
    46
    Views
    1,006

    Re: join three tables to get Sum

    Show me what you are trying to do with data
  38. Replies
    46
    Views
    1,006

    Re: join three tables to get Sum

    You are very welcome!
  39. Replies
    46
    Views
    1,006

    Re: join three tables to get Sum

    That is achieved with a different method.

    What you are showing me now is that MTbl and Act_tbl are treated the same. The Tarif value and Recette values are simply added up for a date.

    That is...
  40. Replies
    46
    Views
    1,006

    Re: join three tables to get Sum

    Does the date that you are selecting only exist one time in MTbl?

    If it does not exist, do you want to show that PersonID at all?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width