iSeries Token Error
Need help with this query – it will not run token error.  Here is the query: SELECT   SUM  (“T16.CTDT”.TD_DETAIL_AMT_01 * .10) AS TOTAL, “T16.CPRP”.CP_DISTRICT_CODE

Answer Question   |  January 15, 2010  5:12 PM
iSeries, iSeries Navigator, Query, Token Error

as/400 query printing with DBCS data
We are having some problems printing query reports since a software upgrade. The upgrade now has DBCS file data and print files. The strange thing is the reports will print on some select printers and not on others. It is very strange, some printers and set-up as *VRT Client Access and others are *LAN. The [...]

Answer Question   |  November 24, 2009  9:00 PM
AS/400, DBCS, Printing, Query

Slow query response time in SQL Server 2005


Answer Question   |  October 27, 2009  4:30 PM
Query, Slow SQL Query

Can a command button macro run a make-table query with an auto-inputted parameter value?
I want to run a make-table query with a parameter, using a command button click event on a form showing a single record. The parameter value needs to be inputted automatically using the value of a control in the current record of the same form. Can this be done with a macro event? If so, [...]

Answer Question   |  July 28, 2009  11:46 AM
append, Control, Form, make-table, parameter, Query, run, SQL, value, where

Using the query to filter out the specifics
Hello, i was just wondering if there is any way to use the query to filter out all the list with the word “mexT” in their lines/box. For example, in the column, there are bunch of lines with lines such as “cexT3df3#”, aextT3rdfad” “mexT124ef3″ “mexT235tgc#”, etc…. but not exactly just mexT. How can i use [...]

Answer Question   |  July 7, 2009  2:32 PM
Query

0 Row affected
Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM],

Answer Question   |  June 29, 2009  5:32 AM
Database engineering, Query, rows affected, SQL, Update

Update field in table from a calculated query field
I have a form attached to a query with calculations. How do I make the calculated values write back to the table?

Answer Question   |  April 24, 2009  8:30 PM
Calculating fields, Query

MS SQL query to update a table with the last entry in another table.
Hi, Could anyone please assist. I’m trying to update a Reporting Table with the last entry in another table. I’ve tried to arrange the table according to the ID row. This works great. Then the query to get the last entry woks as well, but to get the two to work together and update the [...]

Answer Question   |  March 26, 2012  11:14 AM
Query, SQL, SQL queries, SQL Query, sql report, UPDATE statement

AS/400 Query: How to select records with digits and/or characters
Hi, I’m doing a cleanup and I need your help. 1) Is it possible by using As/400 query to select records which containing digit or signs (1, 2, @, -, & Etc.). For example, field “customer name” with digits/signs. 2) Is it possible by using As/400 query to select records which containing characters (a, b, [...]

Answer Question   |  January 1, 2009  8:24 AM
AS/400, Query

Query 400 – SSN
Hi all, I need to strip all but the last 4 digits of employees SSN in a file…I cannot remember what the string is!!! Can someone help? BTW, the current field has NO dashes in the SSN. Thanks in advance!! Rick

Answer Question   |  December 18, 2008  6:16 PM
AS/400, Query, SSN

Landesk query
Landesk version 8.7 SP 4 I am trying to write a query in the Landesk consol In the Machine components I have selected logon names. I have tried using “=” and “like” But if I insert more than one logon name, save the query and run it I get a “no results” the query will [...]

Answer Question   |  November 7, 2008  7:06 PM
LANDesk, LANDesk 8.7, LANDesk 8.x, LANDesk Query, Query

Edit codes using Strqmqry
I am passing a date field to a query via strqmqry command. However, my numeric edit codes are not what I defined them in the query definition. Seems a default code for numerics is used. What am I doing wrong?

Answer Question   |  August 26, 2010  4:51 PM
Query, STRQMQRY

Alpha to numeric
How to converet a field from alpha to numeric in query

Answer Question   |  October 10, 2008  2:34 PM
Development, Programming, Query

How to pass value at run time from VB 6 to Access 2000 Query for reporting
I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is [...]

Answer Question   |  October 6, 2008  10:19 AM
Access, Access 2002, Query, Query tuning, VB, VB 6, Visual Basic 6, Visual Basic developers, Visual Basic for Applications

T-SQL Query- how to explode XML fragment stored as NText into table?
I’m using a commercial storefront software that offers “extension data” fields as NText to store custom data. I am storing an xml fragment that looks like this: <priceSplit xmlns="http://tempuri.org/priceSplit.xsd"> <split> <type>Credit Processing Fee</type> <acct_code>901010300</acct_code> <value>0.30</value> </split> <split> <type>Shipping Fee</type> <acct_code>901010500</acct_code> <value>0.30</value> </split> <split> <type>Proceeds</type> <acct_code>900000000</acct_code> <value>9.4000</value> </split> </priceSplit> I need to explode this data into [...]

Answer Question   |  September 25, 2008  8:03 PM
Query, SQL Query, SQL Server 2005, T-SQL, XML

Writing a query in SQL for use in SQL Server 2005
I’d like to write a query that would allow me to view items with a characteristic of my choosing and filter out the others. Is it possible to write something like this in SQL and use it in SQL Server 2005?

Answer Question   |  September 17, 2008  3:14 PM
Query, SQL, SQL Query, SQL Server 2005

Writing a specific query involving primary keys in SQL
I need to write a query in SQL that will get the fifth-from-last record from my database when either a primary key is defined or no primary at all is defined. How would this query look?

Answer Question   |  September 16, 2008  5:51 PM
Primary keys, Query, SQL, SQL Query

Making a query for a SQL Server database
I would like to make a query for my SQL Server database to specify that only unmatching records should be displayed from both tables. Can you help me in doing so?

Answer Question   |  September 8, 2008  8:14 PM
Query, SQL Server database

Delphi BUY BACK or After Market Sells of OCS
Searching for any info on the existence of a Delphi OCS buy-back program or resell vendors that deal primarily with the OCS display systems. Recently acquired a complete unit (OCS9200-150 15” Color AM/TFT LCD with the full support interfaces housing unit and an IMS9000 Intelligent Modem Switch) both inventory back up units – excellent condition. [...]

Answer Question   |  August 30, 2008  6:40 AM
Delphi, IMS9000 Intelligent Modem Switch, OCS., OCS9200-150 Color Order Confirmation System, Project management, Query, Visual Basics

Problems with the SQL query function
I am designing a website, and I’m having a problem with the SQL query function. My table looks like this: Table Structure Ref_ID Mem_ID 1001 1002 1001 1003 1001 1004 1002 1005 1003 1006 1003 1007 1003 1008 When I try the command “select * from table where ref_id=’1001′,” it returns 1002, 1003 and 1004. [...]

Answer Question   |  August 22, 2008  4:16 PM
Query, SQL, tables