Re: render() Invalid subscript reference

Larry Hendren wrote:
> I have a report that is very simple – it only regurgitates the data from a
temporary table.  I have used the report and associated form for about 4 years
and now I am updating it to utilize both dBase and MS SQL tables.
> 
> I changed the datamodule reference as well as the datamodref.  In addition,
I changed the appearance and placement of some of the text.
> 
> When I run the form; I get the error message:  Error Invalid subscript
reference; Line 4039 which is “rpt.render()”
> 
> When I try to run the report (without the form); I get the error message: 
Error Invalid subscript reference; Line 7 which is “r.render()”
> 
> I cannot run the report designer for this report.
> 
> I need some direction on where to look for causes of the error.  I think I
saw one thread where there is a limitation on the size of variable names which
could generate this error message.  Is that correct?

This error typically means just what it says. A field reference 
(usually) cannot be found ... the subscript reference is often:

form.datamodulename.queryname.rowset.fields["fieldname"]

And it's the "fieldname" that can't be found ... the problem of course

is that it's not pointing where you might expect, but instead to the 
render method of the report. I hate to say it, but it sounds like you're 
going to have to examine this to make sure each place you reference a 
field is properly set up ...

Ken
-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/dbase/dBASEReportsBook.htm
http://www.goldenstag.net/GSP

I have a report that is very simple – it only regurgitates the data from a
temporary table.  I have used the report and associated form for about 4 years
and now I am updating it to utilize both dBase and MS SQL tables.

I changed the datamodule reference as well as the datamodref.  In addition, I
changed the appearance and placement of some of the text.

When I run the form; I get the error message:  Error Invalid subscript
reference; Line 4039 which is “rpt.render()”

When I try to run the report (without the form); I get the error message:  Error
Invalid subscript reference; Line 7 which is “r.render()”

I cannot run the report designer for this report.

Larry Hendren wrote:
> Ken, it was a field name.  I found it within 5 miniutes of reading your
message after 3 days of looking in the wrong place.
> Thank you very much!

Whew. Glad that did the trick. <g> I know how frustrating these things 
can be.

Ken

-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/dbase/dBASEReportsBook.htm
http://www.goldenstag.net/GSP

Ken, it was a field name.  I found it within 5 miniutes of reading your message
after 3 days of looking in the wrong place.
Thank you very much!


Ken Mayer [dBVIPS] Wrote:

> Larry Hendren wrote:
> > I have a report that is very simple – it only regurgitates the data
from a temporary table.  I have used the report and associated form for about 4
years and now I am updating it to utilize both dBase and MS SQL tables.
> > 
> > I changed the datamodule reference as well as the datamodref.  In
addition, I changed the appearance and placement of some of the text.
> > 
> > When I run the form; I get the error message:  Error Invalid subscript
reference; Line 4039 which is “rpt.render()”
> > 
> > When I try to run the report (without the form); I get the error
message:  Error Invalid subscript reference; Line 7 which is “r.render()”
> > 
> > I cannot run the report designer for this report.
> > 
> > I need some direction on where to look for causes of the error.  I
think I saw one thread where there is a limitation on the size of variable names
which could generate this error message.  Is that correct?
> 
> This error typically means just what it says. A field reference 
> (usually) cannot be found ... the subscript reference is often:
> 
> form.datamodulename.queryname.rowset.fields["fieldname"]
> 
> And it's the "fieldname" that can't be found ... the problem of
course 
> is that it's not pointing where you might expect, but instead to the 
> render method of the report. I hate to say it, but it sounds like you're 
> going to have to examine this to make sure each place you reference a 
> field is properly set up ...
> 
> Ken
> -- 
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
> 
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/dbase/dBASEBook.htm
> http://www.goldenstag.net/dbase/dBASEReportsBook.htm
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase