Thread Subject: Need Matlab Code for storing and retrieving data from database

Subject: Need Matlab Code for storing and retrieving data from database

From: John

Date: 15 Nov, 2009 09:11:03

Message: 1 of 2

Hello,
  I have created a GUI which contains two buttons 'Report' and 'Calculate' and I am looking for a matlab code which stores data in a very simple database(like Ms Access or anything which is simple as possible) and retrieve it whenever i want.
For eg on pressing 'calculate' button an area is calculated using a specific formula and it is stored in a variable called 'area' and the value of this variable(area) is then stored in a database which contains a field 'Area'. On pressing the 'report' button,it should generate a report which contains a string "The Area is:"
concatenated with the value of the area retrieved from the database's field 'Area'

Subject: Need Matlab Code for storing and retrieving data from database

From: Jesper Lauridsen

Date: 15 Nov, 2009 14:48:01

Message: 2 of 2

"John " <umercis@yahoo.com> wrote in message <hdogj6$5gb$1@fred.mathworks.com>...
> Hello,
> I have created a GUI which contains two buttons 'Report' and 'Calculate' and I am looking for a matlab code which stores data in a very simple database(like Ms Access or anything which is simple as possible) and retrieve it whenever i want.
> For eg on pressing 'calculate' button an area is calculated using a specific formula and it is stored in a variable called 'area' and the value of this variable(area) is then stored in a database which contains a field 'Area'. On pressing the 'report' button,it should generate a report which contains a string "The Area is:"
> concatenated with the value of the area retrieved from the database's field 'Area'

Hello John

I am very interested in the GUI you are trying to create. I have the same gold to create a GUI where you can export and import data to matlab. I have been working on understanding the functions matlab use to export and import data. The function you have to use if you have the Database toolbox is INSERT, EXEC and UPDATE.

EXEC: Function that import data to matlab

UPDATE: Function that export data from matlab to replace values in database.

INSERT: Export data from matlab to database.

I have spending alot of time to understand the Insert function, but I have run into problem. The following threat describe my problem:

http://www.mathworks.com/matlabcentral/newsreader/view_thread/265597#693974

Maybe you have some idea how to control which row in the column you export the data is inserted to?

Best regards Jesper

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
database reporting John 15 Nov, 2009 04:14:04
rssFeed for this Thread

Contact us at files@mathworks.com