Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Associated statement is not prepared
Message
De
07/12/2012 15:48:07
 
 
À
07/12/2012 15:43:33
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01559065
Message ID:
01559089
Vues:
47
>>>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

Show me the VFP code, please.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform