Search results

Note that -n is not the same thing as licensed user count. It might be worth reviewing your type of user license, who is actually using it in which way (e.g., multiple sessions by the same person or on the same device), and the like. This might allow you to either raise -n and still be within...

True ... so Squirrel support? :)

Indeed, sounds like a call to support is indicated, provided the OP is on support. Further reason to do it a different way.

While this doesn't answer your question, I wonder why you would use a SQL query to do what a dump already does.

You might try showing the query and the table indices so that we have at least a little information to go on. One might also ask what use is a query that returns over 4 billion rows...

Scroll down, there are 4 jobs boards at the bottom.

Still no sponsor label under Tom's name ...

It is there for Rob and I.

No, I was only listing JSON as one of many ways to pass data. In order to make a recommendation of the preferable way to exchange the data, I would have to know more about your actual requirements. I might note that I tend to frown on passing temp-tables regardless. Better to encapsulate them...

For starters, I would recommend that you *not* do big complicated things in constructors. If they fail, you are left with a class that doesn't exist and the error handling is consequently more complicated. Better to initialize the class with a minimal constructor and then use an Initialize...

"Looks like" is not confidence inspiring. One should "know" what will happen.

It is very unclear what you are trying to do or expecting to happen. As Stefan said the USING statement has no function than to allow the use of an unqualified class name in the remaining body of the class. I.e., being able to reference just "base" instead of "ProcedureLibraries.base"...

Never have seen ads, but then I use AdBlock Plus.

Is it even Progress? Hard to imagine someone upgrading in 2020 from 4 to 9.

There are many different answers, depending. Is the time you have a string or a date-time datatype or what. Are you looking for seconds since midnight?

Or better a bcc.

Point being, based on the code you supplied, the error message is reasonable.

In your code, you never set yesno, so it will be false and so you will not have opened the stream.

Tom, what about the wisdom of writing in chunks vs using LOBs?

This is a plus for other uses of substitute as well, e.g., some kind of slice and dice where one could assemble pieces, but it would require additional logic to detect and handle unknown values.