----------------------------As far as printing to a file from a DBGrid this
turned out to be significantly easier than I had imagined:
OUTPUT Stats.FLE
UNLOAD DATA FOR &RBTI_FORM_TBLNAME USING #1, #2, #3, #4, #5, #6 +
AS CSV ORDER BY &RBTI_FORM_COLNAME
OUTPUT SCREEN
The next step is to try and adapt this basis for other forms where the number
of tables and columns in the form vary.
Thanks again for your pointer, Bernie,
Regards,
Alastair.
----- Original Message -----
From: Bernard Lis
To: RBASE-L Mailing List
Sent: Sunday, June 01, 2008 8:21 PM
Subject: [RBASE-L] - Re: Printing from a form without creating a report first
instead of using column names try sel #1,#2 from tablename.
if all your tables are in same order, then you can use the same code for
other tables.
----- Original Message -----
From: Alastair Burr
To: RBASE-L Mailing List
Sent: Sunday, June 01, 2008 3:07 PM
Subject: [RBASE-L] - Re: Printing from a form without creating a report
first
Many thanks for the offer, Bernie, but you've hit my problem: the column
names and the number of columns nearly always vary from form to form - as do
the table names.
I can possibly extract the table name and the column names with Properties
but I think I would have to skip through from first to last to pick up each one
- I'm thinking out loud here - and then try and work out the current sort
sequence somehow. That doesn't sound very slick but it might be a starting
point...
Again, thanks & regards,
Alastair.
----- Original Message -----
From: Bernard Lis
To: RBASE-L Mailing List
Sent: Sunday, June 01, 2008 7:51 PM
Subject: [RBASE-L] - Re: Printing from a form without creating a report
first
Hi Alastair,
If you can't find a way to do it automatically, and If you need to write
code to get the job done, send me the column names involved and what you want
the output to look like and I'll write it for you.
Bernie Lis
----- Original Message -----
From: Alastair Burr
To: RBASE-L Mailing List
Sent: Sunday, June 01, 2008 2:28 PM
Subject: [RBASE-L] - Re: Printing from a form without creating a report
first
Thanks Bernie,
Not so much trying to avoid writing code as to avoid re-inventing the
wheel and writing code that _has_ to be different for each form.
I was hoping that something like the browser facility might be exposed
for use somewhere that I hadn't yet found.
I hope that I can write the code to select and print but, so far, I
can't think of a way to make it variable for whatever table(s) is in use,
whatever columns and the current sort (dbgrid, mainly) and put it in one
generic button for use on any form.
Lazy, maybe, but if I could get what I want to do to work it would be
unrestricted not only between forms but also databases - I already have an
"Action Bar" (actually a group box) of buttons that does all my navigation,
save, exit, etc. and this would be a nice addition.
Regards,
Alastair.
----- Original Message -----
From: Bernard Lis
To: RBASE-L Mailing List
Sent: Sunday, June 01, 2008 6:47 PM
Subject: [RBASE-L] - Re: Printing from a form without creating a
report first
Hi Alastair,
Are you trying to avoid writing code?
Otherwise a speed button on your form with an eep to select the
columns into vars, then output printer and/or output filename (to export), then
a write statement.
That should give you what you want, I think.
Bernie Lis
----- Original Message -----
From: Alastair Burr
To: RBASE-L Mailing List
Sent: Sunday, June 01, 2008 12:59 PM
Subject: [RBASE-L] - Printing from a form without creating a report
first
I have been considering how to create a button (or, at least, the
code behind it) to enable me to print from a form in much the same way that you
can click on [Menu][Edit] | [Print Data] and [Menu][Edit] | [Export Results To]
in the data browser.
I am particularly interested in exporting the data in the sequence
that it is currently displayed which may not be the same as the original data
set sequence. I'm trying to avoid creating a separate report for a number of
forms but I haven't been able to find any way to code what I want to obtain.
Am I missing something obvious? Is there a way to do what I want or
is this something that might be a candidate for an enhancement request?
Thanks in advance for any insights.
Regards,
Alastair
----------------------------
Alastair Burr
St. Albans, UK.
[EMAIL PROTECTED]
-----------------------------
----------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.24.4/1476 - Release Date:
31/05/2008 12:25
--------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.24.4/1476 - Release Date:
31/05/2008 12:25
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.24.4/1476 - Release Date: 31/05/2008
12:25
