Re: Btrive time fields in Crystal Report dont display properly

Bill,
The intresting thing here is that it works fine if the entire Crystal
Reports 8.5 is installed. It is only when i imbed it that if fails. I
use the Crystal 8.5 merge module in Installshield developer. So, in my
imbedded installation is where Crystal fails to pick up the time
field.
I will repost this in a crystal NG, unless somthing comes to mind such
as a required dll, or a formula. In any event, thanks for your help.
-Bill Roman


On Mon, 16 Jan 2006 16:47:26 -0600, "Bill Bach"
<goldstar@xxxxxxxxxxxxx> wrote:

>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