Re: [lazarus] DataBase Queries

2008-02-05 Thread Roberto Padovani
2008/2/5, Michael Van Canneyt [EMAIL PROTECTED]: On Mon, 4 Feb 2008, el stamatakos wrote: Hi, I am working with a database and I am doing the following tFile:string; tFileName:=mainForm.SQLQuery1.FieldValues['tFileName']; You should never use FieldValues, this is a horrible

[Lazarus] Wrong error message ?

2008-01-26 Thread Roberto Padovani
Hi, I coded (too quickly) the following lines: sqlite.SQL := 'SELECT COUNT(id) FROM utenti WHERE id = '+id_utente+' AND password='+editOldPsw.Text+''; and a few lines later: sqlite.SQL:= 'UPDATE utenti SET password='+editNewPsw.Text+', scadenza_psw=date(now,+90 day) WHERE id = '+id_utente;

Re: [lazarus] Simulate ALT+KEY to open a menu

2008-01-16 Thread Roberto Padovani
code is: var k: word; begin ... k:= 65; { this is ASCII character A} self.FormKeyDown(self,k,[ssAlt]); ... end; cheers, R# 2008/1/16, Fabio Dell'Aria [EMAIL PROTECTED]: Hi, 2008/1/15, Roberto Padovani [EMAIL PROTECTED]: why don't you call the method FormKeyDown yourself

Re: [lazarus] Solution to the BIG compiled file issue!

2008-01-15 Thread Roberto Padovani
I think to be the typical example of the average user, so I'll give my opinion as well. - I don't care about the download size, so I am fine with downloading the full debugging objects files - I don't care about hard disk size (being anyone not too much for nowadays): the installer could run the

Re: [lazarus] Simulate ALT+KEY to open a menu

2008-01-15 Thread Roberto Padovani
why don't you call the method FormKeyDown yourself? ... begin ... self.FormKeyDown(self, 65,[ssAlt]); end; R# 2008/1/15, Fabio Dell'Aria [EMAIL PROTECTED]: Hi, 2008/1/15, Lee Jenkins [EMAIL PROTECTED]: Fabio Dell'Aria wrote: Hi to all, how I can simulate the ALT+E key-press

Re: [lazarus] New icon for lazarus

2007-12-21 Thread Roberto Padovani
Hi, this morning I felt like graphing... the print on the ground is a nice idea, so I tried to solve the problem of contrast and resolution in windows detail view, i.e. 16x16 icons. Contrast is solved by using the color of a cheetah instead of grey as a basic color + high-lining (English??) the

Re: [lazarus] New icon for lazarus

2007-12-21 Thread Roberto Padovani
the cheetah face in 48x48 and 32x32, but using the 16x16 cheetah print. R# 2007/12/21, Marc Weustink [EMAIL PROTECTED]: wile64 wrote: 2007/12/21, Roberto Padovani [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: Hi, this morning I felt like graphing... the print

Re: [lazarus] libview enhancement

2007-12-16 Thread Roberto Padovani
thanks to you! let me know when the new release is ready. Btw, when I don't feel like working I'm having a look at how to make it work under *nix (which will fit to my beloved Mac, as well) R# 2007/12/16, Felipe Monteiro de Carvalho [EMAIL PROTECTED]: Hi Roberto Padovani, I will do a new

[lazarus] key mappings (lowest priority ever!)

2007-12-16 Thread Roberto Padovani
Hi, I just wanted to change some key mappings in the editor options and everything worked just fine, except that I added a shortcut to set a free bookmark (I liked Ctrl-B) and it doesn't work. Any other shortcut for this doesn't work. I couldn't find anything on the mantis, so is there anyone

Re: [lazarus] vote for bdd related component icon

2007-12-11 Thread Roberto Padovani
://wiki.lazarus.freepascal.org/Wile64 French Forum : http://lazforum-fr.tuxfamily.org/index.php -- -- Ing. Roberto Padovani via Mandrioli, 1 40061 Minerbio (BO) Italy mail: [EMAIL PROTECTED] cell: 340-3428685

Re: [lazarus] splash image: share your ideas

2007-12-11 Thread Roberto Padovani
the actual spalsh is beautiful, but I agree on the fact that it's too abstract: it takes time to look at it completely, in every detail, and it takes even more time to understand it IMHO, it is suitable for the home page, where you can stare it, but not for a spash which disappears in a moment. a

Re: [lazarus] libview enhancement

2007-12-10 Thread Roberto Padovani
shared objects filedefinetely out of my reach, I honestly don't know anything about the internals of .so On the other hand, for the *nix platform, one may try to wrap around the nm utility which is part of binutils. R# 2007/12/10, Al Boldi [EMAIL PROTECTED]: Roberto Padovani wrote: This helps

Re: [lazarus] MySQL problems compiling in RedHat 4.5

2007-12-10 Thread Roberto Padovani
at http://www.lazarus.freepascal.org/mailarchives -- -- Ing. Roberto Padovani via Mandrioli, 1 40061 Minerbio (BO) Italy mail: [EMAIL PROTECTED] cell: 340-3428685

Re: [lazarus] SQLite 3 datetime and timestamp

2007-12-03 Thread Roberto Padovani
Hi Luiz, first of all, thanks a lot for the good job you did with sqlite for us all! So, now my app can understand a timestamp field as a TDateTime instead of a string... .. [removed] ... Here's how sqlite works (for good and bad): - You can create tables with any field type: TIMESTAMP,

Re: [lazarus] SQLite 3 datetime and timestamp

2007-12-03 Thread Roberto Padovani
Now, about assumptions. in sqlite3ds there is the assumption that BOOLEAN fields are stored as 1 or 0. In fact, to recover a db that had TRUE and FALSE, I made a new class where I changed ftBool to fString. In this way I could read them, parse them and then write them back as 1 or 0. With the

Re: [lazarus] Main Form retreiving data from Child Form

2007-12-03 Thread Roberto Padovani
-- -- Ing. Roberto Padovani via Mandrioli, 1 40061 Minerbio (BO) Italy mail: [EMAIL PROTECTED] cell: 340-3428685 - _ To unsubscribe: mail [EMAIL PROTECTED

Re: [lazarus] Main Form retreiving data from Child Form

2007-12-03 Thread Roberto Padovani
and not good practise and TIniFiles are a little cubersome. Is there a better way in Lazarus. Thanks Lefti -- -- Ing. Roberto Padovani via Mandrioli, 1 40061 Minerbio (BO) Italy mail: [EMAIL PROTECTED] cell: 340-3428685

[lazarus] SQLite 3 datetime and timestamp

2007-12-02 Thread Roberto Padovani
Hi all! two things: 1) a (possible) improvement to sqlite3ds; 2) the old problem with dates and time 1) I found a sqlite database that uses the TIMESTAMP data type, but this is not directly supported by the Tsqlite3Dataset written by Luiz. I added the if-else checks in sqlite3ds.pas for this

[lazarus] SQLite 3 datetime and timestamp

2007-12-02 Thread Roberto Padovani
Hi all! two things: 1) a (possible) improvement to sqlite3ds; 2) the old problem with dates and time 1) I found a sqlite database that uses the TIMESTAMP data type, but this is not directly supported by the Tsqlite3Dataset written by Luiz. I added the if-else checks in sqlite3ds.pas for this

Re: [lazarus] Child Form not being created

2007-11-30 Thread Roberto Padovani
PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives -- -- Ing. Roberto Padovani via Mandrioli, 1 40061 Minerbio (BO) Italy mail: [EMAIL PROTECTED] cell: 340-3428685

Re: [lazarus] MySql 4.1 Database Questions

2007-11-29 Thread Roberto Padovani
2007/11/29, el stamatakos [EMAIL PROTECTED]: Hi, I finally got passed the Project Raised exception class 'EInOutError with message: Can not load MySQL library libmysqlclient.so. Please check your installation. Indeed I had to create a symbolik link. a symbolic link in the project

Re: [lazarus] Lazarus-0.9.24: SIGSEGV in TOpenDialog

2007-11-29 Thread Roberto Padovani
_ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives -- -- Ing. Roberto Padovani via Mandrioli, 1 40061 Minerbio

Re: [lazarus] Contribution?

2007-11-28 Thread Roberto Padovani
_ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives -- -- Ing. Roberto Padovani via Mandrioli, 1 40061 Minerbio (BO) Italy mail

Re: [lazarus] some questions

2007-11-28 Thread Roberto Padovani
the forums and receiving help. Thanks in advance. Lefti -- -- Ing. Roberto Padovani via Mandrioli, 1 40061 Minerbio (BO) Italy mail: [EMAIL PROTECTED] cell: 340-3428685

Re: [lazarus] SQLite 3 -- Capture FieldValues into a variable

2007-11-26 Thread Roberto Padovani
2007/11/26, Daniel Rincón García [EMAIL PROTECTED]: Hi, I need to capture the FieldValues of a SQLite database into a string variable. If I do it: while not dsTest.EOF do begin DataToSend := DataToSend + dsTest.FieldValues ['Code'] + '\' +