Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Analyst2004

  1. Analyst2004

    ComBine Worksheets into one Workbook

    I am new to VB and I have a simple requirement - I have a directory which has 3 excel sheets and I need to combine them programatically into one workbook so that each sheet is on different tabs(wksheets) within that. I want to do this via Access/Vb when user pushes a button. Directory...
  2. Analyst2004

    String Manipulation

    I have a requirement to get the IP's stored in a table in a standard format. The IP's are as below. I'm just taking into consideration the first Octant currently. 010. 011. 167. 001. 065. 170. I need to change these in the format below and remove the zero padding.As there are millions of such...
  3. Analyst2004

    Customising Temporary Substitution variable - &

    A very basic question about SQL , about Temporary Substitution Variable that is '&' Ampersand Whenever I use '&' to accept input from user before running a sql statement, I get a standard prompt. See Eg. below. SQL> Select * from Emp where empno = '&eno' ; 'Enter value for eno:' Is...
  4. Analyst2004

    Pass Through Query from Access to Oracle

    ok foolio12 & PHV I tried your advice and in the query design - properties saved the ODBC info (which appended few things to my string as below.) So, on copying this in my Code, I was able to avoid the prompting of server & user info and was able to run it Successfully. THANKS A TON...
  5. Analyst2004

    Pass Through Query from Access to Oracle

    Thanks friends for your suggestions.... I used ORACLE ODBC Driver instead.I created a System Data source and tried to run the code. It is ABLE to connect. However each time it asks for the Service name and User name (pwd already populated). Even though I am supplying the connection service...
  6. Analyst2004

    Pass Through Query from Access to Oracle

    I need to query Oracle database while I am in Access. I am able to programatically create a passthrough query and change its definition as required. My problem is that my query gives ODBC error and can't connect first time. However, if I manually do a sample passthrough query and then come...
  7. Analyst2004

    NOT-IN problem

    I am trying to run a query select id, subid, brand from xyz where code = 'A' and (id,subid ) NOT IN (select substr(z_id,1,3) , substr(z_id,4,3) from ABC where model = 'P') My problem here is that the "NOT IN" does not work as expected and returns all rows which meet the condition...
  8. Analyst2004

    Sqlplus / Batch file Question - Windows platform

    Ya, plus80 -s works... I am not getting the sqlplus window now. thanks
  9. Analyst2004

    Sqlplus / Batch file Question - Windows platform

    I am running a Batch file (.bat) from Windows 2000. This Batch file invokes sqlplus and calls a sql script.Once the script is executed, I get a dmp file in the specific location in C Drive as coded. However, when I execute the batch file which invokes a sqlplus -s session, I get two windows 1...
  10. Analyst2004

    ORDER BY - QUESTION

    Order by Input - Here means that I want to arrange the rows as per the data supplied by the user. I just want the output to be just as the user entered the input values, and not sort it any default order. I cannot use union all as I have multiple OR-conditions and Union will make the stmt too long.
  11. Analyst2004

    ORDER BY - QUESTION

    Thanks Turkbear for the suggestion, but with each DECODE stmt, you notice a new variable, (which however represents the same column in the table). BUT - since I want the user inputS in same SQL stmt, I have to use multiple input variables, SO the QUESTION still remains unanswered. more...
  12. Analyst2004

    ORDER BY - QUESTION

    I take 4 pair of inputs from user in a SQL query with '&Variable'. The input is part of DECODE statement(in the Where -Clause) and it pulls the data from the Table as per the DECODE condition. However, my result set is not in the order of the user-input. I want to sort it as per the data user...
See more

Part and Inventory Search

Back
Top