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

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


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';

Tried this but the exception now is:

Line 1: Incorrect syntax near '='

when my string is 'SET TEST="TNC:\CHARLIE"'

/Bo
.

Relevant Pages

  • RE: Detailed ASP.Net info not displaying in browser
    ... HTTP 500 page when an exception is thrown from the web service. ... at VOSE.Data.DataRequest.dr_DB2Process.DeleteCommRows(String company, String ... objQueue, tOrderManagementIndicator omindicator, Int32 intTriggerId) in ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.xml)
  • RE: Detailed ASP.Net info not displaying in browser
    ... HTTP 500 page when an exception is thrown from the web service. ... at VOSE.Data.DataRequest.dr_DB2Process.DeleteCommRows(String company, String ... objQueue, tOrderManagementIndicator omindicator, Int32 intTriggerId) in ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.xml)
  • Re: App_data - ASPNETDB.MDF
    ... is only because I want my site work, without exception. ... Server Error in '/' Application. ... serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Could not load file or assembly...
    ... The problem shows when EL exception handling ... context, ExceptionHandlerData objectConfiguration, IConfigurationSource ... configurationSource, ConfigurationReflectionCache reflectionCache) ... context, String name, IConfigurationSource configurationSource, ...
    (microsoft.public.dotnet.framework)
  • Re: Error handling not working
    ... Dim exception As Exception = Server.GetLastError.GetBaseException ... Dim ErrorString as String ... GetBaseException retrieves the "real" innerException object. ... CustomErrors in my webconfig file: ...
    (microsoft.public.dotnet.framework.aspnet)