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 John Tel 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 jdu2006

  1. jdu2006

    OBID

    Are you going to change the object's name? Name change will not affect the object's members.
  2. jdu2006

    returning a *string and string[] from a function

    The codes may be reduced. you don't need destString and you should get length as a stopper of while loop. Be carefully coding in C, don't let memory leak.
  3. jdu2006

    WHY In Clause Faster than EXISTS clause?

    Great point. I will check my sql data and indexes and return you back. Thanks. John
  4. jdu2006

    WHY is LogicalFile but not index?

    After switched a data file from using logical file to index, the sql process got tremendously slowed down ( the file has millions records). Why and how can I fix it?
  5. jdu2006

    WHY In Clause Faster than EXISTS clause?

    I used to use the exists clause in my embedded sql statement and it was always working fine. But my process is suddenly chocked and I found out the problem was exists clause, if I changed the exists clause to in clause, the process would be resumed. Any idea? Please help and thanks in advance
  6. jdu2006

    WHY In Clause Fater than EXISTS clause?

    I used to use the exists clause in my embedded sql statement and it was always working fine. But my process is suddenly chocked and I found out the problem was exists clause, if I changed the exists clause to in clause, the process would be resumed. Any idea? Please help and thanks in advance

Part and Inventory Search

Back
Top