Search found 11 matches
- 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 )) ;...
- 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
I'm quite confused about the component i must use.
ps. i'm out of thread for awhile call direct from socket.read
- 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...
- 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)) + ',' +...
- 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
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
- 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 ?
do you have any suggestions for creating the game ?
- 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
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
- 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.
thank.
- 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.
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.
- 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
I find this thread http://zeoslib.sourceforge.net/viewtopic.php?t=3281
But I cant contact him for the solutions
Thanks for comments
- 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
I really need an advice
thnanks