Re: [Virtuoso-users] Transitivity question (and crash report)

2013-12-02 Thread Quentin
Prematurely sent. The query that gets me 'almost' there is: = prefix : with SELECT * WHERE { { SELECT ?anchor ?s ?p ?o WHERE { ?anchor ?anchorPred ?s . ?s ?p

[Virtuoso-users] Transitivity question (and crash report)

2013-12-02 Thread Quentin
Assuming some data as below: prefix : with insert { a :DummyClass . :predA "Entity 1" .

[Virtuoso-users] SPARQL Transitive options - t_direction

2013-12-02 Thread Quentin
Having read through this: http://www.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSScalableInference I've been playing with sparql transitivity and it seems pretty cool so far. I'm wondering if there is any documentation on the option parameter: "t_direction"? Evidently it can be 1 or 3 but I'm

Re: [Virtuoso-users] Sql exec function documentation

2013-12-02 Thread Quentin
The error I got was: SQLState: 22023 Message: SR169: signal state should be an integer 100 (NO DATA FOUND) or a string value, not an INTEGER However it was my fault, I had overlooked the line "state := '0';" and wasn't setting the state variable to an initial value as I had assumed the '000

Re: [Virtuoso-users] Sql exec function documentation

2013-12-02 Thread Hugh Williams
Hi Quentin, The example as defined in the docs link does work (apart from minor error in variable declarations which will be corrected) : SQL> create procedure tb_is_empty (in tb varchar) { declare state, msg, descs, rows any; state := '0'; exec (sprintf ('select 1 from %s', tb), sta