View Single Post
Old 03-31-2001, 01:24 AM
phear phear is offline
Senior Member
Join Date: Mar 2001
Posts: 325
Default RE: RE: RE: (MEMO) in DBGrid

there are two ways of avoiding this, the first one is to make a CAST in SQL to return the field to the type you want : CAST is an SQL Server function, check if it's available in your database.

the second way : remove all fields from field editor and re-add all fields -> delphi gets all the fields with the correct types. if you still have a (MEMO) in your grid, it comes from the fact that the type of that field is not meant to be displayed in a DBGrid : TMemoField has line breaks so it's not meant to be displayed in the cell of a DBGrid. use TDBMemo instead or change the type of your field in your database.
Reply With Quote