Any kind individual able to let me have a simple (or complex) project showing how to link the TMS DBPlanner to a DBISAM table using a TDBDisjunctDaySource

I'm going round the bend here.

Roy Lambert

Roy Lambert <roy.lambert@skynet.co.uk> wrote in
news:992D36CA-E79B-4F98-B54C-A22CA86B9805@news.elevatesoft.com:

> Any kind individual able to let me have a simple (or complex) project
> showing how to link the TMS DBPlanner to a DBISAM table using a
> TDBDisjunctDaySource
>
> I'm going round the bend here.

Sorry, Roy, I only bought the AdvString Grid so I can't help with this one.

Good luck.
--
Chris
(XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.04 build 3)

Hi Roy,

As in the help manual (TMS) you have to

- set active = false
- fil the dates in the array
- set the active to true

besides that, you have to connect the Datasource and to set the filter (
DBDisjunctDaySource1SetFilter event )

that filter event wil let you select in the TDBPlanner1 select the correct
records
for that , your database wil have to have the following fields:

StartTime (this is the date and the time on that date)
Endtime
Key

for the Key I use a GUID string ( defined as String 40)

In the Filter event I do a setrange, that's for me the quickest-result ( I
use a DBDaySource instead of a DBDisjunctDaySource1)
If you use a query for it, than (in our application) it's too slow in a
network envirmonment, but possibily quick enough for your database...

I unfortunately cannot show you our application-code in a simple way, it's
too complicated (the complete appl. is 15 mb, 700.000 lines of code with
about 200 different tables and runs on more than 1200 sites).
Eventually I can send you our dem-cd but it's without the code    and
besides , it is in dutch...

please aks, if you want more info !

regards

Erik





"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:992D36CA-E79B-4F98-B54C-A22CA86B9805@news.elevatesoft.com...
> Any kind individual able to let me have a simple (or complex) project
> showing how to link the TMS DBPlanner to a DBISAM table using a
> TDBDisjunctDaySource
>
> I'm going round the bend here.
>
> Roy Lambert