Truncation of Argument with ADo Components

From: Norman McFarlane (normanATredpointDOTcoDOTza)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 17:35:11 +0200

Hi all,

I have encountered and interesting and frustrating problem with the ADO
components in D7.

Specifically, when I pass a string argument which is destined for an image
column in the DB into a parameterised INSERT query, only the first character
finds its way into the column. I am using a TADOCommand component to do the
insert. I've had this problem in the past, and overcome it by using a stored
proc which accepts a VRCHAR input parameter, the argument of which is posted
into an image column. I would, however, like to solve this problem without
resorting to using a stored proc.

I have taken a look at the value of the parameter in the IDE before I
execute the INSERT statement, and it is complete, but only the first
character ends up in the DB.

Does anybody have any ideas?

The DB backend is MS SQL 2000 Enterprise.

Regards,

Norman

Relevant Pages

  • Re: Data String Manipulation
    ... Function MakeString(Scan As String) As String ... Dim Ret As String ... GoTo Exit_Func ... always need to delete the first character in the scanned string, ...
    (microsoft.public.access.modulesdaovba)
  • Re: LPCWSTR to CString conversion problem
    ... I get the first character of the string and pass it to ... LPCWSTR to CString conversion. ... Do you compile as Unicode or Ansi? ... GetAtreturns the second character of the string, ...
    (microsoft.public.vc.atl)
  • Re: Converting Type Characters to type string
    ... used to determine whether or not the input was a integer roman numeral ... advice and are using Get_Line to read an entire string first, ... look at the first character of the string to see whether it's Q or a ... can still convert the entire input string using Integer'Value. ...
    (comp.lang.ada)
  • RE: Help required to read and print lines based on the type of first character
    ... Please, don't top-post, and learn to quote & snip ... elif '##' in data: ... Read doc for the strip method of string ... the specification is that it should seek for the first character and based on that it should take the decision. ...
    (comp.lang.python)
  • Re: Capitalizing the first letter
    ... Education Technology Department Ankara / TURKEY ... In PHP ucfirstfunction make a string's first character uppercase. ... But ralph smith have two words respectivetely ralph and smith. ... string, ...
    (php.general)