bazzer747

I have a RadioGroup setup with all letters of the alphabet (for filtering surnames on first letter). The items are entered A, B, C, D, E ... etc and are spread over 9 columns and 3 rows (dictated by the space available on a form. However, the buttons don't display in a left-to-right format but a top-down format, so along the top row I see A, D, G, J ... etc. and A, B, C are column 1, D, E, F column 2 and so on. This layout isn't very User friendly in my view, and I suppose I could add the items in an order that visually fixes it so the top row reads A, B, C, D ... etc. Just wondering if there is another way? (Couldn't see a property that does this; BiDiMode I thought might do it but doesn't).

Hi, Often I have a project with many breakpoints to help in debugging. When I'm done with the session of debugging I no longer need those breakpoints. I know I can manually remove them one by one, but is there a way to remove them all at once to save time? I read that these are stored in the .dsk file, but is the only way to remove them is to edit this file and delete them there? Deleting that file, whilst an option, doesn't seem to be a good thing to do as it holds many other settings.

Hi, I have a button on a form that I initially have disabled, as I don't want it clickable until a couple of comboboxes on the form have values selected. When the two comboboxes have been selected I enable the button. However, a first click on the button does nothing. A second click actions the code behind the OnClick event - which is to open up another form. I have a breakpoint on the OnClick event but nothing happens on the first click. On the second click the breakpoint kicks in and takes me to the OnClick event. It's as though the first click never happened. Any thoughts on why this should be would be appreciated.

So easy! And obvious! Must look before asking :-). Thanks

Hi, I see Embarcadero have released 10.4.1. I'm especially happy they are fixing problems found in prior versions, more so than any 'new' features. However, yet again they say you need a total uninstall and reinstall for this update. What I don't understand is why a full uninstall is necessary for a 'minor' release. This isn't 10 to 11, or even 10.4 to 10.5 - this is one level further - 10.4 to 10.4.1! A full install causes me all sorts of issues. I have a few add ons which I I have to wait on other companies to provide their own updates to the new version which can take weeks. Recall the problems with the Konopka VCL components when 10.4 arrived, it was a couple of weeks before they provided and updated set in GetIt and that component suite is owned by Embarcadero! Even Ray Konopka couldn't understand why this happened. Some companies must have many more add-ons than I have and suffer more than I do with this issue? Surely for a minor upgrade all that is needed is replacing the files that have changed, which can't be that many (being a minor upgrade)?

Many thanks for the info, especially the blog by Darian, very clear explanation of why the 'problem' exists and why it won't go away soon. This is one of the reasons I find this forum so useful and view it regularly. My issues are minor in comparison to the larger world which uses Delphi on a more professional and deeper level than I ever will.

That's a bit pedantic. Ace Reporter is a suite of components as is eDocEngine, I accept, but these are the 'add-ons' I add on to my Delphi. They are applications I add to my Delphi, and need installation routines to integrate them. Hence all my comments above. So if you don't like my term add-on, please substitute with component suites.

eDocEngine and Ace Reporter I see the Konopka VCL components install OK via Getit.

No, I ran the installer letting it uninstall/reinstall keeping settings. The fact the add-on vendors needed to provide me with an update also meant they would not have worked using their previous installers. Are you suggesting that any add-ons, which have been installed OK in 10.4, will work in 10.4.1? This I hope for and will see what happens when my 'test' install on my laptop completes.

Traditions should be ditched if they don't provide a happy client base 🙂 When I went to 10.4 from 10.3 none of my add-ons worked and needed re-installs. I've contacted my vendors and asked this question, still awaiting their reply. My feeling is they will need an update, even though this is a minor upgrade. I hope for otherwise. Yes, I'm installing on my other machine to see what's what.

Hi, I mainly use Outlook to send emails, and on some I attach a document. My code mainly revolves around this line: vMailItem.Attachments.Add( filename ); (vMailItem being the Outlook item object. However, what I'm finding is that after I've sent an email with a file, if I want to send another email but without a file, the file is still attached to the email. I've cleared the edit box which holds the file name (which I use to get the name of the file). I use a boolean variable to say whether there is an attachment or not and that code does bypass the above line, but the previous file is still being attached. Is there a method which can remove any previous file attachments to an email, like 'vMailItem.Attachments.Remove' ?

Anders, That code works perfectly, many thanks, so my problem is solved. With Outlook closed, when I run the code the email is created and I can see Microsoft Outlook (32 bit) in Task Manager. Even after the VarClear( Outlook ) executes Outlook is still there. When I close or send the email Outlook then closes. When the line GetActiveOleObject('Outlook.Application') is run I get an error message: 'Operation unavailable', but the email still gets created and displayed/sent. This only occurs in debug mode. When I run in normal mode I don't get an error message, but as above Outlook opens only on the vMailItem.Display line, and only closes when I send/delete the actual email.

After I've done a vMailItem.Send (or .Display), I issue a VarClear( Outlook ). This is for every individual email sent.

Anders, try Outlook:= GetActiveOleObject('Outlook.Application'); except Outlook:= CreateOleObject('Outlook.Application'); end; vMailItem := Outlook.CreateItem( olMailItem ); .. and later on ... if gvbAttached = True then vMailItem.Attachments.Add( gvAttachedFile ); //(gvbAttached being boolean which determines if file is to be attached, and gvbAttached being the location/name of that file).

Hi, I'm trying to do a MSSQL UPDATE on a table, but when I run this command the application freezes: fdc.ExecSQL('UPDATE tPGCMatches SET Completed = :pC, Result = :pR, Score = :pSc WHERE ID = :pM',[ 1, cResult, cScore, gviMatchID ]); fdc is the Firedac Connection to the MSSQL Server. This also happens if I do a Edit/Post on the table, instead. It feels like the table is locked and the command is waiting for access, but I'm 100% certain nothing else is using the table. Just wondering if there is some FireDAC parameter set somewhere for this table that is preventing access. Any thoughts would be welcome.

I've put at Start Transaction, TRY .... Commit structure around this single MSSQL Update statement and it runs OK now. I don't normally use transaction structures unless I have more than one SQL statement happening in a process, but, well, this solves the problem, without knowing why.

Hi, I've been getting a lot of Access Violations in my applications recently and have now tracked down what I think is the cause. I only 'think' because what I've done seems to have reduced the AVs. I have used Hints/ShowHint on many buttons in the apps. I tracked some of the AVs down to where ShowHint was checked but there was no actual text in the Hint property. Now why this should cause an AV is beyond me, there should be an easy coding that just show a blank, or the ShowHint should not be checkable if Hint is empty, but then this is Delphi! What I'd like to know is - is there a quick and easy way to go through all the properties in an application and check if there is text in all the Hint property where the ShowHint is checked, or vice versa see if there is text whenever the ShowHint is not checked? Going through every form and every component would take forever...

Hi I often use the Value pairs in a combo box, and can easily get the 'value' from the current index. I also use IndexOf to check if a certain item is in the list, but that checks the Name side not the Value side. Is there a way to check if an item is in the Value side of a combobox?

Yes, I have that value. Copied the old DLL (luckily I had a copy of the old dll in a Documents backup ). It's now installed in 10.3 and 10.4 without errors. Feel like a major milestone achieved :-). What I don't understand is even when I've uninstalled on 10.3 and 10.4 there are still remnants, files/registry items, lying about causing problems. Surely this sort of 'cleaning up' is a basic requirement these days of installs. I recall these problems over 20 years ago with uninstall programs not cleaning up all traces. Anyway, all's well now, so many thanks for your help and guidance ...

Well that doesn't work! Installed on 10.3, restarted as it wanted after the install - now I get Access Violations in module ParnassusCoreEditor.dll, which I OK, and then get another AV in bds.exe. And Projects don't load correctly. I've uninstalled again, and still get AVs in that dll - so the uninstall clearly doesn't uninstall properly. What a mess.

So I took out Bookmarks from 10.4 AND 10.3 (as it was screwed), does this means I can use GetiT to install Bookmarks in 10.3 AND 10.4 and they won't clobber each other? The 10.4 install overwrote that dll so I don't have a 10.3 version; does GetiT install the correct versions I suppose I'm asking, or do I have to do some manipulating?

Hi I have an MSSQL update I run which looks like this: dm.fdc.ExecSQL( 'UPDATE tPGCMatches SET FirstTeeTime = :p1T, Interval = :pIn, SecondTeeStart = :p2, SecondTeeTime = :p2T WHERE ID = :pMI' ,[ c1stTeeStartTime, cInterval, c2ndTeeHole, c2ndTeeStartTime, gviMatchID ]); I have a similar command in a different project which uses the query ExecSQL to do the update (rather than the connection) but to a different named (but structurally the same) table. I've tried using the query ExecSQL as well, I usually now prefer to use the connection for these types of SQL statements. I do many updates elsewhere in my project which work fine, but this one freezes when attempting to execute. I've run the FireDac Monitor but on the line execution nothing new appears to indicate if the command is being processed. I've checked the parameters are all OK, and run the update in Management Studio (entering values instead of parameters) and it runs OK there, so the table seems OK. It's as though it's getting stuck formulating the sql command to send to MSSQL but I don't know a way to trace what is happening to make it freeze, and the format of the command looks OK. Any suggestions/possible answers would be appreciated.

How do I find out this 'transactioncount'?

An update …. although I can't explain fully why, but I now have the code updating! Although thereis only one SQL update in the process I put a TRY EXCEPT construct around the code and with a Start Transaction, so the code block now looks like this: TRY dm.fdc.StartTransaction; dm.fdc.ExecSQL( 'UPDATE tPGCMatches SET FirstTeeTime = :p1T, Interval = :pIn, SecondTeeStart = :p2, SecondTeeTime = :p2T WHERE ID = :pMI' ,[ c1stTeeStartTime, cInterval, c2ndTeeHole, c2ndTeeStartTime, gviMatchID ]); end; dm.fdc.Commit; EXCEPT on E : Exception do ShowMessage(E.ClassName+' error raised, with message : '+E.Message); END; Lo and behold the update went through. Note I haven't changed the SQL update command in any way, or any of the variable values /parameters. So, like many things in Delphi, it is a mystery. I normally use the Start Transaction construct where I am doing several SQL Updates &/or Inserts to different tables, so wouldn't normally need one around a single SQL command. The problem I have (now) with the above code id I normally have a Rollback if the transaction fails, but I'm unsure where I can put this, or even if it is needed as an error presumably won't do the Commit and will go to the EXCEPT. My lack of knowledge shows here.

Lars, Yes, I agree, it's not getting past pre-processing. I've double checked the values in the parameters and they all have valid values. I ran the update using just one of the parameters at a time, thinking it was one of them that was the problem, but whichever parameter was used gave the same problem. To TigerLilly, thanks for your input. I get the same behaviour from another PC, and the same when the update is going to my Live SQL Server (as well as my Test SQL Server). So all this (to me) points to the command never leaving the application. I'll look at that trace info for SQL, thanks, even if the Monitor isn't sending anything there - it will at lkeast prove nothing is getting there. Just in case it is I'm recreating the table to do some more testing, and from a new (small) application! I'll beat this problem to death … eventually!