Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database Results Wizard Error (02)

    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?

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Database Results Wizard Error (02)

    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
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database Results Wizard Error (02)

    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.

  4. #4
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database Results Wizard Error (02)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •