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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. KrisUK

    Trouble with a Select query

    Hi ujb, Thanks for the quick reply!! The first option worked like a charm I used select E.EMP_REF,E.FORENAME,E.SURNAME from EMPLOYEE_DETAILS E where not exists (select * from ONE_OFF_TRAINING t where e.EMP_REF = t.EMP_REF and t.ONE_OFF_COURSE_TITLE=:ONE_OFF_COURSE_TITLE) ORDER BY E.SURNAME")...
  2. KrisUK

    Trouble with a Select query

    Hi, I'm trying to work out a way to find the following info from a table called TRAINING: EMP_REF COURSE_REF 1 1 1 2 1 3 1 4 2 1 2 2 2 3 etc From this data I need to find which employees have taken a...
  3. KrisUK

    Interbase 6.5 server crashing

    Hi Martin, Thanks for the reply, you are right as I found this to be the problem after much experimentation!. The problem for me is my server has two nics and IB 6.5 IBEvents component can only work with one, however I did find the AutoRegister property to also be problematic as you suggested...
  4. KrisUK

    Interbase 6.5 server crashing

    Hi all, I have a remote database sitting on a Windows 2000 Server machine running Interbase server 6.5. I have around 10 clients connected through an application written in C++ builder with Interbase Express components (TCP connection). Recently I installed the application on another machine...
  5. KrisUK

    Create Table in interbase (runtime)

    OK thanks, could you give me an example of this please? Thanks Kris
  6. KrisUK

    Create Table in interbase (runtime)

    Hi, Im looking to create tables at runtime using CBuilder 6 and interbase, preferably using a stored procedure. Ive tried a few different methods without success and can find nothing on the net. Any advice would be appreciated. TIA Kris

Part and Inventory Search

Back
Top