Search found 11 matches

by MacWomble
10.09.2019, 08:23
Forum: MySQL
Topic: Big problem when updating '0'-values on DB field DECIMAL(14,6)
Replies: 6
Views: 951

Re: Big problem when updating '0'-values on DB field DECIMAL(14,6)

CodeTyphon is nothing more than pre-configured Lazarus in fact CT is much more than a preconfigured Lazarus. There are many changes and extensions in the IDE. So I can understand you wont support CT but Lazarus and I try to solve my problem with PilotLogic. Thank you for your informations. There ne...
by MacWomble
09.09.2019, 22:37
Forum: MySQL
Topic: Big problem when updating '0'-values on DB field DECIMAL(14,6)
Replies: 6
Views: 951

Re: Big problem when updating '0'-values on DB field DECIMAL(14,6)

Sorry, I gave wrong information in my first post. I did not use TDBEdit. My fields are TEdit. The part of the code where the problem occure: with qryPreis do begin dsPreis.Edit; FieldByName('prs_zeit').AsFloat := StrToFloat(F.edZeit.Text); case F.cmbBruttoNetto.ItemIndex of 0: begin FieldByName('prs...
by MacWomble
08.09.2019, 12:05
Forum: MySQL
Topic: Big problem when updating '0'-values on DB field DECIMAL(14,6)
Replies: 6
Views: 951

Big problem when updating '0'-values on DB field DECIMAL(14,6)

I found a big problem with ZEOS in Source SVN Rev 5737 - SVN Rev 5894: On my form there are 4 TEdits. When I open the record I see the all stored data. There is one field with value 0. When I edit and post the field swith 0 are given empty from post. e.g. post generates UPDATE price SET price_one=1....
by MacWomble
27.08.2018, 11:32
Forum: Lazarus / Freepascal
Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
Replies: 14
Views: 4801

Re: Crash in ZEOS in TZAbstractDataset.ApplyUpdates

It's not easy to use the SVN with CodeTyphon because they renamed all files, so I reported my problems to pilotlogic now.

I use my older version of ZEOS again witch is working fine.
by MacWomble
26.08.2018, 16:44
Forum: Lazarus / Freepascal
Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
Replies: 14
Views: 4801

Re: Crash in ZEOS in TZAbstractDataset.ApplyUpdates

I tried to generate a testprogramm but: 1. I created a schema 'TEST' in mysql. I can connect with TZConnection, but I can't use TZQuery with that. TZQuery converts 'TEST' to 'test' and can't find the database. Thats definitly an error! 2. I created a new schema 'test' and can now use TZQuery wit TZC...
by MacWomble
26.08.2018, 07:24
Forum: Lazarus / Freepascal
Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
Replies: 14
Views: 4801

Re: Crash in ZEOS in TZAbstractDataset.ApplyUpdates

I found out now that the error occurs on tables where I use Mediumtext. Changing this to Varchar in the Database makes it work.

Also Tinytext, Blobs etc won't work!

This is an error in my opinion and should be corrected in ZEOS.

Regards Klaus
by MacWomble
25.08.2018, 20:07
Forum: Lazarus / Freepascal
Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
Replies: 14
Views: 4801

Re: Crash in ZEOS in TZAbstractDataset.ApplyUpdates

Sorry, the first code in the last post was wrong - so I deleted it! The error is in combination with TDBMemo. May be when using german 'Umlaute' (using UTF8-bin in MySQL) The code-part working for me is: stUnicodeStream, stAsciiStream: begin Blob := GetBlob(ColumnIndex, IsNull{%H-}); if Blob.IsClob ...
by MacWomble
25.08.2018, 18:26
Forum: Lazarus / Freepascal
Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
Replies: 14
Views: 4801

Re: Crash in ZEOS in TZAbstractDataset.ApplyUpdates

OK, found a difference:

The version witch works for me has in ZDbcCache.pas in procedure:
procedure TZRowAccessor.SetPAnsiChar(ColumnIndex: Integer; Value: PAnsichar;
Len: PNativeUInt);

Edit: See next post
by MacWomble
25.08.2018, 16:46
Forum: Lazarus / Freepascal
Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
Replies: 14
Views: 4801

Re: Crash in ZEOS in TZAbstractDataset.ApplyUpdates

OK, lets look to the facts first: I use CT Lab 6.60 and they wrote : -Update pl_ZeosDBO to Ver 6.6.2 Source SVN Rev 4943 This must be 5 days old in my opinion. - The older version SVN Rev 3942 is the last I know it works in my project. My problem occurs with newer versions and I did a screen from th...
by MacWomble
22.08.2018, 19:14
Forum: Lazarus / Freepascal
Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
Replies: 14
Views: 4801

[Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates

Hallo,

I got a big problem in ZeosDBO in all versions after Zeosdbo SVN Rev 3942.

Please have a look at http://www.lazarusforum.de/viewtopic.php?f=17&t=11738

Any tipps or hints for me?

Thank You
Klaus