Post reply

DELPHI BDE CONNECTION TO SQL

  • November 28, 2003 at 4:09 am

    #65580

    When I update a column in SQL defined as TEXT with a string longer than 255, the update converts to a couple of special characters, instead of the long description. I am using an ODBC connection with the Borland DataBase Engine. I have tried using varchar (1500) which works in Oracle and Interbase, but not in SQL. Can you help?

  • November 30, 2003 at 10:29 am

    #484053

    I've seen something similar when working with BDE, setting the blob size to a higher number in the BDE worked for me.

    HTH

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • December 2, 2003 at 12:35 am

    #484218

    Delphi treats TEXT fields as ftMemo. Try setting FieldType to ftString manually. Also, I agree with the provious suggestion about higher BLOB SIZE value.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply