cancel
Showing results for 
Search instead for 
Did you mean: 

Capstone Fundamental Ex 1.5

pravigak
New Contributor

refServiceHandle: hopen `::5010
**1.5 Using the handle `refServiceHandle` and the `uniqueOpts` variable we created before, call the
`getOptionRef` API and retrieve the associated Options Reference data. Store the returned table
in a variable `optRef`.**

optRef: refServiceHandle(`getOptionRef;uniqueOpts)

Using this line of code is not working. IPC says blocked. How do I fix it?

1 ACCEPTED SOLUTION

megan_mcp
Community Manager Community Manager
Community Manager

@pravigak 

I notice for your uniqueOpts variable you've declared it as:

uniqueOpts: enlist (select distinct option_id from trade)

 Tables are created out of lists, so by enlisting the option_id column you are creating a list of a list.

Since we already have our list, we just want to convert this into a list format. To do this you can use the exec  keyword. 

Once you've edited this, it should work fine.

Thanks,

Megan

View solution in original post

5 REPLIES 5

megan_mcp
Community Manager Community Manager
Community Manager

Hi @pravigak!

Can you try 

refServiceHandle: hopen 5010;

instead of 

refServiceHandle: hopen `::5010

Let me know if this works,

Megan 🙂

Hi @megan_mcp 

It still says its blocked unfortunately. 

Praviga. 

megan_mcp
Community Manager Community Manager
Community Manager

@pravigak can you download your notebook and send it to me so I can take a closer look?

You can dm me on here or email me (mmcparland@kx.com).

Thanks,

Megan

megan_mcp
Community Manager Community Manager
Community Manager

@pravigak 

I notice for your uniqueOpts variable you've declared it as:

uniqueOpts: enlist (select distinct option_id from trade)

 Tables are created out of lists, so by enlisting the option_id column you are creating a list of a list.

Since we already have our list, we just want to convert this into a list format. To do this you can use the exec  keyword. 

Once you've edited this, it should work fine.

Thanks,

Megan

Thanks Megan! It's working for me now! 🙂