Re: ADO exception with character combination inside string...

From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
Date: Wed, 20 Sep 2006 22:16:20 -0500

procedure TForm1.btnModifyClick(Sender: TObject);
var
SQLString: string;
begin
try
SQLString := 'UPDATE Categories SET [Description] = ''' +
edData.Text + ''' WHERE CategoryID = 4';

use the QuotedStr function

SQLString := 'UPDATE Categories SET [Description] = '
+QuotedStr(edData.Text) + ' WHERE CategoryID = 4';
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Follow-Ups:
- Re: ADO exception with character combination inside string...
  - From: Bo Berglund

References:
- ADO exception with character combination inside string...
  - From: Bo Berglund
- Re: ADO exception with character combination inside string...
  - From: Bo Berglund

Prev by Date: Re: ADO exception with character combination inside string...
Next by Date: Re: Proper way of using ctDynamic cursortype on network with MS Access
Previous by thread: Re: ADO exception with character combination inside string...
Next by thread: Re: ADO exception with character combination inside string...
Index(es):
- Date
- Thread