Did you run a STRPCO before your STRPCCMD ? It should work fine.
View Answer | October 18, 2004 3:37 AM
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
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
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
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
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
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
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
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
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
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
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
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
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
Check out www.guistuff.com
View Answer | October 7, 2004 11:52 AM
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
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
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
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
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