Search:

If it never prompts you for the key, then it's a cracked copy ... whether you use it or not is up to you. We're not in the position to tell you if it's safe or not.

And my wife wonders why I have...

We use Ci/CD here, but only to our development branch/environs ... releasing to test and users is still on a daily/weekly schedule....

-tg

Two updates in 5 hours ... you're a beast Wayne ...

Have you thought about going to a single release per day? I can't keep up...

-tg

Indeed... I never said anything about the code... I said to look at the "table structure" ... in the database ... it sounds like there are constraints on the fields to prevent them from being...

Look at the table structure. Can your fields even hold a NULL value - Are the Nullable? Or are they marked "Not-Null"? That maybe the source of the problem. You're potentially trying to stuff a NULL...

Wasn't part of the sample data there... but what about "ABC12345" or "ADBC12345a"? IT could be argued that there are 4 numbers in a row there ... Just something to keep in mind.

-=tg

How often will you have a CR or LF that's not a CRLF?

-tg

So, if I'm reading right... sometimes you want to remove the empty lines ... other times not ... Would an optional flag PreserveEmpty work? Default to false. False would include the...

You've returned the value into a string...


Dim TransSDD As String
...
TransSDD = Datarowview("Store")


DateProcessed isn't an index, presumably it is a variable (it's what you used to...

I bet it's the DoEvents that's actually tripping things up.
Putting in loops & sleeps and doevents isn't solving the problem, nor is it going to help find the problem. All it's doing is altering...

See if this is any help - it's Excel, but the syntax should still be the same. There's a POST example a little way down.
https://codingislove.com/http-requests-excel-vba/

-tg

Try using MSXML2 and the XMLTTP object...



' Set myMSXML = New MSXML.XMLHTTPRequest

set myMSXML As New MSXML2.XMLHTTP

I'll admit it's been sometime since I've done VB6 ... but shouldn't this:


Set myMSXML = New MSXML.XMLHTTPRequest

be this:


Set myMSXML = New MSXML.XMLHTTPRequest()

Yeah, in this case, Wayne takes input from people, but ultimately he gets to decide if something goes in or not, and if so, how. But, it is good to get some input from others based on how they might...

Does that include comments? Or only executable lines (which makes sense)?

-tg

If I recall correctly, there's an option burried deep in the SSMS somewhere ... a checkbox ... it's been too long since I've gone looking for it to remember off hand where it's at. I'll see about...

yeah, admitedly I almost never use int or long, but Int/Integer or Long ... And I can't think I've ever gone with a string, it's always String.
I wouldn't be surprised if it's maybe leftover...

It's all about organization and not duplicating code needlessly. So if you have a sub or funciton that is used by more than one form... stick it in a class or module (which ever is appropriate). If...

Sometimes I just need a simple int for a counter. Other times I plan to do more with it... that's when I go for the Integer. That said, something that's a pain is if a method wants an Integer, I...

Yeah, your sub takes three parameters, but you only supplied two when calling it. Also it's a SUB, not a function so it's not going to retutn anything, so your 'total =' when you call it will do...

That's what the sender object is on event handlers... the object that raised the event.

-tg

Put your hands on your hips...

-tg

I've heard of people doing that on Feb 29 every time it comes around.
For me on New Years... it comes right at midnight doing The Time Warp.


-tg

Here's my contribution:
http://www.vbforums.com/showthread.php?t=585094

-tg

Point of order... If Jan 1 (New Years) is on Friday, Monday would be the 4th... and a valid first work day of the month...

-tg

Depends... what it full then emptied? Or was it empty then filled?

If a hole is filled, is it really a hole any more?

-tg

Also, you may want to print out, or use a MessageBox to display what your ModulesNumber is before you start the loop. If it's 0, it'll never execute the loop, and never read from the reader... which...

This doesn't make sense:


For IVar = 1 To My.Settings.ModulesNumber
dreader.Read()
Next


You're looping to a number, and reading from the reader ......

1) Rechner is set to 0... and never changes
2) case var expression when Rechner <= 100001: doesn't look right to me ... case when Rechner <= 100001: should be right.
3) But Rechner is always 0, so...

When you call it initially, the InvokeRequired will be set to true... so it drops into the Me.TextBox1.Invoke line ... which then calls the method on the UI tread... so yes, it's recursive... but on...

South Carolina did the same thing. I think it was an extra 10% for hybrids and an extra 30% for full electrics.

-tg

Here the monies generated by the lottery really do go towards education. By law, by design, that's all it can be used for. A majority of it goes towards scholarships. $500 just for going to college....

I've left FB for the most part. Lately been only using it to keep track of some hobby groups and that's it. I don't interact with anyone's posts or even make any. I removed all bookmarks for it...

How's that "war on drugs" working out for ya? "Just say no", amirite?

-tg

Can't answer for other places, but here in South Carolina here's what's going on:
Cigarettes as far as I know are largely unaffected. What did get hit here were flavored vapes. Like Number Five......

The banning of flavored cigs wasn't supposed to included menthols ... the intent was to ban "designer" cigs that have flavors to them that attract teens. That was the intent at least ... the result...

something else to potentially be considerate of... Let's say you have an acronym that's "ABC" ... and it appears 6 times. You run it oince, and it changes the first ABC to A Better Control, there are...

Meanwhle this was posted in the VB6 area... not .NET ... so..... yeah.... gonna need you to fill out the TPS reports by the end of the day.... yeaaaahhh.....

-tg

FYI - this:


Shell Environ("COMSPEC") & " /c " & Chr(34) & "C:\Users\Administrator\Desktop\aegeg.bat" & Chr(34)


Can be written this way:


Shell Environ("COMSPEC") & " /c...

"" escapes it in the middle
""" escapes it on the ends. More specifically the "" (2) escapes its, then the final " (1) then ends the string. You can't have "" (2) on the end... that would keep the...