MATLAB Central Newsreader - Database ToolBox Help Needed

Database ToolBox Help Needed

Fake Ghost — Tue, 19 May 2009 06:39:01 -0400

hi everyone:

can anyone tell me how to delete a row of Access Database in matlab. Please.
i don't know what command matlab have for that purpose.
like to insert into database it uses "fastinsert" but what it uses for delete a row.

i want to do this in matlab.

DELETE from Employee where E_Name='Ghost'
above is SQL format. please can anyone tell me how to do this in matlab.

please help.

Re: Database ToolBox Help Needed

Nicolaie Popescu-Bodorin — Tue, 19 May 2009 11:28:02 -0400

Hello Ghost,

Try something like this:
exec(yourconnection, 'yoursqlquery')
More on this topic here:
http://www.mathworks.com/access/helpdesk_r13/help/toolbox/database/database.html

Regards,
Bodorin

"Fake Ghost" <fake.ghost007@gmail.com> wrote in message <gutk65$gjp$1@fred.mathworks.com>...
> hi everyone:
>
> can anyone tell me how to delete a row of Access Database in matlab. Please.
> i don't know what command matlab have for that purpose.
> like to insert into database it uses "fastinsert" but what it uses for delete a row.
>
> i want to do this in matlab.
>
> DELETE from Employee where E_Name='Ghost'
> above is SQL format. please can anyone tell me how to do this in matlab.
>
> please help.

Re: Database ToolBox Help Needed

Fake Ghost — Tue, 19 May 2009 18:04:03 -0400

Thanks Nicolaie.:
my problem is solved. thanks again.

"Nicolaie Popescu-Bodorin" <freeseosubmit@yah00.com> wrote in message <guu542$hhn$1@fred.mathworks.com>...
> Hello Ghost,
>
> Try something like this:
> exec(yourconnection, 'yoursqlquery')
> More on this topic here:
> http://www.mathworks.com/access/helpdesk_r13/help/toolbox/database/database.html
>
> Regards,
> Bodorin
>
>
> "Fake Ghost" <fake.ghost007@gmail.com> wrote in message <gutk65$gjp$1@fred.mathworks.com>...
> > hi everyone:
> >
> > can anyone tell me how to delete a row of Access Database in matlab. Please.
> > i don't know what command matlab have for that purpose.
> > like to insert into database it uses "fastinsert" but what it uses for delete a row.
> >
> > i want to do this in matlab.
> >
> > DELETE from Employee where E_Name='Ghost'
> > above is SQL format. please can anyone tell me how to do this in matlab.
> >
> > please help.