Search results for query: *

Awesome Frederico - that took only 1 second to complete. Thank you! Regards Anthony

Hi George Thanks - that did work but the problem is that it is too slow. It takes 8 minutes to return the results on just 1 'lastname' - I have 850 lastnames so as you can see the complete query will take an impractical amount of time. Any ideas on how to make this fast? Cheers Anthony

Hi I am doing a query against a relatively large table. The basic query is as follows: select aud.record_id, aud.auditdatetime, seqno, substring(cast(aud.oldrecord as varchar(max)), (dbo.fnNthIndex(aud.oldrecord,'|',8) + 6), 4), substring(cast(aud.newrecord as varchar(max))...

Hi We have developed an application which uses java, spring 4.0.3, jsf and primefaces 5, running on Tomcat 7.0.50. We need to authenticate the user without a login form (i.e. it will pick the Windows user ID and compare that to our access management database). Basically we tried to set up...

Hi Guys Many thanks to you both - both approaches worked for me :) Cheers Anthony

Hi I am trying to dynamically retrieve my server name and then, from that, run a statement which will vary depending on the server name that is returned. I can obtain the server name dynamically but am unable to pass it to my IF statement; regardless of everything, @srvName in my IF statement...

Thanks for the reply. We had already tried this but unfortunately it doesn't work as the HeaderFooter class and Footer interface only allow strings to be added; they do not allow images/pictures... or are we missing a trick here?

Hi We are doing an inhouse java development. We are invoking Excel and are trying to insert an image into the footer. We have tried various libraries and have considered using .NET code adapted to VB Script but have not had any luck. Has anyone else encountered this problem and is their a...

Hi At work I am on Outlook 2003 connected to Exchange 5.5. When I do a Reply To All on an e-mail received from outside the company it puts me in the To list; when I Reply To All on internal e-mails all works fine. I've checked the web and all ideas revolve around people with multiple e-mail...

Hi. I guess I should have done the debug SELECT without being told. When I debugged I couldn't find the record, not because the date wasn't there but because of the format. The corrected syntax is: MM_editCmd5.CommandText = "UPDATE dbo.ProjectReport SET Project_ID = ?, Report_Objectives = ...

Hi Guys. I am trying to update a record in a table which needs to be found using 2 fields (i.e. WHERE xxx = qaz AND zzz=456). When I am matching on 1 field only it finds records but where I try to match on the 2 fields it fails to match. My code is as follows...

I reckon you need to Grant rights to the data using the usual SQL GRANT command. To get at the data, you will need to use the SQL Explorer tool that comes with Progress 9.1C. You may have problems if the database has been given a user name and password and you don't know what they are. I do...

Hi George Makes sense and worked a treat! Thanks. Tony

Hi Guys I have a data load programme which reads data in from a CSV file. It then selects a record from the database and updates that database record accordingly. The sql SELECT statement is generating an error when I introduce a WHERE clause; the WHERE clause is comapring 2 database fields...

This is too complex to explain here. However, the migration from 9.1x to 10.1x is all fully documented with the software released by Progress - I did it loads of times; piece of cake.

I may be wrong, but I have never come across Views within Progress.

Hi. Crystal connects to Progress via the ODBC driver. What you need to do is start your Progress db and then configure the driver from within the Windows Control Panel and test the connection. If that works then you are almost there. However, you need to either ensure that your db has been...

Hi Guys Thanks for all your help - we rebuilt a new server from scratch and that seems to have fixed the problem. What the original problem was we don't have a clue; fingers crossed it doesn't happen again.

Hi. I've tried the code and yes, I still get the error. Therefore, we can happily say its not an application or database error but must definitely be an infrastructure problem...or maybe even hardware. I shall check the system logs to see if they give a clue...but I'm not holding my breath.

Hi. Given that MDAC isn't the problem as the sample code you gave me works fine, any ideas what may be the cause of the problem?