Search results

Thanks for the response, I'll check into Crystal commands.

Nice. With this concept (multiple joins) I was able to find pleanty of resources on the web. I'll post one such site for anyone who's interetsed: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6188 Thanks again.

Say for simplicity that we have two tables. One table is called shoes. It contains an index field and a description field. Next, say we have a table called people. In the People table, there are two columns - one for work shoes, and the other for leisure shoes. We store the index of the shoe...

I'm not a 4gl devleoper. I'm a support specialist trying to help a customer get the most out of their software. The tools that I have access to are SQL based. (no Progress development license =(

Thank you for the response. I will use your query to get the job done, although I still wonder how the query would look in SQL.... It is definitely possible.

We're trying to delete "all items in the database that don't have a UPC associated with them". Our primary key is "item#" and the tables are PUB.item and PUB.upc. items are in the item table, and upcs are in the upc table. each UPC has an item number associated to it in the "item#" field. I...

I averted the problem by using a Crystal/VB formula instead of an expression. I then used the split() function to parse out the desired field. At that point it was a trivial task to get to the subfield (extent) that I wanted.

I've created a Crystal report to chart sales totals by date and by store from a large Progress database. In Crystal the data looks great, I'm using SQL expressions to parse out discrete values from extented fields using pro_element() ... However in my application, when I run the report I...