Database Adapter Integration Issues with ElevateDB

FNC TMS FNC Gantt Chart
1

Hi team,

Thank you for developing the Database Adapter. We've successfully tested your demo and attempted to integrate it with our ElevateDB by creating a database table for testing purposes.

However, we've encountered a few issues:

  • Sometimes double-clicking on a task opens it, but other times it doesn't.
  • We're unable to modify the date/time fields using your date picker.

Could you please review our table structure? It's possible we might have misconfigured something.

CREATE TABLE "PROJEKTE_DETAILS" (
"mindex" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1),
"projekt_mindex" INTEGER,
"vWBS" VARCHAR(32) COLLATE "UNI_CI",
"vName" VARCHAR(255) COLLATE "UNI_CI",
"vDescription" CLOB COLLATE "UNI_CI",
"vPlannedStart" TIMESTAMP,
"vPlannedEnd" TIMESTAMP,
"vDuration" VARCHAR(10) COLLATE "UNI_CI",
"vDependencies" VARCHAR(20) COLLATE "UNI_CI",
"vProgress" INTEGER,
"vStatename" VARCHAR(255) COLLATE "UNI_CI",
CONSTRAINT "MINDEX" PRIMARY KEY ("mindex")
)
2

Hello,
We are not able to simulate the double-clicking issue at the moment.

For your question regarding the database.
First, it is not necessary to have the PlannedEnd and the Duration in the database as it only uses one of them.
(Duration is advised if you start working with the Gantt Chart and have no other applications needing the end time. This is the EndTimeType property in the DatabaseAdapter.)

For the problem related to the datetime fields, you might check the timestamp type.
In the databaseadapter, the date is stored with the internal AsDateTime functionality in Delphi. It might be possible that this has a conflict with the Timestamp field in ElevateDB.
With the OnSetFieldFromTaskPlannedStart/OnSetTaskPlannedStartFromField (and also for end time) events, you can manipulate the data from the database to get it converted correctly to a Delphi TDateTime.