[tinysql] blob support and date
Davide Antoni
davide.antoni@ifc.cnr.it
Mon, 01 Mar 2004 16:19:40 +0100
--=====================_538102119==.ALT
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
Content-Transfer-Encoding: quoted-printable
1 how to exract the memo internal adderess? and there are a metod with this=
=20
one to exstract the memo field?
2 there's a bug: when i make a query on a date field that return the date=20
in table but with one months added ex
18-10-2003 return :18-11-2003
18-12-2003 retunr : 18-1-2004
i don=EC't think so that i do a bed query:
rsTiny =3D stmtTiny.executeQuery("select DATA_ENTRA, DATA_USCIT from Cartel=
=20
where N_CART =3D "+N_CART);
i have teh cvs version that u give me
regards.
At 15.55 01/03/2004, you wrote:
>Davide Antoni wrote:
>>Tiny support blob?
>>when a make query on blob it give me e number not a string.
>>
>>_______________________________________________
>>tinysql mailing list
>>tinysql@as220.org
>>http://as220.org/mailman/listinfo/tinysql
>No, tinySQL does not support BLOBs, what you get is certainly the
>internal address of the memo-area. Memo support is not included
>yet, and therefore BLOBs or CLOBs aren't too.
>
>TinySQL only supports the basic data types: CHAR, NUMERIC, DATE.
>TinySQL is also bound to the limitations of the DBase file format.
>
>The supported types for both drivers are documented in the files
>"dbase.txt" and "textfiles.txt" contained in the root directory of
>the tinySQL package.
>
>Have more fun,
>said Thomas
>
>--
>Hi! I'm a evil cooperative .signature virus! Copy me into your=20
>~/.signature to help me spread and delete 10 random files from your=20
>system. Thank you!
***************************************************
Davide Antoni
SiC
Sezione di:
Via Trieste 41, - 55100 PISA
Sistema Informativo
Linux Registered User 223916
Voice: +3950913639
E-mail: davide.antoni@ifc.cnr.it
***************************************************
--=====================_538102119==.ALT
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<body>
1 how to exract the memo internal adderess? and there are a metod with
this one to exstract the memo field?<br><br>
2 there's a bug: when i make a query on a date field that return the date
in table but with one months added ex <br>
18-10-2003 return :18-11-2003<br>
18-12-2003 retunr : 18-1-2004<br><br>
i don=EC't think so that i do a bed query:<br><br>
rsTiny =3D stmtTiny.executeQuery("select DATA_ENTRA, DATA_USCIT from
Cartel where N_CART =3D "+N_CART);<br><br>
i have teh cvs version that u give me <br><br>
regards.<x-tab> </x-tab><br><=
br>
<br>
At 15.55 01/03/2004, you wrote:<br>
<blockquote type=3Dcite class=3Dcite cite>Davide Antoni wrote:<br>
<blockquote type=3Dcite class=3Dcite cite>Tiny support blob?<br>
when a make query on blob it give me e number not a string.<br><br>
_______________________________________________<br>
tinysql mailing list<br>
tinysql@as220.org<br>
<a href=3D"http://as220.org/mailman/listinfo/tinysql" eudora=3D"autourl">htt=
p://as220.org/mailman/listinfo/tinysql</a></blockquote>No,
tinySQL does not support BLOBs, what you get is certainly the<br>
internal address of the memo-area. Memo support is not included<br>
yet, and therefore BLOBs or CLOBs aren't too.<br><br>
TinySQL only supports the basic data types: CHAR, NUMERIC, DATE.<br>
TinySQL is also bound to the limitations of the DBase file
format.<br><br>
The supported types for both drivers are documented in the files<br>
"dbase.txt" and "textfiles.txt" contained in the root
directory of<br>
the tinySQL package.<br><br>
Have more fun,<br>
said Thomas<br><br>
-- <br>
Hi! I'm a evil cooperative .signature virus! Copy me into your
~/.signature to help me spread and delete 10 random files from your
system. Thank you!</blockquote>
<x-sigsep><p></x-sigsep>
<font face=3D"Tahoma"=
size=3D2>***************************************************<br>
</font><font face=3D"Tahoma">Davide Antoni<br>
</font><font face=3D"Tahoma" size=3D2>SiC<br>
Sezione di: <br>
Via Trieste 41, - 55100 PISA<br>
Sistema Informativo<br><br>
</font>Linux Registered User 223916<br><br>
<font face=3D"Tahoma" size=3D2>Voice: +3950913639<br>
E-mail: davide.antoni@ifc.cnr.it<br>
***************************************************<br><br>
<br>
</font></body>
</html>
--=====================_538102119==.ALT--