Re: Webdb (Link to form)

Hi Robin,

I get the same message when i use a table with an invalid field name in it (for example umlaut or special characters). Maybe you have got a field name with an invalid character in one of your tables.

Try a report based on a SQL-Query on both single tables. 1. Try SELECT * FROM <table>
2. Try SELECT <fieldname>, <fieldname>, <fieldname>... from <table> or try the same report with the wizard (also field by field)

If 1. works and 2. does not, you have found the invalid table now try to find the invalid field by using 2. again with single fieldnames only. Also use UPPERCASE for single fieldnames.

Hope i could help you and wish you a fine Y2K

Peter

<info_at_sententia.nl> schrieb in im Newsbeitrag: 3860ddaf.799921366_at_news.demon.nl...
>
> Hello,
>
> Here is the "problem":
>
> I have a report based on two tables. I want to link the report to a
> form for updating records.
>
> The _rowid = id and _alt_rowid = ID. The ID is the primary key of
> table i want to link to.
>
> When i want to run the report i get the massage: CURSOR IS NOT OPEN.
>
> I tried the link on a single table based report and then i don't have
> this problem.
>
> I also tried a view and then it will not work.
>
> What is wrong ?
>
> Regards
> Robin van Spankeren
Received on Thu Dec 30 1999 - 18:47:58 CET