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

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 (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - March, 2006 ***
*** Chicago: Pervasive DataExchange Class - March, 2006 ***

caterpillar wrote:

Hi Bill,
The query returned a 4 for the fields in question.
It is quite possible this file was created with Smithware.
-Bill Roman

On Wed, 11 Jan 2006 17:06:12 -0600, "Bill Bach"
<goldstar (AT) speakeasy (DOT) net> 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 (AT) speakeasy (DOT) net> 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 (AT) goldstarsoftware (DOT) com
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:

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 (AT) speakeasy (DOT) net> wrote: