This is a multi-part message in MIME format.
------=_NextPart_000_003C_01C78017.C0F5DD10
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_003D_01C78017.C0F5DD10"
------=_NextPart_001_003D_01C78017.C0F5DD10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Fredy,=20
Comprueba este flag.
Saludos
--=20
Ignacio Ortiz de Z=FA=F1iga
http://www.xailer.com
"Fredy" <
fredy@aglsl.com> escribi=F3 en el mensaje =
news:[email=
a20b86f349f58c94dbae8a0d2d8@news.xailer.com...]
a20b86f349f58c94dbae8a0d2d8@news.xailer.com...[/email]
> Hola,
>=20
> Probando el odbc con mysql me he dado cuenta de que al hacer un =
select, los=20
> datos que se retornan se guardan en una dbf con la extructura de la =
tabla=20
> sql y los valores correspondientes. Bueno ,m=E1s o menos.
>=20
> Resulta que al crear esa table temporal los campos tipo Integer se =
crean=20
> no con la longitud dada en la tabla sql sino con la longitud del valor =
retornado,=20
> esto es, si digo "select importe from facturas" y el importe es 0, se =
crea=20
> un campo llamado importe de tipo num=E9rico y longitud 1, con lo cual =
a la=20
> hora de actualizar este dato con, por ejemplo 100, no me deja ya que =
excedo=20
> la longitud permitida en dicho campo.
>=20
> Si en la tabla sql es un integer(11) creo que tendr=EDa que crearse un =
campo=20
> de longitud 11, independientemente del valor que en ese momento =
estemos usando.
>=20
> Un saludico,
> Fredy
>=20
>=20
>
------=_NextPart_001_003D_01C78017.C0F5DD10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Fredy, </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>Â</DIV>
<DIV><FONT face=3DArial size=3D2></FONT><IMG alt=3D"" hspace=3D0=20
src=3D"cid:003701c78006$fd682b10$
0202fea9@ozlan.local" align=3Dbaseline=20
border=3D0></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>Â</DIV>
<DIV><FONT face=3DArial size=3D2>Comprueba este flag.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>Â</DIV>
<DIV><FONT face=3DArial size=3D2>Saludos</FONT></DIV>
<DIV><BR><FONT face=3DArial size=3D2>-- <BR>Ignacio Ortiz de =
Z=FA=F1iga<BR></FONT><A=20
href=3D"http://www.xailer.com"><FONT face=3DArial=20
size=3D2>http://www.xailer.com</FONT></A></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>Â</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>Â</DIV>
<DIV><FONT face=3DArial size=3D2>"Fredy" <</FONT><A=20
href=3D"mailto:
fredy@aglsl.com"><FONT face=3DArial=20
size=3D2>
fredy@aglsl.com</FONT></A><FONT face=3DArial size=3D2>> =
escribi=F3 en el=20
mensaje </FONT><A =
href=3D"news:
a20b86f349f58c94dbae8a0d2d8@news.xailer.com"><FONT=20
face=3DArial=20
size=3D2>news:
a20b86f349f58c94dbae8a0d2d8@news.xailer.com</FONT></A><FONT=
=20
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> =
Hola,<BR>>=20
<BR>> Probando el odbc con mysql me he dado cuenta de que al hacer un =
select,=20
los <BR>> datos que se retornan se guardan en una dbf con la =
extructura de la=20
tabla <BR>> sql y los valores correspondientes. Bueno ,m=E1s o =
menos.<BR>>=20
<BR>> Resulta que al crear esa table temporal los campos tipo Integer =
se=20
crean <BR>> no con la longitud dada en la tabla sql sino con la =
longitud del=20
valor retornado, <BR>> esto es, si digo "select importe from =
facturas" y el=20
importe es 0, se crea <BR>> un campo llamado importe de tipo =
num=E9rico y=20
longitud 1, con lo cual a la <BR>> hora de actualizar este dato con, =
por=20
ejemplo 100, no me deja ya que excedo <BR>> la longitud =
permitida en=20
dicho campo.<BR>> <BR>> Si en la tabla sql es un integer(11) creo =
que=20
tendr=EDa que crearse un campo <BR>> de longitud 11, =
independientemente del=20
valor que en ese momento estemos usando.<BR>> <BR>> Un=20
saludico,<BR>>ÂÂ Fredy<BR>> <BR>>=20
<BR>></FONT></BODY></HTML>
------=_NextPart_001_003D_01C78017.C0F5DD10--
------=_NextPart_000_003C_01C78017.C0F5DD10
Content-Type: image/png;
name="2007-03-29_101551.png"
Content-Transfer-Encoding: base64
Content-ID: <003701c78006$fd682b10$
0202fea9@ozlan.local>
iVBORw0KGgoAAAANSUhEUgAAATcAAACUCAIAAAB5v/mRAAAABmJLR0QAAAAA AAD5Q7t/AAAACXBI
WXMAAA7EAAAOxAGVKw4bAAAWGElEQVR4nO2dS48sSXXHcwdLb2zJkjdsvEJI 49Ug3S9hIe+9YOUN
4hOYPQKpVyMLLHRXGIQXFgjPFfKAhhEzAo19kRCa0XC53H7dflTXo6u7b1dG Zrcj43HiZLwyI6eq
M6rrhP7KyYx/RuTJrPjlicyqnltMTj+5v7//5je+fi9K8bf/94W3Pvmbf5l+ 8Z9e3FOhQiWDUhCl
VKhkXohSKlRyL0QpFSq5F6KUCpXcC1FKhUruhSilQiX3QpRSoZJ7IUqpUMm9 EKVUqOReiFIqVHIv
RCkVKrkXopQKldwLUUqFSu4lRmnxz98ikUjjiyglkXKXS+kXNaXcIpFIo4so JZFyF1FKIuUuopRE
yl1EKYmUu4jSXdFi9vLVb757/s5Xjr/95cehw3eevHj/O/y8Os9920WU7oo4 otMfvLV69vb9R08e
h9h7X+VnxM+r89y3XWmU8vvW8z8+/9GzX+798Gdj6elPf/HR7z/mkUiNHk/+ klfsxdOvrd59+/7D
J49J/Iz4eXWO8m1XGqUciZ9/8PHh6eR+vHKxWPIYeCQS0dHjyb/IK7b3ve9X 1Z2lv/rrv8982Sl+
Xp2jfNuVRinPWgenk7uRS31wes4j4ZTmEU/+pbliXkofgYhSe28+farriksU NooYK2+uLnkknNIc
4slf6oqFc2me6hkbUWrvzakom7IaT7fXV5fz6RlQOnY8+UtfsR65tCiKAdba lXSsHaX0C1FKb2/f
3N7euOJX1lsfV2qrN2+ul4vpxdkxUBqKR3YOpbPnTSg1gJ67JclcsR65NCtK KZeCkim9ubkSWlri
V9atXLuury8X8/Pzk32gtGc8mw7P7b9/ABuNzVyxrlwq2QjR+PCU9hRRau/d n4oNaTClm9aWUorz
lZdSNBuwXVjHO+B+rJ371xSUS9saQKn8+C8tFc1Q81TK4tbISmvp7QTr+nqx mJ+dn7xClCbE44bk
HtobjNXK20/RPmJos0DFauvu0xkSPoRX5opFc2kRwM+q9O7m7mP10KefeM8R EaX23oIK/sE3n70l
fmUjNXI9VCM/11A/WFdX8/ns9Oz1XxClfeMJBWAd2lvjtorUeAPwnqDVNtJ5 aB/vaWKZKxbNpUU/
SqsAVFC8rXCN2yTUinIpKBdKI/34x9z6KO1Tg4u3884a2IwcsX9I3iN6Fac0 go2XnMoBz90nXuO2
ihyrj4hSe29OBXz2lviVjdTI9VCNWx/ScjmbTU9Ojw2l/eOJBNC/JtR5Zw1s RvrvE0D/ayVlrlg4
l4aYKQLkxNfXVUO5FLQrlPYH4PPXRAKIt+3TubdJRHFKMRXemgKV0P7WPt49 vZ2Eaop2/3ERpfbe
nAr47C0V7WJVeneTm7CEHdzOQZeX0+nF65Ojl0BpKB73WN6Q3EN7g+nsx2rY JwC3bRE4nPcoVg8h
mSvW9Y43N/WMjSi19xZUzLiWy+nnlBhh3btZury8mF4cnxz9GVG6nngeTMNO fLDMFev6vnRLRZTa
e39OKtpppHt/V0RpquKU9sxXo6hnbESpvTenAj77UbRYTC4mR68PXwCl48aT v8wVo1y6tUqmlD/n
cC0WF6NoPp9Mzo+ODwyl48aTv8wVo1y6tUr+mxi4Q4+i+fx8cn54fPAnROmY 8eQvc8UCubTPn2KP
tewjotTeu2FDf/ajaDY7PT87ONr/DCgdN578Za4YzXi3VsmUis/+bCzNpidn J68O9z8FSseNJ3+Z
K0aUbq0SKf3e90nbq84Rv43qPOtHoARK9x7px0wiZS6ilETKXUQpiZS7iFIS KXcRpSRS7iJKSaTc
lUYpi/ZFLrnkbsJNozTSNYlE2pAGUFpHeySXXHLX7Hop/bRPLmWwZGKF3ZFL LrmbcAdQat0DaJM2
aXOzm+mUMqcX5izJJZfc9bnplKrGLdbbIpdcctfpplGKJs2od11JLrnkbsJN o1TyLZ50+bLGXetO
ySWX3DW7qZTe2T22eieXXHLX7w6iVNKvlk13DNbJJZfcdbtplDLThepX9FLL enLJJXcTbiqlteqO
1aIL2JS9k0suuet30yitJNy8C9Ud3qzJJZfcTbgDKFVvnyqBPhPoM3SkkLuY vXz1m++ev/OV429/
OVsdvvPkxfvf4aHqK0UijSPMURqlCjnWUC4grPFtIO5yRKc/eGv17O37j55k K/beV3mQPNTOi0gi
bVSYI9+/QPEPfd4e1VLMvJiq4+6Lp19bvfv2/YdPMhcPkof6o2e/3PvhzzLU 05/+4qPff8yzvdTz
Pz7PM9T848QRdjIzkhRHaZRW6gG31kLrOjuH3C3681Qe6uHp5D7LcrFY/vyD j/mgl0Ofr+cZav5x
4gg7h8QYMhylUdrkRqZaiozcqCGTyZqYu12U3uVb6oPTc56X+Njiy4PTSdf+ Y5X84zQRdg6JMWQ4
SqW0ZiZtyiR5pya3oibibhelNY+6KSw3MVbeXF3u6X+Ag8eZZ6j5x4kj7BwS IwhxlEaporHpRb8u
gpwJrAbcOKVFu8ia7jPpoQH98FDLcpWlbq+vLufTMxj9ZVM6Wz288o+zFaF3 GDBf5YO5mKM0Shl6
BFVPnkx2bUANuZ2UdtakCjOfJB7q7e2NV9bdRNaEdu4v3GFEb95cLxfTi7Nj GP23t2/iHW5RnJ2H
ju+QJCvCziExghBHiZQyhTjTGdKsyOfSsPvwlA7uh4d6c3N1c7N0xXvrrEkV 7iHe2/X15WJ+fn6y
D6NfxOkJdRvjjPf5+ePHsiIMD4Y6OlQ26hp80igVb4Nq/U2O6UU9f0bdwZTC vRZbVqW1Q7znTj0w
pf17Gzb6+/Scqg3FGel2vfG7lJp5pvzFD2sNiYd3MUfplCIa1WNnZZYRt5NS Fzx3H6veqvECOZRS
/lleuhJjxV8D8WPLqrR26NM/1vX1YjE/Oz95hUb/0hvqlsbpjcraxDVuQ3e3 PhGiT99KceNtIo6S
KTXgqamszpn6RVHI7aQ0VIOve+Wj1Ns80nOneKj8Xss/SFc4GKhx97HqrRq3 SbwedHU1n89Oz17/
BY3+S2+om4sT9xlSUpzezUhUSTUhWRG2IGHOchzXcJRIqXyFq3NmhSBkcjPs DqO0cJh0a0I9xOsj
ilMaqilQCY2YyNCJj6pr39jqP/qv1xdnnx0Gx+kNMhRnn5qQYpTaqsdxEUdp lKq3uJVKmEwvNaIx
d3OUQo3bSagyLkFp80G64r15a3B9qCbUQ6jS1XI5m01PTo/N6Icx19nhWuLs 6Q6OEzZD8eP1PjUh
WRF6clrrAXIU13CUTCljVWuWq7HU89ugO4zSypnxRmp69typDVEKNVYnbp8h DR79bgx9aiJxxmMe
Fmd8PR5naJ+QbEplUqkMKkJy6N6N5BqOEv8FCpjB6l5Y+71RxN3Eb4+KdAL7 iIcqP0hX/IihmgKV
eI3bg7unV5eX0+nF65OjlzD6Ycw9QJx4z0iQy8Q4Q316Q7L2hM34bp0Rmk+f OeOBBdY37GKOEimt
FIQYy+bnVjDpDbvrohR/DJ07D5OglH+W03VJjJju3Tp1eXkxvTg+OfozGv2z NYa6LXH2UfxcrAjF
564nn0P/70TrdTFHiZSibKkIbNbNLDfirovSB9BaKG3f1Lv376NNjP5tibOP +p+Lj1L9ZlXORd3f
8T2sizlKo5QJ8OCZU85pRWXFhCLudlEqP8jctFhMLiZHrw9fwOiHMZeV8o/T ilCM2DuJihi6zTBg
ZnMMF3GUSqnKmbAUxFdmPexuF6X8uWWxuMhN8/lkcn50fGBGP48zw1Dzj9OK sFJ4yAFQ6+SGNx/c
RRwNobQBD14OOZSG3G2jlH+Wk9w0n59Pzg+PD/6ERv9FhqHmH6cVYaWyVgOM eGdjyJFvYsdwDUdp
lKrnTMyklT/D7nZRKj/I3DSbnZ6fHRztfwajH8ZcVso/TivCKv3/4/UALiiN UvHwKVtWaimwrKoK
Vfrd7aJ0Pj/LULPpydnJq8P9T2H0izHX3fCBlX+cVoQVejLUL1qBnLtRXMxR IqUN63WlXwiJJTyC
VnF3uyglkcYV5mgApRVKlXpOWwGlQXdveyglkcbVnpm3NhwlUqqzMPxWwcxy 0aTX6xKlJFJPSdaA
o1RKK50kK/WjBY0lAwVcopRE6qk9/Zt5yVEypRWAJyhvTXGjLlFKIvUU5FIW yqXR/++RAZKZbClT
aBV3iVISqafMvDWUS6P/rwY0s8UQmkQadIlSEqmnEKUNR2mU+iB0V/zunvuP FLdFLrnkSlnz1sGU
NmonT1uWS7mUROqp9owXUTq9OOJKojRJmtLaG5YWueSSe2exZiit6zI1l7Zl P4harpVLGSzlnwW0
/1adXHJ32Q1SypfH06ovpWV7WbaZ9LmBXEqbtEmb9qZiTRPUovT5y96UYhqF Sjd/tl1FKXPiY86S
XHJ327UyYovS336y6kEpa0PI2pQGXTTjrZ27CBa55O66aygVHLUo/eAPb3pQ ylsK+krEJM6lAVc0
x8HpdV1JLrnkypUGFsRRi9L3nt/2pbR52mRAZomfSwOuyKXNnUM8Jdfqr+lM rHfkkkuulKJUc5RO
qfWiiKm+cIL2umbGi2NtxU0uueQ2ir3j/Z//7ZzxaurKSiRkOdFlCsio234u hWUTHIN1csklF+VS
yVGL0nd/d9PxNzGiUalfEJeNJI0S0Zi75/5CkMn4avN9EbnkkisoxRy1KP3v 317HKdW5UfCI3+KK
L0XjrqC0VqEwuIXITRk3ueSS27hy3goctSj9rw+7ciljikaVPVmpVir1Ujfs tma8KlC8WZNLLrnS
VRlRczSEUiYxR9+1lJBIwy789qgJiKnbBhM3FYaiJJdccjVrvm9i/vPX/Sg1 qVJ8ywJkRl05422C
YM0NQ4RVQ7iV3iSXXHLN96WCoxalP3m/47lUwK2ntSpVakLV292g2357VEvJ +Mx9hVxyyRUzXsxR
i9If/2rZ9fZIYycyZCm/ddVZNO7uqX9Y0YSFQ4S8Ty655JpfNbi59LOD205K y1LmRgUhUzNbJr9x
ibhiwixSvIhJ5PpGTaxM1pBLLrlNjcqImiND6a//8Pq+8/8hqOa0sr1+FJVw mhmv3xWU1kzcKqrm
RiJC1LcTJmrIJZdcVkEuVRwZSi8Wyx//6lVnLjUEqlQp5rSlwjPiqhlvozsZ k4xV3UUgenLJ3XlX
/KrBcKQoXcz2pXpSKglUcIpUiSn1uuZXDUwsG92J+4cMtCaXXHJlpaQUOFKU QumgFOa0un0rYUZd
9Vwq4mD6nmFW5EydXHLJRX+5Zij9139/Bup+LoV8ibAEFCPunvznT5mM5k6v NGFVTN9gyCWXXPXb
I8NRYaEoKA3/TUzTRmGn5s2yGCCDrqIUxScjkxGruMkll1z19shwlEapyZl4 hQk40eTW60pKTSgi
SgaJntXkkkuudPE7XjYolwJ7el0DGXf1O947GZMMEcJicpNccsnVlAJHDaU/ +Y9/A3XlUp01yxJx
iEvQNe94pXR86hZS1eSSS650xatWw5Gi9Jvf+LpUH0rb+DFVpWqCrqS0+XFv ZW4bECiTCrtWMHEl
9Uwuubm58H2KpMhQir6Jicx4gUWm06YGUj+Yhlx4LmUMotTB6XtJxOUB/N0/ fquPJKX9eyaX3Nxc
mRGBoxalk67nUitDqjSpkqWdPy1XPZfqECHQSv+z5HFXUrq//0Lq4ODl0dGr 168Pzs6OJ5PT2Wyy
WMyWy4Wk1O25QCXpuLJtyMXd9jkjcfSBrrfn9nn52+pTTuvZdZt+ulz3WkEr uGKpx91BV7+pVRwN
odRMbvUTru4u5lq5VMXUrJu8H3ExpSFEr6+XmlK752b06J71QOl1XGhrxrp2 dY1qqzjx9ey27XPc
ThfdGirYdNumnm/Itc63pyujAteKuc9xd9CFbz0lR6mUolmtWMK2rgy64oG4 guDUvaRRE5r4Y9SY
C5R6Ef3S0y9xRN+8ucEzXtyzGqm6ZwFer+NCW5NJtKs7UW3VjcB3Rm7bPsft dOURO9vqwBJ6DrkY
RXy+8lJ428qbF1yrnjHvuIveAZXJubShblWWK8wlQ+sxd0/+TQxExnRkVWXW w66kNIQoF0d0tbpt
UYp6NpTqTXALXaRb6MyJRqGqNzWVGXCtPtsd4j6hW94Wu3IFR4Wb2xG2r1Wh +7fOF/ePz8i6Gng3
WLFct2f3fGXMuK11EewrgDvv9+nvmttQijhKoxS3REWnzKgLlDahVCjKdtwh V1IqEeVMWohycUR5
BECp1XMhh3jV3vQNNTWAAi7uGbuQsiqHB2sQu5vQFo7r3dnqWe7gXivvGfWJ CtrKKwCTDnwlC0AL
nW/kBOG4eAf3uHBGw8bG43PRO6CmJFKqqBNlxdpps/1fx91TvxCsGI4S4tNR hlxJqcyiEksXUd66
PeM1PZuxKwQjDEYhVHqoQC7uGbt4B+ChcvrEm1W4nukRzPSwhoKvlRVS/Iw6 o4K2uFtY97bt7Blc
iMrtvM+nv2uuoVRwNIBSaGze6trF58rnUh1NpZYi0KqqUKXflZTKiS7AaSFa 17Wm1O5ZD47WZlXB
A1VzXDPCdFvXxT1jl8Gzmai3jgttvZvQNhKV91qh3fxR4TPqjAra4muFr4bb trNncCEqHDMcFw6H
VhLGxuNzFWuao2GUIgBXpTPd9bvqt0fN3aKSj8hiqW4eIsqYKykNTXQrgejd 3R2847V6LsQ7DNmz
GhzCFeNMHbeFSsDFPWO3Um9WKtYao+q40LYwyaoVFeyGXfe4uOdKJajKckNn BG0LUdyooC1EZV0N
73Ghrfd83agibQePjcfnwjcxsiRSuhLvh1waNZMRV1PaxASBihX5jquKu5JS /KWLiyg/BZVLnZ4L
VCzX1OtBDK4eWyqqSNtCoyV3g2K1LQwwld70uK0+UY17rdo7d5yRqtTHLVph mPMt9HGtqwHHhZ5x
W/eMoEBU8baDx8bjc62MmEhpqXPmqly1X+eqEnb126MmLB6UfmiWUcIcPehK SgFR+UbXQtRQmtLz
2l01EAe1JZdcXgGsSY7SKUUoGg5XCMmAq59L5W2jSfEVCpSBAq6kNI4oUJrU 89rdwqTQ5Lbkkstk
LkUcDaG04VuQpxJmO2eGXP2rBh2KuH/oiGWIMXeS+Dve/j2TS25uLocFc5RO KSAOAK4MnREXveOt
dJRmvdmKulYwcSX1TC65ubmYtVXycylGUa6sVqrSAtVxxfellQkFh6UCJZdc chu1fkGUmkvlJFZP
ZVelntOuZGaOuua5tBWWu0IuubvuAmsSnjRKRb5c6ay5gqmzYjLqtilt1L6d 2CKX3J11NWuKo0RK
5Qx2tdIpE6a4K7BCrkspiUTySrIGHKVSqh43FegrOZktEZVBt4vSOmyRS+5u uSKXGo5SKUXPoKuV
mucqIldxt0Vp2V6W7SjJJXe3XZkRgaNESmVTTaMgEFEadT25FIVbWha55O6w K94eGY7SKJUorvRT
qMqXsB51NaWsHRZrx00uueQKShE76ZSq1GjysT3HDbgml5YinhJFie8u5JK7 8656e6Q5GkApZM4S
1hCSQbdFadksIdayrCDEkGsFE1dSz+SSm5sLlEqO/h/5NkUcZc5mGwAAAABJ RU5ErkJggg==
------=_NextPart_000_003C_01C78017.C0F5DD10--
Attached files