dBase compatibility problem in Delphi. BUG! Help!
Craig Manley
Hi everyone,
I'm using Delphi 2.0. I'm busy writing a utility that performs an SQL
query on a dBase file. The results are then copied into a new dBase
file.
I've encountered a big problem though. In dBase, there are numeric
fields with possible decimals as well as float fields. My file has a
numeric field of width=11 and decimals=0. Delphi interprets this as a
float field and makes it 20 wide with 4 decimals. That sux!
Is Delphi known to have these compatibilty problems with dBase? Also
when you read the table into DBGrid you don't get to see the numeric
field values. I've attached the file for you all to see. The field I'm
talking about is RSPID.
Greetings, |\
_ \ \
\ \ _\ \__
-------- Craig Manley ----------- /_/\_/ /__>
/ /
|/
E-mail : c.ma...@tip.nl
Homepages: http://www.flnet.nl/~0manley01
http://www1.tip.nl/~t960341
http://www1.tip.nl/~t960341/wb
*---\ ___ _
\ / \ | |
\---| \ / / |
*-------------| *----- /
|----
Craig Manley
This is a multi-part message in MIME format.
--------------4843307731B3
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Craig Manley wrote:
>
> Here's the file:
>
> ---------------------------------------------------------------
>
|\
_ \ \
\ \ _\ \__
-------- Craig Manley ----------- /_/\_/ /__>
/ /
|/
E-mail : c.ma...@tip.nl
Homepages: http://www.flnet.nl/~0manley01
http://www1.tip.nl/~t960341
http://www1.tip.nl/~t960341/wb
*---\ ___ _
\ / \ | |
\---| \ / / |
*-------------| *----- /
|----
--------------4843307731B3
Content-Type: application/zip; name="Rsp.zip"
Content-Transfer-Encoding: base64
Content-Disposition: inline; filename="Rsp.zip"
<encoded_portion_removed>
AAAAjAcAAAAA
--------------4843307731B3--
Craig Manley
This is a multi-part message in MIME format.
--------------181832007338
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Here's the file:
--------------181832007338
Content-Type: text/plain; charset=iso-8859-1; name="Rsp.dbf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline; filename="Rsp.dbf"
=03a=08 @=00=00=00=01=03u=02=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00=
=00=00=19=00=00RSPID=00=00=00=00=00=00N=00=00=00=00=0B=00=00=00=00=00=00=00=
=00=00=00=00=00=00=00=00RSPBDR=00=00=00=00=00C=00=00=00=00(=00=00=00=00=00=
=00=00=00=00=00=00=00=00=00=00RSPACHNM=00=00=00C=00=00=00=00(=00=00=00=00=
=00=00=00=00=00=00=00=00=00=00=00RSPINT=00=00=00=00=00C=00=00=00=00
=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPTSSVGS=00=00C=00=00=00=00=
=0F=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPGSL=00=00=00=00=00C=00=
=00=00=00=01=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPSTR=00=00=00=00=
=00C=00=00=00=00+=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPHSNMMAN=00=
C=00=00=00=00
=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPPSTCD=00=00=00C=00=00=00=00=
=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPPLT=00=00=00=00=00C=00=00=
=00=00=1E=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPTLF=00=00=00=00=00=
C=00=00=00=00=0F=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPFX=00=00=00=
=00=00=00C=00=00=00=00=0F=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSP=
TTLID=00=00=00N=00=00=00=00=0B=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00=
RSPGBRINS=00=00C=00=00=00=00=04=00=00=00=00=00=00=00=00=00=00=00=00=00=00=
=00RSPDTMINS=00=00D=00=00=00=00=08=00=00=00=00=00=00=00=00=00=00=00=00=00=
=00=00RSPOPM=00=00=00=00=00C=00=00=00=00=FE=00=00=00=00=00=00=00=00=00=00=
=00=00=00=00=00RSPLNDID=00=00=00N=00=00=00=00=0B=00=00=00=00=00=00=00=00=00=
=00=00=00=00=00=00RSPHSNMM=00=00=00C=00=00=00=00
=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPAFD=00=00=00=00=00C=00=00=
=00=00=1E=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPNNMLCD=00=00C=00=
=00=00=00=01=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPDTMGBR=00=00D=
=00=00=00=00=08=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPFNC=00=00=00=
=00=00C=00=00=00=002=00=00=00=00=00=00=00=00=00=00=00=00=00=00=00RSPTP=00=
=00=00=00=00=00C=00=00=00=00=01=00=00=00=00=00=00=00=00=00=00=00=00=00=00=
=00
1123 Fake Name =
G.J. MFake Street =
Fake HOOFDDORP =
0 LINR1997-05- =
=
=
=
149 14806 W =
R 1234 =
Fake Name L. =
van MFake Street Fak=
e REUVER 0 =
BURI1997-04- =
=
=
149 11 =
W =
R 543 Fake=
Name Y. VFake Street=
Fake SCHOONHOVEN =
0 UTZ11997-06- =
=
=
=
149 16 =
W R 45=
3 Fake Name =
C.J. MFake Street =
Fake HOUTEN =
0 UTZ11997-04- =
=
=
149 =
26 W =
R 17588 =
Fake Name P. =
MFake Street Fake VUGH=
T 0 BURI19=
97-05- =
=
=
149 3 =
W =
R 15673 Fake Name =
F. MFake Street =
Fake HELMOND =
0 LINR1997-04- =
=
=
=
149 112 W =
R 18106 =
Fake Name =
van FFake Street =
Fake NUENEN =
0 UTZ11997-06- =
=
=
149 6 =
W =
R 18110 =
Fake Name A. van de Fake =
Street Fake EDE GLD =
0 UTZ11997-06- =
=
=
=
149 31 =
W R 1810=
7 Fake Name =
G.P. Fake Street =
Fake SOEST =
0 UTZ11997-06- =
=
=
=
149 41 W =
R 18112 =
Fake Name J. =
Fake Street Fake =
GOUDA 0 =
UTZ11997-06- =
=
=
149 30 =
W =
R 18115 Fake Name=
J. van VFake Street =
Fake VOORBURG =
0 UTZ11997-06- =
=
=
=
149 14 W =
R 18114 =
Fake Name =
VFake Street =
Fake HOOGVLIET ROTTERDAM =
0 UTZ11997-06- =
=
=
149 =
15 W =
R 18127 =
Fake Name J.G. =
Fake Street Fake ETTEN LEU=
R 0 UTZ11997-06=
- =
=
=
149 195 =
W =
R 18129 Fake Name =
G.P. Fake Street =
Fake SPRUNDEL =
0 UTZ11997-06- =
=
=
=
149 41 W =
R 18119 =
Fake Name J.H.J. =
Fake Street Fa=
ke MAASTRICHT 0 =
UTZ11997-06- =
=
=
149 11 =
W =
R 18121 Fak=
e Name J.W.J. Fake Stree=
t 6 Fake ARNHEM =
0 UTZ11997-06- =
=
=
=
149 1 =
W R 18125 =
Fake Name =
A. Fake Street =
Fake BOXTEL =
0 UTZ11997-06- =
=
=
149=
1 W =
R 18122 =
Fake Name B. =
Fake Street Fake GRO=
OTEBROEK 0 UTZ11=
997-06- =
=
=
149 42 =
W =
R 18130 Fake Name =
P. Fake Street =
A Fake DEURNE =
0 ZORN1997-06- =
=
=
=
149 25 W =
R 18140 =
Fake Name A.=
Fake Street =
Fake OIRSCHOT =
0 UTZ11997-06- =
=
=
149 10 =
W =
R 18138 =
Fake Name J.M. VFake=
Street Fake OEGSTGEEST =
0 ZORN1997-06- =
=
=
=
149 26 =
W R 181=
32 Fake Name =
J.H.T. Fake Street =
Fake VENRAY =
0 ZORN1997-06- =
=
=
=
149 22 W =
R 18135 =
Fake Name J. =
Fake Street Fake =
DOKKUM 0 =
UTZ11997-06- =
=
=
149 66 =
W =
R 18142 Fake Nam=
e P.F. Fake Street =
Fake HELLEVOETSLUIS =
0 UTZ11997-06- =
=
=
=
149 4 W =
R 18148 =
Fake Name =
M. Fake Street =
Fake HOORN NH =
0 ZORN1997-06- =
=
=
149 =
66 W =
R 18152 =
Fake Name G. =
Fake Street Fake ELST GLD=
0 ZORN1997-0=
6- =
=
=
149 11 =
W =
R 18145 Fake Name =
Fake Street =
Fake KROMMENIE =
0 UTZ11997-06- =
=
=
=
149 1 W =
R 18161 =
Fake Name R. =
Fake Street F=
ake ENSCHEDE 0 =
UTZ11997-06- =
=
=
149 12 =
W =
R 18154 Fa=
ke Name F.C.A.M. van Fake Stre=
et Fake TILBURG =
0 UTZ11997-06- =
=
=
=
149 218 =
W R 18157 =
Fake Name =
G. Fake Street =
Fake BEILEN =
0 ZORN1997-06- =
=
=
14=
9 71 W =
R 18164 =
Fake Name H. de =
Fake Street Fake LE=
LYSTAD 0 ZORN=
1997-06- =
=
=
149 1152 =
W =
R 18166 Fake Name =
G. Fake Street =
Fake ZWIJNDRECHT =
0 ZORN1997-06- =
=
=
=
149 73 W =
R 18162 =
Fake Name A=
=2EM. Fake Street =
Fake ZUTPHEN =
0 ZORN1997-06- =
=
=
149 =
226 W =
R 18211 =
Fake Name G. F=
ake Street Fake HOOGLAND =
0 ZORN1997-06- =
=
=
=
149 12 =
W R =
18163 Fake Name =
J. van Fake Street =
Fake DEURNE =
0 UTZ11997-06- =
=
=
=
149 25 W =
R 18167 =
Fake Name H. =
Fake Street Fake=
ALMERE 0 =
ZORN1997-06- =
=
=
149 16 =
W =
R 18220 Fake =
Name E.M. Fake Street =
Fake ZOETERMEER =
0 ZORN1997-06- =
=
=
=
149 183 =
W R 18215 =
Fake Name =
P.J.H. Fake Street =
Fake DONGEN =
0 ZORN1997-06- =
=
=
149 =
11 W =
R 18212 =
Fake Name E. =
Fake Street Fake BEILE=
N 0 ZORN199=
7-06- =
=
=
149 8 =
W =
R 18217 Fake Name =
J.J. Fake Street =
Fake GEMERT =
0 UTZ11997-06- =
=
=
=
149 39 W =
R 18214 =
Fake Name A.J.=
Fake Street =
Fake ALPHEN AAN DEN RIJN 0=
ZORN1997-06- =
=
=
149 55 =
W =
R 18216 =
Fake Name F.J. Fake S=
treet Fake ZOETERMEER =
0 ZORN1997-06- =
=
=
=
149 55 =
W R 19128=
Fake Name =
A.A. Fake Street =
Fake ALBLASSERDAM =
0 UTZ11997-06- =
=
=
=
149 56 W =
R 18271 =
Fake Name A. =
Fake Street Fake =
BEST 0 Z=
ORN1997-06- =
=
=
149 90 =
W =
R 18223 Fake Name =
J. Fake Street =
Fake ENKHUIZEN =
0 ZORN1997-06- =
=
=
=
149 21 W =
R 19326 =
Fake Name =
S.G. VFake Street 3 =
HOOG Fake AMSTERDAM =
0 SPIP1997-08- =
=
=
149 =
317 W =
R 19328 =
Fake Name S. =
Fake Street Fake GOUDA =
0 SPIP1997-08-=
=
=
=
149 384 =
W R=
19327 Fake Name =
G.F.G. Fake Street =
Fake BREUKELEN UT =
0 SPIP1997-08- =
=
=
=
149 175 W =
R 19331 =
Fake Name M. =
VFake Street Fak=
e DEVENTER 0 =
SPIP1997-08- =
=
=
149 17 =
W =
R 19329 Fake=
Name P.J. van de Fake Street=
Fake GRONINGEN =
0 SPIP1997-08- =
=
=
=
149 73 =
W R 19332 =
Fake Name =
A. Fake Street =
C Fake ENTER =
0 SPIP1997-08- =
=
=
149 =
34 W =
R 19334 =
Fake Name M.F. =
Fake Street Fake GRON=
INGEN 0 ZORN19=
97-08- =
=
=
149 108 =
W =
R 19333 Fake Name =
G. Fake Street =
Fake BOXMEER =
0 ZORN1997-08- =
=
=
=
149 5 W =
R 19330 =
Fake Name G.J=
=2E Fake Street =
Fake HORST =
0 SPIP1997-08- =
=
=
149 33=
W =
R 19335 =
Fake Name G. Fak=
e Street Fake BRUCHT =
0 ZORN1997-08- =
=
=
=
149 14 =
W R 19=
337 Fake Name =
J.H. van der Fake Street =
Fake ZEIST =
0 ZORN1997-08- =
=
=
=
149 2389 W =
R 19336 =
Fake Name B. =
Fake Street Fake =
VRIEZENVEEN 0 =
ZORN1997-08- =
=
=
149 42 =
W =
R 19338 Fake Na=
me J. Fake Street =
Fake VELDHOVEN =
0 ZORN1997-08- =
=
=
=
149 9 W=
R 9060 =
Fake Name =
H. MFake Street =
Fake DORDRECHT =
0 BHON1996-12- =
=
=
149 =
302 W =
R 11194 =
Fake Name J. =
Fake Street Fake SOMEREN=
0 BHON1997-=
03- =
=
=
149 20 =
W =
R 6946 Fake Name =
J. Fake Street =
Fake HOORN NH =
0 LEEM1996-09- =
=
=
=
149 24 W =
R 607 =
Fake Name E.L.M.=
Fake Street =
Fake NIEUWEGEIN 0 =
DOMR1996-09- =
=
=
149 19 =
W =
R 12709 F=
ake Name J. MFake Str=
eet Fake BODEGRAVEN =
0 UTZ11997-04- =
=
=
=
149 29 =
W R 8263 =
Fake Name =
L. MFake Street =
Fake HEEMSKERK =
0 BHON1996-12- =
=
=
1=
49 48 W =
R=1A
--------------181832007338--