vba open query

IamlaosongI do Excel tools, connect Oracle database query data, usually can run very well, both XP and Win7 can. Later encountered a Win7 (64-bit) system, found unable to connect to the database, reported " connection is not open" error .error Description: Sqlplus can be connected with Oracle's tool, but the macro in Excel is "ORA-06413: Connection not open" Erro

This section describes how to use VBA to select a file and use VBA to open a file.Clicking open file will pop up a Windows File opening dialog box. In Excel, how does VBA implement this function? Sub selectfile ()Dim filename as Variant'The file name returned by the

The world's API viewer has been a lot, but for VBA with almost no. I myself wrote a Windows API Viewer that provides the export functionality of VBA statements and can provide MSDN link queries for more than 20,000 APIs.Environmental requirements: Windows 7.1 SP1 and above operating systems, install. Net 4.5.2 and above frameworks.: API Viewer v1.1 DownloadWrote a Windows API Viewer that provides the abilit

This Code reads all files in a folder, and can also filter other formats based on the extension.'With the file name, open the file, get the sheet name of each file, and write it to the desired place. Sub macro1 ()Dim mydialog as filedialog, ofile as object, strname as string, N as integerDim FSO as object, myfolder as object, myfiles as object, dim FN $Set mydialog = application. filedialog (msofiledialogfolderpicker)N = 1With mydialogIf. Show lt; g

Learn VBA, just to make a small tool for finance:Sub Open Personnel Information table () Dim WB as Workbook, C as Integer Set WB= Workbooks.Open ("C:\Users\wzn\Documents\ Workbook 2.xlsx",0, True) c=WB. Worksheets.count If C3Then WB. Worksheets.add after:=Worksheets (worksheets.count) WB. Worksheets (1). Select End SubSub Add selected person () Dim FW as Worksheet, LW as Worksheet, fr As Integer, LR As Int

' Check public Function check () as Variant on Error GoTo erlb dim strdir as String st Rdir = Thisworkbook.worksheets ("Path"). Range ("B2") objfile = Dir (Strdir "\*.xlsx") thisworkbook.worksheets ("Result"). Activate with ActiveSheet . Range ("a2:b400"). Select '. Cells.select selection.clearcontents . Range ("A1"). Select end with application.screenupdating = False do while objfile icnt = 0 startrow = 9 with ActiveSheet for iRow = StartRow to MaxRow If Trim (ActiveSheet.Ce

Open MySQL Slow query MySQL Slow query log for tracking Php+mysql system under the MySQL load tuning problem is very useful, such as installing a lot of discuz! plug-ins users, so you can probably troubleshoot those plug-ins have code problems. In fact, the slow query log to enable MySQL is very simple, only need to a

OPEN INFOREB SEARCH QUERY logsmation EXTRACTION fromWEBSEARCH QUERY LOGSChapter I.IntroductionSearch engines are increasingly more advanced than traditional keyword input and document output, and by focusing on user-oriented tasks to improve user experience, user-facing tasks include query suggestions, search personal

Http://blog.sina.com.cn/s/blog_75ad10100101by7j.htmlHttp://www.cnblogs.com/zemliu/archive/2013/08/03/3234372.htmlFirst: Query_cache_type How to use query cachingIn general, we will set the Query_cache_type to on, which should be on by defaultMysql> SELECT @ @query_cache_type;+--------------------+| @ @query_cache_type |+--------------------+| On |+--------------------+Query_cache_type has 3 values of 0 for closing the

Label:One, why do you want to open this query? The database is a very easy place to create bottlenecks, and now nosql people are talking about the heat, and it's estimated that the database is depressing. MySQL is the most affected by the speed of the query is very slow, these slow statements, may be not enough to write reasonable or big data under the multi-tabl

MySQL slow query log is useful for tracking problematic queries, can be analyzed in the current program has a very resource-intensive SQL statement, that how to open MySQL slow query log records it? In fact, open MySQL slow query log is simple, only in the MySQL configurati

gave a detailed introduction to Lucene's principles, structures, and APIs. http://www.e.com.cn/.but it is no longer effective. There areBluepoint2009Is named 《Lucene3.6 getting startedOfArticleIt is worth your reference. For some entry-level examples of Lucene, refer to the example code provided by the blogger: "create search and learning instance source code of Lucene", "query regenxquery by Lucene regular expressions", and "Lucene filter

Turn on caching, set cache size, and implement the following: 1, modify the configuration file, Windows under the My.ini,linux is my.cnf; On the last append to the configuration file: The code is as follows Copy Code Query_cache_type = 1Query_cache_size = 600000 Need to restart MySQL in effect; Then adopt the second way; b to open the cache, two ways: A) Use the MySQL command: The code is as fol

Incremental index update into the new standard of text retrieval, spanner and F1 showed us the possibility of cross-datacenter database. In Google's second wave of technology, based on hive and Dremel, emerging big data companies Cloudera open source Big Data query Analysis engine Impala,hortonworks Open source Stinger,fackbook

ROWNUM, SUBSTR (A.sql_text, 1, a) Sql_text, TRUNC ( A.disk_reads/decode (a . executions, 0, 1, a.executions)) reads_per_execution, a.buffer_gets, a.disk_reads, a.executions, A.sorts, a.address from v$sqlarea a ORDER by 3 DESC) WHERE ROWNUM Querying and displaying the actual Oracle connection in the viewSELECT Osu

A common web site often need to query n SQL statements to get the results of the page, when the Web site access speed is slow and the front-end done a lot of optimization work, the database bottleneck of the search is also an important part of the Web optimization.MySQL provides a slow query logging function, you can query the SQL statement time is greater than t

Original: http://blog.csdn.net/a11085013/article/details/17370053Show variables like '%quer% '; query whether to open a slow query!!Step One: Modify My.ini (mysql config file)Add the following two words to the My.iniLog-slow-queries = "D:\wamp\mysql_slow_query.log"Long_query_time=5The first sentence is used to define the path to the slow

Because the query cache relies on level two caching, you must first turn on level two caching. The steps are as follows: First, open the query cache with a configuration file Situation one, project has hibernate.cfg.xml file Open the query cache function by modifying the Hib

Navigation Catalog: Farseer.net Lightweight Open source Framework Catalog Previous: Farseer.net lightweight open source framework Getting started: deleting data in detail Several ways to query a list1 // field value specified plus 1 2 1). ToList ();1 // Query the first 10 data

Linux enable MySQL slow query The code is as follows Copy Code Vim/etc/my.cnf[Mysqld]Slow-query-log = on # Open slow query functionSlow_query_log_file =/usr/local/mysql/data/slow-query.log # Slow query log store path and nameLong_query_time = 5 #