Search results for query: *

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

Thank you! It worked like a charm....

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

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

Hello ddiamond, I am using Nexus Database Server version 1.08, and I am using Borland Delphi 7 as my programming language. Thanks, clakerley

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

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

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

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

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

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

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

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

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

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

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

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