Search found 11 matches

by top1
09.02.2016, 18:27
Forum: ZeosLib 7.2 Forum
Topic: why sometimes does 'last insert id' return 0
Replies: 7
Views: 2296

Re: why sometimes does 'last insert id' return 0

finally after 2 day , I nailed it by below code with zqry1 do begin sql.Clear; SQL.Add('select idi,uid,itemid from py_itens where 1=1'); Open; Insert; fieldbyname('uid').AsInteger := 1; fieldbyname('itemid').AsInteger := 188905095; Post; chklst1.Items.Add( IntToStr( fieldbyname('idi').AsInteger )) ;...
by top1
08.02.2016, 18:50
Forum: ZeosLib 7.2 Forum
Topic: why sometimes does 'last insert id' return 0
Replies: 7
Views: 2296

Re: why sometimes does 'last insert id' return 0

Do you have a example page please ?

I'm quite confused about the component i must use.

ps. i'm out of thread for awhile call direct from socket.read
by top1
08.02.2016, 02:34
Forum: ZeosLib 7.2 Forum
Topic: why sometimes does 'last insert id' return 0
Replies: 7
Views: 2296

Re: why sometimes does 'last insert id' return 0

I faced this problem again and again i have to truncate table every time for get last last_insert_id works again :evil: Edited... when AutoIncreasement reached to 59 it will be return 0 at 60 and come back work again at 100 and will be 0 again at 600 every time i try it will be like this pictures ar...
by top1
24.01.2016, 19:44
Forum: ZeosLib 7.2 Forum
Topic: why sometimes does 'last insert id' return 0
Replies: 7
Views: 2296

Re: why sometimes does 'last insert id' return 0

I'm using Delphi7 as compiler with MariaDB-10 protocal and MariaDB-10 in xampp as sql server , here below is my sql text SELF_QUERY.Close; SELF_QUERY.SQL.Clear; SELF_QUERY.SQL.Add('insert into xxx (uid, itemid, C0, tempo, DATE_RECEIVE, DATE_END) values (' + QuotedStr(inttostr(Client[i].uid)) + ',' +...
by top1
23.01.2016, 20:31
Forum: ZeosLib 7.2 Forum
Topic: why sometimes does 'last insert id' return 0
Replies: 7
Views: 2296

why sometimes does 'last insert id' return 0

As the above question
Why sometimes does last insert id retuning 0

After i call another procedure to insert , its works again after i fire the another insert by another procedure

I'm creating tzquery object every time when procedure runs with the same connection
by top1
05.01.2016, 14:48
Forum: ZeosLib 7.2 Forum
Topic: Delphi 7 Exception List index out of bound ()
Replies: 5
Views: 1076

Re: Delphi 7 Exception List index out of bound ()

i think my problem is my program can't share a component in parallel ? like tzquery or tzconnection even tzstoredproc?

do you have any suggestions for creating the game ?
by top1
04.01.2016, 14:49
Forum: ZeosLib 7.2 Forum
Topic: Delphi 7 Exception List index out of bound ()
Replies: 5
Views: 1076

Re: Delphi 7 Exception List index out of bound ()

i'm using 7.2 with lasted rev with 10.1.8-MariaDB as server

i'm implementing some game when the socket calls receivetext i 'll call new thread every time , in thread , its has own tzconnection and tzquery , create every time when thread runs, thread can run in parallel

thank you
by top1
22.12.2015, 18:35
Forum: ZeosLib 7.2 Forum
Topic: Current Snapshots ZEOS 7.1, 7.2, 7.3.
Replies: 2
Views: 3518

Re: Current Snapshots ZEOS 7.1, 7.2, 7.3.

what are differences between the version sanpshots

thank.
by top1
22.12.2015, 18:33
Forum: ZeosLib 7.2 Forum
Topic: Is this a bug for ZStoredProc ?
Replies: 1
Views: 483

Is this a bug for ZStoredProc ?

ZStoredProc by second times or more than one time, Its always show me an error ZDbcCache about ZCompitible Code Page or something similar to this , Is this a bug ?

I have to use ClearInstant to solve the problem

Have anyone has an idea for this problem ?

I'm using 7.2 last rev.

thank you.
by top1
27.11.2015, 14:47
Forum: ZeosLib 7.2 Forum
Topic: Delphi 7 Exception List index out of bound ()
Replies: 5
Views: 1076

Delphi 7 Exception List index out of bound ()

I have ZConnection and ZQuery on its own seperate thread but when the thread fires at the same time problems may occur

I find this thread http://zeoslib.sourceforge.net/viewtopic.php?t=3281

But I cant contact him for the solutions

Thanks for comments
by top1
22.11.2015, 18:13
Forum: 6.6 - stable
Topic: ZeosDBO & multithreading safely
Replies: 15
Views: 5894

Re: ZeosDBO & multithreading safely

I have the same problems

I really need an advice

thnanks