Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
'Retrieve record from SQL Server Set cnt = New ADODB.Connection stADO = "Provider=SQLOLEDB.1;" & _ "Data Source=xxxx;Initial Catalog=Dynamics_BAK;User ID=report;Password=123" With cnt .CursorLocation = adUseClient .Open stADO .CommandTimeout = 0 End With 'SQL Statement stSQL = "select * from WMSORDERTRANS where SHIPMENTID = 'A10009480' order by linenum" Set rst = cnt.Execute(stSQL) If rst.RecordCount <> 0 Then rst.MoveFirst Do MsgBox rst("itemid") rst.MoveNext Loop Until rst.EOF rst.Close End If
|Query Missing Money orders...||6||72|
|Excel VBA - Gather data into a single summary sheet from multiple worksheets||7||24|
|Macro Excel - Multiple If conditions||2||8|
|Added a column screws up code||5||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!