Allen Harkleroad - Microsoft MVP
|
| Posted: 09/06/2002, 7:22 AM |
|
I have a problem that is driving me insane. I have an app I created
(database front-end) that runs fine on my SQL servers. I put it out for
general beta testing and several testers are getting an error (converting
text to ntext).
The problem I believe is the form field is text and the SQL field is
nvarchar), the error says error converting text to ntext (but the field on
the server is nvarchar.
Am I correct that on that form control (text box) I just specify nvarchar in
the DBformat properties or is there another way or workaround (other than
changing the database field to text)?
Many thanks for any and all suggestions, and also thanks to code charge for
such a great and productive tool.
Allen
--
Allen Harkleroad
Microsoft MVP
1996 to present
"please keep replies in the newsgroup
so others can benefit, email requests will
be ignored"
Spammers can send email to:
blockme@relays.osirusoft.com
(if you want to be added to the black list)
|
|
|
 |
donb
|
| Posted: 09/06/2002, 8:11 AM |
|
DBformat is a formatting-string specification - "nvarchar" should not be
entered there. This property will be set to something like "mm-dd-yyyy" if
the database format is a date. I have yet to need to use this in an app - I
leave it blank and set the Datatype property to Text, Date, Boolean, as
appropriate. For SQL Server, the app should not need to be aware of varchar
or nvarchar in the table design
don
"Allen Harkleroad - Microsoft MVP" <allenharkleroad@spamcop.net> wrote in
messagenews:aladnc$ffj$1@news.codecharge.com...
> I have a problem that is driving me insane. I have an app I created
> (database front-end) that runs fine on my SQL servers. I put it out for
> general beta testing and several testers are getting an error (converting
> text to ntext).
>
> The problem I believe is the form field is text and the SQL field is
> nvarchar), the error says error converting text to ntext (but the field on
> the server is nvarchar.
>
> Am I correct that on that form control (text box) I just specify nvarchar
in
> the DBformat properties or is there another way or workaround (other than
> changing the database field to text)?
>
> Many thanks for any and all suggestions, and also thanks to code charge
for
> such a great and productive tool.
>
> Allen
>
> --
> Allen Harkleroad
> Microsoft MVP
> 1996 to present
>
> "please keep replies in the newsgroup
> so others can benefit, email requests will
> be ignored"
>
>
> Spammers can send email to:
>blockme@relays.osirusoft.com
> (if you want to be added to the black list)
>
>
|
|
|
|
|
