For many years I've used a function SelfMakeMemoryTable in conjunction with the persistent fields I've defined for a TDBISAMTable and now TEDBTable to create the table in memory.

Now I've hit a point where I want to specify the case sensitivity of a varchar field and I can see no way of entering the data in the IDE into the field definitions. If there's anyone out there brighter than me please tell me where.

Roy Lambert

Roy,

<< Now I've hit a point where I want to specify the case sensitivity of a
varchar field and I can see no way of entering the data in the IDE into the
field definitions. If there's anyone out there brighter than me please tell
me where. >>

Welcome to the world of trying to fit anything more than basic information
in the TFieldDefs.  You've found the origin of the TDBISAMFieldDefs in
DBISAM, and why we removed this type of architecture in EDB and stopped
using it for metadata creation, etc.

The quick answer is: there's no place to surface that information for the
TFieldDefs.  Check out edbreverse.pas that comes with the EDB Manager source
code to see code that will generate SQL for an existing table.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>The quick answer is: there's no place to surface that information for the
>TFieldDefs.

That's what I thought, but I've just realised I might be able to use the Tag. I don't think I've ever used a fields tag property with a memory table, and only rarely for a disk table. Or Possibly the CaseInsFields in the IndexDefs. The latter places a bit of a restriction but since its only for in-memory tables I think it will work.

Roy Lambert