Search found 11 matches
- 10.09.2019, 08:23
- Forum: MySQL
- Topic: Big problem when updating '0'-values on DB field DECIMAL(14,6)
- Replies: 6
- Views: 983
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...
- 09.09.2019, 22:37
- Forum: MySQL
- Topic: Big problem when updating '0'-values on DB field DECIMAL(14,6)
- Replies: 6
- Views: 983
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...
- 08.09.2019, 12:05
- Forum: MySQL
- Topic: Big problem when updating '0'-values on DB field DECIMAL(14,6)
- Replies: 6
- Views: 983
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....
- 28.08.2018, 10:46
- Forum: Lazarus / Freepascal
- Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
- Replies: 14
- Views: 4855
Re: Crash in ZEOS in TZAbstractDataset.ApplyUpdates
Works now with ZeosDBO_SVN_5018
- 27.08.2018, 11:32
- Forum: Lazarus / Freepascal
- Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
- Replies: 14
- Views: 4855
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.
I use my older version of ZEOS again witch is working fine.
- 26.08.2018, 16:44
- Forum: Lazarus / Freepascal
- Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
- Replies: 14
- Views: 4855
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...
- 26.08.2018, 07:24
- Forum: Lazarus / Freepascal
- Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
- Replies: 14
- Views: 4855
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
Also Tinytext, Blobs etc won't work!
This is an error in my opinion and should be corrected in ZEOS.
Regards Klaus
- 25.08.2018, 20:07
- Forum: Lazarus / Freepascal
- Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
- Replies: 14
- Views: 4855
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 ...
- 25.08.2018, 18:26
- Forum: Lazarus / Freepascal
- Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
- Replies: 14
- Views: 4855
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
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
- 25.08.2018, 16:46
- Forum: Lazarus / Freepascal
- Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
- Replies: 14
- Views: 4855
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...
- 22.08.2018, 19:14
- Forum: Lazarus / Freepascal
- Topic: [Solved] Crash in ZEOS in TZAbstractDataset.ApplyUpdates
- Replies: 14
- Views: 4855
[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
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