Prev: digital image processing
Next: sending and receiving data in matlab using UDP object
From: lee ?? on 3 Dec 2009 00:20
function popupmenu1_Callback(hObject, eventdata, handles)
popupmenu_id_str = get(hObject,'string');
popupmenu_id_index = get(hObject,'value');
set_id = deblank(popupmenu_id_str(popupmenu_id_index,:));

function popupmenu1_CreateFcn(hObject, eventdata, handles)
if ispc && isequal(get(hObject,'BackgroundColor'), get(0,'defaultUicontrolBackgroundColor'))
set(hObject,'BackgroundColor','white');
end
conn = database ('orcl','scott','tiger','oracle.jdbc.driver.OracleDriver',...
'jdbc:oracle:thin:@***.***.***.***:1521:');
distinct_query = 'select no from test';
distinct = exec(conn, distinct_query);
setdbprefs('DataReturnFormat','structure');
[id] = fetch(distinct);
id_result = [id];
id_result.Data;
ans.NO;
name_list = {'Name'; str2mat(ans)};
set(hObject,'String',name_list);

function pushbutton1_Callback(hObject, eventdata, handles)
conn = database ('orcl','scott','tiger','oracle.jdbc.driver.OracleDriver',...
'jdbc:oracle:thin:@***.***.***.***:1521:');
update(conn, 'test', {'data'}, {'10'}, 'where no = ''????''');

======
hello~
How to change this query so that instate of the question marks i can choose the id from the function called (set_id) ?
From: lee ?? on 3 Dec 2009 01:08
sorry, data type is "no = varchar2, data = intger"
 | 
Pages: 1
Prev: digital image processing
Next: sending and receiving data in matlab using UDP object