FP2003 Database Results Wizard

[Guest]

I am using Jim Buyens' book "MS FP2003 Inside Out". I have a database with
15 columns. I chose, split records into groups with 5 records per group.
And, I added a search form. I pulled up the xxxx.asp page via the Internet
and all 15 columns were displayed! It was only supposed to display 5 columns
and have buttons to move through the displayed (alleged 5 column) database.
The buttons were not even present on the web page (even though they appeared
during the development phase in design view). I followed the book and it
does not work.

It's been 2 years since FP2003 was released ... it should be robust by now.
I'm a novice at this, but I did follow the book (and, I did save several
different more examples and they did not work either!). Is there a web site
to look for an eratta sheet for the book?

Anyway ... what do I do now? I followed the book!!!!!

P.S. By the way, the search feature worked great!!!!!

 

[John Malone]

One of the best resources I think is
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp

By the way the 5 records per group was the rows not the columns.

The columns "displayed" you select in the third page (I think(off the top of
my head)) of the wizard.

Good luck!
--
John Malone
==============
|I am using Jim Buyens' book "MS FP2003 Inside Out". I have a database
with
| 15 columns. I chose, split records into groups with 5 records per group.
| And, I added a search form. I pulled up the xxxx.asp page via the
Internet
| and all 15 columns were displayed! It was only supposed to display 5
columns
| and have buttons to move through the displayed (alleged 5 column)
database.
| The buttons were not even present on the web page (even though they
appeared
| during the development phase in design view). I followed the book and it
| does not work.
|
| It's been 2 years since FP2003 was released ... it should be robust by
now.
| I'm a novice at this, but I did follow the book (and, I did save several
| different more examples and they did not work either!). Is there a web
site
| to look for an eratta sheet for the book?
|
| Anyway ... what do I do now? I followed the book!!!!!
|
| P.S. By the way, the search feature worked great!!!!!
| --
| NuBee

 

[Guest]

Thank you ... that was very helpful ...

 

[Andrew Murray]

You seem to have intermixed the terms "Columns" and "Records" and getting
confused (or else I'm confused over what your question actually is).

"Columns" refers to the field in the database (a field being an individual
place holder for data e.g. "Phone Number". Records contain several columns
(or fields). A database (tables, fields & records collectively) contains
many records.

The Results wizard can split the number of *records* (not columns or fields)
per page. Your post refers to 'splitting the number of *columns* over
several pages, which is where the confusion is.

You can delete or insert the field names within the results area in FP as
you wish --- Insert > Database > Column Value... then choose the column
value (the fieldname) you want. Remeber to click the cursor at the point
whereyou want that field name to appear e.g. add an extra row or column to
the table or however you've laid the results out.

To delete a field, select it and press "Delete" key.

Therefore you do have some control over the field names that are displayed
for each record, and you have control over the number of records you see on
each screen;

Do you have a live example of your attempt to follow the book? Can you post
the URL if so or else publish the page(s) and post the URL when you've done
so.

One other thing - do you have *more than 5 records* in the database? If not,
that's why it is not splitting the records over several screens - since
there are less than the number-of-records-per-page specified. A rather
obvious observation, but I thought I'd raise that point anyway.

Hope this sorts it out.

 

[John Malone]

Your Welcome! 8)

--
John Malone
==============
| Thank you ... that was very helpful ...
| --
| NuBee
|
|
| "John Malone" wrote:
|
| > One of the best resources I think is
| > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp
| >
| > By the way the 5 records per group was the rows not the columns.
| >
| > The columns "displayed" you select in the third page (I think(off the
top of
| > my head)) of the wizard.
| >
| > Good luck!
| > --
| > John Malone
| > ==============
| > | > |I am using Jim Buyens' book "MS FP2003 Inside Out". I have a database
| > with
| > | 15 columns. I chose, split records into groups with 5 records per
group.
| > | And, I added a search form. I pulled up the xxxx.asp page via the
| > Internet
| > | and all 15 columns were displayed! It was only supposed to display 5
| > columns
| > | and have buttons to move through the displayed (alleged 5 column)
| > database.
| > | The buttons were not even present on the web page (even though they
| > appeared
| > | during the development phase in design view). I followed the book and
it
| > | does not work.
| > |
| > | It's been 2 years since FP2003 was released ... it should be robust by
| > now.
| > | I'm a novice at this, but I did follow the book (and, I did save
several
| > | different more examples and they did not work either!). Is there a
web
| > site
| > | to look for an eratta sheet for the book?
| > |
| > | Anyway ... what do I do now? I followed the book!!!!!
| > |
| > | P.S. By the way, the search feature worked great!!!!!
| > | --
| > | NuBee
| >
| >
| >

 

[Guest]

Thank you ... that really helped! I have the terms confused. I thought the
records were the columns. I understand now. With MS, fields are the columns
and records are the rows. I guess that's the difference between MS and
Oracle. Thanks much!!!!!