Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB Tools

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 03-26-2018, 06:40 PM
JoeC JoeC is offline
Junior Member
 
Join Date: Feb 2018
Location: Miami, FL
Posts: 4
Exclamation Delphi Berlin Firedac - Error when string has & and @ characters

I have a stored procedure that updates a string in a table.
It works from the management studio and it also works from a form in Delphi.
The only problem in Delphi is when one of the strings have the @ or & characters.
This is only a problem in Firedac, not in SQL.
I get this error message:
[Firedac][Phys][ODBC][Microsoft][SQL Native Client 11.0][SQL Server]String or binary data would be truncated.
Reply With Quote
  #2  
Old 03-27-2018, 07:30 AM
Norrit Norrit is offline
Moderator
 
Join Date: Aug 2001
Location: Landgraaf
Posts: 7,305
Default

"String or binary data would be truncated" is normally when you try to save a string that is too long.
For example, you try to store a string of length 50 in a db field with length 40
I doubt this has anything to do with the @ and & characters
Reply With Quote
  #3  
Old 03-27-2018, 06:08 PM
JoeC JoeC is offline
Junior Member
 
Join Date: Feb 2018
Location: Miami, FL
Posts: 4
Default

The fields are both 30 char. The controls are limited to 30 characters.
The program works fine and only raises the error when there are @ or & characters on one of the fields.
Reply With Quote
Reply

Tags
firedac, sqlserver, stored procedure

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:58 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2018, vBulletin Solutions, Inc.