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!

  • Congratulations bkrike 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 amerbaig

  1. amerbaig

    Opnion About inline view

    I am working in very important sector in Canada and using Oracle widely. There is a group of experienced managers and developer who discourage to use inline views. They have some reasons in addition to (may be misleading) information pass on by Oracle. According to them Inline views are “devils...
  2. amerbaig

    How to use Bulk Insert

    It gives me error like ---- Server: Msg 4832, Level 16, State 1, Line 1 Bulk Insert: Unexpected end-of-file (EOF) encountered in data file. When I chnage \n with \n\r the it then it appears Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 1...
  3. amerbaig

    How to use Bulk Insert

    I want to Load a text file in a three column Table with three fields, all comma separated like:- 923335100025,Amer,Baig 923335100017,Asif,Qazi 923335100089,Maz 923335120084,Tahir,Ch 923335120085,Waseem My format file is 7.0 3 1 SQLCHAR 0 20 ",&quot...
  4. amerbaig

    Sum of some Columns

    Output sould be Result 1 Customer Order_Amount Riz 100 Tiz 400 Result 2 Customer Order_Amount Biz 200 Ciz 300 I need both output as one output.
  5. amerbaig

    Sum of some Columns

    I have a table with two columns CustomerId ---- Varchar Order_Amount ----- Integer Now data is Customer Order_Amount Riz 100 Biz 200 Ciz 300 Tiz 400 Hiz 500 Uiz 600 I want...
  6. amerbaig

    How to scale the Oracle

    Dis somebody install OPS on Win2K? Please help Amer
  7. amerbaig

    How to scale the Oracle

    Please explain the procedure and process. I will be obliged. Regards, Amer
  8. amerbaig

    How to scale the Oracle

    I have two machines running on Win2K with Oracle 8.1.7 I want to do such a arrangments that my two databases running on both machines seems one to me. I am most concerned with space. I want to use one of the machine with 200GB free space. Is it possible to create one table space in which the...
  9. amerbaig

    Avoid Duplicate Records.

    1. I have text file of atleast 4 million records. 2. I want to export it into a Table (Tab1) using SQL Loader. I may chose other option. 3. During export the duplicate records should not be populated into Tab1. 4. Duplicate Records should be populated in Tab2 for re-checking. How to achive...
  10. amerbaig

    MS Flex Grid

    I have come to know that this is known limit. See following link See this article: http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q191006 Regards, Amer
  11. amerbaig

    MS Flex Grid

    I am adding 200000 rows in MS Flex Grid. It give me memory error. Is this max limit of Grid? Please advice Amer
  12. amerbaig

    Terminal Services

    I am logging to a Server using Terminal Services. Can I prevent some user based on IP. I also want to get a log of all users logged in to server. Please help me Regards, Amer
  13. amerbaig

    List(index) Limit crossed

    It gives me error Invalid procedure Call or argument COde I run is Combo1 = Combo1.List(40000) Combo1 = GetComboItem(Combo1, 40000) Regards Amer
  14. amerbaig

    List(index) Limit crossed

    Any work-around?
  15. amerbaig

    List(index) Limit crossed

    Dear All I am using combobox in VB and putting 33000 in index. It is not allowing me. It looks that I crossed the limit of integer. How to solve it? cmbName.List(33000) = "test" Please help

Part and Inventory Search

Back
Top