

bazzer747
Members-
Content Count
195 -
Joined
-
Last visited
-
Days Won
1
bazzer747 last won the day on June 3 2024
bazzer747 had the most liked content!
Community Reputation
26 ExcellentRecent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
Arrgghh! Found it. It was on a form which contained two Ace Reports, the one I wanted was minimised on the form, the other was maximised so hid the report I was after when I opened the form. The .pas name equated to the maximised report so when I was looking before that one came up in searches. It would pay me to put one report per form to avoid this confusion in the future. I had followed many of your suggestions, so thankyou all very much for helping through this.
-
Roger, Have tried the debugger route, after I press F7 on the "sctRepCustList.run" the report is created and the IDE just goes to the next line. Here is the code for the button that runs the report: So it doesn't step into the form where the report has been created. procedure TfCompetitions.btnReportClick(Sender: TObject); var bRec: TBookMark; begin //First save the record we are on in the dbgGrid dbgrid bRec:= dm.qCompetitions.GetBookmark; dm.qvCompEnrolments.Open('SELECT * FROM vPGCCompEnrolments ORDER BY Yes DESC, Maybe DESC'); dm.qvCompEnrolments.DisableControls; //Run the report fRepCompEnrolment.sctRepCustListt.Run; dm.qvCompEnrolments.Open('SELECT * FROM vPGCCompEnrolments ORDER BY CompDate, Yes DESC, Maybe DESC, DateBooked DESC, SName'); //Now restore the record we were on in dbgGrid ... dm.qCompetitions.GotoBookmark( bRec ); dm.qvCompEnrolments.EnableControls; end; I have also emailed the creator of Ace Report who is very good at responding to support queries. If/when he answers I'll post it here. I'll maybe try some of the other suggestions, many thanks for helping.
-
Uwe, OK, more clarity :-). When I run my project, one of the buttons runs an Ace Report with a "sctRepCustList.Run" command. This runs the report which is on a form. I don't get to see the form, just the report output. It isn't like I have the report form open in the IDE where I would know know exactly what it is called and what name I save it with. Mark, A global search in all files doesn't show anything other than the form where I run the Ace Report from.
-
Is there a simple way to find out what .pas file a form uses? I use ACE Reporter for my reporting and usually name my .pas file in a format like uRepCustomerList.pas so I can easily see all the report forms and what they do. I have a lot of .pas files in my project and for some reason when I created a certain report I didn't follow the usual system. So it could be named anything. I don't really want to open up every .pas file until the one I want pops up, so I'm thinking is there an easier way. I might not be seeing the woods for the trees here, so apologies if this is a silly question.
-
Well I'm wondering where the £1,475 cost comes from in the first instance as they say the 'normal' cost is £3.299 for Delphi Enterprise. Yes, £1.475 + £999 x 20% VAT is £2,968 (mind who want to pay £999 for maintenance, surely a 'hidden' cost as you can't not have it.
-
Just had (another) offer for upgrading to the latest version. However, I can't quite make out what they are actually offering. The headline (in the email) is 'up to 30% off' - as I have Enterprise Delphi, this is only 25% off. Hmmm, I wondered what that eventually came to. So I followed the link, clicked on the upgrade for Enterprise which says '25% OFF' - which also shows a full price of £3,299, and in much larger red figures '£1,475 perpetual licence + £999 Year one Maintenance'. Which is £2,474. OK, 25% off £3299 is £2,474.25 - so £1,475 + £99 x 25%. Anyway, I 'Add to Cart' and on the next page it says the price is now £2,969.10 (with £3,950.00 crossed out - where did that come from?) So now they want £2,969.10 from me for the upgrade. My working out says it should be £2,474.25 - some £494.35 less. Have I missed something?
-
Existing connection forcibly closed by remote host
bazzer747 replied to bazzer747's topic in Databases
That's cracked it. I changed the driver to v17 (from 11) and it connects with no issues. I think the hosting company has uprated the server I couldn't connect to so it didn't allow driver v11 to connect, whilst the other two servers I had no trouble with still allowed v11 to connect OK. Many thanks for your help, I can now continue with my development/text work! -
Existing connection forcibly closed by remote host
bazzer747 replied to bazzer747's topic in Databases
I have ODBC Driver 11 for SQL Server and ODBC Driver 17 for SQL Server on my local PC. As this message seems to relate to the 11 version, does that mean Firedac somewhere is told to use the 11 version rather than the 17 version? Could I remove the 11 version and Firedac would automatically revert to using the 17 version? -
I run many Windows applications connecting to MSSQL Servers via Firedac, and have done for many years. My 'Live' connectivity to the tables and views work OK, but in the last 2 weeks my connectivity to a 'test' Server is throwing up the error shown in the attached screenshot "An existing connection was forcibly closed by the remote host." In reporting this to the hosting company they are saying the 'test' Server should have no issues connecting to it, and I'm saying why, then, can I connect all my applications to the 'Live' Server with no problems, but none of these applications now connect to the 'Test' Server (when they did connect a couple of weeks ago?) They have come back with suggestions that seem to indicate using TLS1.2 may solve the issue. It seems TLS1.2 and TLS1.3 are enabled by default in Windows 11 (my local PC is Windows 11 Professional), but I'm finding it difficult to verify that. And I'm thinking this is a red herring anyway. My question her6e, really, is has Firedac any involvement in what version of TLS is used &/or is this something Firedac has an answer to that error?
-
Delphi 12.1 Amnesty price isn’t what I thought it was…
bazzer747 replied to Al T's topic in Delphi IDE and APIs
Granted, but having used Delphi for probably over 20 years now, there is no 'upgrade' price that acknowledges the amount of money spent on versions over the years. It seems you are treated as a 'new' customer regardless of your 'loyalty' to the product. With other products, existing users normally get upgrade prices that are significantly better than a new customer would pay. Also, when I buy a product I would expect to get any bug fixes for that product free with an apology, rather than having to pay for it. Embarcadero seem to be like the Carpet shops, there's always a 'sale' on. I can't believe anyone, company or individual, ever pays the advertised price. Why don't they have some integrity and show a normal price! Whatever 'special deal' is running the actual amount they want is always around the same (which in my opinion is way too much). -
Delphi 12.1 Amnesty price isn’t what I thought it was…
bazzer747 replied to Al T's topic in Delphi IDE and APIs
These 'offers' are nothing like helpful. Why they 'force' a years maintenance into the price makes me wonder - I've used Delphi (now on 10.4) since Delphi 4 - and never required a maintenance contract. Never had to call Emarcardo to help fix a problem. Why would I nee6d one now! My biggest gripe, though, is that whilst I have Enterprise (that was a 'con' years ago getting a decent price for an upgrade) when I only needed Professional), now I'm stuck with Enterprise because I can't get Firedac with Professional. -
Looking for a couple of good "starter" Delphi books
bazzer747 replied to t2000kw's topic in General Help
Why not look at Alistair Christies' web site Welcome to LearnDelphi.tv I found the articles 'Free Content' very useful and the 'Premium' content extremely useful in weaning my way into Delphi. -
Hmmm, surprises me it uses a local paserver at all. I'll check this out next time I get the error, but looking in Task Manager now, with Delphi running, there is no paserver in any other processes or services running.
-
My application is for Windows 64 bit. The application starts with Firedac connectivity to a remote SQL Server (not paserver) hosted on an internet provider. Normally the connectivity is good and reliable, and also when I run in non-debug mode the connection is made with no problem. I rebooted my PC this morning and set the initial database connections to an SQL Server on my local PC (rather than the remote server) and I don't get the disconnected session error. As I mentioned I've been getting this issue maybe once or twice a month for quite a while now. Normally I end Delphi with Task Manager and fire it up again and it's OK. Only yesterday it continued to fail.
-
Just recently, I've been getting 'disconnected session' error messages. See attached snapshot of the message. It occurs when I am in debug mode but not when I'm not in debug mode. To 'close' Delphi I have to open Task Manager and end the session from there, I can't get to the application to close it or use it any other way. I've no idea what is causing this, as it isn't consistant - I can operate in debug mode with no issues most of the time, but occasionally have this problem. If anyone can read the details on the error shown and give me a cluse as to where to look I'd appreciate it. I run Delphi 10.2 Enterprise.