Database Results Wizard Error (02)

Topic

New Reply

Problems with the database Editor generated by FP 02.

Since I didnt see what my problem is with the FP generated code, I set fp_DEBUG = True in the file fpdbrgn1.inc.

The FP database Editor frames page now shows this message in the lower frame:

“Your page contains a query with user input parameters that could not be resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing
s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.”

Nor can I find the recommended article.

Can I get a clue?

Reply | Quote

Replies

No joy on your question, however ..
Since I didnt see what my problem is with the FP generated code, I set fp_DEBUG = True in the file fpdbrgn1.inc.
Care to expand on how and why? Its’ a useful trick.

Cheers

Reply | Quote

More information: I have been using FP03beta which has a different way to do the database wizard. I.e., some of the FP03 code is different from FP02 code (no surprise there). What I am suffering from now is that either the install or I have mixed code. I made the rookie mistake of opening a working site in a beta product, rather than a copy of the working site. (gaak!)

FP uses 4 VBScript files in the _fpclass folder to work much of its magic. (You may need to view the “hidden” folders to see _fpclass, where I note that _fpclass is misnamed ~ these files contain functions, they have no classes in them at all.) When FP generates database pages, it includes fpdbrgn1, writes a few definitions, and then includes fpdbrgn2. So if you want to change how these files work, simply open them in an editor and whale away. NO NO NO wait wait wait DO IT ON A COPY NOT the originals.

My next move is to import the FP files into a VB6 project and see how they work, whilst copying the fpclass files from an old, untouched site to see if i can get them to work.

Reply | Quote

More information: I have been using FP03beta which has a different way to do the database wizard. I.e., some of the FP03 code is different from FP02 code (no surprise there). What I am suffering from now is that either the install or I have mixed code. I made the rookie mistake of opening a working site in a beta product, rather than a copy of the working site. (gaak!)

FP uses 4 VBScript files in the _fpclass folder to work much of its magic. (You may need to view the “hidden” folders to see _fpclass, where I note that _fpclass is misnamed ~ these files contain functions, they have no classes in them at all.) When FP generates database pages, it includes fpdbrgn1, writes a few definitions, and then includes fpdbrgn2. So if you want to change how these files work, simply open them in an editor and whale away. NO NO NO wait wait wait DO IT ON A COPY NOT the originals.

My next move is to import the FP files into a VB6 project and see how they work, whilst copying the fpclass files from an old, untouched site to see if i can get them to work.

Reply | Quote

Fixed! Copied in the old files, everything works except the database UPDATE, but that was easy to write myself.

Reply | Quote

Fixed! Copied in the old files, everything works except the database UPDATE, but that was easy to write myself.

Reply | Quote