Search Results | query
PREV 1   2   3   4   5   6   7   8   9   10...   20   30   40   50   60   70...169 NEXT
Sort by:  Most Relevant  |  Date
Modifying a module in Access 2007

Answer  I have a database with around 40 queries. I have a module which runs all the queries using the following (abbreviated) code: Function RunQueries() On Error GoTo RunQueries_Err DoCmd.OpenQuery "Query_1", acViewNormal, acReadOnly DoCmd.Close acQuery, "Query_1" DoCmd.OpenQuery "Query_2", ac...

Last updated: Sep 2, 2008   2:06 AM GMT   |    Access Database, Microsoft Access 2007
Reference a query object from another query

Answer  I want to be able to reference a db2 query from another query. Is this possible? For example: select table_data.field1, query_data.field1, query_data.field2 from table_data, query_data where table_data.field1 = table_data.field 1 In the above example, query_data is a db2 query tha...

Last updated: Oct 26, 2005   2:28 PM GMT   |    SQL
Time To Dump Query/400

Blog  I admit opening up Query/400 (IBM Query for i) on the rareoccasion to crank out a straight forwardreport. I think its more for nostalgic reasons because Query wasthe first reporting tool I learned on the AS/400 so many years ago. But my Query/400 use is becoming less and less and instead I am...

Last updated: Nov 2, 2012   5:55 PM GMT  |  Blog: AS/400 Programming Tips, Tricks, & Techniques
update query fails as table gets locked by select query (sql blocking issue).

Answer  I have a perl script which updates some table records in sqlserver 2000, the flow is like below: * A select query This select query selects IDs(with other records too) * An update query This update query updates a bit column from 0 to 1 for the IDs retrieved from above select query. The pro...

Last updated: May 1, 2008   9:32 PM GMT   |    Microsoft SQL Server 2000, Perl
AS/400: Check where output file is used as an Input

Answer  We have a few important queries whose outputs form the basis of several (even hundreds) of other queries and reports. If we wanted to make a change in one of these main ones, is there a simple way to tell which other queries use it for an input? For example: Query: ABCD2014 Library: Lexample1 Out...

Last updated: Jul 28, 2014   9:04 AM GMT   |    AS/400, AS/400 output files
Report language change in Oracle Reports 6i

Answer  I have a report in which report headings query is main query and report data query is sub query. I want to change the report language based on the language data available in the child query. Can anyone suggest to how to proceed?

Last updated: Nov 17, 2014   1:51 PM GMT   |    Oracle Reports 6i
AS400 File to MS Access by SQL Passthrough Query

Answer  I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM ...

Last updated: Aug 11, 2009   1:03 PM GMT   |    AS/400, iseries v5r4, Microsoft Access
Difference between Structured Query and Query in AS/400?

Answer  We used STRSQL- FOR START SQL(Structured Query Language) and STRQRY- FOR START QUERY. What is the difference between Structured Query and Query? (SQL and QRY)

Last updated: Jul 23, 2012   5:55 PM GMT   |    AS/400, QRY, SQL
How Much Is That Query Costing?

Blog  When we think about the cost of the query we typically think about the cost which SQL Server assigns to execute the query. However when we look at performance tuning queries there is another cost that we need to think about. This additional cost is the cost to the company while the query is running....

Last updated: Feb 12, 2014   2:00 PM GMT  |  Blog: SQL Server with Mr. Denny
How change work of Oracle database engine?

Answer  When running a query, we have result of query one time. If it happens, the error while running query we will not have any result. I want to how change on database engine to have part of query if happen bug while running query. I want any search in subject. Thank you very much!

Last updated: Feb 9, 2018   7:12 AM GMT   |    Database, Oracle, Oracle Database
How to run a query in PS Query using Microsoft Excel macro

Answer  Hi, I am working on a macro in Excel that can automate the running of a query in people soft PS Query application.Result should also be save in Excel format at given path. Here is what i exactly want to do 1. Put all query name under column A.(not entire query only its name) 2. Run macro 3. que...

Last updated: Dec 11, 2008   9:48 AM GMT   |    Microsoft Excel, PeopleSoft, PS Query
SQL - Pass the result of the first query as the second query select column name

Answer  I want to pass the result of a SQL query as the column name in another query eg. (note there will be a single result for the first query): SELECT CASE WHEN fld_type1 = 'A' THEN 'VAL_ALPHA1' WHEN fld_type1 = 'D' THEN 'VAL_DATE1' ELSE 'VAL_NUM1' END AS FIELDNAME FROM TABLE1 I want the result of the fi...

Last updated: Mar 24, 2009   11:07 AM GMT   |    Dynamic SQL, SELECT statement, SQL
How to retrieve an outfile in QMQRY?

Answer  I am working at new place where they have a lot of Queries which works as series one after another, doing selection, writing to outfile. Then next query uses this previous' query outfile, join with something writes to the next outfile etc. To analyze this numerous queries, I used RTVQMQRY command ...

Last updated: Dec 23, 2015   6:26 AM GMT   |    AS/400, QMQRY, WRKQRY
Microsoft Access QueryDef problem with numeric column anme

Answer  I have a form that creates a query on the fly. It works great, but has a problem with columns that have numeric names. The table is not mine so I can not change the columns. When I run the query the column name appears in the column. I tried to find anything wrong in the query and could not. IF I op...

Last updated: Nov 19, 2008   12:15 AM GMT   |    Database programming, Microsoft Access, Microsoft Access forms
Learning SQL

Answer  I work in a large company in the automotive industry. We use the AS400 system corporately. I am just learning the query system. I have used a little of the iSeries and found that to be somewhat burdensome. My co-worker introduced me to the SQL language. What I am trying to do is using MS Access a...

Last updated: Jul 27, 2009   12:39 AM GMT   |    SQL
Difference between QM Query and traditional query

Answer  When both a QM Query and a traditional Query are run against a database file with IDENTICAL record selection, the traditional query returns more records. I can only guess that it has to do with a difference in the wayeachutilityhandles uncommitted data. It almost looks as if traditional Query ...

Last updated: Sep 29, 2010   7:01 PM GMT   |    Database Files, Query, Query Management Query
Query for a Mail Merge

Answer  When I access my Auction Query in Access I can pull it up and everyone is there. When I try to do a mail merge and pull up my auction query all the other queries are there except the auction query.

Last updated: Nov 29, 2011   7:59 PM GMT   |    Mail merge, Microsoft Access, Microsoft Access queries
Sql Query in AS400

Answer  I am trying to execute a Query String but I receive following error Query exceeded the specified time limit or storage limit however my query length is normal, nevertheless i have executed larger query too. How to solve this problem.

Last updated: Jul 20, 2009   7:21 AM GMT   |    SQL queries, SQL Query
Identifying output files in query definitions

Answer  How can one identify all/only output files in a list of query definitions (the list has over 1000 queries in it)? Executing in batch RUNQRY with parameter PRTDFN(*YES), in a loop for each query, then scanning the collective result, might theoretically do the job but doesn't work for queries in which...

Last updated: Aug 25, 2008   4:06 AM GMT   |    AS/400 output files, AS/400 Query, Batch files
Optimising WMI callspart 1

Blog  Recently saw some code where user was running this $bootupMemory = gwmi -Query "SELECT * FROM Win32_OperatingSystem" -ComputerName $srv $cpuLoad = gwmi -Query "SELECT * FROM Win32_Processor" -ComputerName $srv $tSessions = gwmi -Query "SELECT * FROM Win32_TerminalService" -ComputerName $srv $ima ...

Last updated: Aug 29, 2016   7:37 PM GMT  |  Blog: PowerShell for Windows Admins
PREV 1   2   3   4   5   6   7   8   9   10...   20   30   40   50   60   70...169 NEXT

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: