delete selected cell from data base SQL

1 次查看（过去 30 天）

Cristian Martin 2022-6-11

评论： Cristian Martin 2022-6-11

Hi, I have a uitable GUI loaded from an SQL DB and I want to select a row from table and delete also from SQL DB, could you give me a direction ?

D=get(handles.uitable4,'Data');

Index=get(handles.uitable4,'UserData');

D(Index.Indices(:,1), :) = [];

set(handles.uitable4,'Data',D);% here a delete the row only from uitable

conn = database('data_base', '', '');

curs = exec(conn, 'SELECT * FROM prices.prices order by Crt desc');

curs = fetch(curs);

close(curs);

I use R2015a.

Thanks

Cristian Martin 2022-6-11

function uitable1_CellSelectionCallback(hObject, eventdata, handles)

% hObject handle to uitable1 (see GCBO)

% eventdata structure with the following fields (see MATLAB.UI.CONTROL.TABLE)

% Indices: row and column indices of the cell(s) currently selecteds

% handles structure with handles and user data (see GUIDATA)

handles = guidata(uitable1);

data = get(uitable1, 'Data');

index = Event.Indices;

set(handles.text15, sprintf('%g', data(index(1), index(2))));

I'm trying to get value from cell selected but somewere i'm wrong, where?

MATLAB Language Fundamentals Data Types Data Type Identification Whos

在 Help Center 和 File Exchange 中查找有关 Whos 的更多信息

R2015a

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

Translated by