Re: RE : [fpc-pascal] Re: RE : Re: RE : RE : RE : Assigning value to ftVariant datatype& varbytes-still stuck

2011-08-10 Thread Reinier Olislagers
On 10-8-2011 9:49, Ludo Brands wrote: >> Oops, sorry, you're right. Your cygwin diffs don't seem to >> agree with (the way I use) fpc patch; I got it to apply only >> the first part of the patch... Now it works. >> > > The patches I upload to bugs.freepascal are made with svn diff. The ones I >

Re: RE : RE : [fpc-pascal] Re: RE : RE : RE : Assigning value to ftVariantdatatype& varbytes-still stuck

2011-08-10 Thread Reinier Olislagers
On 10-8-2011 11:51, Ludo Brands wrote: >>> I do get a segfault in the last test when assigning to >>> ftWideString256. When tracing the code it crashes when moving the >>> size+1 chracters to the database. This fixed length moving is >>> fundamentally wrong. The string is only 20 or so chars long

[fpc-pascal] XMLXSDExport: line ending in Excel cells

2011-08-12 Thread Reinier Olislagers
Hi list, I've been refactoring the XMLXSDExport code and am now busy fixing some bugs based on testing. I'd appreciate your input. In Excel text fields, you can generate a line ending by pressing Alt-Enter. On export to XML this is written as So far so good. If exporting dataset text (memo, st

[fpc-pascal] Re: XMLXSDExport: line ending in Excel cells

2011-08-12 Thread Reinier Olislagers
On 12-8-2011 12:32, Reinier Olislagers wrote: > In Excel text fields, you can generate a line ending by pressing > Alt-Enter. On export to XML this is written as > So far so good. > > If exporting dataset text (memo, string, ..) data to Excel XML text > fields, which chara

[fpc-pascal] Explicit encoding of LF in XML

2011-08-12 Thread Reinier Olislagers
All, Looking at multiline support of text/string cells for export to Excel XML format. My code, such as: TDOMElement(FieldNode).SetAttribute('ss:Type', 'String'); FNode := Foutputdoc.CreateTextNode(LeftStr(UTF8Decode(EF.Field.AsString), 32767)); writes out a cell like: First line. Second

Re: RE : [fpc-pascal] Explicit encoding of LF in XML

2011-08-12 Thread Reinier Olislagers
On 12-8-2011 16:31, Ludo Brands wrote: >> Excel needs an encoded LF: >> First line. Second line >> >> How can I produce that? >> > > Uses strutils; > ... > Foutputdoc.CreateTextNode(LeftStr(UTF8Decode(AnsiReplaceStr(AnsiReplaceStr(E > F.Field.AsString,#10,' '),#13,'')),32767)); > > Ludo > That's

[fpc-pascal] ftGuid displaytext & output

2011-08-13 Thread Reinier Olislagers
While trying to export dataset data to XML, I use this for ftGUID fields: FNode := Foutputdoc.CreateTextNode(Utf8decode(GUIDToString(TGuid(EF.Field.Value; This works on Windows 32 and shows a hex representation of the GUID, like {---C000-0046} On Linux x64, I

Re: RE : [fpc-pascal] ftGuid displaytext & output

2011-08-14 Thread Reinier Olislagers
On 13-8-2011 13:04, Ludo Brands wrote: > TGuidField stores guid in the string format (GuidToString). > EF.Field.AsString should give you the correct string value. > > Ludo Thanks, Ludo. I think I was using AsString at first. I'll have a further look; maybe I'm putting in rubbish; I'll probably h

Re: RE : RE : RE : RE : [fpc-pascal] Re: RE : RE : RE : Assigningvalue toftVariantdatatype& varbytes-still stuck

2011-08-14 Thread Reinier Olislagers
On 14-8-2011 16:30, Ludo Brands wrote: >> In our previous episode, Ludo Brands said: >>> Sorry mate. No reaction. Everybody seems to be happy with >> the current >>> implementation. Under these circumstances, I'm not going to >> spend any >>> time on creating a patch that makes a, minor, change

Re: [fpc-pascal] Patch: new XML export for FCL-DB ready for inclusion, issue 19790 - includes Delphi Clientdataset

2011-08-15 Thread Reinier Olislagers
On 28-7-2011 9:24, michael.vancann...@wisa.be wrote: > On Thu, 28 Jul 2011, Reinier Olislagers wrote: >> On 27-7-2011 20:52, michael.vancann...@wisa.be wrote: >> Code like >> >> ftWideString: //fixed length or at least max length string >> begin

Re: [fpc-pascal] Patch: new XML export for FCL-DB ready for inclusion, issue 19790 - includes Delphi Clientdataset

2011-08-15 Thread Reinier Olislagers
On 15-8-2011 11:25, Michael Van Canneyt wrote: > I created a dataset with 2 fields. A ftString field with size 33, and a > ftWideString field with size 44. > > Based on the following output from SaveToFile, I would say that you'll > need to put Size*SizeOf(CharTypeUsedInfield), which should be Dat

Re: [fpc-pascal] Patch: new XML export for FCL-DB ready for inclusion, issue 19790 - includes Delphi Clientdataset

2011-08-15 Thread Reinier Olislagers
On 15-8-2011 11:44, Reinier Olislagers wrote: > On 15-8-2011 11:25, Michael Van Canneyt wrote: >> I created a dataset with 2 fields. A ftString field with size 33, and a >> ftWideString field with size 44. >> >> Based on the following output from SaveToFile, I would say

Re: [fpc-pascal] Patch: new XML export for FCL-DB ready for inclusion, issue 19790 - includes Delphi Clientdataset

2011-08-15 Thread Reinier Olislagers
On 15-8-2011 12:33, michael.vancann...@wisa.be wrote: > I applied the patch, thank you very much for this work :-). > > But please: > - Try to split patches in smaller chunks. It's better for bugfixing. > If you break something it's harder to track what caused the break with > these huge patch

[fpc-pascal] Funambol/syncml and fpc

2011-08-30 Thread Reinier Olislagers
Hi all, Has anyone used funambol/syncml libraries or an FPC equivalent to talk the syncml protocol? I've got a Firebird address database that I would like to sync some day using Funambol (with Thunderbird, or sogo/OpenChange in future). (Also, another very wild idea is trying to write a Thunderbi

[fpc-pascal] DBF Field name length and fpdbfexport

2011-09-02 Thread Reinier Olislagers
Hi all, If I Googled correctly, the following field size limits are present for the various DBase formats: 3: DBase III: 10 characters 4: DBase IV: 10 characters 7: DBase VII: 32 characters 8: FoxPro: 10 characters 3,4: http://www.clicketyclick.dk/databases/xbase/format/dbf.html#DBF_STRUCT 7: II

Re: [fpc-pascal] DBF Field name length and fpdbfexport

2011-09-02 Thread Reinier Olislagers
On 2-9-2011 13:23, michael.vancann...@wisa.be wrote: > > On Fri, 2 Sep 2011, Reinier Olislagers wrote: > >> Hi all, > > Presumably, yes. > > Michael. ;) Thanks, I'll give it a go and attach a patch to Mantis... Reinier ___

Re: [fpc-pascal] DBF Field name length and fpdbfexport

2011-09-02 Thread Reinier Olislagers
On 2-9-2011 13:23, michael.vancann...@wisa.be wrote: > On Fri, 2 Sep 2011, Reinier Olislagers wrote: >> In packages\fcl-db\src\export\fpdbfexport.pp >> These tablelevels/formats are defined: >> TTableFormat = (tfDBaseIII,tfDBaseIV,tfDBaseVII,tfFoxPro); >>

Re: [fpc-pascal] DBF Field name length and fpdbfexport

2011-09-02 Thread Reinier Olislagers
On 2-9-2011 15:09, michael.vancann...@wisa.be wrote: > On Fri, 2 Sep 2011, Reinier Olislagers wrote: >> On 2-9-2011 13:23, michael.vancann...@wisa.be wrote: >>> On Fri, 2 Sep 2011, Reinier Olislagers wrote: >> I think I've also found the solution to >> http://bu

[fpc-pascal] Improved LazUpdater - testers welcome on Windows

2011-09-03 Thread Reinier Olislagers
Hello FPC and Lazarus lists, I've been improving the LazUpdater FPC/Lazarus SVN downloader/installer written by Ingo Steiniger for a while now. I didn't get any reaction from the original author http://forge.lazarusforum.de/issues/118 so I uploaded my version to a mercurial repository: https://bi

[fpc-pascal] TField.Attributeset explanation?

2011-09-05 Thread Reinier Olislagers
Hi all, Working on the SQLDB Tutorial1 on the wiki. I'm struggling with getting dbgrid-driven inserts to work. Using Firebird employee.fdb CUSTOMER table; CUST_NO is an integer primary key with Firebird generator/sequence + trigger => sort of an autonumber/autoinc field. When inserting records w

[fpc-pascal] FPCDocs Git repository

2011-09-05 Thread Reinier Olislagers
Hi all, goeiemore Graeme ;), While there are git repositories for FPC and Lazarus, there doesn't seem to be one for FPCDocs. Is a public git repository available for FPCDocs? The reason: I'm looking into extending my version of LazUpdater https://bitbucket.org/reiniero/lazupdater_baremetal to su

Re: [fpc-pascal] TField.Attributeset explanation?

2011-09-05 Thread Reinier Olislagers
On 5-9-2011 10:30, michael.vancann...@wisa.be wrote: > On Mon, 5 Sep 2011, Reinier Olislagers wrote: >> When inserting records with an empty CUST_NO, I get an error that >> CUST_NO is required. > > That is normal. > > Just set the 'Required' property of t

Re: [fpc-pascal] FPCDocs Git repository

2011-09-05 Thread Reinier Olislagers
On 5-9-2011 12:19, Graeme Geldenhuys wrote: > I'm a bit busy at work at the moment, but will see if I can setup a > Git mirror in a few days time. > > Regards, > - Graeme - Baie dankie dat jy dit wil doen! Thanks a lot in advance, Reinier ___ fpc-pasc

Re: [fpc-pascal] TField.Attributeset explanation?

2011-09-05 Thread Reinier Olislagers
On 5-9-2011 11:39, michael.vancann...@wisa.be wrote: > On Mon, 5 Sep 2011, Alex Shishkin wrote: >> 05.09.2011 12:30, michael.vancann...@wisa.be пишет: >> Forget the 'Attributeset' property. It's not used in FPC. >> >> (in fact, I don't even know what it's for or where it comes from) >> >> Michael.

Re: [fpc-pascal] DBF Field name length and fpdbfexport

2011-09-05 Thread Reinier Olislagers
On 2-9-2011 14:38, Reinier Olislagers wrote: > I think I've also found the solution to > http://bugs.freepascal.org/view.php?id=20069 > (patch attached), so if somebody would be so kind to review & apply > them, I'd be very happy. Turns out the dbf export code needs a

Re: [fpc-pascal] DBF Field name length and fpdbfexport

2011-09-05 Thread Reinier Olislagers
On 5-9-2011 23:20, Michael Van Canneyt wrote: > On Mon, 5 Sep 2011, Reinier Olislagers wrote: >> Turns out the dbf export code needs at least another patch. >> DBF export missed support for ftfloat and other field types. >> >> Issue + patch at >> http://bugs.fre

Re: [fpc-pascal] DBF Field name length and fpdbfexport

2011-09-06 Thread Reinier Olislagers
On 6-9-2011 8:32, Michael Van Canneyt wrote: > On Tue, 6 Sep 2011, Reinier Olislagers wrote: >> Wasn't aware of your/maintainers' preferences regarding naming, so I'll >> keep that in mind. To be honest, just thought you guys were lazy & old >> fashione

CSVExport: was Re: [fpc-pascal] DBF Field name length and fpdbfexport

2011-09-07 Thread Reinier Olislagers
On 6-9-2011 9:14, Reinier Olislagers wrote: > On 6-9-2011 8:32, Michael Van Canneyt wrote: >> On Tue, 6 Sep 2011, Reinier Olislagers wrote: >>> Also, creating a Lazarus XMLSDExport component, and possibly >>> rewriting CSVexport to use sdfdata, so it needs less code

[fpc-pascal] How to detect supported data types in dataset?

2011-09-07 Thread Reinier Olislagers
Hi list, Possible newbie question so feel free to educate me ;) (Away for some days, so may not read response until back) A patch by Ludo Brands on bufdataset (mantis 19930) got me thinking: const ftSupported = [ftString,ftGuid,... and so on]; procedure TCustomBufDataset.CreateDataset; var i:

[fpc-pascal] Re: How to detect supported data types in dataset?

2011-09-15 Thread Reinier Olislagers
On 8-9-2011 9:16, michael.vancanneyt-0is9kj9s...@public.gmane.org wrote: > On Thu, 8 Sep 2011, Reinier Olislagers wrote: >> Am I missing something obvious or does it make sense to expose something >> like a SupportedFieldTypes property for datasets? >> How does Delphi do t

[fpc-pascal] [Patch] New tests for fcl-db export

2011-09-16 Thread Reinier Olislagers
Hi list, FYI & hopefully implementation: I've been writing some tests for fcl-db export, that test basic functionality for: - CSV export - DBF export - SimpleXML export Please find them in Mantis: 20271 [Patch] SimpleXML export: new test for fcl-db 20268 [Patch] CSV export: new test for fcl

[fpc-pascal] How to do conditional compilation with macros

2011-09-18 Thread Reinier Olislagers
Trying to test for a certain minimum version of FPC. Have got FPC version 2.7.1 [2011/09/17] for i386 on Windows. What am I doing wrong? program conditional; {$mode objfpc}{$H+} uses {$IFDEF UNIX}{$IFDEF UseCThreads} cthreads, {$ENDIF}{$ENDIF} Classes; begin //How should I use FPCVU

Re: [fpc-pascal] How to do conditional compilation with macros

2011-09-18 Thread Reinier Olislagers
On 18-9-2011 13:41, Sven Barth wrote: > On 18.09.2011 13:29, Reinier Olislagers wrote: >> What am I doing wrong? > > Additionally to what Marco wrote: > > You must not use the "$" as prefix for the "variable" if you reference > such a compiler define i

[fpc-pascal] Hints on getting FPDocs to work on Linux

2011-09-18 Thread Reinier Olislagers
Hi gang, Any hints on which packages to install on Debian Squeeze (current stable) or which files are required so I can try generating some FPDocs content? Something like aptitude install texlive tex4ht python-plastex hevea dvi2tty perhaps? (Looking into writing some documentation on the db ex

Re: [fpc-pascal] Hints on getting FPDocs to work on Linux

2011-09-18 Thread Reinier Olislagers
On 18-9-2011 19:56, Graeme Geldenhuys wrote: > On 18/09/2011, Reinier Olislagers wrote: >> >> Any hints on which packages to install on Debian Squeeze (current >> stable) or which files are required so I can try generating some FPDocs >> content? Thanks Marco &

Re: [fpc-pascal] Hints on getting FPDocs to work on Linux

2011-09-18 Thread Reinier Olislagers
On 18-9-2011 23:27, Graeme Geldenhuys wrote: > On 18/09/2011, Reinier Olislagers wrote: > >I never install binary releases of the various distro packages - they >are always out of date. LazUpdater ftw ;) (When I have it working on Linux) >> Your post did remind me to ch

[fpc-pascal] fcl-extra ServiceManager doesn't seem to working with unelevated Windows account?

2011-10-04 Thread Reinier Olislagers
Hi list, First wanted to check with you if I'm doing something wrong. Using the ServiceManager unit (Windows only), I'm trying to find out if a service is running (Vista x64). I can do: sc query samss on the command line without problem. When I run fpc ServiceTest.pas rem Free Pascal Compiler vers

Re: [fpc-pascal] fcl-extra ServiceManager doesn't seem to working with unelevated Windows account?

2011-10-04 Thread Reinier Olislagers
On 4-10-2011 12:31, Sven Barth wrote: > Am 04.10.2011 12:22, schrieb Reinier Olislagers: >>Services.Connect; >>Services.Acces := SC_MANAGER_CONNECT; //Note typo in property. > > You need to set "Acces(s)", before calling "Connect", becaus

[fpc-pascal] [Semi-OT] Git format patches don't seem to work

2011-10-04 Thread Reinier Olislagers
Hi all, Having some trouble creating patches that actually work. (On Windows) I've been using git to get FPC trunk and git diff --no-prefix > %temp%\mypatch.diff rem --no-prefix : Do not show any source or destination prefix. to create patches. Using Msysgit: git --version git version 1.7.6.msysg

Re: [fpc-pascal] [Semi-OT] Git format patches don't seem to work

2011-10-04 Thread Reinier Olislagers
On 4-10-2011 13:14, Marco van de Voort wrote: > In our previous episode, Reinier Olislagers said: >> Having some trouble creating patches that actually work. >> (On Windows) >> I've been using git to get FPC trunk and >> git diff --no-prefix > %temp%\mypatch.di

[fpc-pascal] Git line endings leading to patch problems - was [Semi-OT] Git format patches don't seem to work

2011-10-06 Thread Reinier Olislagers
On 4-10-2011 14:41, Reinier Olislagers wrote: > On 4-10-2011 13:14, Marco van de Voort wrote: >> In our previous episode, Reinier Olislagers said: >>> Having some trouble creating patches that actually work. >>> (On Windows) >>> I've been using git to g

Re: [fpc-pascal] Git line endings leading to patch problems - was [Semi-OT] Git format patches don't seem to work

2011-10-06 Thread Reinier Olislagers
On 6-10-2011 16:56, Alex Shishkin wrote: > 06.10.2011 16:37, Reinier Olislagers пишет: >> On 4-10-2011 14:41, Reinier Olislagers wrote: >>> On 4-10-2011 13:14, Marco van de Voort wrote: >>>> In our previous episode, Reinier Olislagers said: >>>>> Havin

Re: [fpc-pascal] Git line endings leading to patch problems - was [Semi-OT] Git format patches don't seem to work

2011-10-06 Thread Reinier Olislagers
On 6-10-2011 17:07, Graeme Geldenhuys wrote: > On 06/10/2011, Reinier Olislagers wrote: >> >> Git: >> https://github.com/graemeg/freepascal/raw/7026b7669fd422f88ffe33174dac1725c0295427/packages/fcl-extra/src/win/ServiceManager.pas >> => Unix line endings >&

Re: [fpc-pascal] Git line endings leading to patch problems - was [Semi-OT] Git format patches don't seem to work

2011-10-06 Thread Reinier Olislagers
On 6-10-2011 17:04, Alex Shishkin wrote: > 06.10.2011 18:59, Reinier Olislagers пишет: >> Thanks Alex, I already fiddled with that. I'll try again with >> core.autocrlf set to true and false to make sure it doesn't work... >> >> > not "true" n

Re: [fpc-pascal] Git line endings leading to patch problems - was [Semi-OT] Git format patches don't seem to work

2011-10-06 Thread Reinier Olislagers
On 6-10-2011 17:04, Alex Shishkin wrote: > 06.10.2011 18:59, Reinier Olislagers пишет: >> Thanks Alex, I already fiddled with that. I'll try again with >> core.autocrlf set to true and false to make sure it doesn't work... >> > not "true" not &qu

Re: [fpc-pascal] Git line endings leading to patch problems - was [Semi-OT] Git format patches don't seem to work

2011-10-07 Thread Reinier Olislagers
On 7-10-2011 9:15, Graeme Geldenhuys wrote: > On 06/10/2011 20:41, Reinier Olislagers wrote: > The Git installation under Windows set mine to true (not input). true it is, see other message ;) >> So while it could be used, I'd have to remember to run unix2dos over it >> - th

Re: [fpc-pascal] Git line endings leading to patch problems - was [Semi-OT] Git format patches don't seem to work

2011-10-07 Thread Reinier Olislagers
On 7-10-2011 9:15, Graeme Geldenhuys wrote: > I don't think that is needed. I believe the 'patch' program will sort > that out by itself. I have sent numerous patches to FPC and Lazarus > (both those repositories are git ones on my Linux system). Nobody has > ever complained that the EOL style was

Re: [fpc-pascal] Git line endings leading to patch problems - was [Semi-OT] Git format patches don't seem to work

2011-10-07 Thread Reinier Olislagers
On 7-10-2011 15:13, Graeme Geldenhuys wrote: > On 07/10/2011 12:52, Reinier Olislagers wrote: >> doesn't work - will need patch -p1 < git.diff > > Correct, and anybody that has applied a handful of patches or more in > there time would have known that already. ;-

[fpc-pascal] Re: Git line endings leading to patch problems - was [Semi-OT] Git format patches don't seem to work

2011-10-07 Thread Reinier Olislagers
On 7-10-2011 11:28, Marco van de Voort wrote: > I usually apply patches on FreeBSD, and in rarer cases Linux. > > Even up to date patch doesn't always process lineendings properly btw. I > have to dos2unix often on *nix too. > > Recently a lot of patches with incorrect filenames, or no filenames

[fpc-pascal] Re: Git line endings leading to patch problems - was [Semi-OT] Git format patches don't seem to work

2011-10-07 Thread Reinier Olislagers
On 7-10-2011 16:08, Graeme Geldenhuys wrote: > On 07/10/2011 15:53, Reinier Olislagers wrote: >> Sure, but why add to the aggravation - SVN diff doesn't do this, so one >> less difference to worry about: > > It's still in the universal patch format, with or wi

[fpc-pascal] Windows API translation - or better way to update system tray?

2011-10-09 Thread Reinier Olislagers
Hi all, (See http://lazarus.freepascal.org/index.php/topic,14847.msg79038.html#msg79038 for initial question) My program starts and stops external programs that have icons. It would be nice to immediately clean up the icons from the system tray once those programs have stopped. I've found this c

Re: [fpc-pascal] Windows API translation - or better way to update system tray?

2011-10-09 Thread Reinier Olislagers
On 9-10-2011 14:17, Sven Barth wrote: > That's not C++, but C, but in both "NULL" can be used for both: pointers > and ordinals. In Pascal HWND is an ordinal and there the correct > equivalent is of course "0". So yes, you should use "0". Maybe you'll > need to do this for the first param as well.

[fpc-pascal] Stunnel replaced by FPC?

2011-10-13 Thread Reinier Olislagers
Hi list, For my remote assistance screen sharing project https://bitbucket.org/reiniero/checkride/ I'm currently using stunnel on Windows to tunnel VNC traffic over an SSL/TLS tunnel. Can I replace stunnel with e.g. Synapse code? The Synapse documentation only shows https examples. I'd like to t

Re: [fpc-pascal] Stunnel replaced by FPC?

2011-10-13 Thread Reinier Olislagers
On 13-10-2011 14:22, Wimpie Nortje wrote: > Have a look at BEEP (beepcore.org) and Vortex (www.aspl.es/vortex). I > think it covers all of your requirements. Thanks, I'll have a look. ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://li

[fpc-pascal] Reopen issue 20500: TSQLParser cant Parse Statements containing "as"

2011-10-17 Thread Reinier Olislagers
The issue reporter gave this example: select ORDERNO as OrderNo from ORDERS as Orders; It does parse AS, but only for a field. Michael Van Canneyt replied: TSQLParser implements SQL syntax as used in Firebird, and firebird does not allow AS for a tablename, just append the alias. The correct synt

Re: [fpc-pascal] Reopen issue 20500: TSQLParser cant Parse Statements containing "as"

2011-10-17 Thread Reinier Olislagers
On 17-10-2011 20:57, Michael Van Canneyt wrote: >> Would it make sense to reopen this bug? > > ? Eh ? If indeed it is accepted, then yes please. > > Quite strange, because I implemented the SQL parser based on the > official Firebird server docs. And it definitely was not allowed. > > But I'll t

Re: [fpc-pascal] Reopen issue 20500: TSQLParser cant Parse Statements containing "as"

2011-10-19 Thread Reinier Olislagers
On 18-10-2011 7:13, Reinier Olislagers wrote: > On 17-10-2011 20:57, Michael Van Canneyt wrote: >>> Would it make sense to reopen this bug? >> >> ? Eh ? If indeed it is accepted, then yes please. >> >> Quite strange, because I implemented the SQL parser base

[fpc-pascal] Re: How to insert a record and get the primary key with sqldb?

2011-10-24 Thread Reinier Olislagers
On 22-10-2011 15:33, michael.vancanneyt-0is9kj9s...@public.gmane.org wrote: > > > On Sat, 22 Oct 2011, Marco van de Voort wrote: > >> In our previous episode, Felipe Monteiro de Carvalho said: >>> Ok, now I want to insert a record in my table and I would like to >>> obtain the auto-generated Pri

Re: [fpc-pascal] Re: How to insert a record and get the primary key with sqldb?

2011-10-24 Thread Reinier Olislagers
On 24-10-2011 11:14, michael.vancann...@wisa.be wrote: > On Mon, 24 Oct 2011, Reinier Olislagers wrote: >> Also, using INSERT...RETURNING it's very well possible to get the >> sequence value directly when inserting the data. > > Yes, but not all DBs support this. We

[fpc-pascal] Re: How to insert a record and get the primary key with sqldb?

2011-10-24 Thread Reinier Olislagers
On 24-10-2011 14:23, Henry Vermaak wrote: > On 24/10/11 13:05, Marco van de Voort wrote: >> In our previous episode, >> michael.vancanneyt-0is9kj9s...@public.gmane.org said: Henry Summary: 1. A lot of (or some) people don't like GUID PKs 2. Some (or a lot of) people do. Regardless of being in cam

[fpc-pascal] Spatialite (a GIS extension to Sqlite) & SQLite Load_extension

2011-11-07 Thread Reinier Olislagers
Hi all, I'm looking into getting road, vegetation, building etc. data from OpenStreetmap and generating a map for the Rigs of Rods truck/driving/flight/boat simulator using FPC/Lazarus if possible. I've found Spatialite [1], an extension to the SQLite database engine, that allows e.g. easy im

[fpc-pascal] SQLite Load_extension seems to be working

2011-11-07 Thread Reinier Olislagers
On 7-11-2011 8:23, Reinier Olislagers wrote: > 2. You can apparently load the spatialite (and dependencies) dll/so as > an extension to SQLite, with a statement like [3] > select load_extension('libspatialite-4.dll'); > However, it seems you have to enable the extensio

Re: [fpc-pascal] SQLite Load_extension seems to be working

2011-11-07 Thread Reinier Olislagers
On 7-11-2011 10:49, michael.vancann...@wisa.be wrote: > On Mon, 7 Nov 2011, Reinier Olislagers wrote: >> On 7-11-2011 8:23, Reinier Olislagers wrote: >> Attached diff (against fixes_2_6) seems to work for letting SQLite load >> the libspatialite extension >> I'll u

[fpc-pascal] Re: ioda joda fulltext search not working

2011-11-12 Thread Reinier Olislagers
On 12-11-2011 4:44, noreply-buo9vyj1...@public.gmane.org wrote: > I was reading recently that MySQL has fulltext on InnoDB built in.. don't > know much about it but I came across that recently while googling. > Firebird has no fulltext built in to it I guess, eh? > No, but there was an effort to e

[fpc-pascal] [OT] AI programming challenge includes FreePascal

2011-11-14 Thread Reinier Olislagers
Hi all, In case you didn't know and are interested, there is an online artificial intelligence competition [1] that lets you program an ant colony that fights other colonies. There's a FreePascal starter kit available as well. You can test your program against others now; your submission needs t

[fpc-pascal] Makeskel error or error behind keyboard?

2011-11-14 Thread Reinier Olislagers
Hi list, Trying to start documenting fpXMLXSDExport: c:\development\fpc\bin\i386-win32\makeskel --disable-private --emit-class-separator --update --package=fcl --input=C:\development\Fpc\Source\packages\fcl-db\src\export\fpxmlxsdexport.pp --output=fpxmlxsdexport.xml MakeSkel - FPDoc skeleton XML d

Re: [fpc-pascal] Makeskel error or error behind keyboard?

2011-11-15 Thread Reinier Olislagers
On 15-11-2011 9:50, michael.vancann...@wisa.be wrote: > On Tue, 15 Nov 2011, Sven Barth wrote: >> Am 14.11.2011 17:11, schrieb Reinier Olislagers: >>> Snippet of the code in question: >>>TCustomXMLXSDExporter = class(TCustomFileExporter) >>>const &

[fpc-pascal] SQLDB Firebird port other than 3050

2011-11-15 Thread Reinier Olislagers
Hi all, This is probably my confused week, but I couldn't find any documentation. How do I specify the port number when connecting to Firebird/Interbase databases with sqldb on a different port than the default (3050)? Thanks, Reinier ___ fpc-pascal ma

[fpc-pascal] Re: RE : SQLDB Firebird port other than 3050

2011-11-15 Thread Reinier Olislagers
On 15-11-2011 16:30, Ludo Brands wrote: >>> How do I specify the port number when connecting to >> Firebird/Interbase >>> databases with sqldb on a different port than the default (3050)? >> >> Try >>/portnr:/path/to/database >> in your databasename. > host/port:c:\...\data.fdb > http://www.d

[fpc-pascal] Makeskel & how to add Firebird connection documentation?

2011-11-16 Thread Reinier Olislagers
Hi list, I want to document packages/fcl-db/src/sqldb/interbase/ibconnection.pp So I run this to get started: makeskel --disable-private --emit-class-separator --update --package=fcl-sqldb --input=/home/reinier/fpc271/packages/fcl-db/src/sqldb/interbase/ibconnection.pp --output=ibconnection.pp W

Re: [fpc-pascal] Makeskel & how to add Firebird connection documentation?

2011-11-17 Thread Reinier Olislagers
On 17-11-2011 10:06, michael.vancann...@wisa.be wrote: > On Thu, 17 Nov 2011, Reinier Olislagers wrote: >> I want to document >> packages/fcl-db/src/sqldb/interbase/ibconnection.pp >> What do I enter as package? fcl-sqldb? How do I find out? (And if so, >> can that be d

[fpc-pascal] Setting environment variables on Unix/Linux?

2011-11-17 Thread Reinier Olislagers
Hi list, It seems FPC allows one to retrieve environment variables on Linux/Unix (GetEnvironmentVariable) but not to set them. Is that correct? Some digging: Setting environment variables on Unix with gnu libc: http://www.gnu.org/s/libc/manual/html_node/Environment-Access.html#Environment-Access

Re: [fpc-pascal] Setting environment variables on Unix/Linux?

2011-11-17 Thread Reinier Olislagers
On 17-11-2011 13:55, michael.vancann...@wisa.be wrote: > On Thu, 17 Nov 2011, Reinier Olislagers wrote: >> Hi list, >> >> It seems FPC allows one to retrieve environment variables on Linux/Unix >> (GetEnvironmentVariable) but not to set them. >> >> Is th

[fpc-pascal] Makeskel generation question

2011-11-18 Thread Reinier Olislagers
Hi list, I've run makeskel on ibconnection.pp. This declaration: protected ... function GetHandle : pointer; override; gets output as: Shouldn't the TIBConnection.GetHandle.Result function result visibility be protected as well? I understand that the function result is... l

Re: [fpc-pascal] Makeskel generation question

2011-11-18 Thread Reinier Olislagers
On 18-11-2011 11:13, Graeme Geldenhuys wrote: > For the FPC documentation, only Public and Published methods & > properties are documented. So you should have generated the initial xml > file specifying only Public or higher visibility in the output makeskel > generates. > So apparently no help f

Re: [fpc-pascal] Makeskel generation question

2011-11-18 Thread Reinier Olislagers
On 18-11-2011 12:23, Graeme Geldenhuys wrote: > On 2011-11-18 13:15, Reinier Olislagers wrote: >> >> So apparently no help for the poor developer who wants to inherit a >> class and wants to figure out how to use the protected methods & >> properties ;) > >

Re: [fpc-pascal] Makeskel generation question

2011-11-18 Thread Reinier Olislagers
On 18-11-2011 13:14, Michael Van Canneyt wrote: > On Fri, 18 Nov 2011, Reinier Olislagers wrote: >> >> >> >> >> >> Shouldn't the TIBConnection.GetHandle.Result function result visibility >> be protected as well? > > No, why ? A functio

[fpc-pascal] IBConnection blobsegmentsize irrelevant & performance

2011-11-19 Thread Reinier Olislagers
Reinier http://tech.groups.yahoo.com/group/firebird-support/message/115826 Posted by: "Ann Harrison" Fri Nov 18, 2011 9:10 am (PST) Reinier Olislagers wrote: > > I came across BLOB segment size and understand that, when writing BLOBs, > you need to write in chunks smaller than or

[fpc-pascal] Patch/Test BlobSegmentSize was: IBConnection blobsegmentsize irrelevant & performance

2011-11-19 Thread Reinier Olislagers
On 19-11-2011 13:28, Reinier Olislagers wrote: > Hi list, > > The Firebird/Interbase ibconnection.pp code has this code in its > SetParameters procedure to upload blobs in segments (BlobSegmentSize > property is set to 80 on object creation): > while BlobBytesW

Re: [fpc-pascal] Patch/Test BlobSegmentSize was: IBConnection blobsegmentsize irrelevant & performance

2011-11-20 Thread Reinier Olislagers
On 19-11-2011 23:36, Michael Van Canneyt wrote: > On Sat, 19 Nov 2011, Reinier Olislagers wrote: >> On 19-11-2011 13:28, Reinier Olislagers wrote: I wonder >> whether/what changes are required for reading blobs... > > The following function needs ad

Graeme: FBLIB blob segment size was: [fpc-pascal] Patch/Test BlobSegmentSize

2011-11-20 Thread Reinier Olislagers
On 19-11-2011 23:36, Michael Van Canneyt wrote: > On Sat, 19 Nov 2011, Reinier Olislagers wrote: >> On 19-11-2011 13:28, Reinier Olislagers wrote: >>> Hi list, >>> >>> The Firebird/Interbase ibconnection.pp code has this code in its >>> SetPar

Re: Graeme: FBLIB blob segment size was: [fpc-pascal] Patch/Test BlobSegmentSize

2011-11-20 Thread Reinier Olislagers
On 20-11-2011 13:06, Graeme Geldenhuys wrote: > On 20/11/2011, Reinier Olislagers wrote: >> >> Had a look at tiOPF FBLib FBLDsql.pas. It defines >> BLOB_SEGMENT_LEN = 4095; >> used in both reading & writing blob data. >> >> ... might/could/should that

Re: [fpc-pascal] Patch/Test BlobSegmentSize was: IBConnection blobsegmentsize irrelevant & performance

2011-11-21 Thread Reinier Olislagers
On 20-11-2011 10:31, Reinier Olislagers wrote: > On 19-11-2011 23:36, Michael Van Canneyt wrote: >> On Sat, 19 Nov 2011, Reinier Olislagers wrote: >>> On 19-11-2011 13:28, Reinier Olislagers wrote: I wonder >>> whether/what changes are required for reading blobs... &

[fpc-pascal] Re: Firebird Connection documentation: suggestions? remarks?

2011-11-21 Thread Reinier Olislagers
On 19-11-2011 14:21, Reinier Olislagers wrote: > Hi list, > > Please find attached my current version for the Interbase/Firebird > connection documentation source. If the attachment gets deleted by the > list or if you want to see the latest version, please go to > https://bitb

[fpc-pascal] Re: Firebird Connection documentation: suggestions? remarks?

2011-11-22 Thread Reinier Olislagers
On 22-11-2011 10:32, michael.vancanneyt-0is9kj9s...@public.gmane.org wrote: >> Still don't understand what the TIBConnectionDef/TConnectionDef class is >> used for? > > It is uses for the TSQLConnector component. > >> Actually, I don't understand registering/unregistering connections. >> SQLDB ma

[fpc-pascal] Re: Firebird Connection documentation: suggestions? remarks?

2011-11-23 Thread Reinier Olislagers
On 19-11-2011 14:21, Reinier Olislagers wrote: > Hi list, > > Please find attached my current version for the Interbase/Firebird > connection documentation source. > I have some doubts/questions: > 1. Do I need to document inherited properties etc or will a documented > pare

[fpc-pascal] Re: Patch/Test BlobSegmentSize was: IBConnection blobsegmentsize irrelevant & performance

2011-11-24 Thread Reinier Olislagers
On 21-11-2011 9:31, Reinier Olislagers wrote: > On 20-11-2011 10:31, Reinier Olislagers wrote: >> On 19-11-2011 23:36, Michael Van Canneyt wrote: >>> On Sat, 19 Nov 2011, Reinier Olislagers wrote: >>>> On 19-11-2011 13:28, Reinier Olislagers wrote: I wonder >>

Re: [fpc-pascal] Re: Patch/Test BlobSegmentSize was: IBConnection blobsegmentsize irrelevant & performance

2011-11-25 Thread Reinier Olislagers
On 25-11-2011 10:07, Michael Van Canneyt wrote: > On Fri, 25 Nov 2011, Reinier Olislagers wrote: > > Database patches by default get assigned to Joost, and Joost is busy. > I'll have a look at it. You can always directly assign bugs to me if > we've discussed them here

Re: [fpc-pascal] Re: Patch/Test BlobSegmentSize was: IBConnection blobsegmentsize irrelevant & performance

2011-11-26 Thread Reinier Olislagers
On 25-11-2011 10:21, Michael Van Canneyt wrote: > On Fri, 25 Nov 2011, Reinier Olislagers wrote: >> On 25-11-2011 10:07, Michael Van Canneyt wrote: >>> Sometime in the now misty past, Michael Van Canneyt wrote: >>> Database patches by default get assigned to Joost, and J

[fpc-pascal] Latest bootstrap compilers?

2012-01-06 Thread Reinier Olislagers
Hi all, I looked at ftp://ftp.freepascal.org/pub/fpc/dist/2.6.0/bootstrap/ and saw there is e.g. no i386-win32-ppc386.zip Is this intentional? The reason I'm asking: I'm writing a small SVN downloader that should download a bootstrap compiler if required and wanted to know what to get for Win32,

[fpc-pascal] Command line FPC/Lazarus SVN downloader/installer

2012-01-10 Thread Reinier Olislagers
Hi Lazarus & FPC people, I got very tired of writing Windows and Linux batch files, so I've written an FPC/Lazarus installer that allows you to keep a copy of FPC and Lazarus that it updates from SVN. This copy can live apart from a regular FPC/Lazarus install as it uses --primary-config path for

[fpc-pascal] IPTables log parser?

2012-01-19 Thread Reinier Olislagers
Hi list, I noticed ik has started a project to manipulate Linux iptables firewall rules... which got me thinking. Is there any FreePascal/Delphi code lying around to parse IPtables log output (e.g. in the /var/log/messages syslog file), e.g. into CSV format? If not, I'll probably write my own...

Re: [fpc-pascal] IPTables log parser?

2012-01-19 Thread Reinier Olislagers
On 19-1-2012 11:10, Mark Morgan Lloyd wrote: > Reinier Olislagers wrote: >> Hi list, >> >> I noticed ik has started a project to manipulate Linux iptables firewall >> rules... which got me thinking. >> >> Is there any FreePascal/Delphi code lying around to pa

[fpc-pascal] iptableslogparser released was Re: IPTables log parser?

2012-01-23 Thread Reinier Olislagers
On 19-1-2012 10:51, ik wrote: > On Thu, Jan 19, 2012 at 11:37, Reinier Olislagers > mailto:reinierolislag...@gmail.com>> wrote: > I noticed ik has started a project to manipulate Linux iptables firewall > rules... which got me thinking. > > Is there any Free

[fpc-pascal] Request for Win32 bootstrap compiler on ftp.freepascal.org/

2012-01-27 Thread Reinier Olislagers
Hi list, On ftp://ftp.freepascal.org/pub/fpc/dist/2.6.0/bootstrap/ there are a lot of bootstrap compilers, but I miss a x86 Windows bootstrap compiler. Would it be possible to upload one, or can I use the 2.4.2 compiler to compile FPC 2.6.x/2.7.x sources on Windows? Thanks, Reinier _

Re: [fpc-pascal] Request for Win32 bootstrap compiler on ftp.freepascal.org/

2012-01-27 Thread Reinier Olislagers
On 27-1-2012 13:01, Marco van de Voort wrote: > In our previous episode, Reinier Olislagers said: >> On ftp://ftp.freepascal.org/pub/fpc/dist/2.6.0/bootstrap/ there are a >> lot of bootstrap compilers, but I miss a x86 Windows bootstrap compiler. > > It is the responsib

Re: [fpc-pascal] Request for Win32 bootstrap compiler on ftp.freepascal.org/

2012-01-27 Thread Reinier Olislagers
On 27-1-2012 13:22, Marco van de Voort wrote: > In our previous episode, Reinier Olislagers said: >>> It is the responsibility of the platform maintainers to upload that. >>> >>> That being said, for windows it makes less sense than for other platforms, >&

Re: [fpc-pascal] Request for Win32 bootstrap compiler on ftp.freepascal.org/

2012-01-27 Thread Reinier Olislagers
On 27-1-2012 13:33, Marco van de Voort wrote: > In our previous episode, Reinier Olislagers said: >> That's what I suspected. So when building a Win32 system from scratch, >> I'd have to either extract the files from the installer or perhaps get >> them fro

Re: [fpc-pascal] Request for Win32 bootstrap compiler on ftp.freepascal.org/

2012-01-27 Thread Reinier Olislagers
On 27-1-2012 14:00, Marco van de Voort wrote: > In our previous episode, Reinier Olislagers said: >>> >>> No, tags/release_2_6_0 would then be the one. What is currently already in >>> fixed could theoretically already have been changed for 2.6.2 >>> >&g

[fpc-pascal] Poor man's resource code available and CheckRide update: now with editor

2012-01-30 Thread Reinier Olislagers
Hi all, (Cross posted to Lazarus+FPC lists) Thanks to UPayload (http://www.delphidabbler.com/articles?article=7) and some help on the forum, I could implement an alternative way of storing files in an executable file (basically it just appends them with a footer). See source: poormansresource.pas

<    1   2   3   4   5   6   7   8   >