How to get delete history from schema
You could do this with database triggers. The syntax will be different depending on the database you are using, which you didn’t specify. —————————-

View Answer   |  May 14, 2009  3:15 PM
Database programming, Database schema

Free Chapter – Tuning database applications for performance
Enjoy the chapter and be sure to check out the related database development resources listed at the bottom of the download page. Voice your feedback on this chapter or let us know of other books you’d like to see featured on the IT Bookworm Blog by leaving a comment. Thanks.

View Answer   |  May 14, 2009  12:27 PM
Data access, Database applications, Database performance, Database scalability, Free Chapters, John Goodson, Prentice Hall, Robert A. Steward

How do you create a file containing Simplified Chinese characters (DBCS) and English in the same field on IBM iSeries IFS in UNICODE UTF-8 format?
this can be done. create the pf with e field like this: DESC 500G CCSID(13488) then you can parse the xml with QXML4PR500 ibm parser and write data into the PF. We are doing this to print multilanguage labels (including Chinese and Simplifiedl Chinese) and it works fine.

View Answer   |  May 14, 2009  9:58 AM
ASCII, CCSID, EBCDIC, iSeries, Unicode, UTF-8, XML

Dialing softphone from Java Application?
Hi Here is a sip phone implemented as java applet (still in beta version, but the basic functionality is already working) <a href=”http://www.mizu-softphone.com/WebPhone.aspx”> Web Softphone Please find the some more in the below link: http://www.voip-info.org/wiki/view/VOIP+Phones

View Answer   |  May 14, 2009  5:25 AM
Java, Java applications, Softphone, VoIP

How can I export data from mainframe to Excel in REXX
Laks143, Whenever I want to do this, I work with tab delimited text. Since a tab is equal to a hex ’05′, you can easily incorporate that into your output. Below is an example where I am reading in an Excel spreadsheet, saved as tab delimited text. I’m then creating a new column, and writing [...]

View Answer   |  May 13, 2009  7:51 PM
Mainframe, Microsoft Excel, Microsoft Excel import/export, REXX, REXX Procedure, REXX procedure to export data to Excel

S7300 PLC programming
You are facing an incredibly steep learning curve if you select the Siemens PLC. I use these daily, and I can tell you that they are nowhere near as comprehensible as Allen Bradley products, and many others. One reason is the fact that Siemens documentation is poorly translated from the original German, and the logical [...]

View Answer   |  May 13, 2009  6:33 PM
PLC, Siemens, Siemens S7300 PLC

Conditional formatting in Microsoft Excel 2003
There is no built-in function that I know of that will solve that, but you can write a simple user function. Go to Tools -> Macro -> VisualBasic Editor. Go to Insert -> Module, which will create a new code module Paste in the following code: <pre>Function CountPair(R As Range, pYear As Integer, pChar As [...]

View Answer   |  May 13, 2009  4:00 PM
Conditional formatting, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2003 formulas

run vba code as admin
You can use the VBA command: Shell() to execute SysInternals <a href=”http://technet.microsoft.com/en-us/sysinternals/cc300361.aspx”>ShellRunAs</a> or <a href=”http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx”>PsExec</a> to execute command line instructions on local or foreign machines. However, that would require storing the elevated credentials somewhere Access can read them,.. there may be Security-safe ways to do that, but I’m not familiar with them. Alternatively, if you’re [...]

View Answer   |  May 13, 2009  3:18 PM
Access, Microsoft Access, VBA

Calculating prior Query fields
You may need to create a function of your own instead of using the DLookup. In the function, you could make a SQL query to find what you need. Depending on how your PK is setup, you might be able to do something like this: Function GetEndMeter(CurRowID as long) ‘Pass in the current record’s rowid [...]

View Answer   |  May 13, 2009  10:14 AM
DLookup, Query optimization, WHERE statement

login form
Have a look at <a href=”http://www.java2s.com/Code/ASP/Components/LoginformDemoVBnet.htm”>this Login form Demo (VB.net)</a>, and make the necessary changes to connect to an Oracle database. This article could be helpful as well: <a href=”http://www.oracle.com/technology/pub/articles/cook-vs08.html”>Build a .NET Application on the Oracle Database with Visual Studio 2005 or 2008</a>

View Answer   |  May 13, 2009  1:17 AM
Oracle Database, VB.NET, VB.NET 2005, VB.NET Login Form

What software to create Internal Knowledge Sharing site?
Have you looked at a wiki solution like mediawiki? This <a href=”http://www.wikimatrix.org/”>site </a>lets you compare features and functionality of alot of wikis out there

View Answer   |  May 12, 2009  7:46 PM
Knowledge Management Software, LDAP, Open source, RSS, Software

Is it better to develop Web or Java based applications for the BlackBerry? Why would I choose one over the other?
Java is the way to go for me. I find most of the apps i use are Java based. Here is a link to <a href=”http://na.blackberry.com/eng/developers/javaappdev/javadevenv.jsp”>Blackberry’s JDE</a> I guess in the end it is what you are most comfortable programming in. I think either one would work. I haven’t seen a ton of new apps [...]

View Answer   |  May 12, 2009  3:51 PM
Application and Web development, Application development, BlackBerry, BlackBerry applications, Java, Java applications, Web application development

What is your highest priority enterprise application that requires a mobile client?
Our CRM application is probably the most important one that uses a mobile client..

View Answer   |  May 12, 2009  3:51 PM
Application development, Mobile Application Development, Mobile applications

Access 2007: VB code to make a button press link to a specific record in another form
On your listing form, have the button run the OpenForm method. In the detail form, have the Form_Open event either set the filter property or set the RecordSource property. Using the Filter property: Sub Form_open me.filter = “Component = ” & Forms![ListingForm]![Component] me.filteron = true End Sub With the filter, the user could remove the [...]

View Answer   |  May 12, 2009  3:31 PM
Access 2007 forms, Access VBA, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications

VB6 kernal func GetFreeDiskSpace returns a Long (not long enough)
Use the FileSystemObject. Here is an example. Create a new project and add a label to the form. Paste this code and run it: <pre>Private Sub Form_Load() Label1.Caption = Get_Free_Space(“C:”) End Sub Public Function Get_Free_Space(DrvPath) Dim FS Dim D Dim s Set FS = CreateObject(“Scripting.FileSystemObject”) Set D = FS.GetDrive(FS.GetDriveName(FS.GetAbsolutePathName(DrvPath))) s = Str(D.AvailableSpace) Get_Free_Space = s [...]

View Answer   |  May 12, 2009  2:38 PM
VB6, Visual Basic

Connecting VB2008 to SQLServer2005
Have a look at these links: <a href=”http://msdn.microsoft.com/en-us/library/s4yys16a(VS.71).aspx”>Creating Connections to SQL Server</a> <a href=”http://msdn.microsoft.com/en-us/library/aa905872(SQL.80).aspx”>Connecting to a SQL Server Data Source</a> <a href=”http://www.exforsys.com/tutorials/vb.net-2005/access-and-manipulate-sql-server-data-using-ad-hoc-queries.html”>Access and Manipulate SQL Server data – Using Ad Hoc Queries</a>

View Answer   |  May 12, 2009  2:38 PM
OLE, SQL Server 2005, VB 2008, Visual Basic

Access: Form to input dates
This could be done; but it would take some work. Because the Mon, Tue, Wed, etc. would not be bound to the table at all. You would need VBA code to insert into the table and also to read from the table to display on the form. Could you simply have them key the date [...]

View Answer   |  May 12, 2009  2:27 PM
Access forms, Access Forms Database, Microsoft Access

Access password protected URL and download the output
i want a program in java. By the way can we use SOAP for the above problem.

View Answer   |  May 12, 2009  7:01 AM
Java, SOAP, Web development

sql Help
<pre>SELECT * FROM your_table WHERE your_field NOT LIKE ‘XX%’</pre> In this case XX is the two-character pattern.

View Answer   |  May 11, 2009  5:53 PM
SQL, SQL Fields

Updating Combobox after new data added
which language you are using? are you looking for concept or code

View Answer   |  May 11, 2009  5:01 PM
Access 2003, Access 2003 forms, Access forms, ComboBox, Microsoft Access