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

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

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

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

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

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

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

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

writing html code manually and using programs like ms frontpage
Using Front Page is okay, but bear in mind that if your ISP does not support Frontpage extensions, some of your functionality may be lost. Also, Frontpage doesn’t work on portals, as SAP, typically, actually use their own version of html.

View Answer   |  May 18, 2004  3:54 AM
HTML

Accessing Help File
Need to know what kind of Help file i.e. Windows (.hlp) or HTML (.chm). Also what programming language are you using.

View Answer   |  May 17, 2004  10:53 AM
Visual Basic

Catalog Shopping Autotest
I have used WinRunner software to create test transactions for GUI screens. This software is easy to use (made by the same company as LoadRunner) and is similar to recording Macros in Microsoft Excel.

View Answer   |  May 14, 2004  12:51 PM
ABAP, Automated, Functional, HTML, Java, Performance/Load, Software testing tools, Web

Web Services & Firewalls
I currently use Microsoft’s ISA server to publish our web services and have done so for the past 3 years. It has been very stable and provided a great application level firewall for our applications. I would suggest that anything you choose have some type of application layer filtering and a 2 layer approach (i.e. [...]

View Answer   |  May 14, 2004  10:27 AM
Firewalls, Forensics, Incident response, Intrusion management, Network security, VPN, Web services, Wireless

Oracle Reports development & Oracle Conurrent Manager
I haven’t seen this problem, but just wondering if you’ve tried contacting Oracle support directly and/or tried placing a ticket with their Metalink portal for information on this problem. It has been my experience that they are very helpful with these kinds of issues.

View Answer   |  May 14, 2004  10:09 AM
AIX, Oracle, Oracle Application Server, SQL

Default values in Oracle packaged procedures
If you need to hide values from people who is working in the same schema then your idea with wrapper does not work, because wrapper does not obfuscate literals. Since schema is the same then anybody can dig into wrapped package body and find values there. (By the way, starting from 9i you are prohibited [...]

View Answer   |  May 13, 2004  10:20 PM
Oracle, SQL

ProgressBar Control as Marquee
A quick and easy way would be just to play with the status bar text. Set up your base “bar”: [———-] and then move a character back and forwards: [*———] [-*——–] [–*——-] [—*——] [—-*—–] etc Shouldn’t be hard to do in JavaScript.

View Answer   |  May 13, 2004  5:41 PM
C, VB.NET

ORA-00600 INTERNAL ERROR when inserting
1) can’t group by a column you don’t reference 2) the distinct may return more than one value

View Answer   |  May 13, 2004  1:51 PM
SQL

DISTINCT or work-around
Hi Vijay. I am going to have to recite from the Gospel of Tom Kyte on this one: benchmark, benchmark, benchmark Do not just look at the query plan… tkprof your results to see the timing of these queries. Populate test tables with tens of thousands of rows (using a pl/sql script) and see how [...]

View Answer   |  May 13, 2004  1:01 PM
Oracle, Performance/Load, SQL, Tech support

Database Management: Comprehensive Admin Tools; Business Intelligence; Integrations/Migrations
Eric, I would have said Platinum but they got bought out by Computer Associates. So I would suggest Quest Technology or BMC. I would swing towards Quest most of the Platinum devolopment and support ended up working for them. Each company has toolsets that allow you to manage several diffent DBMS from one console. I [...]

View Answer   |  May 13, 2004  8:45 AM
Business/IT alignment, Data analysis, Database Management Systems, IT architecture, Knowledge management applications, Online transaction processing, Systems management software

Reading Long Column
Proceed as follows: SQL> SET LONG 100000 SQL> select trigger_body from dba_triggers where trigger_name = ‘NAME’; Here NAME stands for the trigger that you want to display. You can set LONG to any higher value if your trigger code is very long.

View Answer   |  May 13, 2004  8:29 AM
SQL

Clear VB variable
Probably one way would be to reset the variable to a default value after the initial processing.

View Answer   |  May 12, 2004  11:09 PM
Visual Basic