Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Associated statement is not prepared
Message
De
07/12/2012 15:43:33
 
 
À
07/12/2012 15:28:20
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01559065
Message ID:
01559087
Vues:
43
>>Why not change the chr(13)? The issue is that SQL eats the chr(13) and I need the line breaks to be as entered, so I change it 1) to something that I wouldn't use usually, and 2) something that HTML would understand, since certain records get exported for HTML display.
>
>They are entered just you didn't see them with SSMS. hides these chars.
>I don't know why, maybe the grid control used to show data has this behavior, but the line break is there.

Not so far as I've noticed, when I bring it back and do AT(chr(13), script) it returns 0 and display (editbox) shows no line breaks
>
>>As far as the 'True' vs .t., SQL, at least our set up, doesn't like/understand .t. being passed in.
>
>Then maybe you use Char fields not BIT one?

Nope, defined as BIT - but none of this explains the error. All of this was in place before I started getting this S1007 error
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform