Error when tried to update the SSOledbGrid connected to with Sybase Server Database
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
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
PL/SQL and Excel
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
SQL
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
SQL
VB Asynchronous Recordset
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
VBA
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
VBA
MySQL CrossTab Query
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
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
Long running Delete Jobs
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
SQL
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
SQL
Best PL/SQL Tool?
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
SQL
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
SQL
VB Report Writer
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
Visual Basic
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
Visual Basic
execute immediate
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
Architecture/Design, SQL
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
Architecture/Design, SQL
IT Grads
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
VB.NET
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
VB.NET
High-Level Overview via “Straw-man Diagram”
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
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
SAP Online store
Try www.sap-press.com or amazon has a really good selection of SAP books. John.
View Answer
| May 27, 2004 9:27 PM
Development
Try www.sap-press.com or amazon has a really good selection of SAP books. John.
View Answer
| May 27, 2004 9:27 PM
Development
Project testing
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
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
VB Reversible Collections
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
Visual Basic
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
Visual Basic
VB and ODBC
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
Visual Basic
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
Visual Basic
Database groups in Ireland
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
Oracle, SQL
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
Oracle, SQL
SQL string limitation
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
Architecture/Design, SQL
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
Architecture/Design, SQL
Delphi run-time error
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
Delphi
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
Delphi
JavaScript window.print() does nothing
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
JavaScript
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
JavaScript
hardware/software configuration for web site hosting
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
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
Powered By SQL Server
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
SQL
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
SQL
