Recent content by mtbim

  1. M

    Sql92 Current-value Function

    I got Service Pack 9.1D 009 and installed it. My problem is solved. Thanks everybody, specially Casper...
  2. M

    Sql92 Current-value Function

    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
  3. M

    Sql92 Current-value Function

    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...
  4. M

    Sql92 Current-value Function

    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?
  5. M

    Sql92 Current-value Function

    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...
  6. M

    Sql92 Current-value Function

    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...
  7. M

    Sql92 Current-value Function

    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...
Top