[tinysql] blob support and date
Davide Antoni
davide.antoni@ifc.cnr.it
Tue, 02 Mar 2004 09:31:39 +0100
--=====================_600021625==.ALT
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
Content-Transfer-Encoding: quoted-printable
I have submited :)
But for me this problem is marginal and i correct this from my program it=20
is "a piece of cake".
But the possibility to read blob or memo is much important ... and if this=
=20
don't to do i have to go to another dbf jdbc such as hxtt.
I explane my problem:
I have the the necessity to read medical Record in a dbf database. The=20
database is populated by a delphy application with BDE support.
My web application read this medical record. The delphy application is not=
=20
made by me and i don't have a source code , and this application work with=
=20
2 blob memo field
Regard.
At 16.35 01/03/2004, you wrote:
>I'm not sure whether we support memo fields or blobs, but I think we
>do not.
>
>Did you populate this table with tinySQL, or did you populate it using
>another database application? Which driver (dbf?) are you using? I think
>this date problem may be a known bug, but I won't have time to look into
>it for a couple of weeks. If you could enter the bug at the bug tracker
>at http://sourceforge.net/tracker/?group_id=3D82881&atid=3D567565, that=
would
>be a big help.
>
>
>On Mon, 1 Mar 2004, Davide Antoni wrote:
>
> > 1 how to exract the memo internal adderess? and there are a metod with=
this
> > one to exstract the memo field?
> >
> > 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
> > 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
> > where N_CART =3D "+N_CART);
> >
> > i have teh cvs version that u give me
> >
> > regards.
>
>_______________________________________________
>tinysql mailing list
>tinysql@as220.org
>http://as220.org/mailman/listinfo/tinysql
***************************************************
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
***************************************************
--=====================_600021625==.ALT
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<body>
I have submited :)<br><br>
But for me this problem is marginal and i correct this from my program it
is "a piece of cake".<br><br>
But the possibility to read blob or memo is much important ... and if
this don't to do i have to go to another dbf jdbc such as hxtt.<br><br>
I explane my problem:<br><br>
I have the the necessity to read medical Record in a dbf database. The
database is populated by a delphy application with BDE support.<br>
My web application read this medical record. The delphy application is
not made by me and i don't have a source code , and this application work
with 2 blob memo field <br><br>
Regard.<br><br>
<br><br>
At 16.35 01/03/2004, you wrote:<br><br>
<blockquote type=3Dcite class=3Dcite cite>I'm not sure whether we support
memo fields or blobs, but I think we<br>
do not.<br><br>
Did you populate this table with tinySQL, or did you populate it
using<br>
another database application? Which driver (dbf?) are you
using? I think<br>
this date problem may be a known bug, but I won't have time to look
into<br>
it for a couple of weeks. If you could enter the bug at the bug
tracker<br>
at
<a href=3D"http://sourceforge.net/tracker/?group_id=3D82881&atid=3D56756=
5" eudora=3D"autourl">http://sourceforge.net/tracker/?group_id=3D82881&a=
tid=3D567565</a>,
that would<br>
be a big help.<br><br>
<br>
On Mon, 1 Mar 2004, Davide Antoni wrote:<br><br>
> 1 how to exract the memo internal adderess? and there are a metod
with this<br>
> 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<br>
> 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<br>
> where N_CART =3D "+N_CART);<br>
><br>
> i have teh cvs version that u give me<br>
><br>
> regards.<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>
<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>
--=====================_600021625==.ALT--