Search results for query: *

Hi all, In my laptop, I have installed an oracle 8.1.7 database with character set WE8ISO8859P1. I want to install a product and the installation will work if and only if I have an oracle database with character set UTF8. I can't alter the database with this character set (see below) : SQL>...

Hi all, I need to audit servers and users activity with Impromptu Web Reports, PowerPlay and Visualizer. I have found the solution for Impromptu Web Reports and PowerPlay. I need to know if it is possible to have in a log file following information : - the report name - the username who...

Hi all, When analyzing statistics for an Oracle 8i request, what is the significance of following parameters : - physical reads - block get - consistent gets - blocks changes - consistent changes - buffers get in trace optimisations How are the following parameters used : - block buffers =...

Hi all, Is it normal to have more Rollbacks than commits in an Oracle 8.1.7 production database? Thanks for your feed-back. Palmero.

Hi all, In a Citrix environment, I have problems of processes remaining in the server even client users are disconnected. The following programs are INACTIVE in the server and anyone is connected : - CTMAPP32.EXE - CFSAPP32.EXE - INTREX32.EXE - SLAPP32.EXE Do you know if these programs are let...

Hi all, The following SQL syntax does work on Oracle, but not on Sybase. Do you have a workaround without using a temporary table? Thanks in advance for your help. SELECT T1.code,T2.label FROM (SELECT ......) T1, (SELECT ......) T2 WHERE T1.code=T2.code; Palmero.

Hi all, The following SQL syntax does work on Oracle, but not on Sybase. Do you have a workaround without using a temporary table? Thanks in advance for your help. SELECT T1.code,T2.label FROM (SELECT ......) T1, (SELECT ......) T2 WHERE T1.code=T2.code; Palmero.

Hi all, I want to install on my PC a Personal Oracle 8i and an Oracle Client NET8. How can I proceed to install the 2 versions on my machine? Thanks in advance for your answer. Palmero.

Hi all, I am populating an Oracle V7.3.4 table from a flat file using the following procedure : create or replace procedure Charge_produit is -- declaration of variables BEGIN WHILE MY_GET_LINE(file_handle,ligne) LOOP BEGIN INSERT INTO TMP_PRODUIT values (...

Hi all, I am loading an Oracle V7.3.4 table from a flat file using the UTL file package. This flat file is transferred from a mainframe to a Windows NT4, Pack 6 server. During the transfer, some caracters are converted. For example, the word "PRêt" becames "PR T" and in this...

Hi, I am developping an application with Visual Basic and I want to perform a menu using the menu editor. I don't have the documentation which explains the different properties of the window editor. What is the meaning of following caracteristics : - Name - Index - HelpContextID - Checked -...

Hi all, I have a Windows NT server with Oracle 7.3.4 installed and this oracle 7.3.4 is handling a datawarehouse. Let's name this machine server A. We have bought a new server (server B) and I want to transfer the A machine database into the B machine using a physical copy of machine A...

Hi all, I want to develop a VB6 application and I want to know how to build a menu. Thanks in advance for your help. Palmero.

Hi all, I am developping with Visual Basic 6.0 attacking an Oracle 8 database. I have a table (code primary key, description). I want : - to add a given code if the code does not exist. - to delete a given code if the code exists. If you have a sample code managing the evolution of such a...

Hi all, THIS IS A SAMPLE CODE USING ADO WITH ACCESS 97. I WANT TO USE THE SAME CODE WITH DAO. HOW TO WRITE THE CODE : Dim Conn as connection, Rs1 as recordset, Rs2 as recordset Set Conn = new Connection Conn.Open YourConnectionString Set Rs2 = new recordset Rs2.open "t2", YourConn...

Hi all, In a VB6 procedure, I have a recordset from table t1 and i want to modify some fields and insert the new value of this recordset in another table t2. t1 and t2 have the same structure. Here is my code : SQLquery = "select * from t1" Set rs1 = db.OpenRecordset(SQLquery, , 3...

Hi all, I'm going to develop an application with visual basic attacking an Access database. I have to choose Access 2000 or Access 97. Any advise is welcome (network performance, multi-access, problems of Access 2000 compatibilty with platforms). Palmero.

Hi all, I'm new on MS Project. I have to roll-out 10 applications in 35 countries. Some colleagues will go in countries to install applications. I want to plan this activity in MS Project. I want to avoid the installation of two different applications in a country at the same time. One person...

Hi all, I am searching information about the following error message on Sybase 11.5: Number : 404 Severity : 19 Text : Too many ANDs or ORs in expression (limit %d per expression level). Try splitting query or limiting ANDs and ORs. Note that I have many ANDs in my request. Thanks in advance...

Hi all, I'm going to develop an application with visual basic attacking an Access database. I have to choose Access 2000 or Access 97. Any advise is welcome (problems of Access 2000 compatibilty with platforms). Palmero.