Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2008-05

TEST SQLITE

13 messages · 6 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Joost van der Sluis
to Chris37

Op vrijdag 30-05-2008 om 01:01 uur [tijdzone +0200], schreef Chris37:

Show quoted text 7 lines
@ Joost van der Sluis Ref: http://bugs.freepascal.org/view.php?id=11350 Hi, Thank but wich version of Lazarus could i download for tested your correction ?

I think I was in time to make it into the snapshots of today or any later date. You can use a lazarus snapshot which contains fpc version 2.1.1

Joost.

Chris37
to Joost van der Sluis

Joost van der Sluis a ?crit :

Show quoted text 24 lines
Op vrijdag 30-05-2008 om 01:01 uur [tijdzone +0200], schreef Chris37: > @ Joost van der Sluis > > Ref: http://bugs.freepascal.org/view.php?id=11350 > > Hi, > Thank but wich version of Lazarus could i download for tested your > correction ? > I think I was in time to make it into the snapshots of today or any later date. You can use a lazarus snapshot which contains fpc version 2.1.1 Joost. _______________________________________________ Lazarus mailing list http://www.lazarus.freepascal.org/mailman/listinfo/lazarus

hi !
2.1.1 ?????

peng
to Chris37

Yes, Look here:

Click below for fpc and Lazarus snapshot
Lazarus - full - fpc 2.2.0 win32
Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe<ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe> Lazarus
- full - fpc 2.2.1 win32
Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe<ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe>

2008/5/31 Chris37 : > > > hi ! > 2.1.1 ????? > -- ??'?????'? http://pengtu.net/ooo -------------- next part -------------- An HTML attachment was scrubbed... URL: http://www.lazarus.freepascal.org/pipermail/lazarus/attachments/20080531/9accacaa/attachment.html
Chris37
to peng

peng a ?crit :

Show quoted text 32 lines
Yes, Look here: Click below for fpc and Lazarus snapshot Lazarus - full - fpc 2.2.0 win32 Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe> Lazarus - full - fpc 2.2.1 win32 Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe> -- 2008/5/31 Chris37 < <mailto:>>: > hi ! 2.1.1 ????? -- ??'?????'? http://pengtu.net/ooo ------------------------------------------------------------------------ _______________________________________________ Lazarus mailing list http://www.lazarus.freepascal.org/mailman/listinfo/lazarus

Thank all but joost modification not implemented in Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe
<ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe> I wait for this :)

Another question svp ?
With TConnection, how read fieldstype ? GetFielsTable send only fieldname in a TStrings

Regard
Chris

Michael Van Canneyt
to Chris37
Chris37 wrote 41 lines
peng a ?crit : > Yes, Look here: > > Click below for fpc and Lazarus snapshot > Lazarus - full - fpc 2.2.0 win32 > Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe > <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe> > > Lazarus - full - fpc 2.2.1 win32 > Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe > <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe> > > > > > -- > 2008/5/31 Chris37 < <mailto:>>: > > > > hi ! > 2.1.1 ????? > > > -- > ??'?????'? > http://pengtu.net/ooo > ------------------------------------------------------------------------ > > _______________________________________________ > Lazarus mailing list > > http://www.lazarus.freepascal.org/mailman/listinfo/lazarus > Thank all but joost modification not implemented in Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe> I wait for this :) Another question svp ? With TConnection, how read fieldstype ? GetFielsTable send only fieldname in a TStrings

You can't.

You can do a
  select * from tablename where 1=0;

that will give you an empty dataset and you can read all filenames, types and whatnot. All other methods are engine dependent.

Michael.

Michael Van Canneyt
to Chris37: Joost van der Sluis a ?crit : hi ! 2.1.1 ?????
Chris37 wrote 27 lines
Joost van der Sluis a ?crit : > Op vrijdag 30-05-2008 om 01:01 uur [tijdzone +0200], schreef Chris37: > >> @ Joost van der Sluis >> >> Ref: http://bugs.freepascal.org/view.php?id=11350 >> >> Hi, >> Thank but wich version of Lazarus could i download for tested your >> correction ? >> > > I think I was in time to make it into the snapshots of today or any > later date. You can use a lazarus snapshot which contains fpc version > 2.1.1 > > Joost. > > _______________________________________________ > Lazarus mailing list > > http://www.lazarus.freepascal.org/mailman/listinfo/lazarus > > > hi ! 2.1.1 ?????

He meant 2.2.1

Michael.

Chris37
to Michael Van Canneyt: You can't. You can do a select * from tablename where 1=0; that will give you an empty…

Michael Van Canneyt a ?crit :

Show quoted text 64 lines
On Fri, 30 May 2008, Chris37 wrote: > peng a ?crit : > >> Yes, Look here: >> >> Click below for fpc and Lazarus snapshot >> Lazarus - full - fpc 2.2.0 win32 >> Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe >> <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe> >> >> Lazarus - full - fpc 2.2.1 win32 >> Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe >> <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe> >> >> >> >> >> -- >> 2008/5/31 Chris37 < <mailto:>>: >> >> > >> hi ! >> 2.1.1 ????? >> >> >> -- >> ??'?????'? >> http://pengtu.net/ooo >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Lazarus mailing list >> >> http://www.lazarus.freepascal.org/mailman/listinfo/lazarus >> >> > Thank all but joost modification not implemented in > Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe > <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe> > I wait for this :) > > Another question svp ? > With TConnection, how read fieldstype ? GetFielsTable send only > fieldname in a TStrings > You can't. You can do a select * from tablename where 1=0; that will give you an empty dataset and you can read all filenames, types and whatnot. All other methods are engine dependent. Michael. ------------------------------------------------------------------------ _______________________________________________ Lazarus mailing list http://www.lazarus.freepascal.org/mailman/listinfo/lazarus

Ok Michael ! thank !

Juan Cortés Cuesta
to Michael Van Canneyt: You can't. You can do a select * from tablename where 1=0; that will give you an empty…

I am trying to download Lazarus from
ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530- win32.exe
and fail (see below)....... File don't exists..... Is the Link correct?
Warmest Regards
Juan
je:/tmp# wget -nH -nd -t 0
ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530- win32.exe
--17:35:16--
ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530- win32.exe
=> `Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe'
Resolviendo ftp.hu.freepascal.org... 193.224.143.26 Connecting to ftp.hu.freepascal.org|193.224.143.26|:21... conectado. Identific?ndose como anonymous ... ?Dentro!
==> SYST ... hecho. ==> PWD ... hecho.
==> TYPE I ... hecho. ==> CWD /pub/lazarus ... hecho. ==> PASV ... hecho. ==> RETR
Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe ...
No existe el fichero `Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe'.

Michael Van Canneyt wrote 55 lines
On Fri, 30 May 2008, Chris37 wrote: > peng a ?crit : > > Yes, Look here: > > > > Click below for fpc and Lazarus snapshot > > Lazarus - full - fpc 2.2.0 win32 > > Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe > > <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe> > > > > Lazarus - full - fpc 2.2.1 win32 > > Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe > > <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe> > > > > > > > > > > -- > > 2008/5/31 Chris37 < <mailto:>>: > > > > > > > hi ! > > 2.1.1 ????? > > > > > > -- > > '': > > http://pengtu.net/ooo > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Lazarus mailing list > > > > http://www.lazarus.freepascal.org/mailman/listinfo/lazarus > > > Thank all but joost modification not implemented in > Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe > <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe> > I wait for this :) > > Another question svp ? > With TConnection, how read fieldstype ? GetFielsTable send only > fieldname in a TStrings You can't. You can do a select * from tablename where 1=0; that will give you an empty dataset and you can read all filenames, types and whatnot. All other methods are engine dependent. Michael.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.lazarus.freepascal.org/pipermail/lazarus/attachments/20080606/c1bbc9bb/attachment-0001.html

Damien Gerard
to Juan Cortés Cuesta

Le Jun 6, 2008 ? 2:38 PM, Juan Cort?s Cuesta a ?crit :

Show quoted text 9 lines
I am trying to download Lazarus from ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530- win32.exe and fail (see below)....... File don't exists..... Is the Link correct?

You should not use this snapshots, a most recent one is available. ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.3-20080606-win32.exe

If you absolutly want this version, you can find it here : http://snapshots.lazarus.shikami.org/lazarus/downloads/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe

Show quoted text 89 lines
Warmest Regards Juan je:/tmp# wget -nH -nd -t 0 ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530- win32.exe --17:35:16-- ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530- win32.exe => `Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe' Resolviendo ftp.hu.freepascal.org ... 193.224.143.26 Connecting to ftp.hu.freepascal.org|193.224.143.26|:21 ... conectado. Identific?ndose como anonymous ... ?Dentro! ==> SYST ... hecho. ==> PWD ... hecho. ==> TYPE I ... hecho. ==> CWD /pub/lazarus ... hecho. ==> PASV ... hecho. ==> RETR Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe ... No existe el fichero `Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe'. On 30 May 2008 at 23:04, Michael Van Canneyt wrote: > > > On Fri, 30 May 2008, Chris37 wrote: > > > peng a ?crit : > > > Yes, Look here: > > > > > > Click below for fpc and Lazarus snapshot > > > Lazarus - full - fpc 2.2.0 win32 > > > Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe > > > <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.0-20080530-win32.exe > > > > > > > Lazarus - full - fpc 2.2.1 win32 > > > Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe > > > <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe > > > > > > > > > > > > > > > > -- > > > 2008/5/31 Chris37 < <mailto: >>: > > > > > > > > > > hi ! > > > 2.1.1 ????? > > > > > > > > > -- > > > ??'?????'? > > > http://pengtu.net/ooo > > > ------------------------------------------------------------------------ > > > > > > _______________________________________________ > > > Lazarus mailing list > > > > > > http://www.lazarus.freepascal.org/mailman/listinfo/lazarus > > > > > Thank all but joost modification not implemented in > > Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe > > <ftp://ftp.hu.freepascal.org/pub/lazarus/Lazarus-0.9.25-fpc-2.2.1-20080530-win32.exe > > > I wait for this :) > > > > Another question svp ? > > With TConnection, how read fieldstype ? GetFielsTable send only > > fieldname in a TStrings > > You can't. > > You can do a > select * from tablename where 1=0; > > that will give you an empty dataset and you can read all filenames, types and whatnot. > All other methods are engine dependent. > > Michael. _______________________________________________ Lazarus mailing list http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
Damien Gerard "Intelligence is 10 million rules." -- Douglas Lenat
Joost van der Sluis
to Chris37

sqlite doesn't even have a memo-field type. So how should we support it?

But sqlite doesn't support any field-type, so we could mask this. But what are you trying to do?

Joost.

Op woensdag 11-06-2008 om 20:51 uur [tijdzone +0200], schreef Chris37:

Show quoted text 18 lines
Hi all, Lazarus 0.9.25 and FPC 2.2.2rc1 With SQLITE3Connection and SQLQuery I have error message 'ftMemo not supported' Have you problems with type ftMemo and Sqlite3 please ? Regards Chris _______________________________________________ Lazarus mailing list http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
Chris37
to Joost van der Sluis

Joost van der Sluis a ?crit :

Show quoted text 28 lines
sqlite doesn't even have a memo-field type. So how should we support it? But sqlite doesn't support any field-type, so we could mask this. But what are you trying to do? Joost. Op woensdag 11-06-2008 om 20:51 uur [tijdzone +0200], schreef Chris37: > Hi all, > > Lazarus 0.9.25 and FPC 2.2.2rc1 > > With SQLITE3Connection and SQLQuery > > I have error message 'ftMemo not supported' > > Have you problems with type ftMemo and Sqlite3 please ? > > Regards > Chris > > _______________________________________________ > Lazarus mailing list > > http://www.lazarus.freepascal.org/mailman/listinfo/lazarus > >

Hi Joost !

Thank :)

-In my sqlite database, my field is declare to 'TEXT' datatype -Its work with TSqlite3Dataset and a dbgrid
-Its *not* work with TSqlQuery and a dbgrid

Regards
Chris