Menu
▾
▴
libsql-discussion — Libsql open discussion mailing list
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(15) |
Nov
|
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006 |
Jan
|
Feb
|
Mar
(13) |
Apr
(1) |
May
(4) |
Jun
|
Jul
|
Aug
(5) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2008 |
Jan
|
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: R. T. <re...@du...> - 2008-02-12 18:11:08
|
Hi, Most likely this it because TJanSQL isn't yet tested / ported to a unix environment, of course you are free to see if you can get it to compile and submit the changes needed. But, since you mention TJanSQL, imho it is not stable enough yet for practical use. The code needs to be checked since it has issues on certain queries causing crashes. Also, i havent checked if Jan did update this code to a newer version. A native pascal SQL engine like TJanSQL has lot of potentional, but at this stage i dont consider the code finished, its primary there to show libsql can support almost any arbitrary sql engine, and as alternative for leight-weight applications that for some reason prefer not to use SQLite (which is a superior solution for embedded sql - but requires a dll or a lot of work to link it as objects in pascal). If and when libsql will be updated i can't promise you. If you are willing to spend time on the project i'd be happy to add you as developer on sourceforge so you can work on the current cvs tree. kind regards, Rene Zlatko Matić schreef: > Hello. > I have installed libsql on Lazarus and then realized that some > components are missng in libsql. > Several components (such as TJanSQL) are disabled in IFNDEF for FPC. > What is the reason? Is this only temporarily? When will those > components be enabled for Lazarus? > > Regards, > Zlatko > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > ------------------------------------------------------------------------ > > _______________________________________________ > libsql-discussion mailing list > lib...@li... > https://lists.sourceforge.net/lists/listinfo/libsql-discussion > |
|
From: Zlatko M. <zla...@sb...> - 2008-02-12 16:44:27
|
Hello. I have installed libsql on Lazarus and then realized that some components are missng in libsql. Several components (such as TJanSQL) are disabled in IFNDEF for FPC. What is the reason? Is this only temporarily? When will those components be enabled for Lazarus? Regards, Zlatko |
|
From: Patrick C. <pc...@ap...> - 2007-08-01 13:42:15
|
Hi, Today I committed to the CVS a small change (a few ifdef) that allow libsql to compile with FPC/Lazarus for WinCE. This make it capable to access a sqlite database on a PDA by just adding an ARM compiled sqlite3.dll. All the basic functionalities are working and performance is reasonable considering the device. The biggest problem is with formated result. Because of problem with the variants you cannot use results[0].Format[0].AsInteger but need to format the raw result yourself with strtoint(results[0].Strings[0]) Patrick |
|
From: <re...@du...> - 2006-08-26 14:31:50
|
Hi, This is a good question and i don't know the answer myself to be honest.= ODBC uses an odd method of escaping, just ' is replaced with '' (twice),= i am not sure how it handles or should handle binary zero's. Other databases use a backslash for escaping, making escaping a binary zero also easy (although i messed up and only recently fixed mysql blob reading thanks to a bug report). libsql has escape functions that behave database specific (=3D backslash= for mysql/sqlite; double quote to insert a single quote in ODBC). If anyone (empirically) finds the answer i'd be happy to implement it. kind regards, Rene Leonardo M. Ram=E9 schreef: > Does anybody knows how to insert or update a blob field in an ODBC con= nection? > > Leonardo M. Ram=E9 > http://leonardorame.blogspot.com > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > ----------------------------------------------------------------------= --- > Using Tomcat but need to do more? Need to support web services, securi= ty? > Get stuff done quickly with pre-integrated technology to make your job= easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Gero= nimo > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&da= t=3D121642 > _______________________________________________ > libsql-discussion mailing list > lib...@li... > https://lists.sourceforge.net/lists/listinfo/libsql-discussion > |
|
From: Leonardo M. R. <mar...@ya...> - 2006-08-25 13:00:40
|
Does anybody knows how to insert or update a blob field in an ODBC connection? Leonardo M. Ramé http://leonardorame.blogspot.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com |
|
From: Leonardo M. R. <mar...@ya...> - 2006-08-17 13:35:23
|
Thanks René,
i checked your fix for the mysql blob problem and it works very well now.
Continuing with the bugs i found, when i compile in Delphi with range checking on and try to do a
select in an Access table (via ODBC) that has a Memo field, a range error exception is raised. I
resolved changing the type of TFieldDesc's _datatype member to smallint (it was Byte), i don't
know if that could break other parts of the code.
Leonardo M. Ramé
http://leonardorame.blogspot.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
|
|
From: Leonardo M. R. <mar...@ya...> - 2006-08-14 18:02:11
|
Leonardo M. Ramé http://leonardorame.blogspot.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com |
|
From: <re...@du...> - 2006-08-14 13:30:53
|
|
From: <re...@du...> - 2006-05-24 07:21:02
|
Hi Alex, Thanks for this info! 1 using cvs now made its first victim ;) I've converted the lineendings to CRLF again. hope this will not mess up cvs (leave others with blank lines), we'll see. 2 you are right, this should be properly switched 3 TList.Assign method is unknown by D5 I've compiled the new source on D5 which seems to be ok, and released it as version 0.751. You can download it from sourceforge: http://sourceforge.net/project/showfiles.php?group_id=103463&package_id=122533 kind regards, Rene Alex Brainman schreef: > Hi there, > > > Sorry to write uninvited, but, I thought, you might be interested of > problems I had compiling libsql-0.75 under Delphi 5. Even still, my > Delphi is pretty out of date, you should be able to fix those > problems, I think. > > 1) Some source files are LF delimited, not CR+LF delimited, Delphi 5 > refuses to compile. I know, that Kylix will compile either with no > problem, maybe you should distribute them as CR+LF only. My version > control system gives me my source with CR+LF on Windows and with LF on > Linux, so I always take files for distribution from Windows workspace. > > 2) janSQL.pas lists variants.pas in it's uses, Delphi 5 doesn't have > that unit. > > 3) fails to compile lsdatasettable.pas with: 'Undeclared identifier > "Assign"' in: > FEditRow.FNulls.Assign(PRecInfo(ActiveBuffer).Row.FNulls); > > That is as far as I got <g>. Thanks for your efforts anyways. > > > Alex |
|
From: Patrick C. <pc...@ap...> - 2006-05-22 12:52:00
|
Ren=E9,
I just do a new change to passqlite.pas because the new Query3 do not work wh=
en using CallBackOnly and onFetchRow. I just add a test to use the old query=
=20method when CallBackOnly is set.=20
Maybe it is possible to add a call to QueryCallback somewhere in Query3 ?
I also comment the SQLITE3_STATIC.
Patrick
=20
----- Original message -----
From: "Ren=E9 Tegel" <re...@du...>
Date: Mon, 22 May 2006 11:13:11 +0200
Subject: Re: [libsql] It work on Mac OS X!
To: lib...@li...
>Patrick,
>
>Thanks a lot! Looks good to me. Think that makes up for a 0.75 release,=20
>i tested yesterday and it compiles just fine on my system, however i=20
>didn't have the time to finish the release yesterday, but probably this=20
>evening i will put latest source on sf.
>
>About the static, that should indeed not be enabled by default i think,=20
>so i removed that again.
>
>Best regards,
>
>Rene
>
>Patrick Chevalley schreef:
>> Hi,
>>
>> Today I fix a few thing to let Libsql to work on Mac OS X with=20
>> FreePascal.
>> This is now committed to the CVS.
>>
>> The whole thing was to replace the .dll by .dylib and reorder a bit the
>> $IFDEF's.
>> It take me more time to test the change with OSX/FPC, Linux/FPC,
>> Linux/Kylix, Win/FPC and Win/Delphi ... and each time with Sqlite and
>> Mysql ...
>>
>> I not change the default value in the passqlite.pas source but you need
>> to remove the {$DEFINE SQLITE3_STATIC}. Maybe we can enclose it in a
>> {$IFDEF WIN32} because it probably not work at the moment on other=20
>> platform.
>>
>> I also IFDEF the new component (JanDb, Dataset) in sqlcomponents.pas
>> because this work only with Win32/Delphi.
>>
>> Last change, I add a Lazarus package (libsql.lpk) to help the=20
>> installation.
>>
>> Regards,
>>
>> Patrick
>>
>>
>>
>> -------------------------------------------------------
>> Using Tomcat but need to do more? Need to support web services, security?
>> Get stuff done quickly with pre-integrated technology to make your job=20
>> easier
>> Download IBM WebSphere Application Server v.1.0.1 based on Apache=20
>> Geronimo
>> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
>> _______________________________________________
>> libsql-discussion mailing list
>> lib...@li...
>> https://lists.sourceforge.net/lists/listinfo/libsql-discussion
>
>
>
>-------------------------------------------------------
>Using Tomcat but need to do more? Need to support web services, security?
>Get stuff done quickly with pre-integrated technology to make your job easie=
r
>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D12=
1642
>_______________________________________________
>libsql-discussion mailing list
>lib...@li...
>https://lists.sourceforge.net/lists/listinfo/libsql-discussion
>
|
|
From: <re...@du...> - 2006-05-22 09:14:08
|
Patrick,
Thanks a lot! Looks good to me. Think that makes up for a 0.75 release,
i tested yesterday and it compiles just fine on my system, however i
didn't have the time to finish the release yesterday, but probably this
evening i will put latest source on sf.
About the static, that should indeed not be enabled by default i think,
so i removed that again.
Best regards,
Rene
Patrick Chevalley schreef:
> Hi,
>
> Today I fix a few thing to let Libsql to work on Mac OS X with
> FreePascal.
> This is now committed to the CVS.
>
> The whole thing was to replace the .dll by .dylib and reorder a bit the
> $IFDEF's.
> It take me more time to test the change with OSX/FPC, Linux/FPC,
> Linux/Kylix, Win/FPC and Win/Delphi ... and each time with Sqlite and
> Mysql ...
>
> I not change the default value in the passqlite.pas source but you need
> to remove the {$DEFINE SQLITE3_STATIC}. Maybe we can enclose it in a
> {$IFDEF WIN32} because it probably not work at the moment on other
> platform.
>
> I also IFDEF the new component (JanDb, Dataset) in sqlcomponents.pas
> because this work only with Win32/Delphi.
>
> Last change, I add a Lazarus package (libsql.lpk) to help the
> installation.
>
> Regards,
>
> Patrick
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> libsql-discussion mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libsql-discussion
|
|
From: Patrick C. <pc...@ap...> - 2006-05-21 21:28:21
|
Hi,
Today I fix a few thing to let Libsql to work on Mac OS X with FreePascal.
This is now committed to the CVS.
The whole thing was to replace the .dll by .dylib and reorder a bit the
$IFDEF's.
It take me more time to test the change with OSX/FPC, Linux/FPC,
Linux/Kylix, Win/FPC and Win/Delphi ... and each time with Sqlite and
Mysql ...
I not change the default value in the passqlite.pas source but you need
to remove the {$DEFINE SQLITE3_STATIC}. Maybe we can enclose it in a
{$IFDEF WIN32} because it probably not work at the moment on other platform.
I also IFDEF the new component (JanDb, Dataset) in sqlcomponents.pas
because this work only with Win32/Delphi.
Last change, I add a Lazarus package (libsql.lpk) to help the installation.
Regards,
Patrick
|
|
From: <re...@du...> - 2006-04-01 10:04:50
|
Hi, I have been thinking the following: hosting is no issue, sourceforge may be an option but they are slow and their hosting is not optimal to run some cms or wiki. I can create a site and subdomain and an account for you on my webserver. About 'my wishes', i am not sure but i think mainly the documentation (from 1st-use howto to more advanced docs) should be better structured. On the actual site and method (manual/cms etc) i have no preference. I'll send you account details privately, and give you a 'carte blanche' on the site itself, if that is ok with you. regards, Rene Andy Chandler wrote: >Rene, > > Yes! Let me know off-list what sort of thing you'd be looking for etc. >and I'll see what I can put together for you. > >Andy > > > > >Thursday, March 30, 2006, 10:49:03 AM, you wrote: > > > >>Hi, >> >> > > > >>If that is an offer to setup/maintain a descent website, i am all ears :) >> >> > > > > >>Andy Chandler wrote: >> >> > > > >>>Rene, >>> >>> >>> >>> >>> >>>>There is lots more one the to-do, excuse my limited time but i would be >>>>happy to give you developer access on sf so you can contribute your >>>>additions or changes in cvs. >>>> >>>> >>>> >>>> >>> >>> >>> >>> >>>>I'll put better website and documentation for libsql on my todo list. >>>> >>>> >>>> >>>> >>>I'm certainly not up to Delphi standard to be able to help you as a developer >>>like Ariel might be, but if you want a hand with any of the >>>donkey-work with regards to the website, I'd be glad to help out as a >>>thank-you for your work and support on LibSQL. >>> >>> >>>Rgs, >>>Andy >>> >>> >>> >>> >>> >>>------------------------------------------------------- >>>This SF.Net email is sponsored by xPML, a groundbreaking scripting language >>>that extends applications into web and mobile media. Attend the live webcast >>>and join the prime developer group breaking into this new coding territory! >>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 >>>_______________________________________________ >>>libsql-discussion mailing list >>>lib...@li... >>>https://lists.sourceforge.net/lists/listinfo/libsql-discussion >>> >>> >>> >>> > > > > > >>------------------------------------------------------- >>This SF.Net email is sponsored by xPML, a groundbreaking scripting language >>that extends applications into web and mobile media. Attend the live webcast >>and join the prime developer group breaking into this new coding territory! >>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 >>_______________________________________________ >>libsql-discussion mailing list >>lib...@li... >>https://lists.sourceforge.net/lists/listinfo/libsql-discussion >> >> > > > > > >------------------------------------------------------- >This SF.Net email is sponsored by xPML, a groundbreaking scripting language >that extends applications into web and mobile media. Attend the live webcast >and join the prime developer group breaking into this new coding territory! >http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 >_______________________________________________ >libsql-discussion mailing list >lib...@li... >https://lists.sourceforge.net/lists/listinfo/libsql-discussion > > |
|
From: Andy C. <and...@bt...> - 2006-03-30 21:09:21
|
Rene,
Yes! Let me know off-list what sort of thing you'd be looking for etc.
and I'll see what I can put together for you.
Andy
Thursday, March 30, 2006, 10:49:03 AM, you wrote:
> Hi,
> If that is an offer to setup/maintain a descent website, i am all ears :)
> Andy Chandler wrote:
>>Rene,
>>
>>
>>
>>>There is lots more one the to-do, excuse my limited time but i would be
>>>happy to give you developer access on sf so you can contribute your
>>>additions or changes in cvs.
>>>
>>>
>>
>>
>>
>>>I'll put better website and documentation for libsql on my todo list.
>>>
>>>
>>
>>
>>I'm certainly not up to Delphi standard to be able to help you as a developer
>>like Ariel might be, but if you want a hand with any of the
>>donkey-work with regards to the website, I'd be glad to help out as a
>>thank-you for your work and support on LibSQL.
>>
>>
>>Rgs,
>>Andy
>>
>>
>>
>>
>>
>>-------------------------------------------------------
>>This SF.Net email is sponsored by xPML, a groundbreaking scripting language
>>that extends applications into web and mobile media. Attend the live webcast
>>and join the prime developer group breaking into this new coding territory!
>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>>_______________________________________________
>>libsql-discussion mailing list
>>lib...@li...
>>https://lists.sourceforge.net/lists/listinfo/libsql-discussion
>>
>>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> libsql-discussion mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libsql-discussion
|
|
From: <re...@du...> - 2006-03-30 09:49:12
|
Hi, If that is an offer to setup/maintain a descent website, i am all ears :) Andy Chandler wrote: >Rene, > > > >>There is lots more one the to-do, excuse my limited time but i would be >>happy to give you developer access on sf so you can contribute your >>additions or changes in cvs. >> >> > > > >>I'll put better website and documentation for libsql on my todo list. >> >> > > >I'm certainly not up to Delphi standard to be able to help you as a developer >like Ariel might be, but if you want a hand with any of the >donkey-work with regards to the website, I'd be glad to help out as a >thank-you for your work and support on LibSQL. > > >Rgs, >Andy > > > > > >------------------------------------------------------- >This SF.Net email is sponsored by xPML, a groundbreaking scripting language >that extends applications into web and mobile media. Attend the live webcast >and join the prime developer group breaking into this new coding territory! >http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 >_______________________________________________ >libsql-discussion mailing list >lib...@li... >https://lists.sourceforge.net/lists/listinfo/libsql-discussion > > |
|
From: <Ars...@bp...> - 2006-03-28 16:53:23
|
Never mind, I put the SQL statement in a MyDB1.Query( and it worked like =
a charm... LibSQL is great!
Ariel
-----Mensaje original-----
De: lib...@li... =
[mailto:lib...@li...] En nombre de =
Ariel S=E1nchez Mora
Enviado el: lunes, 27 de marzo de 2006 18:29
Para: lib...@li...
Asunto: [libsql] MyDB1.Execute( actually gives me a run time error!
I read somewhere if this happens, I'm really doing something wrong. =
Using Delphi 7.1, the error is in the attachment. The first row of the =
for loop does get inserted, I can see it when I check the table; but =
then the runtime error occurs; it even occurs without the for loop. =
(only one Execute)
This is the routine which generates the error:
For fila:=3D0 to StringGrid1.RowCount do
begin
MyDB1.Execute('insert into lista_oficinas VALUES =
(null,"'+StringGrid1.Rows[fila].Strings[0]+'","'+StringGrid1.Rows =
[fila].Strings[1]+'","'+StringGrid1.Rows[fila].Strings[2]+'")');
Memo1.Lines.Add('insert into lista_oficinas VALUES =
(null,"'+StringGrid1.Rows[fila].Strings[0]+'","'+StringGrid1.Rows =
[fila].Strings[1]+'","'+StringGrid1.Rows[fila].Strings[2]+'")');
end;
And this is where the debugger takes me:
FillFieldInfo (PMYSQL_RES(Result));
FCurrentSet.FColCount :=3D =
mf.mysql_num_fields(PMYSQL_RES(Result));
The table's structure is:
CREATE TABLE `lista_oficinas` ( =
=20
`ID_nombre_oficina` smallint(6) NOT NULL =
auto_increment COMMENT 'numero unico para identificar cada oficina', =20
`Nombre_oficina` varchar(40) NOT NULL default '' =
COMMENT 'Nombre comun de la oficina', =20
`Region` varchar(20) NOT NULL default '' COMMENT =
'provincia o region segun el BP', =20
`diagrama_oficina` varchar(100) NOT NULL default '' =
COMMENT 'diagrama en visio en servidor SAOR', =20
PRIMARY KEY (`ID_nombre_oficina`) =
=20
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1
And if I only run the Memo1 part and then copy paste the query in the =
mysql client, theres no prob
mysql> insert into lista_oficinas VALUES (null,"CSF=20
mysql> Alajuela","Alajuela","\\Itin-fps02\subproceso aor\Diagramas de =
red\C
entros de Servicio Financiero\DG013P1-01.vsd");
Query OK, 1 row affected (0.00 sec)
Can anyone direct me in the proper way I should use MyBD1.Execute( ? I =
tried with ';' and no ';' at the end (I saw it in an example). I tried =
taking away the primary key, cause it was a big deal in dbexpress. I'm =
using version .64, and if anyone is interested, i can send you all you =
want :)
Thanks for your time! I'm the only posting... I bet you think I'm a =
nuisance!=20
Rene, I'm not really a sistems engineer, but I'll see what I can do for =
you.
Ariel
|
|
From: Andy C. <and...@bt...> - 2006-03-28 00:49:36
|
Hi Ariel,
Rene will soon correct me if I'm wrong, but I would re-write the
line as
MyDB1.FormatQuery('INSERT INTO lista_oficinas VALUES(%d, %s, %s, %s)",
[null, StringGrid1.Rows[fila].Strings[0],
StringGrid1.Rows[fila].Strings[1],
StringGrid1.Rows[fila].Strings[2]]);
This is a little easier to maintain and read. With Query (versus
Execute) you don't have to worry about closing handles either.
Hopefully this will help you, if only a little ;-)
Rgs,
Andy
|
|
From: <Ars...@bp...> - 2006-03-28 00:29:52
|
I read somewhere if this happens, I'm really doing something wrong. =
Using Delphi 7.1, the error is in the attachment. The first row of the =
for loop does get inserted, I can see it when I check the table; but =
then the runtime error occurs; it even occurs without the for loop. =
(only one Execute)
This is the routine which generates the error:
For fila:=3D0 to StringGrid1.RowCount do
begin
MyDB1.Execute('insert into lista_oficinas VALUES =
(null,"'+StringGrid1.Rows[fila].Strings[0]+'","'+StringGrid1.Rows =
[fila].Strings[1]+'","'+StringGrid1.Rows[fila].Strings[2]+'")');
Memo1.Lines.Add('insert into lista_oficinas VALUES =
(null,"'+StringGrid1.Rows[fila].Strings[0]+'","'+StringGrid1.Rows =
[fila].Strings[1]+'","'+StringGrid1.Rows[fila].Strings[2]+'")');
end;
And this is where the debugger takes me:
FillFieldInfo (PMYSQL_RES(Result));
FCurrentSet.FColCount :=3D =
mf.mysql_num_fields(PMYSQL_RES(Result));
The table's structure is:
CREATE TABLE `lista_oficinas` ( =
=20
`ID_nombre_oficina` smallint(6) NOT NULL =
auto_increment COMMENT 'numero unico para identificar cada oficina', =20
`Nombre_oficina` varchar(40) NOT NULL default '' =
COMMENT 'Nombre comun de la oficina', =20
`Region` varchar(20) NOT NULL default '' COMMENT =
'provincia o region segun el BP', =20
`diagrama_oficina` varchar(100) NOT NULL default '' =
COMMENT 'diagrama en visio en servidor SAOR', =20
PRIMARY KEY (`ID_nombre_oficina`) =
=20
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1
And if I only run the Memo1 part and then copy paste the query in the =
mysql client, theres no prob
mysql> insert into lista_oficinas VALUES (null,"CSF =
Alajuela","Alajuela","\\Itin-fps02\subproceso aor\Diagramas de red\C
entros de Servicio Financiero\DG013P1-01.vsd");
Query OK, 1 row affected (0.00 sec)
Can anyone direct me in the proper way I should use MyBD1.Execute( ? I =
tried with ';' and no ';' at the end (I saw it in an example). I tried =
taking away the primary key, cause it was a big deal in dbexpress. I'm =
using version .64, and if anyone is interested, i can send you all you =
want :)
Thanks for your time! I'm the only posting... I bet you think I'm a =
nuisance!=20
Rene, I'm not really a sistems engineer, but I'll see what I can do for =
you.
Ariel
|
|
From: Andy C. <and...@bt...> - 2006-03-27 20:20:11
|
Rene, > There is lots more one the to-do, excuse my limited time but i would be > happy to give you developer access on sf so you can contribute your > additions or changes in cvs. > I'll put better website and documentation for libsql on my todo list. I'm certainly not up to Delphi standard to be able to help you as a developer like Ariel might be, but if you want a hand with any of the donkey-work with regards to the website, I'd be glad to help out as a thank-you for your work and support on LibSQL. Rgs, Andy |
|
From: <re...@du...> - 2006-03-27 18:54:45
|
Ariel S=E1nchez Mora wrote:
>Excellent then! I'm making progress, the connection went without problem=
s :) has anyone made a program with LibSQL and a DBGrid? I'm curently adv=
ancing using a StringGrid, which would help for my display purposes, but =
a DBGrid where I could ApplyUpdates would be nice.
>
>I guess I could think up a way to make a workaround for ApplyUpdates :) =
This is the code I've used for displaying in StringGrid, any suggestions =
of a better way of doing it? This is a trial database, don't worry about =
the passwordless root account ;)
> =20
>
If you need data editing from a stringgrid, have you considered using=20
libsql's (new) TDataSet compliaonce functidonality? Has some rough edges=20
though but (is presumed to) works with tables on all supported db=20
(sqlite, mysql & odbc).
Further improvends to the library regarding visual components would be=20
support units that would fill components like comboboxes, listboxes,=20
listviews, stringgriids etc. It is outside core functionality but this=20
functionality is typical a re-occuring task.
There is lots more one the to-do, excuse my limited time but i would be=20
happy to give you developer access on sf so you can contribute your=20
additions or changes in cvs.
regards,
Rene
>
>procedure TForm1.Button1Click(Sender: TObject);
>var f : integer ;
>begin
> MyDB1.Connect('localhost','root','','monitoreo_saor');
> if MyDB1.Query('select nombre_dns,region from lista_routers;') then
> begin
> StringGrid1.ColCount :=3D MyDB1.ColCount;
> StringGrid1.RowCount :=3D MyDB1.RowCount;
> ShowMessage('filas: '+InttoStr(MyDB1.RowCount)+' columnas: '+InttoSt=
r(MyDB1.ColCount));
>
> for f :=3D 0 to MyDB1.RowCount do
> begin
> StringGrid1.Rows[f].CommaText :=3D MyDB1.Results[f].CommaText;
> end;
> end
>end;
>
>
>I'm finding LibSQL to be very complete, at least for my needs :) thanks =
for developing it! If you need help putting up examples and maybe a tutor=
ial, I can help, although I don't know much yet ;)
>
>Ariel
>
>
>-----Mensaje original-----
>De: lib...@li... [mailto:libsql-discuss=
ion...@li...] En nombre de Ren=E9 Tegel
>Enviado el: lunes, 27 de marzo de 2006 12:05
>Para: lib...@li...
>Asunto: Re: [libsql] Hi! newbie. What happened to the wiki?
>
>
>Ariel S=E1nchez Mora wrote:
>
> =20
>
>>I have just downloaded everything I could find on LibSQL, but the wiki
>>is full of porn links; someone "broke in" ? Hope you can fix it soon...
>>=20
>>I am looking for an easy solution that will free me of the numerous
>>bugs I find in dbexpress with MySQL and Delphi 7.1. From what I've=20
>>seen, LibSQL is great, so I would really like to know if the group is=20
>>active? So someone can send me pointers when I need them :)
>>=20
>>Good day!
>>=20
>>ariel
>> =20
>>
>
>Hi,
>
>Thanks for alerting me - i will look after the site and probably disable=
=20
>the wiki. Wiki's are a nice idea but simply doesn't work because some=20
>people lack any kind of personal honor it seems.
>
>The sourceforge list is the right one, there may be some delays=20
>sometimes, the group at yahoo is inactive and no longer takes new member=
s.
>
>I'll put better website and documentation for libsql on my todo list.
>
>Regards,
>
>Rene
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by xPML, a groundbreaking scripting langu=
age that extends applications into web and mobile media. Attend the live =
webcast and join the prime developer group breaking into this new coding =
territory! http://sel.as-us.falkag.net/sel?cmd=3Dk&kid=110944&bid$1720&da=
t=121642
>_______________________________________________
>libsql-discussion mailing list lib...@li...
>https://lists.sourceforge.net/lists/listinfo/libsql-discussion
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by xPML, a groundbreaking scripting langu=
age
>that extends applications into web and mobile media. Attend the live web=
cast
>and join the prime developer group breaking into this new coding territo=
ry!
>http://sel.as-us.falkag.net/sel?cmd=3Dk&kid=110944&bid$1720&dat=121642
>_______________________________________________
>libsql-discussion mailing list
>lib...@li...
>https://lists.sourceforge.net/lists/listinfo/libsql-discussion
> =20
>
|
|
From: <Ars...@bp...> - 2006-03-27 18:39:20
|
Excellent then! I'm making progress, the connection went without =
problems :) has anyone made a program with LibSQL and a DBGrid? I'm =
curently advancing using a StringGrid, which would help for my display =
purposes, but a DBGrid where I could ApplyUpdates would be nice.
I guess I could think up a way to make a workaround for ApplyUpdates :) =
This is the code I've used for displaying in StringGrid, any suggestions =
of a better way of doing it? This is a trial database, don't worry about =
the passwordless root account ;)
procedure TForm1.Button1Click(Sender: TObject);
var f : integer ;
begin
MyDB1.Connect('localhost','root','','monitoreo_saor');
if MyDB1.Query('select nombre_dns,region from lista_routers;') then
begin
StringGrid1.ColCount :=3D MyDB1.ColCount;
StringGrid1.RowCount :=3D MyDB1.RowCount;
ShowMessage('filas: '+InttoStr(MyDB1.RowCount)+' columnas: =
'+InttoStr(MyDB1.ColCount));
for f :=3D 0 to MyDB1.RowCount do
begin
StringGrid1.Rows[f].CommaText :=3D MyDB1.Results[f].CommaText;
end;
end
end;
I'm finding LibSQL to be very complete, at least for my needs :) thanks =
for developing it! If you need help putting up examples and maybe a =
tutorial, I can help, although I don't know much yet ;)
Ariel
-----Mensaje original-----
De: lib...@li... =
[mailto:lib...@li...] En nombre de =
Ren=E9 Tegel
Enviado el: lunes, 27 de marzo de 2006 12:05
Para: lib...@li...
Asunto: Re: [libsql] Hi! newbie. What happened to the wiki?
Ariel S=E1nchez Mora wrote:
> I have just downloaded everything I could find on LibSQL, but the wiki
> is full of porn links; someone "broke in" ? Hope you can fix it =
soon...
> =20
> I am looking for an easy solution that will free me of the numerous
> bugs I find in dbexpress with MySQL and Delphi 7.1. From what I've=20
> seen, LibSQL is great, so I would really like to know if the group is=20
> active? So someone can send me pointers when I need them :)
> =20
> Good day!
> =20
> ariel
Hi,
Thanks for alerting me - i will look after the site and probably disable =
the wiki. Wiki's are a nice idea but simply doesn't work because some=20
people lack any kind of personal honor it seems.
The sourceforge list is the right one, there may be some delays=20
sometimes, the group at yahoo is inactive and no longer takes new =
members.
I'll put better website and documentation for libsql on my todo list.
Regards,
Rene
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting =
language that extends applications into web and mobile media. Attend the =
live webcast and join the prime developer group breaking into this new =
coding territory! =
http://sel.as-us.falkag.net/sel?cmd=3Dk&kid=110944&bid$1720&dat=121642
_______________________________________________
libsql-discussion mailing list lib...@li...
https://lists.sourceforge.net/lists/listinfo/libsql-discussion
|
|
From: <re...@du...> - 2006-03-27 18:06:17
|
Ariel S=E1nchez Mora wrote: > I have just downloaded everything I could find on LibSQL, but the wiki=20 > is full of porn links; someone "broke in" ? Hope you can fix it soon... > =20 > I am looking for an easy solution that will free me of the numerous=20 > bugs I find in dbexpress with MySQL and Delphi 7.1. From what I've=20 > seen, LibSQL is great, so I would really like to know if the group is=20 > active? So someone can send me pointers when I need them :) > =20 > Good day! > =20 > ariel Hi, Thanks for alerting me - i will look after the site and probably disable=20 the wiki. Wiki's are a nice idea but simply doesn't work because some=20 people lack any kind of personal honor it seems. The sourceforge list is the right one, there may be some delays=20 sometimes, the group at yahoo is inactive and no longer takes new members= . I'll put better website and documentation for libsql on my todo list. Regards, Rene |
|
From: <Ars...@bp...> - 2006-03-27 16:40:37
|
I have just downloaded everything I could find on LibSQL, but the wiki = is full of porn links; someone "broke in" ? Hope you can fix it soon... =20 I am looking for an easy solution that will free me of the numerous bugs = I find in dbexpress with MySQL and Delphi 7.1. From what I've seen, = LibSQL is great, so I would really like to know if the group is active? = So someone can send me pointers when I need them :) =20 Good day! =20 ariel |
|
From: Andy C. <and...@bt...> - 2006-03-12 10:23:27
|
Hi Rene,
You're right, I'm using SQLite!
I can see my mistake now in assuming that the two methods below would be OK
because I was reading the results from libsql's buffer and not from SQLite.
Of course, not the case with Execute (versus Query).
In my test tables, I have named the id's differently, but in the final
database, the track_id will be consistent across tables as one single
table would have too many columns to be comfortable to handle.
Thanks again, very much appreciated.
I'll look at rewriting this shortly.
Rgs,
Andy
Sunday, March 12, 2006, 9:35:42 AM, you wrote:
> Hi,
> [Assuming you use SQLite]
> You appear to delete records from the same table as you are fetching
> from (i.e. have an open SQLite VM handle). Allowing this would lead to
> inconsistent queries.
> The error in libsql is that you don't get an error message (as you say).
> I will look into this issue. Just fetch the rows in advance (using
> FormatQuery) and then delete them. Also, it appears to me that you mix
> stats_id and track_id?
> regards,
> Rene
> Andy Chandler wrote:
>>Hi,
>>
>>I've come across what I expect is operator error on my part, so I was
>>hoping for some quick advice as to the direction I should be
>>going. The SQL task I'm performing I suspect can
>>be re-written as a compound SQL statement, but while I learn SQL
>>fully, I'm performing it in a couple of stages in Delphi.
>>This is where I have a query.....
>>
>>If I do a "SELECT track_id FROM main WHERE checked='N'" and store
>>the resulting list of numbers in an array or list, then
>>perform the delete command "DELETE FROM main WHERE track_id=%d",
>>using this list of numbers, this works fine with no problems.
>>
>>But if I try to write it all in one loop, it always fails to perform the DELETE commands.
>>No errors reported and it still runs down the full list of results inside the loop.
>>Both ways below fail in the same way..... (maybe the odd typo as
>>I'm writing partially from memory)
>>
>>
>>
>>Using one DB object, but 2 result sets
>>--------------------------------------
>>
>>rs1 := TResultSet.Create (Ldb);
>>rs2 := TResultSet.Create (Ldb);
>>Ldb.StartTransaction;
>>rs1.FormatExecute('SELECT track_id FROM main WHERE checked=%s',['N']);
>>while rs1.FetchRow do begin
>> rs2.FormatQuery('DELETE FROM mp3_stats WHERE stats_id=%d',[temp]);
>> rs2.FormatQuery('DELETE FROM main WHERE track_id=%d',[temp]);
>>end;
>>Ldb.Commit;
>>rs2.free;
>>rs1.free;
>>
>>
>>
>>
>>Using two DB objects
>>--------------------
>>Ldb2.StartTransaction;
>>handle:=Ldb.FormatExecute('SELECT track_id FROM main WHERE checked=%s',['N']);
>>while Ldb.FetchRow(handle,row) do begin
>> temp:=row['track_id'];
>> Ldb2.FormatQuery('DELETE FROM mp3_stats WHERE stats_id=%d',[temp]);
>> Ldb2.FormatQuery('DELETE FROM main WHERE track_id=%d',[temp]);
>>end;
>>Ldb.FreeResult(handle);
>>Ldb2.Commit;
>>
>>
>>
>>
>>Who'd like be first in line to call me a lemon ;-)
>>Thanks all.
>>
>>
>>
>>-------------------------------------------------------
>>This SF.Net email is sponsored by xPML, a groundbreaking scripting language
>>that extends applications into web and mobile media. Attend the live webcast
>>and join the prime developer group breaking into this new coding territory!
>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>>_______________________________________________
>>libsql-discussion mailing list
>>lib...@li...
>>https://lists.sourceforge.net/lists/listinfo/libsql-discussion
>>
>>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> libsql-discussion mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libsql-discussion
|
|
From: <re...@du...> - 2006-03-12 09:35:50
|
Hi,
[Assuming you use SQLite]
You appear to delete records from the same table as you are fetching
from (i.e. have an open SQLite VM handle). Allowing this would lead to
inconsistent queries.
The error in libsql is that you don't get an error message (as you say).
I will look into this issue. Just fetch the rows in advance (using
FormatQuery) and then delete them. Also, it appears to me that you mix
stats_id and track_id?
regards,
Rene
Andy Chandler wrote:
>Hi,
>
>I've come across what I expect is operator error on my part, so I was
>hoping for some quick advice as to the direction I should be going. The SQL task I'm performing I suspect can
>be re-written as a compound SQL statement, but while I learn SQL fully, I'm performing it in a couple of stages in Delphi.
>This is where I have a query.....
>
>If I do a "SELECT track_id FROM main WHERE checked='N'" and store the resulting list of numbers in an array or list, then
>perform the delete command "DELETE FROM main WHERE track_id=%d", using this list of numbers, this works fine with no problems.
>
>But if I try to write it all in one loop, it always fails to perform the DELETE commands.
>No errors reported and it still runs down the full list of results inside the loop.
>Both ways below fail in the same way..... (maybe the odd typo as I'm writing partially from memory)
>
>
>
>Using one DB object, but 2 result sets
>--------------------------------------
>
>rs1 := TResultSet.Create (Ldb);
>rs2 := TResultSet.Create (Ldb);
>Ldb.StartTransaction;
>rs1.FormatExecute('SELECT track_id FROM main WHERE checked=%s',['N']);
>while rs1.FetchRow do begin
> rs2.FormatQuery('DELETE FROM mp3_stats WHERE stats_id=%d',[temp]);
> rs2.FormatQuery('DELETE FROM main WHERE track_id=%d',[temp]);
>end;
>Ldb.Commit;
>rs2.free;
>rs1.free;
>
>
>
>
>Using two DB objects
>--------------------
>Ldb2.StartTransaction;
>handle:=Ldb.FormatExecute('SELECT track_id FROM main WHERE checked=%s',['N']);
>while Ldb.FetchRow(handle,row) do begin
> temp:=row['track_id'];
> Ldb2.FormatQuery('DELETE FROM mp3_stats WHERE stats_id=%d',[temp]);
> Ldb2.FormatQuery('DELETE FROM main WHERE track_id=%d',[temp]);
>end;
>Ldb.FreeResult(handle);
>Ldb2.Commit;
>
>
>
>
>Who'd like be first in line to call me a lemon ;-)
>Thanks all.
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by xPML, a groundbreaking scripting language
>that extends applications into web and mobile media. Attend the live webcast
>and join the prime developer group breaking into this new coding territory!
>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>_______________________________________________
>libsql-discussion mailing list
>lib...@li...
>https://lists.sourceforge.net/lists/listinfo/libsql-discussion
>
>
|
