Re: [lazarus] Can not load MySQL Client

2006-12-12 Thread Joost van der Sluis
> To unsubscribe: mail [EMAIL PROTECTED] with > "unsubscribe" as the Subject >archives at http://www.lazarus.freepascal.org/mailarchives > -- Met vriendelijke groeten, Jo

Re: [lazarus] Database problem ?

2006-12-16 Thread Joost van der Sluis
l [EMAIL PROTECTED] with > "unsubscribe" as the Subject >archives at http://www.lazarus.freepascal.org/mailarchives > -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl

Re: [lazarus] SQLDB TIBConnection

2007-01-04 Thread Joost van der Sluis
stalls to /usr/shared/lazarus > And everything looked like it compiled fine too, at least no visible > errors that I could see. I still find it stranghe, though, that he can't find the firebird- client-library. But I think you've installed something else wrongly.. -- Met

Re: [lazarus] SQLDB TIBConnection

2007-01-04 Thread Joost van der Sluis
On Thu, 2007-01-04 at 09:09 -0500, Lee Jenkins wrote: > Joost van der Sluis wrote: > > On Wed, 2007-01-03 at 21:15 -0500, Lee Jenkins wrote: > >> Kevin hayton wrote: > >>> I have just installed UIB components and there are components on the > >>> palette

[lazarus] Lazarus makefile

2007-01-07 Thread Joost van der Sluis
Hi all, I have some questions about the Lazarus Makefile's. First: why is lazarus installed in share? /usr/share is hard-coded in Makefile.fpc, and so it's hard to change. But since there's compiled code in lazarus, I would say that /usr/lib is the right place... Second: If I change /usr/lib in

Re: [lazarus] Lazarus makefile

2007-01-08 Thread Joost van der Sluis
On Mon, 2007-01-08 at 13:40 -0200, Flávio Etrusco wrote: > On 1/7/07, Mattias Gaertner <[EMAIL PROTECTED]> wrote: > > On Sun, 07 Jan 2007 21:07:03 +0100 > > Joost van der Sluis <[EMAIL PROTECTED]> wrote: > > > > > Hi all, > > > >

Re: [lazarus] illegal qualifier problem arose to a newbie

2007-01-13 Thread Joost van der Sluis
On Sat, 2007-01-13 at 14:24 +0200, Sönmez Kartal wrote: > Hello, > > I am new to Lazarus. I have a book named Mastering Delphi 7 by Marco > Cantu. I got an error when I tried to compile an example. > > procedure TDateForm.FormCreate(Sender: TObject); > begin >TheDay := TDate.Create(); >T

[lazarus] Patch for TDBImage and TDBMemo

2007-01-14 Thread Joost van der Sluis
Hi all, The attached patch actually implements TDBImage and solves a problem with TDBMemo when a dataset is closed. Beware, it'll only work with sqldb from fpc 2.1.1, or maybe wit ZEOS/tDbf. The patch solves bugs 1739 and 1477. regards, Joost. Index: include/dbmemo.inc

Re: [lazarus] ZeosLib and Lazarus

2007-01-16 Thread Joost van der Sluis
On Tue, 2007-01-16 at 08:52 +0200, Graeme Geldenhuys wrote: > > The current problem is that it only is usable for daemons & long running > > programs with a patched 2.0.2 compiler (TDatasat Datetime patch) > > Can you explain this a bit more? Why only usable for daemons and long > running progra

Re: [lazarus] Lazarus for Python (L4P)

2007-01-16 Thread Joost van der Sluis
On Tue, 2007-01-16 at 09:38 +1100, Algis Kabaila wrote: > 1. **My** needs and plans. I will say here only that the needs and plans > relate to the text that I am writing under the GPL. A progress version > (beta?) of the text can be seen at > http://www.pcug.org.au/~akabaila/StructuralAnalys

Re: [lazarus] best use of components for mysql query insert performance benchmarking

2007-01-25 Thread Joost van der Sluis
On Mon, 2007-01-22 at 14:51 -0700, Seth Grover wrote: > I'm writing a program to do some informal benchmarking of insert and > query performance using various MySQL storage engines using MySQL > 5.1.x latest beta. I've got it up and running just fine using Lazarus > and the MySQL components. It was

[lazarus] Strange thing in codetools

2007-02-23 Thread Joost van der Sluis
Hi all, It seems like that the codetools can't handle this line (in typinfo from fpc): {$MINENUMSIZE 1 this saves a lot of memory} To my suprise fpc accepts this, and the compiler-setting is also really set. So, if this a bug in fpc or should the codetoold be adapted? Regards, Joost. __

Re: [lazarus] Recent SVN lazarus won't compile. Can't find unit contnrs.

2007-02-27 Thread Joost van der Sluis
On Tue, 2007-02-27 at 16:14 +0100, Vincent Snijders wrote: > [EMAIL PROTECTED] schreef: > > Hello, > > > > With FPC 2.1.1 SVN 6671 and Lazarus SVN 10693 compilation of lazarus abort > > on > > this message: > > > > /usr/local/src/lazarus/lcl/graphics.pp(36,17) Fatal: Can't find unit contnrs > >

Re: [lazarus] StrToDate error

2007-03-01 Thread Joost van der Sluis
> That wasn't our experience with MS SQL Server 2000 which uses the US > date/time format even though the server was installed in the UK with > UK regional settings. We had similar issues (can't remember exactly > what) with Firebird. Hence the reason we now store it as strings. Ok, so there's a

Re: [lazarus] StrToDate error

2007-03-01 Thread Joost van der Sluis
On Thu, 2007-03-01 at 12:04 +0200, Graeme Geldenhuys wrote: > On 3/1/07, Joost van der Sluis <[EMAIL PROTECTED]> wrote: > > > MS SQL stores date/time fields in a TDateTime format. (That's why it's > > such a strange format.) Firebird uses something similar. The

Re: [lazarus] Strange behaviour of lazarus using fcl-web

2007-03-08 Thread Joost van der Sluis
at like 40 files, or is there another/better way to solve this? Joost. ps: This kinds of explains the situation: http://imagebin.org/7552 On Thu, 2007-03-08 at 00:24 +0100, Joost van der Sluis wrote: > Hi all, > > I've been looking for the problem for a few days now, and I can&#x

Re: [lazarus] Strange behaviour of lazarus using fcl-web

2007-03-08 Thread Joost van der Sluis
On Thu, 2007-03-08 at 22:43 +0100, Michael Van Canneyt wrote: > On Thu, 8 Mar 2007, Joost van der Sluis wrote: > > > > I've isolated the problem. It occurs when inherited TDataModules are in > > one file. According to Jesus Reyes (on IRC) did Mattias say th

Re: [lazarus] PostgreSQL

2007-03-29 Thread Joost van der Sluis
On Thu, 2007-03-29 at 14:52 +0200, Bram Kuijvenhoven wrote: > Darmawan Sugiarto wrote: > > It's OK... now I know If I don't have this error if I compile my code in > > first time... but the second, third, and soon I have this error... So I > > restart Lazarus and my code work clearly... > > If I

Re: [lazarus] listview example cannot be loaded in the IDE on win64

2007-04-16 Thread Joost van der Sluis
On Mon, 2007-04-16 at 09:02 +0200, Mattias Gaertner wrote: > On Mon, 16 Apr 2007 08:49:53 +0200 > Mattias Gaertner <[EMAIL PROTECTED]> wrote: > > > > The trick itself is easy: > > TMethod contains two pointers: code (the address) and data (the > > TObject). Normally you assign both and everything

Re: [lazarus] SQLquery

2007-05-03 Thread Joost van der Sluis
the same query with a SQL manager and using zeos components. > In both cases it works properly. > I build the query at runtime, it collects tens of float fields from > different tables and joined them. -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwer

Re: [lazarus] create DB runtime

2007-05-07 Thread Joost van der Sluis
On Thu, 2007-04-26 at 14:13 +0200, Andrea Mauri wrote: > Hi, > it is possible to create a database at runtime using sqldb? > How can I do it? Use AConnection.CreateDB(...) Joost _ To unsubscribe: mail [EMAIL PROTECTED] with

Re: [lazarus] ide installation on ubuntu

2007-05-14 Thread Joost van der Sluis
WriteLn('bla bla'); > end; > end; > > var > pid: Tpid; > > begin > WriteLn('hi! im a bad daemon!'); > > pid:=fpfork; > if (pid=0) then > daemon; > > end. > > _

Re: [lazarus] Image from SQL

2007-05-15 Thread Joost van der Sluis
> > > "unsubscribe" as the Subject > > >archives at http://www.lazarus.freepascal.org/mailarchives > > > > > > > > > -- > > http://ik.homelinux.org/ > > > > __

Re: [lazarus] Image from SQL

2007-05-15 Thread Joost van der Sluis
On Tue, 2007-05-15 at 13:15 +0200, A.J. Venter wrote: > Hi all, > I would like to be able to store images inside a postgresql table > (inserted WITH a lazarus app) then retrieve them again and display > them from inside a different lazarus app. > XPM would do, but jpg would be ideal. > > I am gues

[lazarus] Release of fpc-2.1.4 aka 2.2.0-beta

2007-05-19 Thread Joost van der Sluis
Hello everybody, I'm happy to announce that release 2.1.4 aka 2.2.0 beta is out. We ask our users to test the changes made in the last few years. This beta will be available for about two months, whereafter 2.2.0 will be released. Helping us to test version 2.1.4 now, can avoid problems when you f

Re: [lazarus] StringReplace -> TReplaceFlags

2007-05-23 Thread Joost van der Sluis
To unsubscribe: mail [EMAIL PROTECTED] with > "unsubscribe" as the Subject >archives at http://www.lazarus.freepascal.org/mailarchives > -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http

Re: [lazarus] Strange bug with SQLQuery.Close

2007-05-29 Thread Joost van der Sluis
On Sat, 2007-05-26 at 15:00 +0200, fedorax wrote: > I've a strange bug. In this fonction ( Which was worked perfectly from few > months an never chage ). > -- > procedure TFunc_Sql.List_TablesSelectionChange(Sender: TObject; User: > boolean); > begin > If List_Tables.Ite

Re: [lazarus] Strange bug with SQLQuery.Close

2007-05-31 Thread Joost van der Sluis
On Thu, 2007-05-31 at 02:20 +0200, fedorax wrote: > Selon Bram Kuijvenhoven <[EMAIL PROTECTED]>: > > > fedorax wrote: > > > Selon Joost van der Sluis <[EMAIL PROTECTED]>: > > > > > >> On Sat, 2007-05-26 at 15:00 +0200, fedorax wrote: > >

Re: [lazarus] "floating point overflow" error when passing parameter value to TSQLQuery

2007-06-10 Thread Joost van der Sluis
;,' > '"results_microbs"."action_limit") as "exceeds_sum",' > 'exceeds_total(exceeds_sum("results_microbs"."result",' > '"results_microbs"."alert_limi

[lazarus] Subrows in grids...

2007-06-20 Thread Joost van der Sluis
Hi Jesus and the rest, Attached is a patch to allow 'subrows' in a row in a grid. You can say, for example that each row should contain two subrows. Then the columns will be divided over those two rows. Second you can specify for each column how much subrows it has to 'span'. For example, with t

Re: [lazarus] Subrows in grids...

2007-06-20 Thread Joost van der Sluis
On Wed, 2007-06-20 at 14:44 +0200, Graeme Geldenhuys wrote: > That's an interesting idea. I believe I have seen 3rdParty Delphi grid > components doing the same thing. Based on you idea and screenshot. > How would you access the cell selected in the screenshot? > > Grid.Cells[???] := 'My new text

Re: [lazarus] Subrows in grids...

2007-06-20 Thread Joost van der Sluis
On Wed, 2007-06-20 at 17:36 +0200, Michael Van Canneyt wrote: > > On Wed, 20 Jun 2007, Joost van der Sluis wrote: > > > Hi Jesus and the rest, > > > > > > Attached is a patch to allow 'subrows' in a row in a grid. You can say, > > for example t

Re: [lazarus] IBConnection error in win64

2007-06-21 Thread Joost van der Sluis
On Wed, 2007-06-20 at 21:26 -0300, Carlos German Tejero wrote: > I put the libmysql.dll in system32 and the application directory and > the problem persist. When i connect with Con.Open; the application > finish. Can you tell what exception. (If it's 'invalid password' you know where to look) And

Re: [lazarus] Subrows in grids...

2007-06-30 Thread Joost van der Sluis
lly there seems to be many problems for > example, the TStringGrid editor doesn't know about subrows, and > crashed my lazarus badly, I also wasn't able to reproduce your image, > if issues are fixed I think we should add it. Here is a new patch. This one works better. -- Met vrien

Re: [lazarus] Subrows in grids...

2007-07-03 Thread Joost van der Sluis
On Tue, 2007-07-03 at 03:05 -0500, Jesus Reyes A. wrote: > - Original Message - > From: "Joost van der Sluis" <[EMAIL PROTECTED]> > To: > Sent: Saturday, June 30, 2007 1:58 PM > Subject: Re: [lazarus] Subrows in grids... > > > > On Wed, 2

Re: [lazarus] Working with XML: crosscompatibility

2007-07-16 Thread Joost van der Sluis
On Mon, 2007-07-16 at 14:26 +0300, Razvan Adrian Bogdan wrote: > I just found that the FPC XML Reader has a nasty bug at least in FPC 2.0.4 > this XML will cause av > > > > > > This is because of this code in XMLRead line 671 in Function ExpectProlog > > // Check for "(doctypedecl Misc*)?"

Re: [lazarus] Another little help with databases

2007-07-17 Thread Joost van der Sluis
o the sql automatically. But then you can get (just like by modifying the sql yourself) an injection-bug. -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _ To unsub

Re: [lazarus] Another little help with databases

2007-07-17 Thread Joost van der Sluis
; I assume that this is also the intended behavior? (That is of course > no problem, as long as the user is aware of this). Yes. It obviously only works with ParseSQL set to true. It also automatically handles the refresh of the dataset. -- Met vriendelijke groeten, Joost van der Sluis

[lazarus] Freepascal 2.2.0 released

2007-09-10 Thread Joost van der Sluis
The Free Pascal Compiler team is pleased to announce the release of FPC 2.2.0! An overview of most changes is available below, but some highlights are: * Architectures: PowerPC/64 and ARM support * Platforms: Windows x64, Windows CE, Mac OS X/Intel, Game Boy Advance, and Game Boy DS support *

Re: [lazarus] Another icons for Lazarus

2007-09-11 Thread Joost van der Sluis
Well... if you have time, do you also allow requests? The icons of the sqldb-components aren't really beautiful. And the components in the fp-web-package (lazarus/components/fp-web) are non-existent... ;) Joost Op dinsdag 11-09-2007 om 16:43 uur [tijdzone +0200], schreef wile64: > See the sujet

Re: [lazarus] Another icons for Lazarus

2007-09-15 Thread Joost van der Sluis
Op zaterdag 15-09-2007 om 00:50 uur [tijdzone +0200], schreef wile64: > /9/11, Joost van der Sluis <[EMAIL PROTECTED]>: > Well... if you have time, do you also allow requests? > > The icons of the sqldb-components aren't really beaut

[lazarus] r12175/gtk1 doublebuffering causes huge slowdowns

2007-10-07 Thread Joost van der Sluis
Since revision r12175 Lazarus/synedit responds very slow on each keypress. (approx 5 sec) I'm using linux/gtk1 through vnc. I didn't test locally, but since I didn't hear anybody else about this problem, I guess the problem is only noticeable through vnc. Joost ___

Re: [lazarus] TRegistry crash on Mac OS X

2007-10-07 Thread Joost van der Sluis
Please create a bug report for fpc (not lazarus) (http://www.freepascal.org/mantis) and attach your files to the bug-report. Joost. Op zondag 07-10-2007 om 23:05 uur [tijdzone +0200], schreef Tobias Giesen: > Hello, > > there are one or two bugs in xmlreg.pp that can cause crashes. > > I am tal

Re: [lazarus] Lazarus review

2007-10-10 Thread Joost van der Sluis
Op woensdag 10-10-2007 om 00:23 uur [tijdzone +0200], schreef Michael Van Canneyt: > Did anyone ever notice this ? Yes > http://www.linux.org/apps/reviews/lazarus.html See the news post of sept 8th on the Lazarus website. Joost _

Re: [lazarus] Anybody on this list use Firebird database with Lazarus?

2007-10-10 Thread Joost van der Sluis
Op woensdag 10-10-2007 om 17:14 uur [tijdzone +0200], schreef Lukas Gradl: > Which Access-Components do you use? > > Unified Interbase (which I use) has only a readonly Dataset-Component, > but there is some alternative Dataset for it, called AlexsDataSet. I > never used it, but it is reported t

Re: [lazarus] SQLdb : get last_inserted_id

2007-10-12 Thread Joost van der Sluis
Op vrijdag 12-10-2007 om 10:39 uur [tijdzone +0200], schreef Alvise Nicoletti: >Qry.Active := false; I don't see anything strange. It should work, except that the following query is incorrect (incomplete). >Qry.SQL.Text := 'INSERT INTO ECCETERA'; And it also has no parameters. Maybe the

Re: [lazarus] beginners questions on handling lazarus

2007-10-16 Thread Joost van der Sluis
Op dinsdag 16-10-2007 om 02:19 uur [tijdzone +0200], schreef Marc Santhoff: > Am Dienstag, den 16.10.2007, 01:53 +0200 schrieb Mattias Gaertner: > > On Tue, 16 Oct 2007 01:10:08 +0200 > > Marc Santhoff <[EMAIL PROTECTED]> wrote: > > > > You should consider updating your lazarus/fpc, because some d

Re: [lazarus] beginners questions on handling lazarus

2007-10-16 Thread Joost van der Sluis
Op dinsdag 16-10-2007 om 08:43 uur [tijdzone +0800], schreef Paul Ishenin: > Marc Santhoff wrote: > > Getting HEAD or trunk is no problem, but I have to support FreeBSD 4 and > > thus fpc 2.0.4 for a while. This requirement leads to checking out the > > last version of lazarus compilable and workin

Re: [lazarus] SQLdb : get last_inserted_id

2007-10-16 Thread Joost van der Sluis
Op dinsdag 16-10-2007 om 10:45 uur [tijdzone +0200], schreef Alvise Nicoletti: > John ha scritto: > > Alvise Nicoletti wrote: > >> Hi... this is the complete code I'm using to extract the > >> last_insert_id from the table TABLE1, but it still don't works. > >> Infact I get always 0 from the varia

Re: [lazarus] beginners questions on handling lazarus

2007-10-16 Thread Joost van der Sluis
Op dinsdag 16-10-2007 om 18:24 uur [tijdzone +0200], schreef Marc Santhoff: > > The difference between the Delphi3 TTable and a query is more then > the > > select. The TTable creates the SQL-statement, which has the > advantage > > that it exactly knows what it's doing, so that the TTable is also

[lazarus] Changes in Makefile.fpc for fpc 2.2.0

2007-10-16 Thread Joost van der Sluis
Hi all, If you run 'fpcmake -Tall' in the lazarus-directory to create a new Makefile, it will fail if you use fpc 2.2.0. That's because the Makefile.fpc says it needs the package 'fcl', but that package doesn't exist anymore. Replacing it by fcl-base, fcl-db, fcl-etcetc could fix it, but then it

Re: [lazarus] SQLdb and 64 bits

2007-10-18 Thread Joost van der Sluis
Op woensdag 17-10-2007 om 18:03 uur [tijdzone +0200], schreef Alvise Nicoletti: > I tryed to compile my linux service for a server with ubuntu 64 bit and > mysql 5. > So I changed in the code every mysql40 reference to mysql50. > I tryed to change target, compile, and copy the binary to the anoth

Re: [lazarus] SQLdb and 64 bits

2007-10-18 Thread Joost van der Sluis
Op donderdag 18-10-2007 om 11:32 uur [tijdzone +0200], schreef Alvise Nicoletti: > Joost van der Sluis ha scritto: > > Op woensdag 17-10-2007 om 18:03 uur [tijdzone +0200], schreef Alvise > > Nicoletti: > > > > > >> I tryed to compile my linux service

Re: [lazarus] SQLdb : program crash using more than 9-10 fieldsets: bug...?

2007-10-18 Thread Joost van der Sluis
Op donderdag 18-10-2007 om 11:23 uur [tijdzone +0200], schreef Alvise Nicoletti: > This is a bug notification... I managed to re-create the "segmentation > fault" bug. > > The service was crashing without giving any output and any reason, the > problem was in the NUMBER of the parameters in the

Re: [lazarus] [fpc] SQLdb: not clear excetion, "Server connect failed."

2007-11-01 Thread Joost van der Sluis
fpc 2.2.0 sqldb-mysql doesn't work on 64-bit systems. You should use fpc 2.2.1. Joost Op woensdag 31-10-2007 om 17:19 uur [tijdzone +0100], schreef Alvise Nicoletti: > I finally managed to install lazarus on a linux 64 bits. > > But when I start the once-32-bit-working program that now is at 64

Re: [lazarus] Bad news

2007-11-13 Thread Joost van der Sluis
Op dinsdag 13-11-2007 om 10:47 uur [tijdzone +0200], schreef Dave Coventry: > On Nov 13, 2007 10:22 AM, Michael Van Canneyt <[EMAIL PROTECTED]> wrote: > > But everyone is open for a constructive discussion. > > Speaking of which, Mr. Trefethen has posted what he claims are some of > the plagiarism

Re: [lazarus] Lazarus IDE revamp

2007-11-15 Thread Joost van der Sluis
Op donderdag 15-11-2007 om 12:33 uur [tijdzone -0800], schreef Ciprian Mustiata: > Based on that issues, and some more, me and that designer will not > look back to Delphi legacy, excluding the LCL and we will try to > manage to make a fork of Lazarus. The role of that fork is very easy: > it will

Re: [lazarus] DataAccess components in lazarus 2.9.24

2007-11-16 Thread Joost van der Sluis
Op vrijdag 16-11-2007 om 08:10 uur [tijdzone +0300], schreef Jury Azovtzev: > Hallo! > > I tryied to make education LiveCD with lazarus for students in local > college. But when i run all i found out there is not transactions, > Mysql and PostrgreSQL components in new lazarus anymore. Could someon

Re: [lazarus] double posted bug report :(

2007-11-16 Thread Joost van der Sluis
Op vrijdag 16-11-2007 om 14:07 uur [tijdzone +0700], schreef Bee: > For Lazarus' Mantis maintainer(s), > > Please remove my bug report with ID: 0010191. It exactly duplicates my > other bug report with ID: 0010190. It's purely unintended because I > accidentally clicked the submit button twice. I

Re: [lazarus] Recompile FPC unit

2007-11-19 Thread Joost van der Sluis
Op zaterdag 17-11-2007 om 10:34 uur [tijdzone +1000], schreef SteveG: > I (think) I have found an error in the FmtBCD unit > (from C:\lazarus\fpc\2.2.1\units\i386-win32\rtl ) > > A simple empty dll will not load if this unit (or any 'using' it is used. > So far as I can tell, the problem 'seems' t

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

2007-11-26 Thread Joost van der Sluis
Op maandag 26-11-2007 om 13:17 uur [tijdzone +0100], schreef Daniel Rincón García: > 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 + > dsT

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

2007-11-26 Thread Joost van der Sluis
Op maandag 26-11-2007 om 15:05 uur [tijdzone +0100], schreef Roberto Padovani: > 2007/11/26, Daniel Rincón García <[EMAIL PROTECTED]>: > To the Great Guys of the lazarus project: > > I am finishing a medium size project with lazarus + sqlite3, for which > I had study and experiment a lot due to th

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

2007-11-27 Thread Joost van der Sluis
Op maandag 26-11-2007 om 23:50 uur [tijdzone +0100], schreef Joost van der Sluis: > Op maandag 26-11-2007 om 15:05 uur [tijdzone +0100], schreef Roberto > Padovani: > > 2007/11/26, Daniel Rincón García <[EMAIL PROTECTED]>: > > To the Great Guys of the lazarus project: &

Re: [lazarus] some questions

2007-11-29 Thread Joost van der Sluis
Op woensdag 28-11-2007 om 15:08 uur [tijdzone -0300], schreef Arí Ricardo Ody: > Talking about databases: > > Was the bug of Lazarus with date, time and timestamp types when > accessing DB2 tables fixed? DB2? I don't know any components which support DB2? Joost

Re: [lazarus] MySQL Queries using Lazarus

2007-12-12 Thread Joost van der Sluis
Op dinsdag 11-12-2007 om 15:54 uur [tijdzone -0800], schreef el stamatakos: > Hi All, > I have an application that connects to a MySQl database. I have found the > only way to get Lazrus to work without giving me an error "Cannot access > Active DataSet" is to do a Clear,Add, Open Close, like be

Re: [lazarus] MySQL Queries using Lazarus

2007-12-12 Thread Joost van der Sluis
Op woensdag 12-12-2007 om 22:51 uur [tijdzone +1100], schreef John: > ik wrote: > > One small note, you have an SQL injection at your code. I recommend > > you to use parameters as how to add the values, but prior to that, you > > should check to see if there are invalid chars, and trim them. That

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Joost van der Sluis
Op woensdag 12-12-2007 om 15:11 uur [tijdzone +0200], schreef Graeme Geldenhuys: > > Step 1: > == > TIBConnection <- TSQLTransaction via 'Database' property. No problem > here. > > Step 2: > == > TIBConnection -> TSQLTransaction via 'Transaction' property. > Why??? Why must you

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Joost van der Sluis
Op woensdag 12-12-2007 om 16:32 uur [tijdzone +0200], schreef Graeme Geldenhuys: > On 12/12/2007, Joost van der Sluis <[EMAIL PROTECTED]> wrote: > > > > > Step 2: > > You don't need to do this. It is used when the TIBConnection tries to > > execute some sq

Re: [lazarus] SqlDB component madness

2007-12-14 Thread Joost van der Sluis
Op woensdag 12-12-2007 om 20:50 uur [tijdzone +0100], schreef Michael Van Canneyt: > > On Wed, 12 Dec 2007, Michael Van Canneyt wrote: > > > > > > > On Wed, 12 Dec 2007, Graeme Geldenhuys wrote: > > > > > On 12/12/2007, Michael Van Canneyt <[EMAIL PROTECTED]> wrote: > > > > > > > > If all work

[lazarus] Question about packages and units

2008-01-08 Thread Joost van der Sluis
Hi al, If you install the fpWeb package, create a new cgi-application with a TFPWebModule. You can drop a THTMLEntityProducer on that module. So far so good. Then you can add an OnWritePage event, but thereafter the program will nog compile anymore, because you have to add the 'htmlwriter' unit to

Re: [lazarus] Question about packages and units

2008-01-08 Thread Joost van der Sluis
Op dinsdag 08-01-2008 om 14:14 uur [tijdzone +0100], schreef Mattias Gärtner: > Zitat von Joost van der Sluis <[EMAIL PROTECTED]>: > > > Hi al, > > > > If you install the fpWeb package, create a new cgi-application with a > > TFPWebModule. You can drop a THTMLE

Re: [lazarus] Question about packages and units

2008-01-08 Thread Joost van der Sluis
Op dinsdag 08-01-2008 om 14:29 uur [tijdzone +0100], schreef Joost van der Sluis: > Op dinsdag 08-01-2008 om 14:14 uur [tijdzone +0100], schreef Mattias > Gärtner: > > Zitat von Joost van der Sluis <[EMAIL PROTECTED]>: > > > > > Hi al, > > > > >

Re: [fpc-devel] "Invalid field size : 8"

2008-01-11 Thread Joost van der Sluis
Op donderdag 10-01-2008 om 20:28 uur [tijdzone +0100], schreef Bogusław Brandys: > Horacio Jamilis wrote: > > It seems that the Size field shoud be 0 (zero) for numeric fields... > > The size property of TField have different meanings for the different > > field types. > > > > So, you should not

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

2008-01-16 Thread Joost van der Sluis
Don't get me wrong, but some discussions are useless and do more harm than good for the Lazarus. project imho. This is one of hem. Normally I would simply not answer. But this takes too long imho, and too much time which can be spend much better. Op dinsdag 15-01-2008 om 13:10 uur [tijdzone -0500

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

2008-01-16 Thread Joost van der Sluis
Op woensdag 16-01-2008 om 09:54 uur [tijdzone +0100], schreef Joost van der Sluis: > Don't get me wrong, but some discussions are useless and do more harm > than good for the Lazarus. project imho. This is one of hem. Normally > I > would simply not answer. But this takes too l

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

2008-01-16 Thread Joost van der Sluis
No I am answering - to myself even: Op woensdag 16-01-2008 om 11:18 uur [tijdzone +0100], schreef Joost van der Sluis: > A thing which does matter, if the amount of memory the application uses > while running. I'm still annoyed by the fact that the 'clock' in the > corn

Re: [lazarus] Making the IDE work with C/C++

2008-01-21 Thread Joost van der Sluis
Op maandag 21-01-2008 om 16:57 uur [tijdzone +0300], schreef Al Boldi: > > Exactly right! The best feature is find declaration/implementation, > but this > only works for pascal code. What is needed to make this work for c/c > ++? Just re-write the codetools. Joost _

Re: [lazarus] Making the IDE work with C/C++

2008-01-21 Thread Joost van der Sluis
Op maandag 21-01-2008 om 19:00 uur [tijdzone +0300], schreef Al Boldi: > Joost van der Sluis wrote: > > Op maandag 21-01-2008 om 16:57 uur [tijdzone +0300], schreef Al Boldi: > > > Exactly right! The best feature is find declaration/implementation, > > > but this only w

Re: [lazarus] Introduction

2008-01-22 Thread Joost van der Sluis
Op dinsdag 22-01-2008 om 15:03 uur [tijdzone +0200], schreef Graeme Geldenhuys: > On 22/01/2008, Mattias Gärtner <[EMAIL PROTECTED]> wrote: > > About: move from LCL to widgetset > > That was the goal of lazarus from the beginning. > > OK, I get that and respect the choice. I'm simply wondering (f

Re: [lazarus] sqldb query parameter properties not loaded?

2008-01-23 Thread Joost van der Sluis
Op woensdag 23-01-2008 om 10:28 uur [tijdzone +1100], schreef John: > John wrote: > > Hi, > > > > Environment: win32, Lazarus SVN 13347, fpc SVN 9468 > > > > In Lazarus, I have a simple query that uses a parameter: select * > > from test_cld where code = :code; > > I am defining it at design time

Re: [lazarus] sqldb query parameter properties not loaded?

2008-01-23 Thread Joost van der Sluis
Op donderdag 24-01-2008 om 00:09 uur [tijdzone +1100], schreef John: > Joost van der Sluis wrote: > > Op woensdag 23-01-2008 om 10:28 uur [tijdzone +1100], schreef John: > > > >> John wrote: > >> > >>> Hi, > >>> > >>&g

Re: [lazarus] DBImage patch

2008-01-27 Thread Joost van der Sluis
Op zondag 27-01-2008 om 16:18 uur [tijdzone +0100], schreef Michael Van Canneyt: > Secondly: > In general, the TDBImage should be more flexible about the kind > of data it expects: it now requires that the first part of the > blob stream is an ansistring with the extension of the image. > This is

Re: [SPAM] Re: [lazarus] why do delphi users hate lazarus so much?

2008-01-29 Thread Joost van der Sluis
Op dinsdag 29-01-2008 om 03:03 uur [tijdzone +0100], schreef willem: > Marco van de Voort wrote: > > Personally I would rank debugger way higher on my wishlist than packages. > > > Yes I agree with you that a debugger is important. > I am thinking of porting DDD to Lazarus. That won't work. DD

Re: [SPAM] Re: [lazarus] why do delphi users hate lazarus so much?

2008-01-30 Thread Joost van der Sluis
Op dinsdag 29-01-2008 om 11:11 uur [tijdzone +0100], schreef willem: > Joost van der Sluis wrote: > > > >>> Personally I would rank debugger way higher on my wishlist than packages. > >>> > > That won't work. DDD is a frontend to GDB. And guess

Re: [lazarus] sqldb query parameter properties not loaded?

2008-01-31 Thread Joost van der Sluis
Op donderdag 24-01-2008 om 20:56 uur [tijdzone +1100], schreef John: > Joost van der Sluis wrote: > > Op donderdag 24-01-2008 om 00:09 uur [tijdzone +1100], schreef John: > > > Snip > >> It does, in so far as the parameter specs are now retained, but now the > &g

[lazarus] Perl-script in lazreport documentation

2008-02-01 Thread Joost van der Sluis
Hi all, Is this file: lazarus/components/lazreport/doc/cvs2cl.pl really necessary? Wasn't it used once and can it be removed now? Joost _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject

Re: [lazarus] Trouble with postgres

2008-02-06 Thread Joost van der Sluis
Op woensdag 06-02-2008 om 10:16 uur [tijdzone +0200], schreef Alex du Plessis: > Vincent Snijders wrote: > > Alex du Plessis schreef: > >> I certainly did - and in the library file directory one only finds > >> the libpq.a file no libpq.dll > >> > > > > That is a bit strange. Did previous version

Re: [lazarus] I need help with DB

2006-03-14 Thread Joost van der Sluis
> in the TPQConnection (in login form). > > >> > > >> Yes. > > >> > > >> - Drop this TPQConnection component on the same form as the query. > > >> - Set Databasename. > > >> - Connect SQLQuery component. > > >

Re: [lazarus] before I go to far with this

2006-03-15 Thread Joost van der Sluis
o much, is a design-fault, imho. They should only be used for images, complete documents and such. -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl __

Re: [lazarus] SQL Statement

2006-03-15 Thread Joost van der Sluis
> _ > To unsubscribe: mail [EMAIL PROTECTED] with > "unsubscribe" as the Subject >archives at http://www.lazarus.freepascal.org/mailarchives > -- Met vriendelijke groeten, Joost van der Sluis

Re: [lazarus] another newbie ? on DB

2006-03-16 Thread Joost van der Sluis
miss is Dataset.Applyupdates And offcourse transaction.commit -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _ To unsubscribe: mail [EMAIL PROTECTED] with

Re: [lazarus] before I go to far with this

2006-03-16 Thread Joost van der Sluis
On Wed, 2006-03-15 at 08:13 -0500, Alexandre Leclerc wrote: > On 3/15/06, Joost van der Sluis <[EMAIL PROTECTED]> wrote: > > A varchar can hold 2000 characters in sqldb. Postgres supports up to > > 8192 characters in a varchar. If you really need 8192 characters, it'

Re: [lazarus] SQL Statement

2006-03-16 Thread Joost van der Sluis
ed separating parts of names making these more readable. > I tried it without quotes and had dificulties. This way works fine, I > have Select statements executed normally but not this Update which I > think is in a general accepted form. > > As I wrote on my complementary reply, this is r

Re: [lazarus] another newbie ? on DB

2006-03-16 Thread Joost van der Sluis
ng all fields in the where part of the update statement. This has to be developed further, it should also be possible that the programmer provides the an update, delete statement and such. But that is not implemented yet. -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen

Re: [lazarus] another newbie ? on DB

2006-03-16 Thread Joost van der Sluis
e the fpc-code: fcl/db/sqldb/examples/fedittable.pp -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _ To unsubscribe: mail [EMAIL PROTECTED] with

Re: [lazarus] before I go to far with this

2006-03-16 Thread Joost van der Sluis
can > only have 1000 chars. Is that correct? No, I thought that limit is 2000 chars. But I was wrong again. The max amount of characters is defined as dsMaxStringSize = 8192 -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl ___

Re: [lazarus] Because I can't get SQLDB working

2006-03-16 Thread Joost van der Sluis
us. This is more a ZEOS issue, then an fpc-issue. (except for fpc-bug 4510) And although the problems are easily fixable, they seems to be to hard for the ZEOS team. -- Met vriendelijke groeten, Joost van der Sluis CNOC Info

RE: [lazarus] SQL Statement

2006-03-17 Thread Joost van der Sluis
> >Cause now I still don't know if it's a bug or not. > > No, it is not a bug. Non-Select statements need .ExecSQL method, not .open. I > had a couple of replies on this, tested and confirmed. I'm still curious if you've got the error message 'Cannot open a non- select statement' or not. (when y

Re: [lazarus] the DB error - I know what is wrong

2006-03-17 Thread Joost van der Sluis
> I think I have now discovered the error in updating the data on the postgres > database. The sqlquery is passing a bad string to the postgres database > engine. In my case the the following is passed: > Update arcust set custno = 'BRS', company = 'Blue Ribbon Stairs' where > (custno=BRS) >

Re: [lazarus] another newbie ? on DB

2006-03-17 Thread Joost van der Sluis
> > What I also miss is Dataset.Applyupdates > > And offcourse transaction.commit > I don't understand the purpose of the datasource.dataset. I have been > reading > the examples files from FPC. In the files they do not use the > datasource.dataset anywhere. Does this mean that I'm not suppo

  1   2   3   >