|
| |
|
|
lu lu
Posts: 418
From: wpg, mb
Status: offline
 |
Who knows how many is too many - 8/28/2001 20:36:00
Form's created...right click form...send to database...create database..."Couldn't append to the table --Exception: too many fields defined"
Who knows how many is too many, and could this be gotten around. Why can't the form be as big as i'd like. Can one submit button work for pages, if the form was divided into say...three pages
|
|
|
|
Mojo
Posts: 2431
From: Chicago
Status: offline
|
RE: Who knows how many is too many - 8/28/2001 13:48:00
How many form fields do you have? Access 2000 is limited to 255 fields/columns. When you create a DB from a form in FP each form field will be created as a column in Access. As it should. The limit you are hitting is due to Access not FP. SQL server has a limit of over 1000. Joe
| |
|
|
|
lu lu
Posts: 418
From: wpg, mb
Status: offline
|
RE: Who knows how many is too many - 8/28/2001 14:08:00
The form has 330ish feilds. There are five forms, each start the same (about 200 fields). Is it possible to have a preform (and db)
and in that preform have options to goto the chosen form upon submit, and the preform info and chosen form info to goto one master db? I'm using fp2k and am wishing to stick with it. What can my options be?[This message has been edited by lu lu (edited 08-28-2001).]
| |
|
|
|
Mojo
Posts: 2431
From: Chicago
Status: offline
|
RE: Who knows how many is too many - 8/28/2001 14:14:00
Yes, Access 2002 is limited to 255.You will need to do something custom. If your going to use the DRW, split your form in half and submit the first one to table1 and the second to table2. Then you just join the two tables in your SQL statement. Joe
| |
|
|
|
Spooky
Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Who knows how many is too many - 8/28/2001 16:22:00
300+ ? ouch
| |
|
|
|
lu lu
Posts: 418
From: wpg, mb
Status: offline
|
RE: Who knows how many is too many - 8/28/2001 16:35:00
Yep big forms - immigration info stuff.
Thanks for the ideas i'll should be able to muster it even though i'm not a progrmr, it sounds straight forward. Thanks again jbennett... and spooky the peaker.
| |
|
|
|
Spooky
Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Who knows how many is too many - 8/28/2001 16:48:00
![]("http://www.frontpagewebmaster.com/ubb/biggrin.gif") To get away from too many fields, I quite often use the trick of "binary" code fields. eg, if you have 20 check boxes (Y/N) fields, its better to use one text field that contains the binary code representing the values eg : 00111000110011000 ...... If all 300 fields are Y/N, then you could have 1 memo field just containing that data. It is more involved as you need to count and update the correct values, but it keeps the fields down. And no, FP doesnt allow you to do that easily, its pure asp ------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
VP-ASP Shopping cart
| |
|
|
|
lu lu
Posts: 418
From: wpg, mb
Status: offline
|
RE: Who knows how many is too many - 8/28/2001 18:06:00
unfortunatly, the form gather typed info as well as yes/no as well as dropdown selections as well as...all pretty much equally. becuase i'm submiting the info to the db and email at the sme time through asp is the idea of two forms (which means 2 tables and 2 ASP pages that is used to process the information, is there going to be problems when i combine the two tables through an sql statement, and does the info (of both tables) directed by the sql statement get placed in one table(all done with fp2k).???????????????????????????????
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
