VBA SQL select query but only show some rows -

-

i have table contains data trying import spreadsheet control on userform in vba/excel.

the results viewed end user, have set value of header cells on initialization opposed the column headings sql table.

my query looks this

dim conn adodb.connection dim rs adodb.recordset dim sconnstring string   sconnstring = "provider=sqloledb;data source=mysource;initial catalog=mydatabase;user id=myusername;password=mypassword;quotedid=no" set conn = new adodb.connection set rs = new adodb.recordset  conn.open sconnstring set rs = conn.execute("select * woft_tbl_clients userid =  '" & userid.value & "';") if not rs.eof    /////////////////     /something here!/     /////////////////  else   msgbox "error: no records returned.", vbcritical end if  if cbool(conn.state , adstateopen) conn.close set conn = nothing set rs = nothing

what trying output of selected columns database , able feed them whatever colomn on spreadsheet control.

so in effect somehow loop allows me output resultset of columns id, name , userid spreadsheet control starting row 2. database contains many other columns not needed in spreadsheet, needed spreadsheet control on same userform, of appear on both.

what able have each column in own recordset, have ids stored in id recordset use in column in spreadsheet control 1, , colomn 6 in spreadsheet control 2?

i hope makes sense! using excel 2010

to have each data column 1 table in recordset lead isolated data lists, wouldn't follow logic of relational database model. if data indeed isolated in way, id list, name list , on, living in same table, - forgive me - database model quite bad.

if nevertheless want columns sql database, specify them in sql statement:

select id, name, userid tablename anycondition order name

to loop through every record recordset object returns, use do-until loop this. don't forget movenext, or may result in endless loop.

do until rs.eof     ... want record ...      rs.movenext loop

i hope needed. feel free further explain, if didn't understand needs correctly.


Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c# - Copy ObservableCollection to another ObservableCollection -

-
how copy observablecollection item observablecollection without reference of first collection? here observablecollection item value changes affecting both collections. code private observablecollection<ratemodel> _allmetalrate = new observablecollection<ratemodel>(); private observablecollection<ratemodel> _metalrateondate = new observablecollection<ratemodel>(); public observablecollection<ratemodel> allmetalrate { { return this._allmetalrate; } set { this._allmetalrate = value; notifypropertychanged("metalrate"); } } public observablecollection<ratemodel> metalrateondate { { return this._metalrateondate; } set { this._metalrateondate = value; notifypropertychanged("metalrateondate"); } } foreach (var item in metalrateondate) allmetalrate.add(item); what causing , how can solve it? you need clone object referenced item before it's a...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more