Re: [Lazarus] How do you install Lazarus on Debian?

2012-11-08 Thread Howard Lee Harkness
**Lazarus<http://wiki.lazarus.freepascal.org/Installing_Lazarus> > -- Howard Lee Harkness (214) 390-4896 -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Re: [Lazarus] How do you install Lazarus on Debian?

2012-11-08 Thread Howard Lee Harkness
configure fpc and fpc-packages before doing the make. After an apt-get install fpc, make appears to be running just fine in the lazarus directory. Now to figure out how to start it up... On Thu, Nov 8, 2012 at 1:40 PM, Chavoux Luyt wrote: > Hi Howard > > On 8 November 2012 21:26,

[Lazarus] How do you install Lazarus on Debian?

2012-11-08 Thread Howard Lee Harkness
iVSPTPSOTO: Command not found make[2]: Entering directory `/etc/lazarus/tools' make[2]: *** No rule to make target `svn2revisioninc'. Stop. make[2]: Leaving directory `/etc/lazarus/tools' make[1]: *** [revisioninc] Error 2 make[1]: Leaving directory `/etc/lazarus/ide' make: *** [ide] Error 2 root@debian:/etc/lazarus# -- Howard Lee Harkness (214) 390-4896 -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Re: [Lazarus] RE : TQuery.Open 100x slower than same code using PostrgreSQL

2012-02-06 Thread Howard Lee Harkness
s attachment size limits) upload it > somewhere and post the link. > > Ludo > > > -- > ___ > Lazarus mailing list > Lazarus@lists.lazarus.freepascal.org > http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus > -- Howard

Re: [Lazarus] Date format conversion function?

2011-12-22 Thread Howard Lee Harkness
On Thu, Dec 22, 2011 at 2:30 AM, wrote: > > See FormatDateTime in sysutils. > > And TDateEdit has a Date property which is of type TDateTime. > > Michael. > I discovered that about thirty minutes after I posted the request. Thanks! -- Howard Lee Ha

[Lazarus] Date format conversion function?

2011-12-21 Thread Howard Lee Harkness
be found, please enlighten me. TIA! -- Howard Lee Harkness (214) 390-4896 -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

[Lazarus] TQuery.Open 100x slower than same code using PostrgreSQL

2011-08-06 Thread Howard Lee Harkness
;).Value := CurrentClientID; >   qPhones.Params.ParamByName('ID').Value := CurrentClientID; > > I have not yet played around with the foreign key stuff, and I'm not > really sure how to enable & use foreign keys in SQLite, anyway. > > On Mon, Aug 1, 2011 at 4:2

Re: [Lazarus] Chain procedure in FPC/Lazarus?

2011-08-03 Thread Howard Lee Harkness
Thanks! I found it after somebody mentioned TProcess. On Wed, Aug 3, 2011 at 3:19 PM, Howard Page-Clark wrote: > On 03/8/11 8:41, Howard Lee Harkness wrote: >> >> In Delphi, I recall that there is an Exec procedure for calling >> another .exe, and a Chain procedure for tr

Re: [Lazarus] Chain procedure in FPC/Lazarus?

2011-08-03 Thread Howard Lee Harkness
2011/8/3 "Arí Ricardo Ody" : > TProcess That was what I needed. Using that as the search term got me the relevant documentation. Thanks! -- Howard Lee Harkness (214) 390-4896 -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepa

[Lazarus] Chain procedure in FPC/Lazarus?

2011-08-03 Thread Howard Lee Harkness
In Delphi, I recall that there is an Exec procedure for calling another .exe, and a Chain procedure for transferring to another .exe. I assume that these are also in FPC/Lazarus, but I haven't found any Lazarus documentation for these calls. Could somebody tell me where to look? -- Howar

Re: [Lazarus] I thought it was solved -- TQuery.Open very slow.

2011-08-03 Thread Howard Lee Harkness
d with the foreign key stuff, and I'm not really sure how to enable & use foreign keys in SQLite, anyway. On Mon, Aug 1, 2011 at 4:21 PM, Howard Lee Harkness wrote: > I have a dummy database and complete program I can let you look at if > you would like. Nothing particularly proprietary

Re: [Lazarus] I thought it was solved -- TQuery.Open very slow.

2011-08-01 Thread Howard Lee Harkness
t over 7Mb. Would you like me to email it directly to you, or post it? On Mon, Aug 1, 2011 at 1:56 PM, Michael Van Canneyt wrote: > > > On Mon, 1 Aug 2011, Howard Lee Harkness wrote: > >> I thought I had fixed the performance problem, but it is still there. >> What I am do

[Lazarus] I thought it was solved -- TQuery.Open very slow.

2011-08-01 Thread Howard Lee Harkness
sqlite3.exe return instantaneously, so I am concluding that I have not set something up correctly in the LCL. -- Howard Lee Harkness (214) 390-4896 -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman

[Lazarus] RE : SQLite performance problem. Simple query takes too long. (SOLVED)

2011-07-29 Thread Howard Lee Harkness
lained the slight difference in behavior, and he thinks that is an improvement, because it will help prevent accidentally entering phone #, address, etc. for the wrong client. Thanks for the help! On Fri, Jul 29, 2011 at 2:21 PM, Howard Lee Harkness wrote: > On Fri, Jul 29, 2011 at 1:42 PM

Re: [Lazarus] RE : RE : SQLite performance problem. Simple query takestoolong.

2011-07-29 Thread Howard Lee Harkness
ightly worse. However, I think maybe I have some insight into what is causing the problem. It looks like the lookups for the dependent tables are happening multiple times. Not sure why that would be (I didn't think I did anything to that part of the code other than change database engines), but

Re: [Lazarus] RE : SQLite performance problem. Simple query takes toolong.

2011-07-29 Thread Howard Lee Harkness
> SQL.Text:=''. > > Now to execute an insert query (assuming > TSQLite3Connection.Connected:=true): >    SQLQuery.SQL.Text:=sql; >    SQLQuery.ExecSQL; >    SQLTransaction.CommitRetaining; > > That's it. SQLTransaction.CommitRetaining; does the COMMIT and

Re: [Lazarus] SQLite performance problem. Simple query takes too long.

2011-07-29 Thread Howard Lee Harkness
: > Am Donnerstag 28 Juli 2011, 22:01:32 schrieb Howard Lee Harkness: >> Unfortunately, it has a lot of information that is sensitive (belongs >> to a client). I will look at building a database with dummy data. I >> can, however, provide the schema, if that would help. >> &g

Re: [Lazarus] SQLite performance problem. Simple query takes too long.

2011-07-28 Thread Howard Lee Harkness
artin > > -- > ___ > Lazarus mailing list > Lazarus@lists.lazarus.freepascal.org > http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus > -- Howard Lee Harkness (214) 390-4896 -- ___

[Lazarus] SQLite performance problem. Simple query takes too long.

2011-07-28 Thread Howard Lee Harkness
n = FormDatabase.SQLTransaction ReadOnly = False SQL.Strings = ( 'select * from clients' 'order by lastname,firstname,middlename' ) Params = <> left = 504 top = 64 end -- Howard Lee Harkness -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Re: [Lazarus] SQLitePass package install problems

2011-07-28 Thread Howard Lee Harkness
___ > Hotmail: Free, trusted and rich email service. Get it now. > -- > ___ > Lazarus mailing list > Lazarus@lists.lazarus.freepascal.org > http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus > > -- Howard Lee Harkness (214) 390-4896 -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Re: [Lazarus] Problem with SQLite commit in Lazarus

2011-07-27 Thread Howard Lee Harkness
e tables into memory during the run of the program? Surely that would speed things up. 2011/7/27 Max Vlasov : > > > On Wed, Jul 27, 2011 at 6:28 AM, Howard Lee Harkness > wrote: >> >> I am guessing that I am missing some basic detail in the setup >> somewhere, or n

[Lazarus] Problem with SQLite commit in Lazarus

2011-07-26 Thread Howard Lee Harkness
or not understanding some subtlety in the operation of SQLite. I would greatly appreciate somebody sending me a clue on how to deal with this. TIA! -- Howard Lee Harkness -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazar