Search:

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

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

nvm - just needed to make a SUB NEW() of my own - moving along now!

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

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