Search:

@jmc - thank you so much - I'll dig into DbDataReader tomorrow AM!

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...

The "..." indicates lots of code - I picked a bad spot to cut code out, lol!

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.

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!

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

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,...

True dat!

Shaggy after an all night bender!

I'm starting to understand the phrase "back in the day" much better!

Could you please move it? Thanks!

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

https://getyarn.io/yarn-clip/059c29a9-452a-44cc-accc-0454314611a3

Do we have a code bank for jQuery?

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...

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!

@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...

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

Here is the result string in that errorMessage() popup function.

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...

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?)

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...

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

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...

@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...

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?

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...

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

@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...

@lord orwell

Not the Surface Pro X (which is ARM). Looking at a Surface Pro 7...

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...

@dragokas, I've asked everyone that same question so far. Taking an impartial poll.

@dragokas - I see this is open source. Does you have commercial clients that pay a fee for use?

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...

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...

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...

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.

Show me what you are trying to do with data

You are very welcome!

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...

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?