Substring A Packed Field
Hello I have a flat record format that I move into an external data structure. Within the external data structure, I have many packed fields. Rather than refer to each of pacekd field by external field name, I would like to be able to substring each packed field out, and then, move the value of [...]

Answer Question   |  September 3, 2010  4:13 PM
Array, Data Structure to Flat File, Data structures, Flat files, Packed Fields, Substring

Access Listbox Without Focusing in WinForms
Is that possible to access ListBox without Focus? I mean as below example I have a TextBox and a ListBox. I wants when cursor in textbox listbox should search the items containing in textbox and do well up and down arrow key. When i press Enter the items which is search by listbox should replace [...]

Answer Question   |  August 27, 2010  3:44 PM
C#, ListBox, Visual Studio, Visual Studio 2005, VS 2005, WinForms

Will the SQL performance improvements in V6R1 affect QUERY?
Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?

Answer Question   |  September 17, 2010  3:13 PM
i5, SQL performance, SQL queries, SQL Query, V6R1

Prophet 21 Database Dictionary
Is there a data dictionary for the prophet 21 database? I am looking to create applications that use data stored by prophet 21 software. Is there available software to interface with prophet 21 data?

Answer Question   |  August 27, 2010  2:20 PM
Application software, Data Dictionary, Database, Prophet 21, SQL, SQL Database

Runtime Session resolution change
I want to change seesion resolution from 24X80 to 27X132 in runtime through RPG ILE. Please help me on this regard, by giving sample code.

Answer Question   |  August 27, 2010  11:49 AM
RPG ILE, RPGILE, Source code

Any open source tools to test desktop applications using Java?
We have a Test Framework in Java.  This framework is used to test client-server and web applications. To test webapplications we are recording application flows for wrappers/Action keywords using Selenium IDE. Selenium provided Java driver to execute the recorded selenium specific code in wrappers. Similarly I want to use our test framework to test desktop [...]

Answer Question   |  August 27, 2010  7:41 AM
Automated software testing, Automated Testing, Automation, Desktop management applications, Java, Open source, Open source testing tools, Software Quality, Software testing

Crystal Reports XI – SQL table fields that fail all compare tests
I have an SQL table with a field that Crystal XI displays as string 300, call it mytable.mystring. If I create a formula field (myformula) such as… if {mytable.mystring} = “test value” then 1 else 2 This is what happens during execution…  when the the preceding test is true, Crystal returns a value of 1 [...]

Answer Question   |  August 26, 2010  3:15 PM
Crystal Reports XI, Crystal XI, SQL, SQL Server, SQL tables, Windows Server

SQL Server 2005 maintenance plans
I have several maintenance plans setup in SQL 2005, but if the backup fails I am not alerted in any manner how can I fix this? Will I need to script something or is this a built in feature?

Answer Question   |  August 26, 2010  1:16 PM
Backup, Maintenance Management, SQL, SQL 2005, SQL Manager, SQL Scripting, SQL Server 2005, SQL Server 2005 backup

SQL Work Files
In the FOCUS programming language, you can retrieve data and hold that data for further processing at some point later in the program.  What is the best technique for doing this in SQL?

Answer Question   |  August 26, 2010  12:23 PM
DB2 SQL, Focus, Programming Languages, SQL, SQL Database, SQL Server, Work Files

Help navigating SQL Server 2008 database?
Hi all, I’m facing an interesting challenge… Lets say: I have a payment coming in and of course my client has not specified which of the 45 open invoices he is paying. The amount does not match any single invoice so it has to be a combined payment for 2 or more invoices. Now, I [...]

Answer Question   |  August 31, 2010  8:44 AM
SQL Server 2008, SQL Server 2008 administration, SQL Server database, SQL Server tables, VB.NET

FoxPro 2.6 DBFS Security
in my absence others open my dbfs (eg sales.dbf) in my computer. How to lock the dbfs and how to unlock it for my use.

Answer Question   |  May 23, 2011  8:26 AM
DBF file, FoxPro 2.6, FoxPro 2.6 for DOS, FoxPro 2.6 for WINDOWS, Windows 2000, Workstation Security

Proper Excel 2007 macros to identify table
dear sir/madam i have a table such as the left table and want to extract a table like the right one please give me the proper macro. best regards. hamid [table style="border-collapse: collapse; width: 300pt;" border="0" cellpadding="0" cellspacing="0" width="400"> [col style="width: 63pt;" width="84">[/cOLIST] [col style="width: 62pt;" width="83">[/cOLIST] [col style="width: 48pt;" width="64">[/cOLIST] [col style="width: 66pt;" width="88">[/cOLIST] [...]

Answer Question   |  August 25, 2010  7:30 AM
excel, Excel 2007, Excel 2007 macros, Excel macros, Excel Tables

Best Website Creation Software?
What would you guys recommend as the best website creation software for someone who does not know html

Answer Question   |  October 20, 2010  8:59 PM
HTML, Web development tools, Website architecture, Website design, Website templates

Best Web-based Automation
Hi, would you know what is the best automation for a webbase, we do have a lot ajax and we work on java. I tried selemium , but i’m not sure how to enter a test case..

Answer Question   |  August 25, 2010  8:51 PM
Ajax, Automation, Java, Selenium, Web based Applications

Indexing in Microsoft SQL
What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?

Answer Question   |  August 27, 2010  8:08 PM
Database design, SQL, SQL Database, sql indexes, SQL Server 2005, SQL Server 2005 index strategy

Agent’s IP Address
hi everybody I want to find agent’s IP Address on the Interface in snmp but I don’t know How? anybody can help me?

Answer Question   |  August 24, 2010  6:10 PM
IP address, Java, Java agent, Java programming, SNMP

Class call not recognized
I have created a class TMT2PropertiesCollection as a separate file. I have a second class (TMT2Layers) and from within Layers I can make a call to Properties (e.g. properties.xxx and back comes a value). But In In my main form I call TMT2properties.xxx and it comes back empty! I am new to class use — [...]

Answer Question   |  August 24, 2010  5:50 PM
VB, Visual Basic, Windows Forms

What is a linear recursive query in SQL?
What is a linear recursive query in SQL?give me an example.Is there any nonlinear recursive query??

Answer Question   |  August 24, 2010  5:28 PM
SQL Query, SQL Server 2000, SQL Server 2000 queries, SQL Server Query

How to inherit parent site permissions when creating subSite using webservice
Using Sharepoint 2007 webservices from a .Net web application I create a subSite (CreateDWS method).  I was originally hoping that the parent permissions would be inherited but no such luck. According to the http://msdn.microsoft.com/en-us/library/ms772546(office.12).aspx, I should be able to add a XML tag like:         Dim strNewUser As String = “<UserInfo>” & _             “<item Email=’someone@somewhere.com’ [...]

Answer Question   |  August 24, 2010  2:04 PM
Active Directory Permissions, SharePoint, Sharepoint Webservices, Visual Basic, Visual Basic .NET, Visual Basic .NET Web services

AS400 to SQL
I am going to be leading a project to convert old AS400 data to SQL, and build a web front end.  Does anyone have a project charter, project plans etc I could use a a baseline for my write?  I’m looking for the whole gambit of information surrounding this ‘conversion’ and lessons learned etc.  Thanks [...]

Answer Question   |  August 25, 2010  1:50 PM
AS/400, Conversion, Java, Project management, SQL