Clarion - dbase real problems

Author

dbase real problems

Frank

2004-03-26, 11:01 pm

Hi,
the old story: convert Topspeed file to dBase.
The problem is the Type Real. If I try to save a value >= 1,000,000
(million) I get an error 90. Any ideas? Howto define the datatype
correctly? (did External: Real=N(9.0) )
I use Clarion 5.5G

Thanks
Frank

Rich Knoch

2004-03-26, 11:01 pm

Frank,

Syntax should be filename = N(9.0). If you have filenames that use an
underscore (_); i.e., Field_Name, they don't convert properly.
Underscores, in Clarion 5.0 used to work properly, though.

Rich Knoch
wwww.compulink-ltd.com

Frank

2004-03-30, 3:30 am

Rich,

thanks for your reply.
I did a bit more of "research":
My app does the following: search for a TPS file and then convert it
to a dbase file, pretty easy and straight forward.
If I do this with the first file everything is OK and the dbase file
is build according the dictionary. But if I do it again all REALs are
build as (9.2) in the dbase file and not as 11.0 as specified in the
dictionary!

Any ideas?

Thanks
Frank

richknoch@cs.com (Rich Knoch) wrote in message news:<1c2ab02e.0403190538.371d829f@posting.google.com>...
> Frank,
>
> Syntax should be filename = N(9.0). If you have filenames that use an
> underscore (_); i.e., Field_Name, they don't convert properly.
> Underscores, in Clarion 5.0 used to work properly, though.
>
> Rich Knoch
> wwww.compulink-ltd.com

Frank

2004-03-31, 9:30 am

fbender@de.imshealth.com (Frank) wrote in message news:<f8844785.0403292305.62c4cbfd@posting.google.com>...[color=darkred]
> Rich,
>
> thanks for your reply.
> I did a bit more of "research":
> My app does the following: search for a TPS file and then convert it
> to a dbase file, pretty easy and straight forward.
> If I do this with the first file everything is OK and the dbase file
> is build according the dictionary. But if I do it again all REALs are
> build as (9.2) in the dbase file and not as 11.0 as specified in the
> dictionary!
>
> Any ideas?
>
> Thanks
> Frank
>
> richknoch@cs.com (Rich Knoch) wrote in message news:<1c2ab02e.0403190538.371d829f@posting.google.com>...

Rich,

no, I am using always the same files, converting results.tps to
results.dbf. Before converting the file xxx.tps is renamed to
results.tps and the file results.dbf is removed. After the processing
the file results.dbf is renamed to xxx.dbf.

Thanks
Frank

Danilo

2004-04-02, 4:30 pm

Hi,

I working with Clipper file. Time ago I found that my dbf file with
number fields defined as REAL=N(x,y) changed to REAL=N(9,2) after
EMPTY instruction. If you use this command I suggest you the CREATE or
PACK command that working right.

Regards
Danilo (Italy)

fbender@de.imshealth.com (Frank) wrote in message news:<f8844785.0403292305.62c4cbfd@posting.google.com>...[color=darkred]
> Rich,
>
> thanks for your reply.
> I did a bit more of "research":
> My app does the following: search for a TPS file and then convert it
> to a dbase file, pretty easy and straight forward.
> If I do this with the first file everything is OK and the dbase file
> is build according the dictionary. But if I do it again all REALs are
> build as (9.2) in the dbase file and not as 11.0 as specified in the
> dictionary!
>
> Any ideas?
>
> Thanks
> Frank
>
> richknoch@cs.com (Rich Knoch) wrote in message news:<1c2ab02e.0403190538.371d829f@posting.google.com>...

Sponsored Links