Search results

I want to find a particular string stored in any field / table in the database? Can you please help? If I try to run a query as below, it says unknown or ambiguous table. How can I check for the data stored in the fields? for each _file no-lock, each _field of _file where _data-type =...

thanks. I resolved the issue Thanks to all of u for helping me. I resolved the issue. Actually, the system has another table which keeps track of the issues/shipments done for the orders. I was unaware of the fact that I had to check only for shipped orders. This table has a sequence number...

thanks The table has a character field (which is the primary index) which stores a number and a prefix to identify the record (the prefix is to know which program had been used to create the record, so the identifiers are like "ca190", "so120", etc.), a date field to store the creation date, a...

The client has a customised table in which they are adding records which have some meter readings. I need to retrieve the last one added to compare with the values they are entering now. As I said earlier, I can't write a create trigger (which I would essentially require to write on the table...

Hi, I need to write a query to retrieve records in the order in which they were added to the table. I can't add a timestamp to these records or sequence (since records are added to the table from many programs and I cannot change them) or write a schema trigger for it. Is there any other way...

Hi, I have just started with Progress and I have seen the use of statements such as STRING(TODAY,"99-99-9999":U) . What does ":U" specify? Thanks, Anu.

I have written a program for uploading user details into the wdm database of TPT. This displays ( using {&out} ) whether a user was loaded or not(if user id already exists in the database) for each user in the file. I am getting a "CGI Application Timeout" when I run this program. I have no...