will
|
Posted: 07/07/2003, 11:24 AM |
|
i have am access 2000 DB,(ASP and IIS5), with a list of countries, followed
by 4 checkboxes, when i checked on of them, an tried to update the record,
it shows this:
Source: Record countries / Update Operation
Command Text: UPDATE countries SET country_name='Anguilla', AccountSt=True,
ASCTech=False, ASCWarranty=False, Parts=False WHERE country_id = 10
Error description: The field is too small to accept the amount of data you
attempted to add. Try inserting or pasting less data. (Microsoft JET
Database Engine)
UPDATE countries SET country_name='Anguilla', AccountSt=True, ASCTech=False,
ASCWarranty=False, Parts=False WHERE country_id = 10
|
|
|
DonB
|
Posted: 07/07/2003, 4:23 PM |
|
I think you actually are attempting to store the string s"True" or False"
because you have not correctly matched the project's true/false
representations to those that the database requires. Recheck the Project
settings (from the CCS menu in the main windows) and also the four checkbox
properties. For Access true is -1 and false is 0. The possibility of
"Angulla" being to long for the country_name field is assumed not the cause
of your problem, but bears checking as well.
DonB
"will" <pcboss1976@hotmail.com> wrote in message
news:becdtj$t57$1@news.codecharge.com...
> i have am access 2000 DB,(ASP and IIS5), with a list of countries,
followed
> by 4 checkboxes, when i checked on of them, an tried to update the record,
> it shows this:
>
> Source: Record countries / Update Operation
> Command Text: UPDATE countries SET country_name='Anguilla',
AccountSt=True,
> ASCTech=False, ASCWarranty=False, Parts=False WHERE country_id = 10
> Error description: The field is too small to accept the amount of data you
> attempted to add. Try inserting or pasting less data. (Microsoft JET
> Database Engine)
> UPDATE countries SET country_name='Anguilla', AccountSt=True,
ASCTech=False,
> ASCWarranty=False, Parts=False WHERE country_id = 10
>
>
|
|
|
|