DBISAM 4 latest, D7 Professional

I am trying to set a table filter using something like:

tblEvents.Filter :=  '(Start >= '+ DateTimeToAnsiStr(Now());

Start is a time stamp. I may be missing the Uses clause for the ansi string
statement but don't know as my help is not available for some reason.
Thanks, Sean

Sean


Try prefacing it with Engine (its one if the TDBISAMEngine methods)

Roy Lambert

Thanks, Roy, it comes back with an error saying this form of method call is
only allowed for class methods???

tblEvents.Filter :=  '(Start >= '+ tdbisam.DateTimeToAnsiStr(Now());



"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:DEE16976-8415-47A4-983E-572A6F160D49@news.elevatesoft.com...
> Sean
>
>
> Try prefacing it with Engine (its one if the TDBISAMEngine methods)
>
> Roy Lambert
>

Hey Sean:

try this:
  uses
    dbisamtb;

  tblEvents.Filter :=  '(Start >= '+ engine.DateTimeToAnsiStr(Now());

Ralf

Sean McDermott schrieb:
> Thanks, Roy, it comes back with an error saying this form of method call is
> only allowed for class methods???
>
> tblEvents.Filter :=  '(Start >= '+ tdbisam.DateTimeToAnsiStr(Now());
>
>
>
> "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
> news:DEE16976-8415-47A4-983E-572A6F160D49@news.elevatesoft.com...
>> Sean
>>
>>
>> Try prefacing it with Engine (its one if the TDBISAMEngine methods)
>>
>> Roy Lambert
>>
>
>

Thanks Ralf, I will try this. I am away today but back tomorrow, many
thanks, Sean

--
==============================
Sean M. McDermott
Horizon Systems Group Inc.
Suite 301, 11 Portland Street
Dartmouth, Nova Scotia B2Y 1H1

902.463.8308
902.463.8951 (fax)
866.606.8308 (toll free)

Visit us at: www.HorizonCanada.com

"Ralf Graap" <r.graap@gmx.de> wrote in message
news:0B687AB0-41B8-4071-8D26-EE3BC9694ACD@news.elevatesoft.com...
> Hey Sean:
>
> try this:
>   uses
>     dbisamtb;
>
>   tblEvents.Filter :=  '(Start >= '+ engine.DateTimeToAnsiStr(Now());
>
> Ralf
>
> Sean McDermott schrieb:
>> Thanks, Roy, it comes back with an error saying this form of method call
>> is only allowed for class methods???
>>
>> tblEvents.Filter :=  '(Start >= '+ tdbisam.DateTimeToAnsiStr(Now());
>>
>>
>>
>> "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
>> news:DEE16976-8415-47A4-983E-572A6F160D49@news.elevatesoft.com...
>>> Sean
>>>
>>>
>>> Try prefacing it with Engine (its one if the TDBISAMEngine methods)
>>>
>>> Roy Lambert
>>>
>>

how about:
tblEvents.Filter :=  'Start >= '+#9+DateTimeToAnsiStr(Now())+#9;


"Sean McDermott" <Sean@HorizonCanada.com> wrote in message
news:E1F2FAA4-2434-4B3F-B20F-5BD9969B439C@news.elevatesoft.com...
> DBISAM 4 latest, D7 Professional
>
> I am trying to set a table filter using something like:
>
> tblEvents.Filter :=  '(Start >= '+ DateTimeToAnsiStr(Now());
>
> Start is a time stamp. I may be missing the Uses clause for the ansi
> string
> statement but don't know as my help is not available for some reason.
> Thanks, Sean
>
>

correction not #9, but #39 which is a single quote to enclose the date
tblEvents.Filter :=  'Start >= '+#39+DateTimeToAnsiStr(Now())+#39;


"GP" <gp@usa.com> wrote in message
news:DBF1F9DF-9203-4A24-A19A-6E76BB875A1D@news.elevatesoft.com...
> how about:
> tblEvents.Filter :=  'Start >= '+#9+DateTimeToAnsiStr(Now())+#9;
>
>
> "Sean McDermott" <Sean@HorizonCanada.com> wrote in message
> news:E1F2FAA4-2434-4B3F-B20F-5BD9969B439C@news.elevatesoft.com...
>> DBISAM 4 latest, D7 Professional
>>
>> I am trying to set a table filter using something like:
>>
>> tblEvents.Filter :=  '(Start >= '+ DateTimeToAnsiStr(Now());
>>
>> Start is a time stamp. I may be missing the Uses clause for the ansi
>> string
>> statement but don't know as my help is not available for some reason.
>> Thanks, Sean
>>
>>
>
>

Will  try, thanks. Currently I am using:

DateString := FormatDateTime('yyyy-mm-dd',StrToDateTime(DatetoStr(NOW)));
   tblEvents.Filter:='(Start >=' +QuotedStr(DateString)+')';
   tblEvents.Filtered:=True;
   tblEvents.Open;

Which works fine, just lacks some elegance

Thanks, Sean

"GP" <gp@usa.com> wrote in message
news:FC5A1519-BB95-427D-AED1-CE8687750C01@news.elevatesoft.com...
> correction not #9, but #39 which is a single quote to enclose the date
> tblEvents.Filter :=  'Start >= '+#39+DateTimeToAnsiStr(Now())+#39;
>
>
> "GP" <gp@usa.com> wrote in message
> news:DBF1F9DF-9203-4A24-A19A-6E76BB875A1D@news.elevatesoft.com...
>> how about:
>> tblEvents.Filter :=  'Start >= '+#9+DateTimeToAnsiStr(Now())+#9;
>>
>>
>> "Sean McDermott" <Sean@HorizonCanada.com> wrote in message
>> news:E1F2FAA4-2434-4B3F-B20F-5BD9969B439C@news.elevatesoft.com...
>>> DBISAM 4 latest, D7 Professional
>>>
>>> I am trying to set a table filter using something like:
>>>
>>> tblEvents.Filter :=  '(Start >= '+ DateTimeToAnsiStr(Now());
>>>
>>> Start is a time stamp. I may be missing the Uses clause for the ansi
>>> string
>>> statement but don't know as my help is not available for some reason.
>>> Thanks, Sean
>>>
>>>
>>
>>
>
>