Create “if then” formula in Access 2003
Hello, I’m new with access. I have a table with article numbers in one column. and intro and outro dates in 6 columns. the intro and outro dates come from 3 tables, so that’s why the 6 columns (2 columns per table) However, I would like to combine the six columns into 2 columns, one [...]

Answer Question   |  August 17, 2011  8:41 AM
Access 2003, Access 2003 date query, Access 2003 forms, Access forms

iSeries source code recovery: SRC B9003E30
Hello there, We still have an old S10 system, on V5R2, for DEV users and unfortunately no more support. Now we have a damaged QSYS object, *SVRPGM, Q2CIO, that we cannot even execute a command. We tried doing an IPL but then we got SRC code B9003E30. Does anyone know how to recover from this [...]

Answer Question   |  January 6, 2011  6:56 AM
AS/400 IPL, AS/400 Troubleshooting, QSYS, Source code management, V5R2

Formview from gridview in Visual Basic
How does one automate by clicking a row in gridview to show a form populated with the clicked row data in visual basic for windows not asp.net

Answer Question   |  January 6, 2011  3:01 PM
Database, DataGridView, GridView, VB, Visual Basic

Windows 7 and KIXTART scripts
Why doesn’t KIXTART work with Windows 7?

Answer Question   |  January 4, 2011  9:19 PM
Kix, Kix Logon Script, Kix Scripts, Windows 7

How to accomplish BPT in SoapSonar?
Lets say there are some 10 APIs that span a particular development project. How to componentize the testing of these so as to be able to refer to individual components rather than creating a copy of each of the components in different projects for different test cases? Essentially asking if there is a way to [...]

Answer Question   |  January 3, 2011  5:17 PM
API, Application development, BPT, SoapSonar, Web application testing

Automate SPLF deletion in AS/400
how can I set up the system to delete old splfs?  I am new to a company who is manually deleting old splf because they are ‘maxing out the number of jobs and the system starts shutting down subsystems’ when this happens.  There may be system values I can manage or write/borrow a small pgm.

Answer Question   |  January 7, 2011  5:04 PM
AS/400, Automation, OUTQ, SPLF, Systems administration

How can I email a query output from Access 2003?
I have a query that runs form a table, the table have data for multiple customers, I give the query the customer numbers, it gives me the customer statement, I then copy and past the statement to excel and email it to the cutometer. I need to automate process if access allows me to do [...]

Answer Question   |  January 3, 2011  4:06 AM
Access 2003, Access Database, Access query, Automation

Recursive Association with compound primary key in SQL database
Hello, I’m afraid I’m very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a ‘Lead Client’ column to represent a recursive relationship where one attendee can be nominated to lead others attending [...]

Answer Question   |  January 3, 2011  11:53 PM
Database issues, Design principles, SQL, SQL Database, SQL Server database, SQL Server errors

SQL Server 2005 query
Hello sir I am new to sqlserver when retriving data like name gender sal deptno df F 100.00 10 mf M 1100.00 10 if M 1010.00 10 uf M 1000.00 20 yf F 1200.00 20 gf F 1030.00 20 hf M 1005.00 30 ff F 1040.00 30 from this i want retrive deptno maletotal sal [...]

Answer Question   |  December 31, 2010  7:54 AM
SQL Query, SQL Server 2005, SQL Server Query, SQL statements

onBlur event to textbox in javascript
I have textboxes in grid ,if the value in that textbox other than p,A,HA,HL i want to give alert message i wrote the code but javascript is not fired in the code i bind script on Rowdatabound of grid   <     script language=”javascript” type=”text/javascript”>     function GetMessage(ctrlText) {     var ctrl1 [...]

Answer Question   |  March 5, 2011  6:27 AM
C# .NET, Java, JavaScript, Scripting, TextBox

Pivot table automatic update in Excel 2010
How to make my pivot table automaticly updated if I edit, delete, append the source data?

Answer Question   |  January 12, 2011  12:31 AM
Excel 2010, Excel Tables, Pivot tables, Windows XP Professional

WPF Window disappears in the screen capture taken by code written in VC or C#, why ?
I have been trying to write a code which can capture screen and if WPF window is opened on the screen then it should also be present in captured screen but I observed is WPF window does not come in screen capture. If I press ‘Print Screen’ button and paste the image on paint then [...]

Answer Question   |  December 30, 2010  11:46 AM
Coding, Windows Application, Windows XP, WPF style

HP quality center or other testing tool
Can we download HP Quality Center for free? I wish to use HP Quality center in my project for requirement and test management.

Answer Question   |  February 1, 2011  5:52 AM
HP Quality Center, Software testing tools, Web application testing

Numeric to character conversion in AS/400
Probably a simple question: I have a numeric field, 14 decimal positions, and i want to copy this value to a character field of 14 positions, and keep the leading (left) zeroes in place. How do I do so in free-form coding?

Answer Question   |  December 30, 2010  3:31 PM
Alphanumeric conversion, AS/400 numeric fields, Conversion functions

As400 JOB Scheduling
Hi Tom I have one question to discuss with you. There are two jobs job A and Job B which is scheduled every day. here my question is to JOB B should be scheduled only when JOB A got completed normally. How i can do this task. Actually JOB B is the job which i [...]

Answer Question   |  December 30, 2010  7:57 AM
AS/400 job scheduler, AS/400 jobs, AS400 - job scheduling, Job scheduling

SQL Server Plan Cache
There is a bucket in plan cache with 75 objects in it and it is the same sql statement. Other than using DBCC FREEPROCCACHE what will clear out the cache? Restarting SQL SERVER Service? I use the code below to look up how many plans are in a bucket. SELECT   bucketid,   entries_in_bucket = [...]

Answer Question   |  December 29, 2010  11:30 PM
Cache, Cache Mode, SQL, SQL 2005, SQL performance, SQL Server

Times spanning midnight in RPG/400 concatenation
I have successfully converted time field to date/time. Now I need to find the total minutes between one field and another but cannot get it to show me any value. I am using DateDiff (‘n’,{@startdatetune}, {@startdatetime}) where n indicates minutes. I should be able to use any field where I have concatenated the date and [...]

Answer Question   |  December 30, 2010  2:02 PM
Concatenate, RPG/400, RPG/400 Field Concatenation

How to run a command within a CLP only during a specific time frame
I have a pgm that perfroms verious system checks and alerts me if there is a problem.  I would like to add an If statement to exclude some of the checks that fall between a certain time period and have it jump to a specific lable in the script to continue. thus skipping over the commands [...]

Answer Question   |  December 28, 2010  7:26 AM
AS/400, CL Commands, CLP, IF statement

iSeries CA 5250-Emulator Issue
I have a user who starts several 5250 sessions, often A to H. For some reason session E is not considered to be a PC and therefore rejects STRPCO command. All other sessions are OK. Anyone out there that could help me?

Answer Question   |  December 29, 2010  10:41 AM
5250 session, Emulators, iSeries, PC5250 Emulator

Please suggest me Java to SAP career
Hi All, I have 9 months of experience in Java. I’m done with my project. Actually planning to change my career from Java to any other technology. I have the knowledge on Tibco, sap abap . Actually planing to change Sap  BO or Tibco or sales force or Java (itself).. please suggest me which is the best according the present market and all other [...]

Answer Question   |  December 27, 2010  12:36 AM
Java, SAP ABAP, SAP BO, SAP careers