webbot update limit

[Guest]

I have a form which updates a database there are 289 fields, most are just
checks boxes.
I have a custom query it works until I reach around field 151. Is there a
limit in webbot?
All the fields can be entered in the query statement, but if I add any above
D658 I receive the following error on the front-end:


Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.



Query:
UPDATE results
SET C010=':010::', C005=':005::', C019=':019::', C020=':020::',
C022=':022::', C025=':025::', C035=':035::', C037=':037::',
C040=':040::', C045=':045::', C050=':050::', C052=':052::',
C055=':055::', C065=':065::', C070=':070::', C071=':071::',
C072=':072::', C073=':073::', C080=':080::', C085=':085::',
C090=':090::', C095=':095::', C100=':100::', C105=':105::',
C110=':110::', C120=':120::', C125=':125::', C135=':135::',
C140=':140::', C145=':145::', C150=':150::', C155=':155::',
C160=':160::', C165=':165::', C180=':180::', C190=':190::',
C193=':193::', C195=':195::', C200=':200::', C201=':201::',
C206=':206::', C207=':207::', C208=':208::', C209=':209::',
C210=':210::', C225=':225::', C232=':232::', C233=':233::',
C240=':240::', C245=':245::', C250=':250::', C255=':255::',
C260=':260::', C265=':265::', C269=':269::', C279=':279::',
C285=':285::', C287=':287::', C290=':290::', C295=':295::',
C310=':310::', C312=':312::', C315=':315::', C318=':318::',
C330=':330::', C335=':335::', C340=':340::', C345=':345::',
C350=':350::', C360=':360::', C365=':365::', C370=':370::',
C375=':375::', C380=':380::', C385=':385::', C390=':390::',
C393=':393::', C395=':395::', C400=':400::', C410=':410::',
C415=':415::', C420=':420::', C425=':425::', C430=':430::',
C435=':435::', C440=':440::', C445=':445::', C450=':450::',
C460=':460::', C465=':465::', C475=':475::', C485=':485::',
C500=':500::', C505=':505::' , C510=':510::', C515=':515::',
C525=':525::', C530=':530::', C540=':540::', C545=':545::',
C550=':550::', C553=':553::', C555=':555::', C556=':556::',
C557=':557::', C558=':558::', C559=':559::', C560=':560::',
C565=':565::', C570=':570::', C575=':575::', C580=':580::',
C590=':590::', C593=':593::', C595=':595::', C605=':605::',
C615=':615::', C620=':620::', C625=':625::', C630=':630::',
C635=':635::', C640=':640::', C645=':645::', C650=':650::',
C652=':652::', C655=':655::', C658=':658::', C605=':605::'
WHERE requiredemail='::requiredemail::'

 

[Stefan B Rusynko]

1) Access DB tables have a limit of 255 Fields maximum

2) Your code snippet has 128 fields not 151
Since you are using Form fields that may be truncated see
http://support.microsoft.com/default.aspx?scid=kb;en-us;820915

3) Not sure about any DBRW limits but since it uses strings you may be exceeding some string limitation of 2048 char

Run your update is 2 stages

PS
To see the true error, open the hidden folder /_fpclass/ and edit the fpdbrgn1.inc file
At about line 19, change :
fp_DEBUG = False
to :
fp_DEBUG = True


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I have a form which updates a database there are 289 fields, most are just
| checks boxes.
| I have a custom query it works until I reach around field 151. Is there a
| limit in webbot?
| All the fields can be entered in the query statement, but if I add any above
| D658 I receive the following error on the front-end:
|
|
| Database Results Wizard Error
| The operation failed. If this continues, please contact your server
| administrator.
|
|
|
| Query:
| UPDATE results
| SET C010=':010::', C005=':005::', C019=':019::', C020=':020::',
| C022=':022::', C025=':025::', C035=':035::', C037=':037::',
| C040=':040::', C045=':045::', C050=':050::', C052=':052::',
| C055=':055::', C065=':065::', C070=':070::', C071=':071::',
| C072=':072::', C073=':073::', C080=':080::', C085=':085::',
| C090=':090::', C095=':095::', C100=':100::', C105=':105::',
| C110=':110::', C120=':120::', C125=':125::', C135=':135::',
| C140=':140::', C145=':145::', C150=':150::', C155=':155::',
| C160=':160::', C165=':165::', C180=':180::', C190=':190::',
| C193=':193::', C195=':195::', C200=':200::', C201=':201::',
| C206=':206::', C207=':207::', C208=':208::', C209=':209::',
| C210=':210::', C225=':225::', C232=':232::', C233=':233::',
| C240=':240::', C245=':245::', C250=':250::', C255=':255::',
| C260=':260::', C265=':265::', C269=':269::', C279=':279::',
| C285=':285::', C287=':287::', C290=':290::', C295=':295::',
| C310=':310::', C312=':312::', C315=':315::', C318=':318::',
| C330=':330::', C335=':335::', C340=':340::', C345=':345::',
| C350=':350::', C360=':360::', C365=':365::', C370=':370::',
| C375=':375::', C380=':380::', C385=':385::', C390=':390::',
| C393=':393::', C395=':395::', C400=':400::', C410=':410::',
| C415=':415::', C420=':420::', C425=':425::', C430=':430::',
| C435=':435::', C440=':440::', C445=':445::', C450=':450::',
| C460=':460::', C465=':465::', C475=':475::', C485=':485::',
| C500=':500::', C505=':505::' , C510=':510::', C515=':515::',
| C525=':525::', C530=':530::', C540=':540::', C545=':545::',
| C550=':550::', C553=':553::', C555=':555::', C556=':556::',
| C557=':557::', C558=':558::', C559=':559::', C560=':560::',
| C565=':565::', C570=':570::', C575=':575::', C580=':580::',
| C590=':590::', C593=':593::', C595=':595::', C605=':605::',
| C615=':615::', C620=':620::', C625=':625::', C630=':630::',
| C635=':635::', C640=':640::', C645=':645::', C650=':650::',
| C652=':652::', C655=':655::', C658=':658::', C605=':605::'
| WHERE requiredemail='::requiredemail::'
|