Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #1658 > unrolled thread

R & R Lists

Started by"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
First post2011-07-10 10:04 +0000
Last post2011-07-12 22:19 +0000
Articles 8 — 3 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  R & R Lists "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-07-10 10:04 +0000
    Re: R & R Lists "Paul D B" <polleke@NOMORESPAMhnt.be> - 2011-07-12 10:04 +0200
      Re: R & R Lists "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-07-12 22:18 +0000
        Re: R & R Lists "Paul D B" <polleke@NOMORESPAMhnt.be> - 2011-07-13 15:41 +0200
          Re: R & R Lists "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-07-14 22:23 +0000
            Re: R & R Lists SteveMcNaughton <stevemcnaughton@auditron.com> - 2011-07-20 03:06 -0700
              Re: R & R Lists "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-07-20 22:50 +0000
      Re: R & R Lists "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-07-12 22:19 +0000

#1658 — R & R Lists

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-07-10 10:04 +0000
SubjectR & R Lists
Message-ID<4e197931$0$2144$c30e37c6@exi-reader.telstra.net>
Hi folks.



I am helping a local company migrate their VO apps toe SQL but it will 
take time before I can get the reports redone So unfortunately we need 
to implement a few features that will be trivial in SQL. I haven't 
touched R&R for years.



In one case I need to send a list of record numbers to R&R. Now I know 
how to send a single parameter:



SetParameter(hPrinter, psz("Parmname"), psz(parmvalue))



But the docs refer to a list parameter also. How do I send a list of 
values? Most notably I'd like to send a list of integers (record 
numbers) but I could live with strings if I had to.



Thanks,



Geoff



[toc] | [next] | [standalone]


#1659

From"Paul D B" <polleke@NOMORESPAMhnt.be>
Date2011-07-12 10:04 +0200
Message-ID<4e1c0014$0$14246$ba620e4c@news.skynet.be>
In reply to#1658
Geoff how are you using R&R? Through the DLL? (rrrpt32.dll or rsrpt32.dll).
I don't know SetParameter(), never heard of it and don't find it in my R&R 
Developers guide.  I"m using the most recent R&R version "Reportworks 12.5 
Infinity".

If it is R&R you are talking about: I use a separate (temp) table in which I 
dump the recordnumbers of the records that I want to print.

Then use the SetMasterTablename() to overrule the name of the table that was 
saved in your report.


Paul

"Geoff Schaller"  schreef in bericht 
news:4e197931$0$2144$c30e37c6@exi-reader.telstra.net...

Hi folks.



I am helping a local company migrate their VO apps toe SQL but it will
take time before I can get the reports redone So unfortunately we need
to implement a few features that will be trivial in SQL. I haven't
touched R&R for years.



In one case I need to send a list of record numbers to R&R. Now I know
how to send a single parameter:



SetParameter(hPrinter, psz("Parmname"), psz(parmvalue))



But the docs refer to a list parameter also. How do I send a list of
values? Most notably I'd like to send a list of integers (record
numbers) but I could live with strings if I had to.



Thanks,



Geoff


[toc] | [prev] | [next] | [standalone]


#1660

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-07-12 22:18 +0000
Message-ID<4e1cc828$0$24353$c30e37c6@exi-reader.telstra.net>
In reply to#1659
Hi Paul,

Yes we are  - and it is version 12.1 (2007).

I can see how your suggestion might work (thank you) but I was hoping to 
not alter the structure of the reports in that way. It will be a 
reasonable amount of work. The query clause in R&R allows for an 
INLIST() component and the SetParameter() offers a list as a choice but 
I wasn't sure how to set the list up in VO. I suspect it might be a 
simple comma delimited string but was just hoping someone somewhere may 
have used this.

Geoff



"Paul D B" <polleke@NOMORESPAMhnt.be> wrote in message 
news:4e1c0014$0$14246$ba620e4c@news.skynet.be:

> Geoff how are you using R&R? Through the DLL? (rrrpt32.dll or rsrpt32.dll).
> I don't know SetParameter(), never heard of it and don't find it in my R&R
> Developers guide.  I"m using the most recent R&R version "Reportworks 12.5
> Infinity".
>
> If it is R&R you are talking about: I use a separate (temp) table in which I
> dump the recordnumbers of the records that I want to print.
>
> Then use the SetMasterTablename() to overrule the name of the table that was
> saved in your report.
>
>
> Paul
>
> "Geoff Schaller"  schreef in bericht
> news:4e197931$0$2144$c30e37c6@exi-reader.telstra.net...
>
> Hi folks.
>
>
>
> I am helping a local company migrate their VO apps toe SQL but it will
> take time before I can get the reports redone So unfortunately we need
> to implement a few features that will be trivial in SQL. I haven't
> touched R&R for years.
>
>
>
> In one case I need to send a list of record numbers to R&R. Now I know
> how to send a single parameter:
>
>
>
> SetParameter(hPrinter, psz("Parmname"), psz(parmvalue))
>
>
>
> But the docs refer to a list parameter also. How do I send a list of
> values? Most notably I'd like to send a list of integers (record
> numbers) but I could live with strings if I had to.
>
>
>
> Thanks,
>
>
>
> Geoff

[toc] | [prev] | [next] | [standalone]


#1666

From"Paul D B" <polleke@NOMORESPAMhnt.be>
Date2011-07-13 15:41 +0200
Message-ID<4e1da071$0$14259$ba620e4c@news.skynet.be>
In reply to#1660
Geoff,

IF you are going to use the SetMasterTablename() function - which I strongly 
recommend, even if you are not using a temp table - then some info:


Where does R&R look for its files? This is a quite complicated approach that 
is explained somewhere in the docs (check out).
After using R&R for 15 years I know it often goes wrong there. Or it will 
use the directory that was saved in the report definition, or it will use a 
setting in the (local !) RRW.INI file etc. etc. A big PITA.

The only reliable way is to use SetMasterTableName() and 
SetMasterindexinfo() and SetDatadir() and SetImageDir()  functions from 
within your VO application.

But then  another problem surfaces.
When your files are installed in a directory with spaces in (e.g. c:\Program 
Files\Data) then you must quote the pathname that you pass into these 
functions.

SetMasterindexInfo(hReport,pszString1)  // where pszString is 'c:\Program 
Files\Data\PRINT.CDX'


However this will work for all those functions EXCEPT SetMasterTableName(). 
Due to a bug that has been present in the R&R DLL, it will leave a trailing 
quote and throw an error:
Cannot open PRINT.DBF'  (mind the trailing quote).
Liveware Publishing knows about this bug, but don't fix it.

The best workaround is to pass in a "Short pathname" like 
c:\Progra~1\Data\PRINT.DBF into the SetMasterTable function. Use the Windows 
API  GetShortPathName() for this. Of course don't quote it otherwise it will 
not work.

Anyway, I dont know what you want to achieve, but if you want to print an 
arbitrary selection of records (e.g. the user selects them in a bBrowser) 
then a temporary printtable (a file PRINT.DBF with only one field: record 
number) as the master Table is the only option in R&R, I guess.


Paul


Paul
"Geoff Schaller"  schreef in bericht 
news:4e1cc828$0$24353$c30e37c6@exi-reader.telstra.net...

Hi Paul,

Yes we are  - and it is version 12.1 (2007).

I can see how your suggestion might work (thank you) but I was hoping to
not alter the structure of the reports in that way. It will be a
reasonable amount of work. The query clause in R&R allows for an
INLIST() component and the SetParameter() offers a list as a choice but
I wasn't sure how to set the list up in VO. I suspect it might be a
simple comma delimited string but was just hoping someone somewhere may
have used this.

Geoff



"Paul D B" <polleke@NOMORESPAMhnt.be> wrote in message
news:4e1c0014$0$14246$ba620e4c@news.skynet.be:

> Geoff how are you using R&R? Through the DLL? (rrrpt32.dll or 
> rsrpt32.dll).
> I don't know SetParameter(), never heard of it and don't find it in my R&R
> Developers guide.  I"m using the most recent R&R version "Reportworks 12.5
> Infinity".
>
> If it is R&R you are talking about: I use a separate (temp) table in which 
> I
> dump the recordnumbers of the records that I want to print.
>
> Then use the SetMasterTablename() to overrule the name of the table that 
> was
> saved in your report.
>
>
> Paul
>
> "Geoff Schaller"  schreef in bericht
> news:4e197931$0$2144$c30e37c6@exi-reader.telstra.net...
>
> Hi folks.
>
>
>
> I am helping a local company migrate their VO apps toe SQL but it will
> take time before I can get the reports redone So unfortunately we need
> to implement a few features that will be trivial in SQL. I haven't
> touched R&R for years.
>
>
>
> In one case I need to send a list of record numbers to R&R. Now I know
> how to send a single parameter:
>
>
>
> SetParameter(hPrinter, psz("Parmname"), psz(parmvalue))
>
>
>
> But the docs refer to a list parameter also. How do I send a list of
> values? Most notably I'd like to send a list of integers (record
> numbers) but I could live with strings if I had to.
>
>
>
> Thanks,
>
>
>
> Geoff 

[toc] | [prev] | [next] | [standalone]


#1676

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-07-14 22:23 +0000
Message-ID<4e1f6c62$0$24350$c30e37c6@exi-reader.telstra.net>
In reply to#1666
Thanks for the thoughts Paul.
You have explained some other issues I've seen.

In the end I just copied the records I wanted to a mirror image table 
and based the report on that table. I wrestled for a while with 
RI_MASTER etc but failed miserably :-)

Cheers,

Geoff


"Paul D B" <polleke@NOMORESPAMhnt.be> wrote in message 
news:4e1da071$0$14259$ba620e4c@news.skynet.be:

> Geoff,
>
> IF you are going to use the SetMasterTablename() function - which I strongly
> recommend, even if you are not using a temp table - then some info:
>
>
> Where does R&R look for its files? This is a quite complicated approach that
> is explained somewhere in the docs (check out).
> After using R&R for 15 years I know it often goes wrong there. Or it will
> use the directory that was saved in the report definition, or it will use a
> setting in the (local !) RRW.INI file etc. etc. A big PITA.
>
> The only reliable way is to use SetMasterTableName() and
> SetMasterindexinfo() and SetDatadir() and SetImageDir()  functions from
> within your VO application.
>
> But then  another problem surfaces.
> When your files are installed in a directory with spaces in (e.g. c:\Program
> Files\Data) then you must quote the pathname that you pass into these
> functions.
>
> SetMasterindexInfo(hReport,pszString1)  // where pszString is 'c:\Program
> Files\Data\PRINT.CDX'
>
>
> However this will work for all those functions EXCEPT SetMasterTableName().
> Due to a bug that has been present in the R&R DLL, it will leave a trailing
> quote and throw an error:
> Cannot open PRINT.DBF'  (mind the trailing quote).
> Liveware Publishing knows about this bug, but don't fix it.
>
> The best workaround is to pass in a "Short pathname" like
> c:\Progra~1\Data\PRINT.DBF into the SetMasterTable function. Use the Windows
> API  GetShortPathName() for this. Of course don't quote it otherwise it will
> not work.
>
> Anyway, I dont know what you want to achieve, but if you want to print an
> arbitrary selection of records (e.g. the user selects them in a bBrowser)
> then a temporary printtable (a file PRINT.DBF with only one field: record
> number) as the master Table is the only option in R&R, I guess.
>
>
> Paul

[toc] | [prev] | [next] | [standalone]


#1713

FromSteveMcNaughton <stevemcnaughton@auditron.com>
Date2011-07-20 03:06 -0700
Message-ID<0e4f822d-fa07-4f13-bd13-2be217f0c74a@t9g2000vbs.googlegroups.com>
In reply to#1676
geoff,

I have some things I can send you privately... in fact, I already
tried but it came back.

if you have my email, send me one from yours...

steve

[toc] | [prev] | [next] | [standalone]


#1733

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-07-20 22:50 +0000
Message-ID<4e275bbd$0$46567$c30e37c6@exi-reader.telstra.net>
In reply to#1713
Steve,

All you had to do was take the obvious 'x' out of the address <g>.

I did solve my problem by replacing the master table with my own (and in 
the report). I have seen what the R&R manual explains and it is 
positively Jurassic. Our client doesn't use the rrw.INI file and this 
makes things a tad more difficult and the data is in a different spot on 
each of the using PCs. Bit messy but there you go.

Thanks for the offer.

Geoff


"SteveMcNaughton" <stevemcnaughton@auditron.com> wrote in message 
news:0e4f822d-fa07-4f13-bd13-2be217f0c74a@t9g2000vbs.googlegroups.com:

> geoff,
>
> I have some things I can send you privately... in fact, I already
> tried but it came back.
>
> if you have my email, send me one from yours...
>
> steve

[toc] | [prev] | [next] | [standalone]


#1661

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-07-12 22:19 +0000
Message-ID<4e1cc86d$0$24354$c30e37c6@exi-reader.telstra.net>
In reply to#1659
Sorry - the function is SetUserParam()





"Paul D B" <polleke@NOMORESPAMhnt.be> wrote in message 
news:4e1c0014$0$14246$ba620e4c@news.skynet.be:

> Geoff how are you using R&R? Through the DLL? (rrrpt32.dll or rsrpt32.dll).
> I don't know SetParameter(), never heard of it and don't find it in my R&R
> Developers guide.  I"m using the most recent R&R version "Reportworks 12.5
> Infinity".
>
> If it is R&R you are talking about: I use a separate (temp) table in which I
> dump the recordnumbers of the records that I want to print.
>
> Then use the SetMasterTablename() to overrule the name of the table that was
> saved in your report.
>
>
> Paul
>
> "Geoff Schaller"  schreef in bericht
> news:4e197931$0$2144$c30e37c6@exi-reader.telstra.net...
>
> Hi folks.
>
>
>
> I am helping a local company migrate their VO apps toe SQL but it will
> take time before I can get the reports redone So unfortunately we need
> to implement a few features that will be trivial in SQL. I haven't
> touched R&R for years.
>
>
>
> In one case I need to send a list of record numbers to R&R. Now I know
> how to send a single parameter:
>
>
>
> SetParameter(hPrinter, psz("Parmname"), psz(parmvalue))
>
>
>
> But the docs refer to a list parameter also. How do I send a list of
> values? Most notably I'd like to send a list of integers (record
> numbers) but I could live with strings if I had to.
>
>
>
> Thanks,
>
>
>
> Geoff

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web