Re: [sqlite] Insert Using Tcl Array?

2010-06-22 Thread Alexey Pechnikov
You can use simple wrapper like as proc ::dataset::update {table fields} { array set info $fields foreach {key value} $fields { if {$key eq {id}} continue if {$key eq {*}} continue lappend sql_pairs $key=:info($key) }

[sqlite] Insert Using Tcl Array?

2010-05-29 Thread Ross Hayden
If SQLite can return to me a Tcl array from SELECT, why does the feature not exist to INSERT, UPDATE, or DELETE using a properly formed Tcl array as an argument? Seems nice to have, but perhaps I'm not aware of possible dangers in such a feature. Thanks. -- Ross