OpenQuery and GetFieldFromQuery

rbuser

Enterprise version 6.03

I'm not sure I remember the function names exactly, but

how do I use OpenQuery and GetFieldFromQuery?
I tried what seemed reasonable, but no luck.

Also, is there documentation available that covers such things?
(Help is partially broken)

Thanks,

Jon Jacobs

nicocizik

Hi Jon,

There are no methods in ReportBuilder named OpenQuery or GetFieldFromQuery.
What exactly are you trying to accomplish? Perhaps if I can get a little
more background on what you are ultimately trying to do, I can help you find
the routines you need and give you more information on each of them.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

> There are no methods in ReportBuilder named OpenQuery or
GetFieldFromQuery.
Aha! That means they are addins. Maybe I can find the source.

find

A couple of secondary tables in the view I built are sellers and buyers. For
each record in the main table there maybe several records in sellers and
several records in buyers, having the same (partial) key as the complete key
of the main table. If, for example, a main record has 3 sellers and 5
buyers, the query produces 15 records, and I only want 5 (the larger of the
two lists) since the sellers and buyers are only related to each other
collectively (via the sale), not individually.

(5 rows like this, not 15 rows)
buy sell
1 1
2 2
3 3
4
5

I tried leaving the sellers and buyers tables out of the views, and wanted
to do a separate pair of queries in an event handler and manipulate the data
there. I would add lines to a couple of memos with stretch turned on, so a
given detail row would only expand the minimum needed.

Speaking of those memos, I need to truncate data to the column width. I do
not want it to have longer data wrap, but I have not been able to prevent
it. Since the font of choice is proportional, predicting how wide a given
string will be is a problem. How can this be done it RB? I've spent many
hours on this to no avail.

Thanks,
Jon Jacobs

nicocizik

Hi Jon,

If you do an inner join on the buyers and sellers tables, you could probably
consolidate the amount of rows that show up in your report.

As far as determining the width of an amount of text before it prints, you
could use the TCanvas.TextWidth procedure to do so before the text object
prints. To get the best accuracy, you should use the TppPrinter.Canvas,
however you chould also create a temporary TBitmap and use its TCavas as
well.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thank you,

Jon Jacobs

probably