Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by denimined

  1. denimined

    Search and Rescue

    Just 3 questions. Question 1 Question 2 Question 3
  2. denimined

    Windows Form with Variable number of Fields

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

    Windows Form with Variable number of Fields

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

    VB6 merge of PDF files.

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

    ADODB Filter with Date

    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?
  6. denimined

    VB6 merge of PDF files.

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

    Pivot action to put sub-rows as multiple column fields.

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

    Pivot action to put sub-rows as multiple column fields.

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

    Running total aggregate column

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

    Search Query Construct-

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

    PCL to ZPL converter (Android)

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

    Qualified minimum.

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

    Qualified minimum.

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

    Qualified minimum.

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

    Qualified minimum.

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

Part and Inventory Search

Back
Top