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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Vertical Display of Text, Especially in ReportBuilder
Hello Everyone, I would like to display text vertically (e.g. take the word "Column" and rotate it counter-clockwise 90 degrees) in part of my Delphi 7 program. More specifically, I would like my column headers in a ReportBuilder report to appear and print vertically so that my columns are...- clakerley
- Thread
- Replies: 1
- Forum: Embarcadero: Delphi
-
Opening and Displaying PDF Files from Delphi Application
Thank you! It worked like a charm....- clakerley
- Post #5
- Forum: Embarcadero: Delphi
-
Opening and Displaying PDF Files from Delphi Application
Hello Everyone, I want to have my application open and display a PDF file when a user makes a menu selection. I know this should be simple, but I cannot find the answer in the Help files. I don't want any dialog boxes to open for the user to select a file name or to select a program to use to...- clakerley
- Thread
- Replies: 4
- Forum: Embarcadero: Delphi
-
Aggregate Data from Two Tables
I use a function similar to the following: //receives a query object & a query string, does the work to run string in query object Function RunQuery(QueryObject: TnxQuery; QueryString : String): Boolean; begin Result := False; try with QueryObject do begin Close... -
Aggregate Data from Two Tables
Hello ddiamond, I am using Nexus Database Server version 1.08, and I am using Borland Delphi 7 as my programming language. Thanks, clakerley -
Aggregate Data from Two Tables
Hello everyone, Well, I finally have a solution that works! A very helpful person at the database server's vendor suggested that I create two temp tables, one to hold the count data and the other to hold the amount data, and then query off of these temp tables. His solution looks similar to... -
Aggregate Data from Two Tables
The vendor just confirmed to me that my problem stems from a limitation of my older version of their database server. It works fine on their latest version; unfortunately for me, upgrading is not an option for me at the moment. I'd still welcome any ideas for possible work-arounds! Thanks... -
Aggregate Data from Two Tables
If it helps, here is my actual, complete SQL statement that gives me the error: SELECT P.BusinessUnit, (NumWon + NumLost + NumPending) as NumQuoted, (ValueWon + ValueLost + ValuePending) as ValueQuoted, NumWon, ValueWon, NumLost, ValueLost, NumPending, ValuePending, (case when ((NumWon +... -
Aggregate Data from Two Tables
Thanks again for your help. I tried something like the above SQL statement, but I get an error complaining about "text after end of valid SQL statement," and it indicates that the error is on this line: ) O INNER JOIN ( Is the suggested SQL standard? Is it supposed to be supported by most... -
Aggregate Data from Two Tables
The expected results would be: BU NumOpps ValueOpps NumWon ValueWon NumLost ValueLost RateNumWon RateValueWon -- ------- --------- ------ -------- ------- --------- ---------- ------------ BU1 1 1100 1 1100 0 0 100 100 BU2 2... -
Aggregate Data from Two Tables
Thanks for that! And while that can work for my simplified example, my actual solution will have to be different. You see, my actual starting query is much more involved than the above examples. One of the things I am doing is showing the number of opportunities that are won or lost, and the... -
Aggregate Data from Two Tables
Hello Everyone, I am having trouble creating a query that pulls aggregate data from separate tables. Background: My database tracks sales data. Each sales opportunity has an opportunity identifier (OppID). Each opportunity is related to a business unit (BU). Each opportunity has one (or... -
Using Barcoding with Borland (Inprise) Delphi
Hello Everyone, I am currently using Delphi 7 and anticipate needing to add barcode capabilities to my program. Can anyone recommend a good product that will allow me to do that? Thanks, clakerley- clakerley
- Thread
- Replies: 2
- Forum: Embarcadero: Delphi
-
Using Barcodes with Borland (Inprise) Delphi
Hello Everyone, I am currently using Borland (Inprise) Delphi 7 and anticipate needing to add barcode capabilities to my program. Can anyone recommend a good product that will allow me to do that? Thanks, clakerley- clakerley
- Thread
- Replies: 1
- Forum: Bar coding and automation
-
Averaging Columns from my Result
Actually, I use a DBMS I had never heard of before my current job, called NexusDB. It is an updated and much more stable version of another DBMS I had never heard of called FlashFiler. If anyone's interested I can post their web site. Is that allowed in this forum? I'm new and am not versed... -
Averaging Columns from my Result
Thanks! This worked like a charm. By the way, is the "as dt" toward the end of your statement technically necessary? I accidentally tried it without that, and it gave me the same results as it did when I added it in. I'm just wondering if including it was technically necessary in ANSI-SQL... -
Averaging Columns from my Result
Hello Everyone, I am having difficulty figuring out how to do a query that averages some of the columns of my result set and making that average part of the result. Here is an example of what I'm talking about. Let's say I have four records on MyTable, as follows: ProgramName BusinessUnit...
