- This topic has 1 reply, 2 voices, and was last updated 6 years, 5 months ago by .
-
Topic
-
All, I was looking at using the hcitbllookup in a tcl script against a SQLite database. Unfortunately it is not behaving as I would expect. No matter what value I provide for the in, I never get a valid out value, it just uses the default I setup. Am I not providing the value correctly?
TCL Snippet:
Code:set computerName [lindex $fields 8]
echo “>$computerName<" echo ">[hcitbllookup Forms_Printer_Lookup $computerName]<"Table config:
Code:#
dflt_passthrough=0
dflt=NONE
dflt_encoded=false
#
out_column_name=pagePrinter
in_column_name=computerName
dbconnection=forms_printer_lookup
sqlstatement=SELECT pagePrinter FROM lookup WHERE computerName=
Database schema:
Code:CREATE TABLE lookup (computerName TEXT, pagePrinter TEXT, labelPrinter TEXT);
Viewing 0 reply threads
Viewing 0 reply threads
- The forum ‘Cloverleaf’ is closed to new topics and replies.