Search results for query: *

I'm having the same problem, but I'm also having a hard time locating this information on the CA support site. Does anybody know where I can find the latest DDFs? Chris Korzen Boston, MA

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 (...

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...

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...

Well, like I said, I'm trying to create a complicated query. The goal is not so much to get a dynamic table name as to assign an alias to a nested SELECT statement, which I believe you need to do if you use a nested query like this. But I wanted to keep it simple for starters. Really what I...

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...