Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-06-28 : 10:02:02
|
I have a problem with Text fields and the way they represent data in my App (which is Access 97 based)Data is put into a text field using a stored procedure which does this - Create procedure MyProcASDECLARE @sToday datetimeSET @sToday = getdate()DECLARE @EOL varchar(4) -- end of line markersSET @EOL = CHAR(10) + CHAR(13)SET @Updates = 'Data created ' + @sTODAY + @EOL + ' by user ' + ISNULL(@CURRENTUSER, 'Indeterminate') + @EOL + <Some other stuff> @UPDATES is then put into a SQL Server TEXT field called UPDATESThat all works fine. My problem is that when I look at the updates field from the app. (in a memo object, not sure if this is a 'standard' object but the prinicple should still apply) instead of a line feed and a carriage return I get spurious characters and it all appears on one line and my poor little users can't cope  Anyone have any bright ideas?Many thankssteveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
|
|
|
|
|
Not SMS