Search results for query: *

Hello all, I am using Crystal 7.0 to report from a cash register's electronic journal stored in Btrieve. I can't figure out how to tell the Record Selection Builder to select ALL lines from the transaction that contains a product from department 'meat' on '2009/01/02'. Table: Trans Date...

The original syntax was used in Pervasive PSQL v10 and completed successfully within a few minutes. I tried the suggested change using "where in" but this does not seem to be supported. Many thanks for your help Mirtheil in recognizing that v8 was the issue.

The result set is around 700 records. A similar select query using the same join took about 5 seconds. I let the above query run for more than an hour and it still did not complete. Can you suggest a way to rewrite this query to avoid the WHERE EXISTS? Perhaps this is the culprit. I am...

I am relatively new to SQL and would appreciate your insight on formulated the following statement. I have two tables representing the header (ek2122) and detail items (ek2124) of a purchase order. I would like to update a value in the details based on a join between the two tables. Here is...

I would like to use the view in Crystal. I don't believe that it will support such a complex query unless it is put into a view. Is there a way to use aliases to get around a union?

Sorry for the bump but I am completely stumped. Mirtheil, you seem to be the expert of this area. Any suggestions? I apologize that my SQL knowledge is weaker than others.

Try accessing your database via the DDF files instead. If you are set on using ODBC, check to see that your database is not set to read-only.

Are you accessing via Terminal Server (remote desktop)? You need to be signed in directly to the server / console as DjangMan has mentioned.

Hello, I am new to SQL and need a hand creating a view in Pervasive PSQL v8. The first table called ITEM2 contains a text field which needs to be split apart into 10 separate fields and joined to a table called PROMOCODE. The following select statement is not pretty but works so far for the...