MSSQL 7.0 nchar Data type

Monzer Yazigi

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

MSSQL 7.0 nchar Data type

Hi all,
I'm using MSSQL 7.0 Database server in my development with
Delphi 5.0
The problem I'm facing is that when I use a table that contains a
field of type nchar I get an error message says "Invalid Field Type".

Any comments please?

Monzer Yazigi

Alain Quesne

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:MSSQL 7.0 nchar Data type

You cannot use fields of type nchar, nvarchar or ntext with the BDE. If you
must use fields of those types, then you have to use ADO (ADO Express or
Adonis, to name those two) to connect to your database.

Alain Quesnel
cinqsanss...@compuserve.com

-----

Quote

Monzer Yazigi <mon...@kems.net> wrote in message

news:2ue3fs049gt74qmioq18ahntqk645q7su6@4ax.com...

Quote

> Hi all,
> I'm using MSSQL 7.0 Database server in my development with
> Delphi 5.0
> The problem I'm facing is that when I use a table that contains a
> field of type nchar I get an error message says "Invalid Field Type".

> Any comments please?

> Monzer Yazigi

Monzer Yazig

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:MSSQL 7.0 nchar Data type

Dear Alain
Thanks for your help. But can I ask one more request.?
Can you give me some more help about how to use ADO with
BDE?

Thanks
Monzer George Yazigi

On Mon, 10 Apr 2000 21:51:39 -0700, "Alain Quesnel"

Quote

<cinqnos...@compuserve.com> wrote:
>You cannot use fields of type nchar, nvarchar or ntext with the BDE. If you
>must use fields of those types, then you have to use ADO (ADO Express or
>Adonis, to name those two) to connect to your database.

Liping Ga

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:MSSQL 7.0 nchar Data type

I also want to know this. Any components( or VCL) for this?
Thanks in advance for any info.

Liping Gao

Quote

Monzer Yazigi wrote:
> Dear Alain
> Thanks for your help. But can I ask one more request.?
> Can you give me some more help about how to use ADO with
> BDE?

> Thanks
> Monzer George Yazigi

> On Mon, 10 Apr 2000 21:51:39 -0700, "Alain Quesnel"
> <cinqnos...@compuserve.com> wrote:

> >You cannot use fields of type nchar, nvarchar or ntext with the BDE. If you
> >must use fields of those types, then you have to use ADO (ADO Express or
> >Adonis, to name those two) to connect to your database.

Alain Quesne

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:MSSQL 7.0 nchar Data type

ADO and BDE are mutually exclusive. You connect to MSSQL with either one but
not both. Connecting with ADO means installing MDAC on the target machines
(unless it is already there; MSIE5, MS Office 2000 and Windows 2000 install
it), and using the ADO components in your Delphi app. No need to deploy the
BDE on the target machines.

Alain Quesnel
cinqsanss...@compuserve.com

-----

Quote

Monzer Yazigi <mon...@kems.net> wrote in message

news:lfo5fssd8h201ufkerrj64um5c7sdnqhge@4ax.com...

Quote

> Dear Alain
> Thanks for your help. But can I ask one more request.?
> Can you give me some more help about how to use ADO with
> BDE?

> Thanks
> Monzer George Yazigi

> On Mon, 10 Apr 2000 21:51:39 -0700, "Alain Quesnel"
> <cinqnos...@compuserve.com> wrote:

> >You cannot use fields of type nchar, nvarchar or ntext with the BDE. If
you
> >must use fields of those types, then you have to use ADO (ADO Express or
> >Adonis, to name those two) to connect to your database.

Other Threads

1. Invalid Field Type for nchar and nvarchar data types (I am using SQL Server 7.0)

2. Invalid Field Type for nchar and nvarchar data types

3. Mssql 7.0 new data type,Delphi filter error

4. MSSQL 7.0 Field Types

5. How use new types in MSSQL 7.0 ?

6. How to save Blob data into MSSQL server version 7.0

7. Help creating a MSSQL 7.0 data base using SQLDMO OLE objects

8. MSSQL 6.5 SP3 and Image Data Type

9. how get all USER DEFINED DATA TYPE from MSSQL 2000 DB

10. Text data type MSSQL