Recent content by denimined

Just 3 questions. Question 1 Question 2 Question 3

Crud - sorry. I thought I was in the VB6 forum. Basically the same idea, but in .NET you do not have control arrays so you have to generated unique names for each of the new controls. Also, you need to define the address of the handler for the control. There's an example here...

You use the Load function to instantiate new controls - usually into a control array. (VB6) Once instantiated, you can set things up on the control properties, just like any other control. (Note that control arrays start from index 0.) What we tend to do is define the controls for element 0...

And the solution is.... ... avoid the problem. We're going to go with - they create an image of their legal document and we'll add that at the end of the report generation - right before we send it off to be PDF generated. Problem solved. Er - avoided. Thx all.

I don't really know Oracle at all, but my first question is, on the format string - are the month and day field sizes simply restrictive or requirements? You have "MM/DD/YYYY" for the date string, but provided "5/5/2015" as the date string (instead of "05/05/2015"). Is it that simple?

Hi there. Our existing software produces reports that can be e-mailed on to customers, managers, etc. We have a client that wants to attach their own (legal) document whenever a document is e-mailed out. When e-mailed, our program already writes out a PDF that can then be attached to the...

OK. I'm pretty sure PIVOT is a wild goose chase. Any other suggestions? [OVER?]

Yes. I know. This is incredibly dumb, but a user is a user is a user. Given master products composed of 1-n sub-products, want a report where the single line for the master product contains up to 5 of the composite sub-products on that line. e.g. sub-products leg seat back top master product...

Given a table of entities with an identifier, a bunch of attributes and a measure. Identifier of: ID Attributes of: Shape, Size, Color And then the measure of: Weight One entry in the table is one entity. e.g. ID:35697 Shape:Round Size:10 Color:Blue Weight:12.345 From a table of 50,000...

Best Sellers: BS Orders: Ord Select BS.* from BS left join Ord on Ord.ISBN = BS.ISBN where Ord.ISBN is null

We're looking for a way print to a ZPL based barcode printer using an Android device using a standard PCL5 driver. Does anyone have any suggestions / thoughts / products? Thx.

George - Here is the connection in VB. It is just the user selected UDL file name. Public cnnp As New ADODB.Connection 'Global database connection object cnnp.ConnectionString = "File Name=" & cpRootPath & cmDataSource & ".UDL" The reference object is system\ado\msado25.tlb Is that what...

Got there the old school way. Given that Error is always < 100, went with: SELECT Key, Error - (FLOOR(Error / 100) * 100) AS Error FROM ( SELECT Key, MIN(Error + (PriorityLevel * 100)) AS Error FROM (<Ugly SQL code>) AS TBL GROUP BY Key ) AS TBL...

Well... Thanks and DRAT... Built it all up, tested it in Studio - everything was good. Put it into VB6 code and... Fall down, go boom. Turns out ADO doesn't know about WITH (or ROW_NUMBER or PARTITION BY). Any suggestions on doing this a different way? Since the content of the ugly SQL...

I have an inherited an incredibly ugly SQL statement INSERT INTO tmptbl (KEY, ERROR) SELECT KEY, MIN(ERROR) AS ERROR FROM (<incredibly ugly statement>) AS Q GROUP BY KEY that returns the lowest error state. Of course, there is now a new error check that needs to return, prior to other checks...