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

Reinier Olislagers reinierolislagers at gmail.com
Sat Aug 6 19:56:20 CEST 2011


On 6-8-2011 19:28, Ludo Brands wrote:
>> After my recent adventures with LazUpdater, back to the XML export.
>>
>> I've written new tests with more data types that at least 
>> produce test output now.
>>
> 
> Problems so far:
> 
> TClientDataSet:
> - ftWideString has zero length by default: Delphi 6 returns invalid
> parameter for WIDTH="0" when opening the tclientdataset. Added FieldDef.Size
> := 255; for ftWideString field definition; 

Ok, should be easy.
> 
> -Access 2000:
> - access doesn't accept the empty value for ftAutoInc. TAutoIncField is read
> only and BufDataSet doesn't do anything with autoincrement fields. Better
> drop it from the test.
Ok, but it should recognize its own version of an autoinc (autonumber I
think it's called. I'll have a look.)
> - access falls over the guid not being a real guid. It aborts reading the
> remainder of the line because dataset not in edit/insert mode anymore ...
> Guid has to be a string of the form {9F5FBC24-EFE2-4f90-B498-EC0FB7D47D15}
Yep.
> - ftWideString creates sometimes non ascii characters at the end. This is
> not the case for TClientDataSet. Still looking in that one; 
Ok.
> - the year 0001 is imported as 2001. Also manually you can't enter the year
> 0001 in access 2002. It always becomes 2001. 
Yeah, I had complaints with Excel as well ;)
> 
> Ludo

Thanks Ludo,

I'll put them on my list...

Regards,
Reinier



More information about the fpc-pascal mailing list