Page 1 of 1

Delphi 6 SQL Server 8 returns (MEMO)

Posted: Fri 25 Sep 2009 22:54
by oldbitman
When I use Universal Data Access Components Demo (Copyright 1997 - 2009) with Delphi 6 to Query a table, all of the fields that are 'text', show up as '(MEMO)". This is using 2.70.0.9 24-Jun-09 of your components.
Am I missing something obvious. It works fine with MySQL and I used the Sobolsoft MySQK to MS SQL Server to port the data over.

Thanks

Posted: Mon 28 Sep 2009 09:04
by Dimon
SDAC and UniDAC for the text and varchar(max) SQL types create the TMemoField field type, because SQL Server returns the field type equal to ftMemo Delphi type for these fields.