Re: Btrive time fields in Crystal Report dont display properly

Hmmm. Data Type 4 is definitely a standard TIME field. This is a
4-byte field with single bytes used for the Hour, Minute, Second, and
Hundredth-second. Should be handled properly, unless Crystal
intentionally broke it.

I'd recommend following up with Crystal Support.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Sydney: Pervasive.SQL Service & Support Class - 02/27-03/02/2006
***
*** Chicago: Pervasive.SQL Service & Support Class - 03/27-03/30/2006
***


caterpillar wrote:

> Hi Bill,
> Thanks for the reply.
> When i run this query, the Xe$DataType is 4.
>
> This app was first developed in 1996, and we started with Smithware.
> We then followed all of the updates from Pervasive as they went
> through the "growing pains" of constant updates, where we finally
> stopped at 2000i. There were aparently some legal issues with
> Pervasive and Smithware/Crystal thet happened along the way.
>
> Is this data type Smithware? Can I do anything about it short of
> changing the ddf?
>
> -Bill Roman
>
>
> On Wed, 11 Jan 2006 17:06:12 -0600, "Bill Bach"
> <goldstar@xxxxxxxxxxxxx> wrote:
>
> > Are they TRUE Btrieve TIME fields, or are they an extended type of
> > TIME field from Smithware?
> >
> > To tell for sure, you can run this query:
> > SELECT X$Field.* FROM X$Field
> > INNER JOIN X$File ON Xe$File = Xf$Id
> > WHERE Xf$Name = 'tablename'
> > ORDER BY Xe$Offset
> >
> > Then, look for the fields you are checking on, and see what data
> > type is being reported therein.
> > Goldstar Software Inc.
> > Building on Btrieve(R) for the Future(SM)
> > Bill Bach
> > BillBach@xxxxxxxxxxxxxxxxxxxx
> > http://www.goldstarsoftware.com
> > *** Chicago: Pervasive.SQL Service & Support - March, 2006 ***
> > *** Chicago: Pervasive DataExchange Class - March, 2006 ***
> >
> > caterpillar wrote:
> >
> >> Hi all!,
> >> I have an app that uses Btrieve time fields, and is running
> >> PVSQL2000i.
> >> When I have the full version of Crystal 8.5 installed, the time
> fields >> display correctly. On my customer's computer however, all
> time fields >> display as 12:00:00. The data in the file is there,
> Crystal jsut wont >> display it.
> >> The only thing I can think of is that I have failed to embed a
> >> required DLL for this function.
> >> The Crystal decisions KB doesnt go into allot of detail on this.
> >> Does anyone know which dll I may have left out, or any other
> knowledge >> you may wish to throw my way?
> >> Thanks in advance,
> >> Bill Roman

.

Relevant Pages

  • Re: date and time syntax
    ... Ken Snell ... > I have a time field that holds appointment time. ... smalldatetime for this column. ... > I get an "wrong data type" error with both. ...
    (microsoft.public.access.formscoding)
  • Re: Btrive time fields in Crystal Report dont display properly
    ... use the Crystal 8.5 merge module in Installshield developer. ... Data Type 4 is definitely a standard TIME field. ... >> This app was first developed in 1996, and we started with Smithware. ...
    (comp.databases.btrieve)
  • Re: How To Convert Number Field To Time Field For Calculation?
    ... Access doesn't have a "time field" data type. ... It does have a date/time data ... we can use the Elapsed Time function to get the intervals. ...
    (microsoft.public.access.modulesdaovba)