What is the error text? Do you have to use adlockpessimistic or can you use adlockbatchoptimistic or some other type of locking?
View Answer | July 16, 2004 3:40 PM
ActiveX, Adaptive Server Enterprise, Database, DB2, Development, Oracle, Servers, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Sybase, Sybase EAServer, Visual Basic
Yes, definately. I had a contract late last year that, for some reason not easily discernable for us mere mortals, the client wanted to change from an existing Visual Basic application to an Oracle solution within an Excel document. I was required to produce PL/SQL and SQL code to replace the Visual Basic code and [...]
View Answer | July 16, 2004 7:37 AM
Check out this article for a detailed code sample http://www.host-web.fr/iishelp/adc/docs/adcdg02_1.htm
View Answer | June 20, 2004 2:11 PM
Check out this link http://www.sqlteam.com/item.asp?ItemID=2955 This code is for SQL Server. You will need to adapt it for mysql
View Answer | June 8, 2004 1:15 PM
MySQL, PHP, VBA
I’m afraid it is a manual process. ST05 will tell you which indices are being used. But you will have to manually compare the code to the index, to see if it is suitable. I stand to be educated if anybody knows a different / better method.
View Answer | June 7, 2004 7:05 AM
This has got to be PL/Sql Developer. It very inexpensive per desktop license (less than 300.00) . It also has excellent debugging facilities, code templates, color coding, standard reports for DBA & devleloper, export/import. Just to name a few. HTH Frank P.
View Answer | June 4, 2004 10:45 AM
Crystal Reports from Business Objects ( www.businessobjects.com ) is a good report writer and can be called from VB.
View Answer | June 3, 2004 9:20 PM
Oracle: EXECUTE IMMEDIATE is the replacement for DBMS_SQL package from Oracle 8i onwards. It parses and immediately executes a dynamic SQL statement or a PL/SQL block created on the fly. Dynamically created and executed SQL statements are performance overhead, EXECUTE IMMEDIATE aims at reducing the overhead and give better performance. It is also easier to [...]
View Answer | June 3, 2004 1:50 PM
Basically you should test for knowledge of database connectivity using ado.net use of sqlconnection, sqladapter, etc. Population of datagrid Concepts of datasets
View Answer | June 1, 2004 12:59 PM
This may depend on your mix of platforms, databases, development staffing, packaged products, maintenance agreements and overall strategy of your organisation. If you can give us more details, it will be easier to answer these questions. In simple terms, in some circumstances, this is a good method, there are development languages and other tools that [...]
View Answer | June 1, 2004 11:35 AM
Data analysis, Database Management Systems, DataCenter, Development, IT architecture, Software Quality Assurance
Try www.sap-press.com or amazon has a really good selection of SAP books. John.
View Answer | May 27, 2004 9:27 PM
Hi, I am not sure what methodology we adopted in our 4.6C upgrade last year however our testing approach comprised the following steps: 1. Functional testing – all utilised functionality defined and tested by BA’s 2. Integration testing – all SAP interfaces defined and tested 3. Performance testing – simulated load 4. User acceptance testing [...]
View Answer | May 27, 2004 9:13 PM
Software testing, Tech support
This won’t help much I know, but I think the Key has to be a string so you may have problems when your data is not this type. Cheers M
View Answer | May 27, 2004 9:41 AM
Hi Carbon, They can be either depending on how you do it. Pass Through queries [harking back to MS Access] are where code is executed directly against the database using for example a Connection object to execute SQL strings. Direct access is when you work with an ADO recordset that you instantiate, manipulate and send [...]
View Answer | May 27, 2004 6:33 AM
I don’t happen to know of one specific to Ireland but I looked at a rather old list of Oracle links and user groups that I have and you could certainly go to www.uk.oracle.com which may have links to user groups in the uk. I also have www.oracleuser.co.uk as a user group link. If anyone [...]
View Answer | May 25, 2004 9:40 AM
The limit of the VARCHAR2 datatype (and presumably for CHAR as well) is indeed 4000 characters. If you need more, you can use CLOB, which is easily converted to/from VARCHAR2 or CHAR. On the other hand, CLOB columns cannot be indexed (AFAIK). Maybe you can define a function-based index on to_char(clob_column)… Regards, ActorJack
View Answer | May 24, 2004 9:44 AM
Hi, I’ve seen this type of thing before and have traced it in the past to permissions issues, however that is not to say that permission settings are always the problem! It might be worth considering.
View Answer | May 24, 2004 6:41 AM
I’ve noticed after modifying ESS screens to open a new window or having a print window pop up that it always failed for certain users. Turned out they had “Pop-up” blockers installed on their browsers which caused it to fail. Just a thought.
View Answer | May 19, 2004 9:56 AM
First, get a domain hosting site. I use www.1and1.com. They have PHP and MySQL included with the monthly charge. If you want to use Oracle, please be prepared to pay big bucks. Not only that, I don’t know of any that would host Oracle, but I don’t know them all. If you decide to host [...]
View Answer | May 18, 2004 5:25 PM
Implementation, Oracle, Web site design & management
Not intended as a non-answer, but have you considered _not_ advertising the database that’s backing your website? Is it just me, or are “powered by” graphics best left to corporations touting their own products or to open-source advocates upping their geek factor (and simultaneously advertising open-source)? I shy away from advertising the software I’m using, [...]
View Answer | May 18, 2004 10:27 AM