Re: Problems saving MemoText (over 255 chars) into ACCESS2000

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 03/13/04

  • Next message: Patrick Ryan: "Re: TClientDataSet, TADOTable & "INSERT INTO" SQL error" 
    Date: Fri, 12 Mar 2004 21:26:03 -0600

    >I am facing the problem of saving the memo text into an Access table.
    >
    >If the text in the memo is less than 255. the saving will work properly.
    >
    >If the text exceeds 255 chars, the saving will get errors.

    I tried your code with the addition of a field list and I don't have any problem
    storing text > 255 characters in the memo fields.

    What version of Delphi are you using?
    Are you using the Jet Ole DB Provider that is what you should be using not ODBC 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: Patrick Ryan: "Re: TClientDataSet, TADOTable & "INSERT INTO" SQL error"

    Relevant Pages

    • Problems saving MemoText (over 255 chars) into ACCESS2000
      ... I am facing the problem of saving the memo text into an Access table. ... How could I save text into the memo field when text is over 255 chars? ...
      (borland.public.delphi.database.ado)
    • Re: Return after AppActivate
      ... the program being automatically shutdown at midnight every night, ... responsible for saving their own work. ... Any losses due to a ... In my company, that memo better come from the CEO himself, ...
      (microsoft.public.scripting.wsh)
    • Re: Looking to download vocie mail message(s) to my PC
      ... I have been saving and resaving some irreplaceable voice mail messages ... Starting the phone's built in memo recorder ... Playing the voicemail which the phone recorded beautifully ... I have a conector that i can hook up to the headset port on the phone and i ...
      (alt.cellular.verizon)
    • Re: Looking to download vocie mail message(s) to my PC
      ... I have been saving and resaving some irreplaceable voice mail messages ... Starting the phone's built in memo recorder ... Playing the voicemail which the phone recorded beautifully ... I have a conector that i can hook up to the headset port on the phone and i ...
      (alt.cellular.verizon)
    • Re: Problem with memo field in query
      ... In this field are 500 chars. ... query it pulls only the first 255 chars from the field and omits the rest. ... This usually happens when you Sort or Group by the memo field. ... won't attempt to sort records on the basis of a memo field (which, ...
      (microsoft.public.access.queries)