zSequence -
Posted: 15.06.2011, 18:10
Can anyone explain why zquery have zSequence.
If i have a multiple / user using db i cant do zsequnec.last id because it couldnot be that the last posted, and i cant use the Query 'insert etc ect returning id' because is visual control not supposed a mix.
How can i have the last id on a open table or zquery 'select * from atable'
I have a Table
CREATE TABLE ATABLE(
AT_ID INTEGER, -with generator/trigger of + 1
AT_NAME VARCHAR(100),
AT_SOME)
i supose that if i use the zSequence on zQuery it should get the id auto whne we insert a new line on a grid for example.
Thanks
If i have a multiple / user using db i cant do zsequnec.last id because it couldnot be that the last posted, and i cant use the Query 'insert etc ect returning id' because is visual control not supposed a mix.
How can i have the last id on a open table or zquery 'select * from atable'
I have a Table
CREATE TABLE ATABLE(
AT_ID INTEGER, -with generator/trigger of + 1
AT_NAME VARCHAR(100),
AT_SOME)
i supose that if i use the zSequence on zQuery it should get the id auto whne we insert a new line on a grid for example.
Thanks