[Hai Nguyen]

Hello Rob,
We were late to register for this event as it’s closed. Is it possible if we can participate the Cloverleaf sessions on Tuesday 5/21 only?
Hope can see you, colleagues, and the Infor team at the event.
Thank you,
…hai
nguyen.hai@mayo.edu

[Hai Nguyen]

Great! looking forward using Cloverleaf engine to implement FHIR.

Thanks Jim and Ron.

[Hai Nguyen]

Same here Jim, I downloaded all resources from FHIR website, and tried to compile their .xsd files in Cloverleaf XML manger, it failed.

[Hai Nguyen]

Only sqlite3 installed on my box:

$ which sqlite3

/hci/qdx5.7/integrator/tcl/bin/sqlite3

$ which sqlite

/usr/bin/which: no sqlite in (/hci/qdx5.7/integrator/…)

I have to wait until our current 5.7 upgrading to CLV version 6 then  😛

Thank you all for your help and check!

[Hai Nguyen]

Thanks for quick response and suggestion Kevin.

I got the same error with both log-in sessions Unix and Cloverleaf user, and there is only “sqlite3” on both sessions.

### Logged in as an Unix user:

$ which sqlite

which: no sqlite in (/bin:/usr/bin:/usr/ucb:/etc:/opt/sfw/bin:/hci:/hci/bin:/hci/kshlib:/usr/local/bin:.)

$ which sqlite3

/usr/bin/sqlite3

$ sqlite3 foo

SQLite version 3.3.6

Enter “.help” for instructions

sqlite> create virtual table bar using fts3;

SQL error: near “virtual”: syntax error

### Logged in as a Cloverleaf user:

$ which sqlite

/usr/bin/which: no sqlite in (/hci/qdx5.7/integrator/…)

$ which sqlite3

/hci/qdx5.7/integrator/tcl/bin/sqlite3

$ sqlite3 foo

SQLite version 3.6.4

Enter “.help” for instructions

Enter SQL statements terminated with a “;”

sqlite> create virtual table bar using fts3;

SQL error: no such module: fts3

My Linux version is:

Red Hat Enterprise Linux Server release 5.9 (Tikanga)

Kernel 2.6.18-348.3.1.el5 on an x86_64

[Hai Nguyen]

Hello,

Yup, I learn the fts feature from https://www.sqlite.org/fts3.html#section_1_2 🙂 and like to try it out.

I have no luck following Charlie’s and Kevin’s suggestion, I always use command “sqlite3” for SQLite.

$ sqlite3 test.db

SQLite version 3.6.4

Enter “.help” for instructions

Enter SQL statements terminated with a “;”

sqlite> CREATE VIRTUAL TABLE docs USING fts3(title, body);

SQL error: no such module: fts3

sqlite> .q

$ sqlite3 foo

SQLite version 3.6.4

Enter “.help” for instructions

Enter SQL statements terminated with a “;”

sqlite> create virtual table bar using fts3;

SQL error: no such module: fts3

sqlite> .q

Max, I have SQLite version 3.6.4, which is embedded in our CLV 5.7. Don’t know why it works for Charlie on the same version with mine.

[Author]

Replies