Problem with LineEnding in DBMemo

[ajosifoski]

Hi

I want my application to create dbf and dbt files which can be edited both in linux & windows. But have problems...

DBMemo are stored in dbt. So when edited on windows there is no problem to see how it looks like in linux. But when created/edited in linux, on windows Carriage Returns are squares.

Help?

[chrnobel]

Are you sure you are using the same character set - to me it sounds like you are using ISO-ANSI on the windows machine, and UTF-8 on the Linux.

Also you have to remember that Windows and *nix interprets newline differently, Windows normally uses CR+LF, whereas *nix only uses LF (but the CR makes no harm).

/Christian

[ajosifoski]

Well I solve problem with some coding

Code: [Select]

...
var st:string;
...
     if Dbf1.FieldValues['Question'] <> null then
     st:=Dbf1.FieldValues['Question']
     else st:=' ';
     for i:=length(st) downto 1 do
     if (st[i]=#10) and (st[i-1] <> #13) then insert(#13, st, i);
     Dbf1.FieldValues['Question']:=st; 
...

And put that code before closing application, on TForm1.OnClose event.
I use TDBF. How can I reference TDBImage from Controls with some DB. It don't have to be TDBF.
Can I make connection to OpenOffice Base .odb with Lazarus?

[ajosifoski]

I use TDBF. How can I reference TDBImage from Controls with some DB. It don't have to be TDBF.
Can I make connection to OpenOffice Base .odb with Lazarus?

Problem solved again.
Using ftBLOB when defining Dbf file. Then DBImage can be conected with it, and pictures can be put in dbt file with Dbf1.Picture.LoadFromFile