Thread Subject: Database ToolBox Help Needed

Subject: Database ToolBox Help Needed

From: Fake Ghost

Date: 19 May, 2009 06:39:01

Message: 1 of 3

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.

Subject: Database ToolBox Help Needed

From: Nicolaie Popescu-Bodorin

Date: 19 May, 2009 11:28:02

Message: 2 of 3

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.

Subject: Database ToolBox Help Needed

From: Fake Ghost

Date: 19 May, 2009 18:04:03

Message: 3 of 3

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.

Tags for this Thread

Everyone's Tags:

Add a New Tag:

Separated by commas
Ex.: root locus, bode

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Tag Activity for This Thread
Tag Applied By Date/Time
running sql que... Nicolaie Popescu-Bodorin 19 May, 2009 07:29:07
matlab Fake Ghost 19 May, 2009 02:44:02
database Fake Ghost 19 May, 2009 02:44:02
delete row Fake Ghost 19 May, 2009 02:44:02
sql Fake Ghost 19 May, 2009 02:44:02
rssFeed for this Thread
 

MATLAB Central Terms of Use

NOTICE: Any content you submit to MATLAB Central, including personal information, is not subject to the protections which may be afforded information collected under other sections of The MathWorks, Inc. Web site. You are entirely responsible for all content that you upload, post, e-mail, transmit or otherwise make available via MATLAB Central. The MathWorks does not control the content posted by visitors to MATLAB Central and, does not guarantee the accuracy, integrity, or quality of such content. Under no circumstances will The MathWorks be liable in any way for any content not authored by The MathWorks, or any loss or damage of any kind incurred as a result of the use of any content posted, e-mailed, transmitted or otherwise made available via MATLAB Central. Read the complete Terms prior to use.

Contact us at files@mathworks.com