[SOLVED]TbufDataSet and setting compound keys

[micoudic]

hi,
How to indicate keys (composed with 2 fields) in the bufdataset?
FYI, I use .dbf files and I was looking for a solution to be able to sort on calculated fields. I don't want to (can't) change everything to use an SQL database.
I rely on the bufdataset to display and update it, and I maintain my DBF tables in parallel.

The problem with bufdataset:
"Indexdefs" is grayed out in the IDE and cannot document "IndexName" and "IndexFileNames".
I tried this:
  on the "Indexdefs" line of the bufdataset, click on "..." and create an index by defining its name, its characteristics and the key fields,
then I document the "IndexName" property. The fields constituting the key are not displayed, and if I fill them in manually, everything disappears.
I tried to create this index by coding in my program.
The compilation runs fine, everything appears fine, but sorting on these keys does not work.
Thanks.

[Zvoni]

hi,
How to indicate keys (composed with 2 fields) in the bufdataset?
FYI, I use .dbf files and I was looking for a solution to be able to sort on calculated fields. I don't want to (can't) change everything to use an SQL database.
I rely on the bufdataset to display and update it, and I maintain my DBF tables in parallel.

The problem with bufdataset:
"Indexdefs" is grayed out in the IDE and cannot document "IndexName" and "IndexFileNames".
I tried this:
  on the "Indexdefs" line of the bufdataset, click on "..." and create an index by defining its name, its characteristics and the key fields,
then I document the "IndexName" property. The fields constituting the key are not displayed, and if I fill them in manually, everything disappears.
I tried to create this index by coding in my program.
The compilation runs fine, everything appears fine, but sorting on these keys does not work.
Thanks.

https://www.freepascal.org/docs-html/fcl/bufdataset/tcustombufdataset.indexdefs.html

IndexDefs is a read-only TIndexDefs property that contains the index definitions for the buffered dataset.

How to create an Index for a dbf
http://www.dbase.com/help/Local_SQL/IDH_LSQL_CREATEINDEX.htm

[micoudic]

Okay, I found a solution that works for me.
Thanks for the time spent

How do I mark the discussion "SOLVED"?

[Zvoni]

Okay, I found a solution that works for me.
Thanks for the time spent

How do I mark the discussion "SOLVED"?

„Modify“ your first post‘s subject line