Search results for query: *

Hello all. I keep going back and forth on this as to whether it's an Oracle issue or a MySQL. So, honestly, I'll let you decide and will take your advice. Not sure if this is allowed, but I've cross-posted this question in the Oracle: Oracle release - 8 and 8i forum, with a similar message...

Hello all. I keep going back and forth on this as to whether it's an Oracle issue or a MySQL. So, honestly, I'll let you decide and will take your advice. Not sure if this is allowed, but I'm going to cross-post this question in the MySQL forum, with a similar message there that it is...

Hello all. OK, I know I know: DON'T EVER USE THE LONG DATATYPE. I understand. But here's my situation: I'm accessing data through a db link that's from from a MySQL database. Like SQL Server (I guess), they have this char datatype (I don't know the official name of the datatype in MySQL) that is...

Hello folks. I am new to MySQL (as you will soon see, no doubt!!). New, as in, like, 2 days new. Can't even hold my eyes straight yet (if you're a parent, you might get that). Our entertainment division uses MySQL as the database of choice for their various websites. They are not...

Hello folks. I am in Oracle Enterprise Manager Console. In the <database_name>: Instance > Sessions > <target session>. I double-click the icon in the far left column and it pulls up the "Edit Session" screen. I go to the "Long Operations" tab and watch the query I'm running. Currently, it says...

Hello folks! Does anyone know of a way to concatenate two fields when loading via SQL Loader? I have data that looks like: ID,Area_Code,Phone_Number 1,704,1234560 2,305,7891230 3,904,456890 I have a table that has a PHONE column, but no columns for area_code and phone_only. My control file...

Hello all. Is there any way to do mortgage calculations in Oracle? Like Principal payment, Interest payment, APR, etc? Thank you. -Mike Kemp

Hello. Does anyone know how to get a report of number of pages printed/day remotely. For example, suppose I have a person in another office telling me they printed 50k pages yesterday, and I want to see for myself that 50k pages went through the printer. Is there a way to do this? Thank you. -Mike

Hello and thanks for reading my question. We have a mixture of Office 2000, Office XP and Office 2003 clients. I just created an application that uses early-binding to send out e-mails via MS Outlook. The entire application fails when it is run on a machine that has a different version of MS...

Hello. I have some code: set xlwks=excel.worksheet with xlwks.pagesetup zoom=false fittotpagestall=1 fittopageswide=3 end with I run this code from MS Access. When I do this, the print is quite small (but it has to be this way). However, I find that if I go Excel and got to...

Hello. I have a procedure in Oracle that calls another procedure. The second procedure takes a view name, passed as a parameter, and outputs the view to a flat file. Every time I run this procedure in Oracle (using TOAD, etc.), it works fine. However, when I run it from MS Access using ADO, it...

Hello. I have the following code: set serveroutput on declare v_doc_text varchar2(2000); v_parser xmlparser.parser; v_doc xmldom.domdocument; v_n xmldom.domnode; nnm xmldom.DOMNamedNodeMap; n_l xmldom.DOMnodelist...

Hello folks. Wow...just got back to Tek-tips after some time away. The new look is really sharp. Question: I just finished some experimentation with populating a native MS Access table with the data contained in an ADO recordset. Initially, I ran a loop on the ADO recordset, and imbedded an...

Hello folks. I have a procedure where I'm automating Excel. 1 Option Compare Database: Option Explicit: Option Base 1 2 Dim xlApp as Excel.Application,xlWkb as Excel.Workbook, xlWks as Excel.Worksheet 3 sub some_procedure 4 on error goto errorhandler 5 set...

Hello. I have the following code: procedure someproc as vcSQL varchar2(1000); begin vcSQL:='drop table sometable'; execute immediate vcSQL; vcSQL:='create global temporary table gttbl_table1 (col1 varchar2(10))'; vcSQL:=vcSQL||' on commit...

Hello. Suppose you have a procedure that loops around say, 1000 times. You want to update the user as to the progress of the procedure via the Status Bar. Is there a way to update the status bar via VBA code, like at the end of a loop in a procedure. Thank you. -Mike Kemp

Hello. Is there an easy way to transfer the contents of an ADO recordset to an Access-native table? Of course I could loop through the recordset and do "insert into...", but this seems like it might be a little tedious. Maybe not, but I thought there might be some command like copy to.... Thank...

Hello. Is there a way to see if the person logged on has administrator privileges on the machine? I've used the environ("username") function to obtain the log-on name and I've checked it to see if that name is "administrator". Now, however, I need to check system privileges, not just the log-on...

Hello. I'm outputting a flat file using the utl_file package. I have something like: create or replace procedure prc_OutputSomeThing as cursor cur_somecur is select col1,col2,col3,col4 from sometable; vcOutput varchar2(500); rwSomeCur cur_somecur%rowtype...

Hello. Is there a way to see if the person logged on has administrator privileges on the machine? I've used the environ("username") function to obtain the log-on name and I've checked it to see if that name is "administrator". Now, however, I need to check system privileges, not just the log-on...