How to access database files in PreText?

[Barbara Ericson]

I tried using the datafile tag and the @add-files on program but I get an error on the build:

error: Unable to generate some datafiles:

error:  'utf-8' codec can't decode byte 0xd1 in position 31: invalid continuation byte

I am using the bikeshare.db file.

[Andrew Scholer]

Is this an activecode with language "sql"?

If so, use @database on the <program> to specify the database. Here is an example from the Sample Book:

https://runestone.academy/ns/books/published/PTXSB/activecode.html#exercise-sql-using-db

If you are trying to use some other language to work with the SQLite DB, @database does not work. If that is the case, what language are you using?

Andrew Scholer

--
You received this message because you are subscribed to the Google Groups "PreTeXt support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pretext-suppo...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/pretext-support/ba5e0444-2a40-40d0-a5e6-042172b32851n%40googlegroups.com.

[Barbara Ericson]

Thanks.  I was able to get it to work using:

 <program interactive="activecode" language="sql" database="database/bikeshare.db">

[Barbara Ericson]

Thank you.  I was able to use  program interactive="activecode" language="sql" database="database/bikeshare.db">.  That worked.  

On Monday, August 3, 2026 at 12:36:01 PM UTC-4 asch...@chemeketa.edu wrote: