Delphi4, MSSQL server7, UpdateSQL and memo fields problem

JableSoft

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Delphi4, MSSQL server7, UpdateSQL and memo fields problem

I'm using the adonis3.5 component suite to access to MSSQL server7 with
Delphi 4. And all works fine except than when I need to use an UpdateSQL
component. If one of the UpdateSQL params is a memo field (i.e. 'UPDATE
Customres SET Name = :Name, Description = :Description WHERE ID = :ID'
description is the memo field) then an error is generated. If I remove this
field from the senteces of the UpdateSQL, then it works( i.e. 'UPDATE
Customres SET Name = :Name WHERE ID = :ID').

Can Anybody tell me the way to update the memofields when I need to use
an UpdateSQL?

Thanks in advence. Rafa.

Shahram Sadegh

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Delphi4, MSSQL server7, UpdateSQL and memo fields problem

I do not use Adonis, but I came across a similar problem before. I have
two suggestions that have helped us before.

1) If you are using NTEXT for the type of your memo fields, and you do
not need the international characters, change the type of your memo
field to TEXT instead.

2) Try to put the memo fields as the last field in your Customers table.

Hope at least one of these helps.

Shahram Sadeghi

Quote

JableSoft wrote:

> I'm using the adonis3.5 component suite to access to MSSQL server7 with
> Delphi 4. And all works fine except than when I need to use an UpdateSQL
> component. If one of the UpdateSQL params is a memo field (i.e. 'UPDATE
> Customres SET Name = :Name, Description = :Description WHERE ID = :ID'
> description is the memo field) then an error is generated. If I remove this
> field from the senteces of the UpdateSQL, then it works( i.e. 'UPDATE
> Customres SET Name = :Name WHERE ID = :ID').

> Can Anybody tell me the way to update the memofields when I need to use
> an UpdateSQL?

> Thanks in advence. Rafa.

Shahram Sadegh

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Delphi4, MSSQL server7, UpdateSQL and memo fields problem

I do not use Adonis, but I came across a similar problem before. I have
two suggestions that have helped us before.

1) If you are using NTEXT for the type of your memo fields, and you do
not need the international characters, change the type of your memo
field to TEXT instead.

2) Try to put the memo fields as the last field in your Customers table.

Hope at least one of these helps.

Shahram Sadeghi

Quote

JableSoft wrote:

> I'm using the adonis3.5 component suite to access to MSSQL server7 with
> Delphi 4. And all works fine except than when I need to use an UpdateSQL
> component. If one of the UpdateSQL params is a memo field (i.e. 'UPDATE
> Customres SET Name = :Name, Description = :Description WHERE ID = :ID'
> description is the memo field) then an error is generated. If I remove this
> field from the senteces of the UpdateSQL, then it works( i.e. 'UPDATE
> Customres SET Name = :Name WHERE ID = :ID').

> Can Anybody tell me the way to update the memofields when I need to use
> an UpdateSQL?

> Thanks in advence. Rafa.

Other Threads

1. HELP! UpdateSQL can not work with memo field

2. problem upsizing pdox memo fields to mssql

3. UpdateSQL and MSSQL Problem

4. Memory leak with Delphi4 Tquery, BDE 5.10(OR 5.11), SQL SERVER7

5. Memory leak with Delphi4 Tquery, BDE 5.10(OR 5.11), SQL SERVER7

6. Anyone using delphi4 and MSSQL 7 without problems?????

7. Problem to open a query in Delphi4 for MSSQL server 7.0

8. Cached Updates & MSSQL 6.0 Memo fields

9. MSSQL 6.0 and 6.5 and TDBMEMO field report (Memo too Large)

10. How to save memo.lines.text into a varchar 4000 field on MSSQL 7