Search results for query: *

Just 3 questions. Question 1 Question 2 Question 3

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

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

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.

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

Sounds so simple. Probably is, but... How do I set the caption font color on a TabPage? Here is a description: I have a TabControl (System.Windows.Forms.TabControl) with multiple TabPage's. (System.Windows.Forms.TabPage) Each TabPage has its own name (Sales / Inventory / Production). On each...

Hi all. In the process of converting VB6 code to .NET, I have run into a date problem. What I want is the DATE value as a number. For example, in VB6 CLng(Now) [for today] returns 41262. [Tomorrow it will be 41263.] Any help would be greatly appreciated. Alternatively, is there a way to get...

I am looking for a replacement for sp_dboption for determining if a database is READONLY. Previously, sp_dboption '<database>', 'read only' would return an ON / OFF status. All the material that I have found so far talks about using ALTER DATABASE to actually change settings. I don't want to...

(This is a re-submission in hopes of getting an answer. [bigears]) I need a way to deconstruct a view. That is, for a given column in a view, find the reference table / column that was used to construct the view. I know that Select * from information_schema.view_column_usage will give me the...

I need a way to deconstruct a view. That is, for a given column in a view, find the reference table / column that was used to construct the view. I know that Select * from information_schema.view_column_usage will give me the source tables and columns for the entire view, but it does not give...