Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1658 > unrolled thread
| Started by | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| First post | 2011-07-10 10:04 +0000 |
| Last post | 2011-07-12 22:19 +0000 |
| Articles | 8 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-07-10 10:04 +0000 |
| Subject | R & 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]
| From | "Paul D B" <polleke@NOMORESPAMhnt.be> |
|---|---|
| Date | 2011-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]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-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]
| From | "Paul D B" <polleke@NOMORESPAMhnt.be> |
|---|---|
| Date | 2011-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]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-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]
| From | SteveMcNaughton <stevemcnaughton@auditron.com> |
|---|---|
| Date | 2011-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]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-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]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-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