Backgorund

am trying execute following code dim transaction pgsqltransaction dim command new pgsqlcommand dim paramlastno pgsqlparameter = command.parameters.add("funcupdategtab03", pgsqltype.int) command.connection = myconnstr myconnstr.open() command.transaction = transaction transaction = command.connection.begintransaction() try command.commandtext = _ "select funcupdategtab03(" & sord & "," & gintacyrid & "," & gintbranchid & ");" command.executescalar() updategtab03 = paramlastno.value transaction.commit() return updategtab03 catch ex exception transaction.rollback() msgbox(ex.message, msgboxstyle.information, "rstari9 - updategtab03") catch ex exception transaction.rollback() msgbox(ex.message, msgboxstyle.information, "rstari9 - updategtab03") myconnstr.close() ...

i have application datagridview. use sqlite database , set table datasource datagridview: i'm getting dataset using sqlitedataadapter , setting datasource: grid.autogeneratecolumns = false; grid.datasource = ds.tables[0].defaultview; grid.columns["criteriaid"].datapropertyname = "rowid"; grid.columns["criterianame"].datapropertyname = "name"; grid.columns["criteriadesc"].datapropertyname = "description"; grid.columns["criteriadirection"].datapropertyname = "direction"; so far seems working want. want update datasource, replacing rows other data dataset got source. wrote: var originalds = grid.datasource dataview; var originaltable = originalds.table; originaltable.rows.clear(); foreach (datarow row in ds.tables[0].rows) { var newrow = originaltable.rows.add(); foreach (datacolumn column in ds.tables[0].columns) { object item = row[column]; var columnname = co...

this trigger , dont know whats wrong since gives me error create or replace trigger dk_enrolments_insert after insert on dk_enrolments each row declare cursor enrolment_cur(e_id dk_enrolments.enrol_id%type) select o.offer_id, a.assmnt_id dk_assessments a, dk_offerings o a.offer_id=o.offer_id , e_id=:new.enrol_id; enrolment_rec enrolment_cur%rowtype; begin open enrolment_cur(:new.enrol_id); loop fetch enrolment_cur enrolment_rec; exit when enrolment_cur%notfound; insert dk_deliverables values(deliv_seq.nextval, enrolment_rec.assmnt_id,:new.enrol_id); end loop; close enrolment_cur; end;​ my guess is cursor enrolment_cur(e_id dk_enrolments.enrol_id%type) this part: dk_enrolments.enrol_id%type may not resolve parser understands - dk_enrolments.enrol_id where defined? if not own object or there no public synonym need include schema. guessing externally defined column table.

i know how can select single cell jtable mouse , after keep value of cell in variable. thank you can use mouselistener . read section swing tutorial on how write mouselistener more information , examples. when click on cell need mouse point mouseevent , convert cell in table. can data table. basic code be: int row = table.rowatpoint(...); int column = table.columnatpoint(...); object cellvalue = table.getvalueat(row, column);

i struggling sql query return duplicate rows, example: employee_id store_no region 2531047 1671 e05 2544970 1254 w09 2566618 1625 e01 2566618 1635 e01 2566618 1835 e01 should like: employee_id store_no region 2566618 1625 e01 2566618 1635 e01 2566618 1835 e01 the above acheived following: select e.employee_id, e.store_no, s.region [usicoal].[dbo].[employee_str_asgn] e right join [usicoal].[dbo].[store] s on e.store_no = s.store_no order employee_id, region i have tried various options can find way remove these duplicates, not display them only... can advise if above possible? thanks in advance, charley. select * stuff st exists ( select 1 stuff xx xx.employee_id = st.employee_id group xx.employee_id having count(*) > 1 ) ;

i working on project in java swing. there text field user name. want validate text field user can't enter digits or special character or blank or space . in short want restriction such user can't enter other alphabets. database ms access , table name "test" , there 1 column named "sname". beginner, simpler techniques appreciated.thanks in advance. import javax.swing.*; import java.awt.event.*; import java.awt.*; import java.sql.*; public class ex_test extends jframe implements actionlistener { public static void main(string[] args) { ex_test ob=new ex_test(); } jtextfield tf1; jbutton b1; int num1; public ex_test() { super("test"); setlayout(new flowlayout()); tf1=new jtextfield(20); add(tf1); b1=new jbutton("ok"); add(b1); setsize(500,500); setvisible(true); b1.addactionlistener(this); } public void actionperformed(actionevent ae) { ...

in document, have 2 separate embedded youtube players. first has id player1 , second has id player2 . <div id="1" class="track"> <iframe width="560" height="315" src="//www.youtube.com/embed/1g4isv_fylg?enablejsapi=1" frameborder="0" allowfullscreen id="player1"></iframe> </div> <div id="2" class="track"> <iframe width="560" height="315" src="//www.youtube.com/embed/fxsovfzyx28?enablejsapi=1" frameborder="0" allowfullscreen id="player2"></iframe> </div> i have 3 buttons: "play", "pause" , "skip". <div id="play-button">play</div> <div id="pause-button">pause</div> <div id="skip-button">skip</div> i want skip button change video affected play , pause buttons. at moment have this: ...