Search:

@Shaggy - thanks for this info - I'll see if I can make some kind of connection to a license program like that. I am doing this for a project I'm working on myself.

I've unfortunately come across the need to use TDE encryption on three databases, and that requires me to purchase MS SQL Standard edition.

Anyone with experience on a good place to make a...

You do realize that my post had ZERO to do with databases.

It was about syntax constructs and what is allowed in the way of a neat and useful exploitation of an existing class to do something...

I'm just a developer - never put a LANGUAGE in front of myself.

I'm helping a client (from a project management perspective) on a two-year implementation of an Enterprise system written 40+ years...

I've only ever used Interitance this one time and it supported a requirement to not touch decade old report writer logic. This was an incredible win for me - we were able to release an update to...

This code:


Do While rsPrint.State <> 0
Do While booGotRS ' rsPrint.EOF = False
booOnPage = True
For i = 0 To rsPrint.Fields.Count - 1
...

Simple - I was wondering if in VB6, is there even syntax to allow you to "Inherit" an existing class - such as a SqlDataReader, and in the code, OVERRIDE just some functions?

I know how to do that...

My Italian half is great grandparents that came from Sicily late 1800's.

And then my Italian grandfather that married into that family, he came from Calabria around 1905.

Both regions are...

Is the following VB .Net code just a library in action? Or are the required "language constructs" needed to accomplish this a .Net only thing?

Do all libraries allow for you to "inherit" such as...

Good on you for even engaging these leftists - I bowed out several years ago!

Being a constitutional conservative in the USA has become a problem and those outside the country love to criticize us...

I finally stumbled upon that old post from Mendhak, over 16 years ago, saying I was missing "the beauty of ASP.NET and the web"!

Wow how times have change - that old VB6 program that gave me a...

I use code like this - written many years ago...lots of stuff in the way, but the bottom line communication code is shown.


Private Function SendReader(cqMS As MemoryStream, ByRef...

You will need a way to communicate with the service app. Many ways to accomplish, I'm sure...

I've used HTTP listeners to communicate between service apps and UI apps.

You could go primitive...

Wow - I totally misunderstood this question.

You did not mean dinner and a movie. Right? Granted this is a programmer forum, and I do not judge!

How I use Closure - this is JS, but concept is the same.

Simple example:

Here I am calling a function that will open an EDIT window in the browser.

It allows you to edit the "report...

Notice the stray "2" in the upper right corner of this comic by Bizarro. He started adding this number so people would know how many "hidden symbols" to looks for.

The "eyeball" is easy to find -...

My Great Blue Heron chases away our Egrets - eats whatever it wants!


https://youtu.be/xBqk6OcZYDM

Cities get "incorporated" in CT - not sure that works in each state government the same way.

Most of the time, "counties" contain "cities" - in the case of New York City, is contains "five...

Not sure if this will be of any assistance...

App I wrote a while ago had 4 services running listening on HTTPListener's - that's besides the point.

For transmitting data, I created a CLASS,...

I'm interested in implementing Azure AD authentication to my web app.

https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/auth-saml

Anyone doing with with IIS on the backend?
...

Basic

My backend webservices most likely do not conform fully to REST protocols

https://www.ics.uci.edu/~fielding/pubs/dissertation/rest_arch_style.htm

...but faking it works as well...


Option...

I'm busy for a few days, come back to check the Post Race and, wow, yikes - I got no words.

Let's move on, nothing to see here!

Random word of the day: Branch

Shaggy - at least you looked at the code!

Teaching people is not about telling them what not to do. It's about helping them navigate what they are trying to do!

fwiw...I am making progress.

I've decided to separate how to "determine" the print style to instead working on "print suggestion" logic. That work has to be done regardless.

Right now I'm...

btw - this is the source of the data - the SlickGrid in a browser window

I'm changing this logic to now take the grid of data and pass it back to the web server, where I've got a report writer engine that will render it into a PDF and deliver it to the client.

So far,...

This might seem like a web post at first - it is not.

Currently I use a SlickGrid in my web apps and when my users go to print these grids, I render the grid content into an HTML TABLE, and drop...

That's nuts! Who would have done that? We need a penetration test! I feel violated!

Seems it might have been VisualAd - it's odd what memories I have in this head of mine...

https://www.vbforums.com/showthread.php?551070-Christmas-Avatar&p=3406194&viewfull=1#post3406194

In my opinion, maintainability is very important in all my queries - client support goes on for decades and enhancements always come down the pike.

If you want to limit the JOIN'd rows, the...

You found me - yup - can't seem to flee! It's my safe space - I just have to remember to keep out of the political threads!

I just realized you have a c-clamp in your avatar, lol!

Put a sock on it!

Needing to see "detail orders" but based on "total quantity", might help in how they will fulfill said orders. Unique requirement for sure.

If I was doing this - I would usually be in a SPROC anyway, and I would build a TEMP TABLE with ITEM and COLOR and the TOTAL QUANTITY as the three fields. Build that in advance and then JOIN to it. ...

@Zvoni - so his query is correct - he needs the "detail rows" NOT GROUPED BY - they need to be in detail, but sorted by the total quantity for that ITEM/STYLE. Not even including the ID in the join...

GROUP BY is the simple, old school syntax, for reducing rows by a column(s) and using aggregate functions like SUM() and MAX()


Select id,item,color, sum(qty) "totalqty" from mytable a group by...

Not my server - not my IT department unfortunately...

My web app was denying logins - LOG disk on the server was full. I found an old 6GB backup of something - deleted it, just to allow logins -...

I just had to use this command to shrink a 350 GB log file!


BACKUP LOG Acctfiles TO DISK='NUL:'

DBCC SHRINKFILE ( Acctfiles_Log, 1)


NUL: - a null device. I feel like I'm back in my...

It is not a C# only world - classes have constructors.

In VB - it's a SUB NEW().

And you can have several - with different signatures. And then be able to create your class in a variety of...