Debug an AS/400 program called from Java
Hi, You should be able to start ISDB for your program :- STRISDB PGM(YOURLIB/YOURPGM) UPDPROD(*YES) INVPGM(*NO) The interactive debugger should startup when your program gets called. Regards, Martin Gilbert.

View Answer   |  October 9, 2008  11:57 AM
AS/400 debugging, AS/400 development, Java

Creating XML file using SQL Server 2005
Create a stored procedure which contains the select statement you wish to use. Make sure that the select statements creates the XML data the way you want it using the FOR XML clause. Then use BCP and use it to run the stored procedure using the QUERYOUT switch giving to the three part name to [...]

View Answer   |  October 9, 2008  6:14 AM
SQL Server 2005, SQL Server import/export, XML

MIgration to 64-bit Sql Server
You don’t face any database file compatibility issues going from SQL 2000 32bit to SQL 2005 64bit. SQL Server 2005 uses the same layout of data within the database file for either 32bit or 64bit. You can move between them without issue. Upgrading between platforms like this is just like upgrading to SQL 2005 32bit.

View Answer   |  October 9, 2008  6:07 AM
64-bit, SQL, SQL database replication, SQL Server 2000, SQL Server migration

How can i make my AS/400 listen to Java program or viceversa?
See this website…. http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp Click on iSeries Information Center, Version 5 Release 3 Click on programming Click on Java

View Answer   |  October 8, 2008  8:40 PM
AS/400, Java

java to AS/400 connection
This website should help you… http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp Click on iSeries Information Center, Version 5 Release 3 Click on programming Click on Java

View Answer   |  October 8, 2008  8:36 PM
AS/400, com.ibm.as400.access.*, Java

Is there an API or other function to list current users of a specific pgm?
Perhaps you will be able to find what you’re looking for, however, what I’ve seen has PgmA write a value into a Data area when it starts and clear the area when it’s done. PgmB checks the area and only continues if it’s clear. Of course PgmA could lock an object like a dtaara and [...]

View Answer   |  October 8, 2008  4:50 PM
API, AS/400 administration

Client Access CRLF
I believe that’s an automatic function of iSeries Access, and that you can’t change it. To get around, you could try copying the file to the IFS using the CPYTOIMPF command, where you could choose the end of record character or combination that you want (CRLF, LF, CR, or LFCR).

View Answer   |  October 8, 2008  1:38 PM
Client Access, CRLF

vb6 menu
You question is a bit vague, but you might find <a href=”http://www.builderau.com.au/program/windows/soa/VB-Tip-Customise-your-program-s-system-menu/0,339024644,320282860,00.htm”>this</a> helpful. It describes adding commands and programs to existing VB6 menus. Good Luck! -Flame ********************************

View Answer   |  October 8, 2008  1:22 PM
VB 6

Visual Basic & Designing a Class Library
All members of the base class must be Protected and then to make the class itself invisible to the form you could mark it MustInherit. This assumes your heirarchy is compiled into its own namespace as a dll. The user of your form will be able to see the names of your base classes by [...]

View Answer   |  October 8, 2008  4:59 AM
.NET, Visual Basic, Visual Basic .NET

Help finding duplicate info in Excel in different columns
I think I have a solution for your problem. Take a <b>copy your file for safety</b>. In the copied file You have to write macros to solve the problem. Just <b>copy & paste the code below in a module</b>. Then <b>first, run the macro “FindDuplicate”</b>, to mark duplicate rows. Then check if everything is ok, [...]

View Answer   |  October 8, 2008  1:57 AM
Duplicate records, Excel functions, Excel macros, Functions, Microsoft Excel

Listbox with DrawMode=OwnerDrawVariable, but i want Multicolumn=true.
I would think you would draw a row of colums as a single line, including your own separators, in the DrawItem method and set the height to max height of each individual column entry for a given row in MeasureItem. If column entries are not supposed to line up, ie can have different heights in [...]

View Answer   |  October 8, 2008  1:01 AM
.NET, C#, ListBox, VB.NET

Using answer as criteria in sql server
SELECT demand_order,supply_order FROM table_name WHERE demand_order = order#; table_name is the table demand_order is the name for the demand order column supply_order is the name for the supply order column order# is the order you want. You can use the same statement for supply orders too.

View Answer   |  October 7, 2008  9:42 PM
SQL, SQL Server

java programing source cods.
Here’s a great <a href=”http://www.robvanderwoude.com/index.html”>scripting website</a>. You might also want to take a look at the official <a href=”http://java.sun.com/docs/books/tutorial/”>Java Tutorials Page</a>, which is a really good start point. ********************************************** This <a href=”http://www.idevelopment.info/data/Programming/java/PROGRAMMING_Java_Programming.shtml”> Site </a> has small code samples for basic programing functions. they make nice “building blocks” <a href=”http://oreilly.com/catalog/javanut/examples/”>Here</a> is another site that has sample [...]

View Answer   |  October 7, 2008  9:24 PM
Java, Java programming

connection of oracle8i i vb6.0
There are many ways to connect to Oracle from a VB application. You can use an ODBC connection and/or use ADO (ActiveX Data Objects). You can also use RDO. If you want to connect via ADO you will need to create an ODBC data source or install the Oracle client software in the client machines. [...]

View Answer   |  October 7, 2008  2:22 PM
Oracle 8i, VB 6

Active x issue for exchange email
This problem can appear under different circumstances. If this is Vista client, you may need a hotfix for your exchange server. See <a href=”http://www.microsoft.com/downloads/details.aspx?FamilyID=5bc06e8a-08eb-4976-bc68-a03ebe3a2552&DisplayLang=en”>KB</a> If this is XP; you need to enable DHTML edit control as follows: In OWA if Windows XP displays a red X, you need to enable the dhtml editor control as [...]

View Answer   |  October 6, 2008  9:51 PM
ActiveX, Outlook Web Access

Automated data entry for some controls based on data in other controls in Access 2003
In your table containing the English words, make another column containing the corresponding French words. Set the properties to display the French word when you select the English word from your drop-down menu. This is what I’ve done in one of my databases; When I select a generic drug name I display the trade name. [...]

View Answer   |  October 6, 2008  7:10 PM
Access 2003, Bilingual database, ComboBox, DataPropagator, DropDownList, Localization, Microsoft Access

can any one give me the source code using java?
If you cannot use ANY function, your function should look something like this: <pre> public int isSquare (int n) { int iRootTest = 1; int iSquareTest = 0; if (n == 0 || n == 1) return 1; while (iSquareTest <= n) { iSquareTest = iRootTest*iRootTest; if (iSquareTest == n) return 1; iRootTest += 1; [...]

View Answer   |  October 6, 2008  6:18 PM
Application development, Java

drag and drop from FORM to FORM
I think you will need to provide more information in order to get some useful responses. What programming language/tool are you using ? Do you want to do this at design time, or runtime ? Regards,

View Answer   |  October 6, 2008  4:36 PM
Application development, MDI

is there a way to intercept and change a .net framework exception message?
You will want to take a look at the TRY CATCH method of catching error messages. <pre>TRY ‘Do something here CATCH ex as Exception ‘Do something here if it didn’t work END TRY</pre>

View Answer   |  October 3, 2008  7:55 PM
.NET, .NET Framework

Dynamically adding rows to Gridview
You need to create the new row first, for example: <pre>DataRow newRow = dt.NewRow();</pre> Then, set the appropriate data, for example: <pre>newRow[NAME] = “New row”;</pre> and add the new row to the data table, for example: <pre>dt.Rows.Add(newRow);</pre> Regards,

View Answer   |  October 3, 2008  3:15 PM
ASP.NET, Database programming, GridView