| Subject | Re: Filtering records that fall into a date range recorded in the settings table |
|---|---|
| Author | venussoftop |
| Post date | 2009-08-26T10:57:31Z |
Hi Doug
Thanks a lot this has resolved the problem for me.
The uSettings has the following structure to help me emulate an (improvised) INI file for application framework purposes:
iID - Integer - PK
iPID - Integer - FK to self
cKey - Char(30) - eg. Current Year, From, To
cValueType - Char(1) - C, D, L for internal application use meaning Character, Date, Logical
dValue - Date - date value
lValue - SmallInt - 1 or 0 used as a logical value in the application
Kind regards
Bhavbhuti
Thanks a lot this has resolved the problem for me.
The uSettings has the following structure to help me emulate an (improvised) INI file for application framework purposes:
iID - Integer - PK
iPID - Integer - FK to self
cKey - Char(30) - eg. Current Year, From, To
cValueType - Char(1) - C, D, L for internal application use meaning Character, Date, Logical
dValue - Date - date value
lValue - SmallInt - 1 or 0 used as a logical value in the application
Kind regards
Bhavbhuti
--- In firebird-support@yahoogroups.com, Doug Chamberlin <dougchamberlin@...> wrote:
> I would change this to