in reply to Win32::ODBC insert question

To insert a subset of the fields in a record, you need to explicitly list the field names in the query. Try
"INSERT INTO orders (item, desc, qty, date_time, user) VALUES('$new_item','$new_desc','$new_qty','$now_time','$new_user')"