On 21-2-2013 12:18, Graeme Geldenhuys wrote:
On 2013-02-21 09:59, Reinier Olislagers wrote:
Is this ISO 8601 format currently the most widely used? It seems the
most sane to me.
Yes, that is the safest and most understood format.
So the JSON date wars have more or less ceased then?
Anyway
On 25-2-2013 6:34, Eric Kom wrote:
Good day,
Please what is a difference between .pp and .pas files extension?
As Ralf said: 2 letters. I have the idea .pp was used in the past to
differentiate from other Pascal compilers, while .pas is used more
commonly now.
Groete,
Reinier
On 24-2-2013 18:35, Andrew Brunner wrote:
If not, does anyone have lightning fast scaling methods in C++ or Java
that I can port/contribute?
You might want to look if e.g. ImageMagick is faster for your needs.
There's bindings for it in Pascal:
http://wiki.lazarus.freepascal.org/PascalMagick
On 25-2-2013 13:38, Michael Van Canneyt wrote:
On Mon, 25 Feb 2013, Reinier Olislagers wrote:
Say I have an fpweb CGI server with action documents registered and I
GET http://server/cgi-bin/tigercgi/documents/301/
1. How do instruct the documents action to handle that? Currently I get
a Error
Hi,
Noticed that the user changes for FPC trunk mentions UPX has been removed:
http://wiki.lazarus.freepascal.org/User_Changes_Trunk#UPX_support_has_been_removed
However, it's also mentioned in 2.6.2:
http://wiki.lazarus.freepascal.org/User_Changes_2.6.2#UPX_support_has_been_removed
Can we
On 25-2-2013 14:06, Michael Van Canneyt wrote:
On Mon, 25 Feb 2013, Reinier Olislagers wrote:
On 25-2-2013 13:38, Michael Van Canneyt wrote:
On Mon, 25 Feb 2013, Reinier Olislagers wrote:
Say I have an fpweb CGI server with action documents registered and I
GET http://server/cgi-bin
I've been looking at adding some support for bilevel (black white)
TIFF images.
I seem to have something working for uncompressed images, but I'm almost
sure that this:
procedure TFPReaderTiff.ReadImgValue(BitCount: Word; var Run: Pointer;
x: dword;
Predictor: word; var LastValue: word; out
On 26-2-2013 15:02, Reinier Olislagers wrote:
Any kind soul who wants to earn eternal glory by adding 1 bit support
for TIFF?
http://bugs.freepascal.org/view.php?id=23959
Mattias,
Thanks a lot for the quick commit!
Regards,
Reinier
___
fpc-pascal
Cryptic subject, isn't it?
I tried to modify fpreadtiff.pas by copying only that module over to a
new directory, write a test program that uses fpreadtiff, fpimage and
other units.
AFAIK from the User's Guide, 3.1.2, the fpreadtiff.pas in my program's
directory should have been found first when
Using fpweb, I'm trying to handle DELETE requests.
The code below works for GET calls:
GET /cgi-bin/tigercgi/document/ HTTP/1.1 200
but gives a 500 server error for DELETE calls:
DELETE /cgi-bin/tigercgi/document/ HTTP/1.1 500
The code doesn't even seem to hit the function:
On 28-2-2013 10:58, Reinier Olislagers wrote:
Using fpweb, I'm trying to handle DELETE requests.
The code below works for GET calls:
GET /cgi-bin/tigercgi/document/ HTTP/1.1 200
but gives a 500 server error for DELETE calls:
DELETE /cgi-bin/tigercgi/document/ HTTP/1.1 500
The code
On 28-2-2013 12:22, Michael Van Canneyt wrote:
On Thu, 28 Feb 2013, Reinier Olislagers wrote:
On 28-2-2013 10:58, Reinier Olislagers wrote:
Using fpweb, I'm trying to handle DELETE requests.
The code below works for GET calls:
GET /cgi-bin/tigercgi/document/ HTTP/1.1 200
but gives a 500
On 28-2-2013 9:24, Reinier Olislagers wrote:
The test program works (I've put in a writeln to show it's modified) but
debugging in Lazarus doesn't because it misses debug info.
1. Is what I am doing the right way?
2. Is there a problem with FPC generating no debug info/duplicate debug
info
On 2-3-2013 11:42, denisgolovan wrote:
Hi all
Currently I am trying to make work attached code under Win64.
It uses LuaJIT 2 as drop-in replacement to Lua.
The code works fine under Linux32, Linux64, Win32, but not under Win64.
Under Win64 it crashes with unhandled exception like
On 2-3-2013 15:02, Marco van de Voort wrote:
In our previous episode, denisgolovan said:
Building FPC with -dTEST_WIN64_SEH makes the trick!
Hmm, maybe it is slowly time to make this defau
Or quickly ;)
Last I heard about it was in July 2012:
Just wanted to post something nice between the ideas for improvement and
bug reports
Noticed via the commits and the fpc-devel list that the devs are adding
more Unicode support to FPC trunk.
(See e.g.
http://www.mail-archive.com/fpc-devel@lists.freepascal.org/msg28644.html)
Congratulations
On 4-3-2013 10:19, Marco van de Voort wrote:
In our previous episode, Joao Morais said:
How ftp://ftp.freepascal.org/pub/fpc/dist/2.6.2/bootstrap
like lists are built? I missed at least i386-linux and i386-win32
binaries.
They are simply the compiler binary extracted from the release in a
On 4-3-2013 10:48, Reinier Olislagers wrote:
On 4-3-2013 10:19, Marco van de Voort wrote:
It's mainly a facility for source based package systems like the *bsd ports,
where the enduser routinely bootstraps compiler + source too.
(if that is sane, is a different question, specially in FPC's
On 1-3-2013 15:03, Ebeling wrote:
I am a low-level-user, who uses fpc only occasionally for small programs
and only with 10 % of its functionality. For my purposes, the text IDE
seems to be adequate. But I stumble upon a basic functionality: the
displayed cursor-position.
When I start a
Hi list,
(Had posted this earlier on the forum)
I'm looking at some day replacing some of my own utilities written using
.net code with FPC code.
One tool extracts birthdays from a database, slaps a reminder time on it
and exports it as ical/.ics
Some searching turned up
On 2-3-2013 15:02, Marco van de Voort wrote:
In our previous episode, denisgolovan said:
Building FPC with -dTEST_WIN64_SEH makes the trick!
Hmm, maybe it is slowly time to make this default in trunk?
Uploaded a patch at
http://bugs.freepascal.org/view.php?id=24012
Please have a look,
Sergei Gorelkin enabled Win64 SEH support in trunk r23732:
* Make Win64 SEH support enabled by default. If necessary to disable,
compiler should be cycled with OPT=-dDISABLE_WIN64_SEH. Mantis #24012.
Seems this fixes issues on Win64 with e.g. embedded Firebird dlls, and
I'm sure many other DLLs.
On 9-3-2013 13:51, Florian Klaempfl wrote:
Am 09.03.2013 08:49, schrieb Reinier Olislagers:
Sergei Gorelkin enabled Win64 SEH support in trunk r23732:
* Make Win64 SEH support enabled by default. If necessary to disable,
compiler should be cycled with OPT=-dDISABLE_WIN64_SEH. Mantis #24012
On 9-3-2013 17:31, Mark Morgan Lloyd wrote:
Tony Whyman wrote:
Mark,
I did something like this a few years ago and the Services API is your
friend - but it is not standard SQL...
[Nod] I suspect that the key is the way that Firebird documents various
activities as differing subsets of
On 9-3-2013 19:56, Mark Morgan Lloyd wrote:
Reinier Olislagers wrote:
On 9-3-2013 17:31, Mark Morgan Lloyd wrote:
It identifies itself as 2.5, and by that I explicitly mean that I'm
querying it rather than trusting any claims by the Debian package
maintainer, and according
On 10-3-2013 11:21, Mark Morgan Lloyd wrote:
reinierolislagers-re5jqeeqqe8avxtiumw...@public.gmane.org wrote:
On 9-3-2013 14:08, Mark Morgan Lloyd wrote:
I don't know whether anybody can help me with this one, but I'm working
on something where I need a program to be able to create
On 10-3-2013 11:26, Jonas Maebe wrote:
On 10 Mar 2013, at 11:21, Mark Morgan Lloyd wrote:
reinierolislagers-re5jqeeqqe8avxtiumw...@public.gmane.org
mailto:reinierolislagers-re5jqeeqqe8avxtiumw...@public.gmane.org wrote:
Have you tried the Firebird admin module that Ludo Brands wrote? It
On 10-3-2013 12:03, Mark Morgan Lloyd wrote:
Reinier Olislagers wrote:
On 9-3-2013 19:56, Mark Morgan Lloyd wrote:
Reinier Olislagers wrote:
On 9-3-2013 17:31, Mark Morgan Lloyd wrote:
Well...
Background: Create user via SQL:
http://www.firebirdsql.org/refdocs/langrefupd25-security-sql-user
On 9-3-2013 14:08, Mark Morgan Lloyd wrote:
I don't know whether anybody can help me with this one, but I'm working
on something where I need a program to be able to create login-capable
database users on-the-fly. I was hoping to be able to use either
PostgreSQL or Firebird as the backend, but
On 10-3-2013 21:56, Mark Morgan Lloyd wrote:
Reinier Olislagers wrote:
I've written a demo application that:
uses regular TIBConnection and SQL commands to
1. create a new db on a server
2. create a user with GRANT ADMIN ROLE and full control over the new db
snip
Subject to a maximum user
On 11-3-2013 9:24, Mark Morgan Lloyd wrote:
Reinier Olislagers wrote:
Subject to a maximum user name length of 31 characters on Firebird. The
manual suggests that PostgreSQL has a limit of 64.
snip
True, but I thought that a detail relating to something that people were
likely to do
Hi list,
(FPC 2.6.0 or trunk)
Been fiddling a bit too long and strongly suspect PEBKAC/PICNIC (and my
seemingly perennial refusal to adapt to Object Pascal's way of dealing
with object references).
Thanks for your suggestions!
See the === marks below
var
CurrentPage: integer;
On 12-3-2013 11:44, Michael Van Canneyt wrote:
Thanks for the help, Michael.
On Tue, 12 Mar 2013, Reinier Olislagers wrote:
//=== the line below works - so CommJSON is a valid object, right?
if Assigned(CommJSON) then
It is assigned, but not necessarily valid. If you freed CommJSON
Permitting myself a small tongue-in-cheek interruption of the regular
activities on this mailing list:
Sad enough that you're almost no student anymore (presumably equals
having to do real work instead of improving FPC and incidentally
studying), but this is really going to far ;) :
On 25-2-2013 13:38, Michael Van Canneyt wrote:
On Mon, 25 Feb 2013, Reinier Olislagers wrote:
As soon as the path has more than 1 component, it is assumed that the
path is composed of
/module/action/whatever.
If - and only if - there is only 1 path component, it is assumed to be
an action
(Cross posted: FPC+Laz lists)
Hi all,
I've updated the fpcup automatic FPC+Laz installer from svn for FreeBSD.
Tested on PC BSD, (similar to FreeBSD 9 x64 but with built in x11).
A quick test showed a clean box with just fpcup will install Laz
trunk+FPC fixes_2.6 well. Of course fpcup can be
Hi all,
Looked into getting an fpcup FreeBSD x64=Linux x86 cross compiler
module going on PC-BSD 9/FreeBSD 9.1.
Although the /compat/linux library is there, it misses binutils like as,
ld etc and I presume it misses a lot of libraries, too.
Tried installing
On 17-3-2013 11:48, Graeme Geldenhuys wrote:
On 2013-03-17 08:59, Reinier Olislagers wrote:
Tried installing
/usr/ports/emulators/linux_dist-gentoo-stage3
which failed: got an error saying it was broken.
Did you do a ports update before you tried to install it? Always update
ports first
On 17-3-2013 13:38, Marco van de Voort wrote:
In our previous episode, Reinier Olislagers said:
Looked into getting an fpcup FreeBSD x64=Linux x86 cross compiler
module going on PC-BSD 9/FreeBSD 9.1.
Although the /compat/linux library is there, it misses binutils like as,
ld etc and I
The program below works fine on Windows for reading e.g. info on
explorer.exe
It fails on Linux (FPC trunk x64, compiled 2013/03/14) when testing with
explorer.exe:
Going to read version resource for /tmp/explorer.exe
An unhandled exception occurred at $00443607:
EResNotFound: Resource 1
On 20-3-2013 21:30, Michael Van Canneyt wrote:
On Wed, 20 Mar 2013, Reinier Olislagers wrote:
The program below works fine on Windows for reading e.g. info on
explorer.exe
It fails on Linux (FPC trunk x64, compiled 2013/03/14) when testing with
explorer.exe:
snip
It should work
On 21-3-2013 9:10, Michael Van Canneyt wrote:
On Thu, 21 Mar 2013, Reinier Olislagers wrote:
On 20-3-2013 21:30, Michael Van Canneyt wrote:
On Wed, 20 Mar 2013, Reinier Olislagers wrote:
The program below works fine on Windows for reading e.g. info on
explorer.exe
It fails on Linux
On 21-3-2013 2:14, S. Fisher wrote:
Not actually a hash-table, but an AvgLvlTree, which can be used the
same way. The AvgLvlTree unit comes with Lazarus; if you don't have
that, you can download avglvltree.pas here:
, 2013, 4:11 AM
On Fri, 22 Mar 2013 01:19:17 -0700
(PDT)
S. Fisher expandaf...@yahoo.com
wrote:
--- On Thu, 3/21/13, Reinier Olislagers reinierolislag...@gmail.com
wrote:
From: Reinier Olislagers reinierolislag...@gmail.com
Subject: [fpc-pascal] Re: Example: regular
expressions and hash
On 24-3-2013 12:11, Ludo Brands wrote:
On 03/24/2013 10:54 AM, Mark Morgan Lloyd wrote:
Is there any way of determining what port the client is using for an
open connection (i.e. not the 3050 at the server end)? Postgres
implements this with inet_client_port(), and I'm considering a situation
While looking at mantis 14473 I noticed that
FPC 2.6.0 writes out ANSI characters when using StrPLCopy:
StrPLCopy(
@PAfterHdrVII(PChar(Header)+SizeOf(rDbfHdr))^.LanguageDriverName[32],
ConstructLangName(FFileCodePage, lLocaleID, false),63-32);
However, FPC 2.6.2 apparently uses the widestring
On 2-4-2013 5:13, Noah Silva wrote:
Actually I think on OS X and Linux it makes sense to depend on OpenSSL,
but not for the reasons you mentioned so much as one more: Security.
That's probably why the previous poster wrote robust etc. Sounds like
security attributes to me.
If
you are using
On 2-4-2013 10:04, Noah Silva wrote:
2013/4/2 Reinier Olislagers reinierolislag...@gmail.com
mailto:reinierolislag...@gmail.com
If you feel so strongly about it, why not submit a patch that uses
OpenSSL on platforms that are sure to have it and use Silvio's native
code for others
On 2-4-2013 10:08, Mark Morgan Lloyd wrote:
Reinier Olislagers wrote:
On 2-4-2013 5:13, Noah Silva wrote:
Depends. If you're using (say) a hash function to store a token in lieu
of a password then the important thing is that this behaves consistently
across platforms and program versions
Hi lists,
Just wanted to let you know about
http://wiki.lazarus.freepascal.org/User_Changes_Trunk#TDBF_unit_deprecation_removed
Currently I'm adding test cases to dbtestframework and verifying if
other existing tests apply to the dbf units, so the dbase units can be
regression tested. New unit
On 3-4-2013 9:39, Graeme Geldenhuys wrote:
On 2013-04-03 07:09, Reinier Olislagers wrote:
Nice, thanks for that. I have plans on possibly using DBF on ARM based
systems (and adding support to tiOPF). DBF is the only server I know
that you can compile into FPC executables - no dependencies
On 5-4-2013 8:52, silvioprog wrote:
Hello,
Please see:
http://bugs.freepascal.org/view.php?id=24229
Well, I'd personnally rather would people to fix:
http://bugs.freepascal.org/view.php?id=20296
[FPC] Recent changes in dwarf crash heaptrc in lnfodwrf.pp
that's been open since 2011 and if
On 5-4-2013 14:13, Vincent Snijders wrote:
2013/4/5 Mark Morgan Lloyd
markMLl.fpc-pascal-wEaNgGkE20o7VdE/foj...@public.gmane.org
mailto:markMLl.fpc-pascal-wEaNgGkE20o7VdE/foj...@public.gmane.org
I agree, Google completely overlooked it when I was searching last
night. I don't see
On 8-4-2013 8:25, Martin Schreiber wrote:
On Sunday 07 April 2013 04:10:18 reinierolislag...@gmail.com wrote:
I'd recommend Graeme's version as well - for one it has increased BLOB
writing speed due to a fix that also went into sqldb (but AFAIK not into
msegui).
Do you refer to the
As a certified high-level coder with a fear for anything that smells
like pointers and bits I hesitated to post this as the answer may well
be: figure it out yourself, it's obvious ;)... but at least it's worth a
laugh to you bitpushers out there.
Have mercy ;)
Going through the dbase code, I
On 12-4-2013 12:01, Ludo Brands wrote:
On 04/12/2013 11:47 AM, Reinier Olislagers wrote:
if (FNullField nil) and (Dst = nil) and (AFieldDef.NullPosition =
0) then
begin
Src := PChar(Src) + FNullField.Offset + (AFieldDef.NullPosition shr 3);
Result := (PByte(Src)^ and (1 shl
Hi FPC Lazarus lists,
I've been working on the tdbf code.
It had rudimentary support for both Visual Foxpro and older Foxpro file
formats, but mixed them up a bit.
I split out the distinction so you can specify either foxpro tablelevel
(25) or Visual Foxpro (30). Just like the original code
On 14-4-2013 20:23, Norbert Saint Georges wrote:
Reinier thank you.
Or can I find sources?
Norbert
Bonjour Norbert,
In FPC trunk/development version/2.7.1 (however you want to call it) ;)
___
fpc-pascal maillist -
Just uploaded a new version of fpcup (automatic FPC+Lazarus svn
downloader/installer for both stable and trunk) at
https://bitbucket.org/reiniero/fpcup/downloads
I welcome feedback from FreeBSD users - the binary should work on
FreeBSD 9 x64...
For the Lazarus installation part, it picks up
Hi all,
(FPC 2.6.2 x86, trunk x64, on Windows; found similar behaviour on Linux x64)
Busy getting DBase III memo support correct ;)
In fcl-db\src\dbase\dbf_common.pas we find this part used to e.g. find
end of file ($1A/ASCII 26) markers in a buffer with memo data: [1]
The problem is: the
On 18-4-2013 8:14, Jeppe Græsdal Johansen wrote:
Den 18-04-2013 07:57, Reinier Olislagers skrev:
In fcl-db\src\dbase\dbf_common.pas we find this part used to e.g. find
end of file ($1A/ASCII 26) markers in a buffer with memo data: [1]
The problem is: the first MemScan function doesn't work
On 19-4-2013 9:26, Toru Takubo wrote:
With analogical thinking, I expected that the following might work
for TSQLQuery in FPC:
var
r,i: Integer;
DBQ: TSQLQuery;
begin
...
DBQ.SQL.Text:='IncValue :@Param';
DBQ.Params.CreateParam(ftInteger,'@RETURN_VALUE',ptResult);
On 20-4-2013 5:01, Toru Takubo wrote:
(2013/04/19 18:53), Reinier Olislagers wrote:
On 19-4-2013 9:26, Toru Takubo wrote:
With analogical thinking, I expected that the following might work
for TSQLQuery in FPC:
var
r,i: Integer;
DBQ: TSQLQuery;
begin
...
DBQ.SQL.Text
On 21-4-2013 19:54, Mark Morgan Lloyd wrote:
Reinier Olislagers wrote:
See this forum thread:
http://lazarus.freepascal.org/index.php/topic,20664.msg119960.html#msg119960
Forum user ocye got mipsel binaries, but the ELF flags apparently need
to be changed due to a bug in older Linux kernels
On 22-4-2013 10:06, LacaK wrote:
Toru Takubo wrote / napísal(a):
2. TSQLQuery (or TMSSQLConnection) does not support OUTPUT parameter.
TMSSQLConnection does not support handling of return status and output
parameters of stored procedures
Theoretically it can be added, but it will complicate
Noticed that an 8086 branch was merged to fpc trunk. Is it time to get
out some 5.25 diskettes[1]?
[1] Shame I dumped all the accompanying hardware long ago ;) Perhaps
break out DOSBOX ;)
___
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
On 29-4-2013 11:50, Lukasz Sokol wrote:
On 27/04/2013 16:06, silvioprog wrote:
2013/4/27 Sven Barth pascaldragon-gM/ye1e23mwn+bqq9rb...@public.gmane.org
mailto:pascaldragon-gM/ye1e23mwn+bqq9rb...@public.gmane.org
On 26.04.2013 21:38, silvioprog wrote:
Oopppss, sorry. I'll delete it.
On 29-4-2013 14:10, Lukasz Sokol wrote:
On 29/04/2013 11:04, Reinier Olislagers wrote:
On 29-4-2013 11:50, Lukasz Sokol wrote:
On 27/04/2013 16:06, silvioprog wrote:
2013/4/27 Sven Barth pascaldragon-gM/ye1e23mwn+bqq9rb...@public.gmane.org
mailto:pascaldragon-gM/ye1e23mwn+bqq9rb
On 29-4-2013 14:41, Jonas Maebe wrote:
On 29 Apr 2013, at 14:12, Reinier Olislagers wrote:
I understand, but the problematic part was an upload to a third party
site which has been deleted long since. So even browsing gmane/other
archives, there's nothing left to see...
He also posted
On 10-5-2013 14:15, Dennis Poon wrote:
snip
Any one has any idea?
When opening a new thread, please do not respond to an existing thread.
Write a new message to the list to start a new thread.
___
fpc-pascal maillist -
On
http://www.freepascal.org/docs-html/
I find
FCL (Free Class Library) reference manual.
however the doc itself (and the 2.6 PDF) specifies Free Component Library
Could this be changed on the site? Does this need to be changed in
Lazarus default online help settings as well?
Thanks,
Reinier
Hi all,
I'd really like to use fields that contain carriage returns and line
feeds in SDFDataset, so I've written a patch for SDFDataset as well as a
test.
I'd appreciate it if someone could look at hopefully implement
http://bugs.freepascal.org/view.php?id=17285
This will help people that
On 22-7-2011 14:01, Michael Van Canneyt wrote:
On Fri, 22 Jul 2011, Reinier Olislagers wrote:
multiline entreaty
I will look at the patch.
Dankjewel, Michael!
PS: Shameless plug: Now working on fcl-db export to Unicode XML with XSD
support for better interoperability with .Net (ADO.NET
On 22-7-2011 14:01, Michael Van Canneyt wrote:
On Fri, 22 Jul 2011, Reinier Olislagers wrote:
snip
BigChimp
PS: Shameless plug: Now working on fcl-db export to Unicode XML with XSD
support for better interoperability with .Net (ADO.NET) and Microsoft
Access...
I will be glad to see your
On 23-7-2011 12:23, Ludo Brands wrote:
Hi Ludo,
Thanks for the help.
TDOMDocument.CreateTextNode expects a DOMString which is WideString. The
windows string to unicode conversion assumes the string is ansi.
Use:
FOutputDoc.CreateTextNode(UTF8Decode(EF.Field.AsString));
UTF8Decode would go
Sorry, didn't realise Ludo had sent his replies to the list as well.
Summary and item for discussion below:
On 23-7-2011 13:38, Ludo Brands wrote:
-Message d'origine-
De : Ludo Brands [mailto:ludo.bra...@free.fr]
Regel 4: nameOnbekende eigenschap
snip helpful corrections
On 23-7-2011 14:06, Ludo Brands wrote:
The decimal point needs also to be localised ;(
Actually, I might just leave it in US format as a . - this
will at least fix the format and allow import by
US/Anglophone countries. What do you think? (Better yet, I'll
have a look at how newer versions
On 23-7-2011 14:40, Ludo Brands wrote:
DecimalSeparator is set to the system value in Sysutils and
correspond
to the machines localisation. You shouldn't hardcode it.
Well, I want to have the same output regardless of which
locale you're in. (Unless there's a really good reason not to
do
On 23-7-2011 14:40, Ludo Brands wrote:
DecimalSeparator is set to the system value in Sysutils and
correspond
to the machines localisation. You shouldn't hardcode it.
Well, I want to have the same output regardless of which
locale you're in. (Unless there's a really good reason not to
do
Hi all,
I'm busy with writing an XML export unit targeting Microsoft Access/.Net
framework (ADO.NET data access framework in particular).
Runing an ADO.NET demo program I found out that the ADO.NET variant
requires timezone info in its date/time fields.
In a sample export I did, it is set to my
Hi all,
I'm busy with writing an XML export unit targeting Microsoft Access/.Net
framework (ADO.NET data access framework in particular).
Runing an ADO.NET demo program I found out that the ADO.NET variant
requires timezone info in its date/time fields.
In a sample export I did, it is set to my
Hi list,
I'm writing XML export for datasets using the XMLWrite and DOM units (as
per documentation at http://wiki.lazarus.freepascal.org/XML_Tutorial)
I've got this snippet:
FOutputDoc := TXMLDocument.Create;
How do I change the first line of the generated XML output from
?xml version=1.0
to
On 24-7-2011 12:49, Michael Van Canneyt wrote:
On Sun, 24 Jul 2011, Reinier Olislagers wrote:
?xml version=1.0 standalone=yes?
I tried adding an attribute like this:
TDOMElement(FOutputDoc.DocumentElement).SetAttribute(
'standalone', UTF8Decode('yes'));
but that gave an access
On 25-7-2011 10:50, Ludo Brands wrote:
1. Is there any way of knowing what kind of timezone a
datetime value
should be in a FPC dataset? (I suppose not...)
No, there is no way. It's always supposed to be 'local time'.
That is also what most of the underlying databases do. They store
On 25-7-2011 11:21, Reinier Olislagers wrote:
On 25-7-2011 10:50, Ludo Brands wrote:
1. Is there any way of knowing what kind of timezone a
datetime value
should be in a FPC dataset? (I suppose not...)
No, there is no way. It's always supposed to be 'local time'.
That is also what most
On 25-7-2011 12:09, Mark Morgan Lloyd wrote:
Pretty much the same for PostgreSQL. I went through all this a few
months ago, and while I didn't explore data entry I found that for data
output I had to apply corrections myself although I could get properties
of the current timezone from an
On 25-7-2011 11:51, Ludo Brands wrote:
Runing an ADO.NET demo program I found out that the ADO.NET
variant requires timezone info in its date/time fields. In a
sample export I did, it is set to my timezone (UTC+2 at this moment).
ADO.NET exports timezones but it isn't required for import.
On 25-7-2011 11:57, Ludo Brands wrote:
That is also what most of the underlying databases do. They store
everything in UTC and convert to local time. Only for those that
support timezoned field types (fe. oracle timestamp_TZ) you can
specify a timezone when entering data. MySQL fe. doesn't
On 25-7-2011 13:31, Ludo Brands wrote:
So you're saying that this:
ADateTime2011-07-22T15:00:00+02:00/ADateTime
can be simplified to this: ADateTime2011-07-22T15:00:00/ADateTime
?
It does. It uses TZ to convert if specified but assumes local time if not
specified. Tested this when importing
On 25-7-2011 17:37, Ludo Brands wrote:
I did see one improvement in your 2010 export: descending
indexes are supported as opposed to Access XP I'll tweak
the format to spit that out see if Access XP can read it...
Still to do...
Tested the creation of index info from MySQL SQLQuery
On 25-7-2011 18:23, Jürgen Hestermann wrote:
Reinier Olislagers schrieb:
...
If so, I'll try and get timezone description from the OS...
Timezone information is not enough to get reliable dates. Dependend on
where dates origin from they can be wrong (wrong clock on computer,
wrong time zone
On 25-7-2011 21:48, José Mejuto wrote:
Hello FPC-Pascal,
Monday, July 25, 2011, 12:54:13 PM, you wrote:
RO Correct. Would you happen to have some cross platform code readily
RO available that spits out either:
RO 1. Offset from UTC for a certain (historical or future) date/time
RO 2.
You don't even let me sleep... ;)
Thanks, Ludo. Applied in mercurial commit 48 2af395d3102c
Some questions:
1: newb alert: if I do patch -i xmlxsd.diff.txt fpxmlxsdexport.pp
I get
patching file `fpxmlxsdexport.pp'
patch: `' expected at line 12 of patch
Maybe some kind of line ending issue?
On 26-7-2011 10:42, Ludo Brands wrote:
Thanks, Ludo. Applied in mercurial commit 48 2af395d3102c
The patch was improved in a later message...
You're right. Did a cut and paste from a few lines below and didn't pay
attention to the double convert.
Ludo
As per mercurial commit 52:
Hi list ( Michael Van Canneyt ;),
Earlier I announced I was writing another XML export module for FCL-DB.
After some interesting hours with Excel, Access, .Net and FreePascal,
and thanks to Ludo Brands for testing and bugfixes, it seems the work is
done.
What is it: an FCL-DB export module that
On 27-7-2011 12:26, michael.vancann...@wisa.be wrote:
On Wed, 27 Jul 2011, Reinier Olislagers wrote:
Suggestions for additional XML export formats are welcome.
Well, I have 2 on my wishlist:
1. The format used by Delphi's TClientDataset ?
Ok, I've used that one once... so I could give
Update: includes first stab at Delphi Clientdataset. Please test with
various datatypes as I haven't been able to map all of them...
Hi list ( Michael Van Canneyt ;),
Earlier I announced I was writing another XML export module for FCL-DB.
After some interesting hours with Excel, Access, .Net
On 27-7-2011 20:49, Ludo Brands wrote:
Update: includes first stab at Delphi Clientdataset. Please
test with various datatypes as I haven't been able to map all
of them...
Some problems with Delphi Clientdataset:
-METADATA comes after ROWDATA and Delphi 2006 complains about missing
On 27-7-2011 20:52, michael.vancann...@wisa.be wrote:
On Wed, 27 Jul 2011, Reinier Olislagers wrote:
Update: includes first stab at Delphi Clientdataset. Please test with
various datatypes as I haven't been able to map all of them...
I added your implementation to SVN.
Thanks, Michael
On 28-7-2011 6:34, Reinier Olislagers wrote:
On 27-7-2011 20:49, Ludo Brands wrote:
Some problems with Delphi Clientdataset:
-Delphi has the dfXMLUTF8 and dfXML format for exporting data but no way to
specify this for reading. The difference is in the first line:
encoding=UTF-8.
Was afraid
401 - 500 of 702 matches
Mail list logo
