I have been trying to make use of the MS SQL Server 7.0 enhancement which
allows you to have Varchar fields of up to 8000 characters. However, when I
try to update the field, it corrupts the data into what appear to be various
formatting characters (e.g.: |?d # ).
I am not using cached updates, but hardcoding the SQL statement in my code,
thus:

     with quUpdateData do begin
        if active then close;
        SQL.clear;
        SQL.Add('update ContactMade set ');
        SQL.add('Notes = :notes, status = :status ');
        SQL.add('where ContactMade_ID = :OLD_ContactMade_ID');
        ParamByName('Notes').asString :=
Request.ContentFields.Values['CurrentNotes']
         + '; ' + Request.ContentFields.Values['NewNotes'] + ' '
         + Request.CookieFields.Values['Username'] + ' ' + dateToStr(Date);
        ParamByname('Status').asString :=
Request.ContentFields.Values['radioaction';
        ParamByName('OLD_ContactMade_ID').asInteger :=
StrToInt(request.ContentFields.Values['contactmade_id']);
        ExecSQL;
     end;

Is this something to do with the BDE?

Peter Tickler
ptick...@potato.org.uk

Use a TTable instead.

Jimb

news:3a34c449_1@dnews...

BDE relies upon MS  dbLib to interface with SQL 7.

MS is no longer maintaining dbLib.

Therefore, the BDE does not support the enhancements for SQL 7.

You must use ADO for these features.

=Bill

Never use TTables against a SQL server.  William of TeamB has the correct
solution.

Good luck,
krf