Board index » delphi » Invalid Field Type for nchar and nvarchar data types

Γεωργ?πουλο? Γε?ργιο

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Invalid Field Type for nchar and nvarchar data types

    Hello guys,
                    I am just trying to create a sample application in
order to view Northwind database, using Delphi 4. I use an alias, I get
connected, but when I try to activate the TTable object I get a message
"Invalid Field Type". I do not get this message with all the other
non-Unicode data types (I created a table that did not contain Unicode
strings!). How can I solve this problem?
 
Alain Quesne

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Invalid Field Type for nchar and nvarchar data types


The only way to solve it is to use something else than the BDE to connect to
SQL Server 7 (ADO, for instance) or not use unicode field types. Microsoft
has no intention of updating the dll that the BDE depends on.

--

Alain Quesnel

P.S.: remove the [brackets] from my address when replying by e-mail.

Quote
????e???? ??t??? <macs...@compulink.gr> wrote in message

news:3816B28A.88C93378@compulink.gr...
Quote
>     Hello guys,
>                     I am just trying to create a sample application in
> order to view Northwind database, using Delphi 4. I use an alias, I get
> connected, but when I try to activate the TTable object I get a message
> "Invalid Field Type". I do not get this message with all the other
> non-Unicode data types (I created a table that did not contain Unicode
> strings!). How can I solve this problem?

jkaraki

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Invalid Field Type for nchar and nvarchar data types


?,
? Delphi 5, ? Delphi 4 ADO add-on.
? ?? ? ? ? ? ?? ??
Unicode - fields.
?
.?? - ??
Quote
?? ?? wrote:
>     Hello guys,
>                     I am just trying to create a sample application in
> order to view Northwind database, using Delphi 4. I use an alias, I get
> connected, but when I try to activate the TTable object I get a message
> "Invalid Field Type". I do not get this message with all the other
> non-Unicode data types (I created a table that did not contain Unicode
> strings!). How can I solve this problem?

Other Threads

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

2. Help - Invalid Field Type - New Field Types?

3. MSSQL 7.0 nchar Data type

4. Fields nchar & nvarchar in SQL Server

5. Money field type same as Currency data type??

6. IDE field types vs. IB6 data type

7. Delphi and NVARCHAR data type

8. MSSQL7 / NVARCHAR type of field

9. datetime data type to smalldatetime data type conversion error

10. datetime data type to smalldatetime data type conversion error