Ok. Thanks.
Now, I have to find Service Packs.
at www.progress.com they want me to write sales number. I know only serial.
For this reason I can't download any pack from progress.com.
Could you write me email if you know where I can download service pack
Error:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210051
[JDBC Progress Driver]:Internal error -1214 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmSeqGetID called from seq_get_seq_id on for . Save log for Progress technical support.
It seems, there is no sequence at...
I think my database has a problem.
I tested sports, sports2000 databases. They works fine!
I can get sequence last value.
What is the problem about my database?
I am really sory.
I created new sequence which name is test.
with procedure editor
SELECT CURRENT-VALUE(test) AS fld FROM TableName
works
But with SQL Explorer (connect over TCP, port)
select pub.test.currval from Pub.TableName
doesn't work.
Any ideas?
Service pack problem...
Thanks
My sequence name: sequence-name
Select PUB.sequence-name.CURRVAL As fld FROM Pub.table_name
I am getting this error:
=== SQL Exception 1 ===
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
Select PUB."sequence-name".CURRVAL As fld FROM...
Hi.
I want to learn how to reach CURRENT-VALUE FUNCTION from sql explorer tool.
I can get the value by using
SELECT CURRENT-VALUE(sequence_name) FROM table_name
in procedure editor.
But I want to get this value from SQL Explorer Tool. (So, I am going to use linked server)
I tried...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.