Matlab and Access

curs = exec(conn,['delete from attendance where eid = ' '''' eid12 ''' & entry= ' '''' dt ''''])

I m trying to run the above statement but i m not getting any output. I tried executing it without putting the & sign and got an output. So there is an error in the AND operator.

Please help with the proper syntax!

Answer 1

[Leah]

It would help to have the error message but if eid12 and dt are numbers (doubles) you have to convert them to strings. Also you need to use "and" instead of "&"

curs = exec(conn,['delete from attendance where eid = ' '''' num2str(eid12) ''' and entry= ' '''' num2str(dt) ''''])

you can always test to make sure you have correctly written your queries by looking at the string on the command line, just try executing

    ['delete from attendance where eid = ' '''' eid12 ''' & entry= ' '''' dt '''']

Then try mine

['delete from attendance where eid = ' '''' num2str(eid12) ''' and entry= ' '''' num2str(dt) '''']

notice the difference

[Ankit]

hey , thanks for replying.

i found the solution. my query was correct. there was just some incompatibility in the data passed and the data type of the columns in the database.