Re: Sql Insert Error

Jeff wrote:

I am getting the message "the field is too small to accept the amount
of data you attempted to add. Try inserting or pasting less data". I
really do not want to make my text field so large just to handle a
few users incoming data that may be to large for my description
field. Is there a way around this to force it to truncate the data?

Using ADO command component and inserting into MS Access.

Thanks!

check the OnSetText event handler for a TField

--
Best regards :)

Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages

  • Re: Nested If problem
    ... Hi Jeff, I must confess VB is obviously my weak point. ... Breakpoint and tried hitting F8 but all I get is a ding from my computer - ... Have you tried inserting a Breakpoint at the start of the If...Then and ... I'm not clear what you expect to have triggering this testing... ...
    (microsoft.public.access.formscoding)
  • Re: INDENTED INSERTED PROJECTS
    ... JEFF wrote: ... MASTER PROJECT WHICH I HAVE DONE BY CREATING INDEPENDENT FILE FOR EACH ... PROJECT AND THEN INSERTING THEM INTO A MASTER. ...
    (microsoft.public.project)
  • jdbc question
    ... Using JDBC, what would be a more elegant way of determining whether or ... not a record already exists in a DB table before inserting it? ... Jeff ...
    (comp.lang.java.programmer)
  • Re: Problem displaying Excel table in Notes in MS Project Professional 2003
    ... As far as copying and pasting, you are limited in by the lack of a ... Project MVP ... I should have said yes I tried inserting as an object. ...
    (microsoft.public.project)
  • Field too small
    ... The field name is FileData and the data type is OLE Object ... The field is too small to accept the amount of data you attempted to add. ... Try inserting or pasting less data.] ...
    (microsoft.public.dotnet.framework.adonet)