Updating MS-Access Database query

hello

i need to update my MS-Access database thru matlab.

when using the following code using function "updates" it updates the
database i.e

.......whereClause = 'where month = ''Nov'''.....

Here "Nov" is an entry in the database.

Now when i assign a variable to the months..ie variable name
"MNTH" could contain Jan /Feb etc,.....and i want to pass the
variable "MNTH" ie

.......whereClause = 'where month = ''MNTH'''.....

it DOES NOT update the database and i receive the error

.....error in horxcat....cannot convert from character to cell
array....

Why am i not being able to pass a variable name which contains the
field name to be updated in the database?

Kindly help
Thanks
Ashish
.

Relevant Pages

  • Update operation in Database
    ... i need to update my MS-Access database thru matlab. ... "MNTH" could contain Jan /Feb etc,.....and i want to pass the ... i.e. we concate the variable name with where clause. ...
    (comp.soft-sys.matlab)
  • Re: Assigning names to matrix columns (as if they were fields of a database)
    ... > field of the database. ... So, when I need to operate on mymatrix, I could use ... > mymatrix, as I currently do in Matlab. ... Try using a struct or struct array rather than an array. ...
    (comp.soft-sys.matlab)
  • Assigning names to matrix columns (as if they were fields of a database)
    ... When dealing with matrices with many columns, I find it often hard to ... manage my matrix as if it were a database, ... let's suppose that mymatrix contains data on some clients ... mymatrix, as I currently do in Matlab. ...
    (comp.soft-sys.matlab)
  • Re: MySQL JDBC
    ... I connect via the database toolbox and JDBC drivers to a ... matlab and the JDBC drivers in the same directory as the ... Matlab code. ... name on the deployed machine. ...
    (comp.soft-sys.matlab)
  • Re: Fields of a Structure
    ... This person _IS_ building a database with a hierarchical data model. ... And implementing a data store in Matlab is just stupid. ... and publisher, each row represents an entry of a book. ...
    (comp.soft-sys.matlab)