Need Docbasic help

Hi,

I need to read a value using a select DQL and pass 1 less than its value (value is a number) to a string variable in docbasic script (dm_event_sender.ebs).

How can I do this? Please correct the following and post it if you are an expert in docbasic script.

query_str4 = "select current_value from number_sequence where object_name='New Cust Setup Num Seq'"
colid$=dmAPIGet("readquery,c," & query_str4)
Do
ECRNum=Str(dmAPIExec("next,c," & colid$))
Print # 2, "Value: " & ECRNum
Exit Do
Loop

Please share your knowledge and experiences for figuring this out.

Thanks.

Find more posts tagged with

Documentum

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

Hartmut_Clausen

The API "next" returns only true (if there was another record in the collection) or false.

To get the actual value you have to use "get":

if dmAPIExec("next,c," & collid) then     print #2, "Value: " & dmAPIGet("get,c," & collid & ",current_value")end if

All comments

DCTM_Guru

Assuming ECRNUM is defined as int:

ECRNum=Str(dmAPIExec("next,c," & colid$))

ECRNum=ECRNum-1

athati

Thanks Johnny. I am using the following code. My DQL is working fine in DA. I get a value, but the I am not able to read the collection. I always get a value of '.

Can you please figure out what is wrong in my code?

    NumSeq="New Cust Setup Num Seq"
    query_str4 = "select current_value from number_sequence where object_name='" & NumSeq$ & "'"
    Print # 2, "DQL to get current_value: " & query_str4
       colid=dmAPIGet("readquery,c," & query_str4)
     Do
  ECRNum=Str(dmAPIExec("next,c," & colid)-1)
  Print # 2, "Value: " & ECRNum
  Exit Do
 Loop

Thanks

Hartmut_Clausen

The API "next" returns only true (if there was another record in the collection) or false.

To get the actual value you have to use "get":

if dmAPIExec("next,c," & collid) then     print #2, "Value: " & dmAPIGet("get,c," & collid & ",current_value")end if