Client Access File Transfer in CL Program
Did you run a STRPCO before your STRPCCMD ? It should work fine.

View Answer   |  October 18, 2004  3:37 AM
Development

Data dictionary find time of long running query
Jim: I’m not sure what you mean by ‘limit it to a specific query’. Do you mean search for specific query text with LIKE in v$sqltext or v$sqlarea?

View Answer   |  October 17, 2004  6:13 AM
SQL

Saving an email in an Access Database-2
Try setting the field in the access table to OLE Object. I’ve never done this before, but I would use the .save method to save the email as .msg or .txt to a temporary location then insert it into the field programmatically. Here’s the rub. I am not sure if you are able to insert [...]

View Answer   |  October 16, 2004  7:45 PM
Development, Exchange, Visual Basic

Excel Help
As far as I know you cannot implement a use counter in a template because when the user saves their data the template is not updated. This is as it should be otherwise mistaken input would alter the template for the next user in ways you never intended.

View Answer   |  October 15, 2004  10:21 AM
Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, Hardware, Microsoft Systems Management Server, Networking, Programming Languages, Security, Systems management software, Tech support, VBA, VBScript, Visual Basic

Oracle In Linux
Pretty broad question, but for installation issues with Oracle on Linux, I have found this site very helpful if used with the installation notes as well as some the documents available on Metalink. Good Luck http://www.puschitz.com/OracleOnLinux.shtml

View Answer   |  October 15, 2004  10:15 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS

Manipulating members using CL
I have used the following logic to extract information about members in a few programs. There is no need to declare the variables found in the file as once the file is declared the CL knows the variables. You need to run the command to create the list once so that the file exists before [...]

View Answer   |  October 15, 2004  8:55 AM
Programming Languages

Accessing a MySQL database using Visual Basic.
Using a latest version of ADO you should be able to connect to your database (though I have not worked with MySQL and that may be different). As for deployment, you can build some initation procedures that create the required settings (I know these are API based calls but we have to get the thing [...]

View Answer   |  October 13, 2004  5:39 PM
Development

Finalize
The Finalize event only fires when the Garbage Collector (GC) destroys the object. The GC may not “collect” (destroy) the object until some time has elapsed. I.E., the GC works on its own schedule… If you want to do some cleanup when you are done with an object, you should use Dispose instead and call [...]

View Answer   |  October 12, 2004  4:14 PM
ASP.NET, VB.NET

database design
Separate out the tables into two parts so that order entry information and product information are separate. If each product or product category has a unique key, then you can fill the order-entry table with key information (INSERT INTO .. (SELECT …)) rather than string values. Provide separate forms for order entry and for product [...]

View Answer   |  October 12, 2004  5:07 AM
Development, J2EE, Java, JavaScript, JSP, SQL, XML

Mpeg video streaming problem with Windows Media Player
My knee-jerk recommendation is to add information to the web page pointing to the latest Media Player patches. Also get users to check that their MP configuration is set for the right speed of internet link. Make sure your server is set up to send the file with all HTTP caching options turned off.

View Answer   |  October 12, 2004  5:04 AM
Web development tools

Datawarehouse building – datamart specification: how would you engage a scattered userbase?
Our customer base is not as widely distributed as yours, but in our ERP implementation we’ve established a Change Management group to liaise with customer “Change Agents”. Our CMs are very survey oriented for getting information from customers, using the Change Agents to champion the surveys. They are successfully using demonstrations (PPT) and web-based articles [...]

View Answer   |  October 11, 2004  4:27 PM
Data analysis, Data warehousing applications, DataCenter, ERP, Financial services applications, Implementation, Information risk management, Knowledge management applications, Remote users, Transaction Systems Architects

database design-2
Howdi, I would design this using relational database design, not worrying about how they want to display the data. i.e. product – product_id – color_id – size_id – price, etc. co_color – color_id – color_name co_size – size_id – size_name customer – customer_id – name, address, etc. customer_order_product_list - customer_product_list_id - customer_id - order_id - [...]

View Answer   |  October 11, 2004  10:17 AM
Development, J2EE, Java, JavaScript, JSP, SQL, XML

Source code recovery from an object
SSTG? RPG Decompiler Converts observable RPG/36, RPG/38, RPG/400 program objects into new source members, retaining field, EXCPT, SUBR names. All original source restored except for comments. SSTG DDS Decompiler Creates new source members from compiled DDS objects for physical, logical, printer and display files.

View Answer   |  October 11, 2004  6:50 AM
Development

ORA-01033 Oracle Initialization or Shutdown in progress & cannot log into sqlplus.
What Oracle version you are using and on what platform/OS?

View Answer   |  October 7, 2004  10:52 PM
DataCenter, Development, Oracle, Storage, Tech support

Grpahs/Charts
Check out www.guistuff.com

View Answer   |  October 7, 2004  11:52 AM
ActiveX, HTML, Java, JavaScript, LotusScript

ADO DSN ACTIVE DIRECTORY
Check out this article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdrefadsprovspec.asp

View Answer   |  October 7, 2004  9:54 AM
VBScript

Issue with SQL Query from two tables that have a 1 to many relationship
Hi Trina, Assuming you are using at least Oracle 8 – you could use an inline view to pre calculate the summary level data and then join this to the detail records. I have tried to rewrite your query so: SELECT my_view_summary.wbt_name, sum(decode(view_work_detail.htype_name,’OT1′,view_work_detail.wrkd_minutes/60,0)) tot_OT1, sum(decode(view_work_detail.htype_name,’OT2′,view_work_detail.wrkd_minutes/60,0)) tot_OT2, my_view_summary.totua FROM (SELECT workbrain_team.wbt_name, view_work_summary.wrks_id, sum(case when view_work_summary.wrks_authorized = [...]

View Answer   |  October 7, 2004  3:28 AM
SQL

Updation of Oracle tables
As far as I know, indexing will degrade performance as indexes have also have to be updated with every update of the table. For the best method, I’ll get back..

View Answer   |  October 6, 2004  11:57 PM
Development, Tech support

Software Development in Java
You should look at Oracle JDeveloper suite. IT has migration tools/guides from Oracle Developer. Other then that, I will recommend JBuilder X and Eclipse. Both are identical in terms of IDE / Debugging capabilities. But JBuilder provides better integration with Web / App servers for the kind of applications you are looking at. On the [...]

View Answer   |  October 6, 2004  4:09 AM
C, Development, Dreamweaver, HTML, J2EE, Java, JavaScript, JSP, PHP, SQL, XML

Updating a number field when one record is deleted
If I have understood your question, once you have deleted the employee from the database, you need to increment all employees numbers below that person by 1. If this is the case, a simple update query should achieve this, such as: UPDATE Contacts SET Contacts.FaxNumber = contacts.faxnumber +1 where faxnumber > 10; Steve

View Answer   |  October 6, 2004  3:26 AM
Development