Search:

Of course we are... 'cause 'Merica!

-tg

Currently using the "-- Select --" not as a prompt, but because there are 3 choices in the dropdown, but 4 possible values - the three that are there and "NULL" ... by setting it to the select...

and for the most part, they are. I bought a collector's item a while back, I still had to go through a FFL and fill out forms to pick it up.
Problem 1 - there's still the illegal gun sales that...

Exactly ... I used to have the same issue ... then I came across an article breaking down the advantages of NULL ... and how it means "Unknown" ... I wish I still had a copy of it.

-tg

I keep hearing that, but I've yet to see anyone define what "stricter laws" that are needed. The problem is that by "stricter" people mean "close loopholes" which leads to the crap restrictions that...

I do not ... but the statement still stands that invoking the click event programatically (as the .Value = True does ... which I forgot about) breaks the error handling chain ... rightfully so ......

Yeah, when you don't have control over the db then it sucks. I'm using Hibernate and JPAs for dataaccess so I don't have control over the generated SQL. If there is no difference between a null and...

If you're going to do that, then just make the field non-nullable and default to an empty string.

Otherwise it's null for a reason, and nulls can be different from an empty string.

But I agree...

Honestly I don't think there's much, other than having get/let/set would make refactoring a bit easier later (somehting needs to change to read-only, for instance; or if you need to do somehting when...

Here in SC they recently enacted open permit cary ... Which means you can now legally open cary as long as you have a conceal cary permit. They stopped just short of constitutional cary (which means...

IT works this way because Command2_Click is being called as a method ... not as a result of an event. If there was a way to programmatically click the button (in .net it would be...

no, no, no ... that's how you know it's the original ... see once you rotate it, it becomes a derivative work... and could be yet another NFT, but since it's derived from the original, not worth as...

It still isn't quite the strangest thing I've seen. Another time, another product, code wouldn't work until someone added:


Dim x as Integer
x = 1


After those two instances, not much...

Cleanup on aisle 12!
Can you please re-post that code but with
tags around it? That's preserve the indenting of the code making it easier to read. It'll look like a river of code than a cliff of...

More likely it was this: "data form" and "ms access database" ...

That said, if I remember right "3426" is a generic SQL Error ... there's a way to get to the extended exception to get details on...

That's why I said "sometimes" ... I've gotten into situations where it drastically changed how something worked (or not) and so have stoped relying on them as a litmus test and use debug prints now. ...

MessageBoxes can and will alter the flow sometimes. Better to use Debug Print statements to get a true idea of how things are flowing.


-tg

Only when I had Break on All Errors turned on... or when I thought something was handled, and it wasn't.

-tg

Really? Still surprised? After all this time? :/

-tg

Of course it's not an odd request... nor is it too much ... I just happen to know about defi with out looking it up ... and in the interest of just moving things along I replied ...
Now I know...

defi - decentralized financing ... a crypto-based decentralized financing scheme
PancakeSwap - presumably a Crypto of some sort.

As for an API ... how you looked at the DeFi documentation?

-tg

Guess we'll see ... I didn't have to login for anytihng to get the CE ... but for 2019 I had to log into my MS Account just to download it.

BUt we'll see I guess, I've only had it installed for a...

Having recently installed the latest two versions... 19 & 22 .... I've only had to login to download VS2019 ... That's it. That's just for the download. Once installed, there was no logging in.

...

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