Search results for query: *

Sorry typo again - should have read update pmwrkord set pmwostatus = "Cancelled", spvend_code =”0236” where pmwrkord = “53022046”; update pmwrkord set pmwostatus = “Jobbing", spvend_code =”0440” where pmwrkord = “53022047”; update pmwrkord set pmwostatus =...

Thanks for that. I got it to work using the following UPDATE pmwrkord SET pmwrkord.pmwostatus = Decode(pmwrkord.pmwrkord_code, '53022037','In Progress', '53022036','Terminated', '53022045','Completed', pmwrkord.pmwrkord_code,pmwrkord.pmwostatus)...

This has updated the three records as required but set the remainder of the records in the table to null.

Sorry, it is a typo. I have about 60 records to update. I want to set the value of pmwrkord.status ( to either "In Progress" or "Terminated". I have been supllied a spreadsheet with these status values and I am trying to update the status codes according to the work order...

Hello all, How do I achieve the following in SQL?? update pmwrkord set pmwrkord.pmwostatus = 'In Progress' where pmwrkord.pmwrkord_code = '53022037' and pmwrkord.pmwostatus = 'Terminated' where pmwrkord.pmwrkord_code = '53022037; I have tried a few variations using case when expressions but...

Hi there, I hope you don't mind me contacting you personally. Quoting Your filter on the right table is nullifying the effect of your left outer join. This is something that has been discussed at length in this forum. Try to conditionally suppress the undesired records rather than...

We have a Sequel database and I connect to it via ODBC. I am connecting two tables CRFDetails and CRFData. I am filtering the CRFData table and using a date parameter. For some reason it still gives ne the same number of records whether it is an equal join or a left outer join.

Hi there, Is there any reason why a left outer join should not work with Crystal reports v8.5? Would it be a fault with our database or is there a bug in Crystal.

I don't know if this will be of any help but have you tried the the format for elapsed time. There is one in custom - [h]:mm:ss. The square bracket denotes elapsed time. Hope this is of help

I have a date in one cell dd/mm/yyyy and a time in another adjacenct cell hh:mm and I am trying to concatenate the two so I have "dd/mm/yyyy hh:mm". I have tried to use the concatenate formula and various others to no avail. Does anyone know how to do this?

I am trying to convert the text of a field into uppercase. I have tried the format field option and then going into the formula bar of the font option ie the X2 next to font. In this formual box I have selected the field and the uppercase function. It doesn't seem to work. Does anyone know...