Hi Ben,
If you want to execute XQuery expressions, the XQUERY should do the job.
I agree that the error output is somewhat confusing. This is just a guess, but maybe it indicates that there is still a little bug in the R client? Did you compare the behavior with any other of our clients?
Cheers, Christian
On Fri, Jun 8, 2018 at 10:15 AM Ben Engbers Ben.Engbers@be-logical.nl wrote:
Hi,
I want to use my R-client to insert csv in a database.
These lines works:
csv_add_run <- 'RUN "./DataScience/RBaseX/CSVexample.xq"' Session$command(csv_add_run)
When I take the content from CSVexample.xq and incorporate that into a EXECUTE command, I get this:
csv_add_exe <- 'EXECUTE "let $root := '/home/bengbers/DataScience/RBaseX/Examples/Parse/;)'; for $path in file:children($root)[ends-with(., '.csv')] return db:add('CSV_test', $path, 'CSV_API', map { 'parser': 'csv', 'csvparser': map { 'header': 'yes', 'separator': ';' }) "'
Session$command(csv_add_exe)
Stopped at , 1/9: Unknown command: 'EXECUTE. Did you mean 'EXECUTE'?
My question is how to define the input for the EXECUTE-command?
Cheers, Ben