Is it possible to count the number of occurrences of the most frequent field? I have a product description which I have the most frequent description for, but I also need to know how many times the description has been found. I have tried to do a conditional count but get an answer of 0 every...
Hi. I am currently writing a crystal report in 8.5 which uses 2 sub reports. However when trying to run the report I am getting two error messages:
ODBC error: [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt
Then
Error with Database dll
It happens only...
I am attempting to launch an application which performs a scan of a PC when a user logs in. I have mapped a drive where the application resides with a directory within it that is used to store the data collected from the PC scans. I seem to be encountering a problem when trying to save the...
Hi,
I am trying to get the Hours and minutes elapsed from two datetime fields (both in the format DD/MM/YYYY HH:MM:SS)They both have hours and minutes as well as the date. I have tried using the DateDiff formula but I could only get hours or minutes. Is there any way I can get both?
Hi, I have developed an application which uses SQL Server. In order to create the relevant databases and stored procedures I am relying on Scripts. At the moment I am having to run these separately to the installation through OSQL. Is there a way to integrate the scripts into the Installation...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.