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: *

  • Users: korzen
  • Content: Threads
  • Order by date
  1. korzen

    Conditional update

    I'm trying to write a single query to update a value in one field based on a value in another field. The updated value is pulled from one of two tables, which is determined by the value in the second field. I've tried this: UPDATE T1 tbl SET tbl.F1 = ( IF (...
  2. korzen

    Windows Authentication not working on WIN 2K workstation

    Hi, We recently upgraded a client machine to Windows 2000. Now, when attempting to access the server through OLE I get the old Login failed for user "(null)" error. SQL is set up for windows authentication, we are logging in as a domain user, and of course the users are set up as...
  3. korzen

    Access violation error executing stored procedure

    I am trying to use Crystal Reports to execute a Pervasive stored procedure. This procedure will populate a temporary table that the report will link to. My procedure works fine when executed from SQL Data Manager. However, when I try to link the procedure in Crystal I receive an "Access...
  4. korzen

    PSQL and nested queries

    I think what I'm referring to is a nested query. Please let me know if there's better lingo available than that. My problem involved trying to execute a complicated query against a 2000i database. It would work in a database like MSSQL, but I'm a little less well versed in Pervasive. So I've...

Part and Inventory Search

Back
Top