Info

This question is closed. Reopen it to edit or answer.

how to connect to database

1 view (last 30 days)
Arun Badigannavar
Arun Badigannavar on 22 Nov 2012
Closed: MATLAB Answer Bot on 20 Aug 2021
I want to connect to database with a variable name,,,,,,,,,,,,(test=database name),,,,,,,,,(a(variable)=test),,,,,,,conn=database('test','','')is the method to connect right,,,,,but i want to connect using variable name,,, conn=database('a','',''),,,,because everytimr my datase file will be selected by user,,,,
  1 Comment
Arun Badigannavar
Arun Badigannavar on 22 Nov 2012
how to perform this,,,everytime my database will be changing

Answers (1)

Titus Edelhofer
Titus Edelhofer on 22 Nov 2012
Hi,
the question is not really clear. Do you mean the following?
a = 'test'; % input from user, e.g., by GUI or input
% use the variable a as database name:
d = database(a, ...);
This works fine as long as the user passes a "known" database name ...
Titus
  3 Comments
Titus Edelhofer
Titus Edelhofer on 23 Nov 2012
The tables are specified when you read data, e.g.
tableName = 'customers';
curs = exec(['SELECT * FROM ' tableName]);
Titus
Arun Badigannavar
Arun Badigannavar on 23 Nov 2012
here table is 'customers' ,,,and u r giving it to 'tableName' right?

Tags

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!