Hi, you are right, afaik triggers on select are not supported. I would define a function, read the data i need from the hardware inside the function and return it.
See http://www.sqlite.org/capi3ref.html#sqlite3_create_function select MyField, GetHardwareSerialNumber() from MyTable Martin Spitzer, Thomas wrote: > Hello, > > As already said, we plan to use the sqlite for the parameters of an > embedded system. > Triggers shall be used, to write the changes do the hardware drivers, > wherever necessary. > > Among the whole paramitration there are some "parameters" which are > actually reads to specific hardware addresses. > There are only a few of them, but it would be nice to read back things > like "serialnumber" direct from the hardware, instead of writing them to > the database file only. > A "Trigger on select" would be the solution, but when I understand the > manual correct, this is not supported. > > Questions: > 1. Is it correct, that triggers on reading values (select) are not > supported? > 2. Any idea, for a workaround? > > Rgds, > Thomas > > Hottinger Baldwin Messtechnik GmbH, Im Tiefen See 45, 64293 Darmstadt, > Germany | www.hbm.com > > Registered as GmbH (German limited liability corporation) in the commercial > register at the local court of Darmstadt, HRB 1147 > Company domiciled in Darmstadt | CEO: Andreas Huellhorst | Chairman of the > board: James Charles Webster > > Als Gesellschaft mit beschraenkter Haftung eingetragen im Handelsregister des > Amtsgerichts Darmstadt unter HRB 1147 > Sitz der Gesellschaft: Darmstadt | Geschaeftsfuehrung: Andreas Huellhorst | > Aufsichtsratsvorsitzender: James Charles Webster > > The information in this email is confidential. It is intended solely for the > addressee. If you are not the intended recipient, please let me know and > delete this email. > > Die in dieser E-Mail enthaltene Information ist vertraulich und lediglich fur > den Empfaenger bestimmt. Sollten Sie nicht der eigentliche Empfaenger sein, > informieren Sie mich bitte kurz und loeschen diese E-Mail. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
