Forum > Databases

Problem with TFixedFormatDataSet

(1/2) > >>

janhsh:
In a form, I place a TFixedFormatDataSet
with schema:

--- Quote ---P=18
E=17
N=24
Z=19
D=10
--- End quote ---

which corresponds to the following fixed column data file

--- Quote ---
--- Code: Text  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---1                 21               31                      41                 51        2                 22               32                      42                 52        3                 23               33                      43                 53        4                 24               34                      44                 54        5                 25               35                      45                 55        6                 26               36                      46                 56        7                 27               37                      47                 57        8                 28               38                      48                 58        9                 29               39                      49                 59        10                210              310                     410                510       11                211              311                     411                511     [/font] 
--- End quote ---

After activation, FieldDefs has 5 items that have a correct size.

So I should have a correct split of the columns of the file but instead, I have the result displayed in the image


Has anyone ever used a TFixedFormatDataSet to read data from a fixed column file?

paweld:
Set theCodePage property to 'windows-1252' and then it should work

janhsh:
It works for numeric values, but my file is originally encoded in utf-8.

So if I put text values ​​in my file, the splitting remains correct but the characters are misinterpreted

CharlyTango:
I think this has something to do with the encoding UTF8 not all letters have the length 1.

I would use a delimited format instead of the fixed format dataset and would work with TBufDataset or at least TMemDataset.

Richard Marriott:
I created the file through the IDE and everything works as expected.
As others have suggested the format of your text file is possibly not ASCII/ANSI. Try opening it in a text editor (say NotePad) to see if it is actually in fixed width format (tabular). If so TFixedFormatDataset should be able to read it. Here is a link to a website/blog that has examples of how to get all of the TDataset descendants that ship with Lazarus to work (in code and through the IDE). Maybe you can spot what the issue is there. Good luck.
https://tdataset7.wordpress.com/

Navigation

[0] Message Index

[#] Next page