Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

datetime retrieval arguments

3 posts in PB Infomaker Report Writer Last posting was on 1999-05-13 13:32:50.0Z
Jorge Rampinini Posted on 1999-04-30 21:41:55.0Z
Newsgroups: sybase.public.infomaker.general
Date: Fri, 30 Apr 1999 18:41:55 -0300
From: Jorge Rampinini <jorger@rionet.rionegro.com.ar>
Reply-To: jorger@rionet.rionegro.com.ar
Organization: Editorial Río Negro
X-Mailer: Mozilla 4.03 [es] (Macintosh; I; PPC)
MIME-Version: 1.0
Subject: datetime retrieval arguments
Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353"
Content-Transfer-Encoding: 7bit
Lines: 14
Message-ID: <348_372A239A.CA4F4A16@rionet.rionegro.com.ar>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6381
Article PK: 241368

Hello,
i am working in my first report that use two retrieval arguments:
firstdate and lastdate, in order to show rows between dates.
When i run the report and i put f.e

firstdate: 26/04/99
lastdate: 30/04/99

infomaker only report the rows between days 26 and 29.

In the query i see:

select
.......
from
.......

where [ mydatetimefield >= :firstdate] AND
[ mydatetime <= :lastdate ]

i m usign infomaker 5.0.2 under windows 95 and Microsoft sqlserver 6.5
under NT 4.0.

any suggestions ?

T.I.A


Ewa MN. Posted on 1999-05-13 13:32:50.0Z
Newsgroups: sybase.public.infomaker.general
Date: Thu, 13 May 1999 09:32:50 -0400
From: "Ewa MN." <knowacz_NoSpam@Angelfire.com>
Reply-To: knowacz@angelfire.com
Organization: somewhere in the bush
X-Mailer: Mozilla 3.0Gold (Win95; I)
MIME-Version: 1.0
Subject: Re: datetime retrieval arguments
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 20
Message-ID: <348_373AD482.739C@Angelfire.com>
References: <348_372A239A.CA4F4A16@rionet.rionegro.com.ar>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6336
Article PK: 241324


Jorge Rampinini wrote:
>
> In the query i see:
>
> select
> .......
> from
> .......
>
> where [ mydatetimefield >= :firstdate] AND
> [ mydatetime <= :lastdate ]
>
> i m usign infomaker 5.0.2 under windows 95 and Microsoft sqlserver 6.5
> under NT 4.0.
>

Hello,
Due to the fact that some users don't know which format may be used to
enter date type parameter, I always use the conversion function so your
example would look similar to the following:
... where ( to_char(mydatetimefiled,'YYYY/MM/DD') >=: firstdate)
and ( to_char(mydatetime,'YYYY/MM/DD') <=: lastdate)

At least you will have the control over user's input and it should work.
Of course retrieval parameters are declared as string.
Hope this helps!
Greetings,
Eva


Terry Dykstra Posted on 1999-04-30 22:00:22.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: datetime retrieval arguments
Date: Fri, 30 Apr 1999 16:00:22 -0600
Lines: 56
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_rAe5FR1k#GA.226@forums.sybase.com>
References: <348_372A239A.CA4F4A16@rionet.rionegro.com.ar>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6380
Article PK: 241364

I think you are getting caught by the time part. Behind the scenes IM is
probably setting a default time part that is larger than the timepart on any
of your records. The best way to verify that is to set a trace: on the
db-profile add the word trace in from of the dbms parameter, e.g. 'trace
odbc'. Look at the pbtrace.log file that will be generated.

If you are using ODBC, you can try customizing the file
...\sys32\pbodb050.ini. Look for the following section:
[DEFAULT_DATETIME]
PBDateFmt=''{d '\'yyyy-mm-dd\'' }''
PBTimeFmt=''{t '\'hh:mm:ss\''}''
PBDateTimeFmt=''{ts '\'yyyy-mm-dd hh:mm:ss.ffffff\''}'' <==== This is the
default value IM will use. Try removing the time portion. Backup your file
before making any changes!!

Alternatively, you might want to try using a date retrieval argument instead
of the datetime.

I strongly recommend upgrading to IM 5.0.04, since it contains quite a few
bug fixes. You can download it from
http://support.sybase.com/esd/pb_win_maint_5004.html

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Jorge Rampinini wrote in message
<372A239A.CA4F4A16@rionet.rionegro.com.ar>...
>Hello,
>i am working in my first report that use two retrieval arguments:
>firstdate and lastdate, in order to show rows between dates.
>When i run the report and i put f.e
>
>firstdate: 26/04/99
>lastdate: 30/04/99
>
>infomaker only report the rows between days 26 and 29.
>
>In the query i see:
>
>select
>.......
>from
>.......
>
>where [ mydatetimefield >= :firstdate] AND
>[ mydatetime <= :lastdate ]
>
>i m usign infomaker 5.0.2 under windows 95 and Microsoft sqlserver 6.5
>under NT 4.0.
>
>any suggestions ?
>
>T.I.A
>