Recent content by Baldur3635

Brilliant, that's a great start point. I'm taking a break until after New Year I hope everyone on this forum had a good Christmas (under the circumstances that have been wished upon us) and let us all hope and pray that things get better in 2022 and we get some semblance of freedom back

Does anyone know of a program where I can feed in a list of words, parse the entire RTF and highlight every word in the list. What's it for? We are writing a story and there are several lists of words, known as 'Filler words', there's another list called 'Crutch words' and a third list called...

I thought that I had it sorted out. I got no errors, but it didn't work. I stepped through the Code and checked the value with Add Watch. Everything was perfect. I hit ExecSQL and no error! Wow, I did it! Well, no I didn't. I checked the database (I did make a backup in case anything went...

For the moment, I don't want to make too many changes. Your method : var SearchValue: string; begin SearchValue := Copy(memDesc.Lines.Text,1,30); //Or whatever the maximum length is. //QStr is a function that I made up that will return a string with the characters that MariaDB uses (which...

Delphi XE7

I've been scanning through all the chunks of text. The biggest I've found is 1587 characters, some are as small as 145 characters. Remember the definition SQL is LongText. Let me test your suggestion but I have doubts that it will work because string us a max of 255 as I remember.

I could kick myself for not keeping my books. I'm trying to do something rea;;y simple I think I have a DBGrid and it's connected to a query. The user selects one of 5 different ItemTypes and a value (string) that he wants to find. There can be anything from one an integer number (I doubt if...

Sorry, I'm using MySQL (actually MariaDB). Here is the full Line : MyQuery1.SQL.Text := ' UPDATE stItems SET iDesc = ''' + memDesc.Lines.Text + ''' WHERE iName like ''%' + edtCval.Text + '%'' ' ; It seems that it doesn't like LongText. it's certainly a lot longer than 255 chars. I think...

That is brilliant DjangMan, I'm still kicking myself, I tried just about everything except your LIKE. I tested it, and it works perfectly, except for two fields, The most important thing is Description. This seems to have been cut and pasted from a catalog (not written by an English speaker it...

DjangMan That's very useful indeed. I wish I hadn't sold all my books when I retired. There's a lot floating around on the web, but I can't remember which one covered databases well. To be truthful, I didn't work very much at all with SQL, most of the work that I did was for Novell eDirectory...

Hi majlumbo Thanks for the tip. You are correct, BUT it actually does, but it doesn't. You have to actually click on some other EditBox before it changes (on screen). My problem was that this was the last box to have focus before commit. I solved the problem by changing the form layout so that...

Oh, I found the problem this morning. MyQuery2.Open; MyQuery2.Execute; is unnecessary. Just replace with MyQuery2.ExecSQL Works like a dream. A few more hours and I should be finished with this job. Waiting for the next one! My Delphi mindset is starting to come back. I didn't do a lot of...

I tried that already, same result. The query is definitely connected to the table and the CRDBGrid is definitely connected to the query. The columns change 100% but not the query. I have stepped through the code. The query text is correct, It passes it to the Query, but for some reason it...

I'm back! My database holds several different things (don't blame me for the database design, someone else did that!). There are three distinct types of things. They all haver some of the fields, but some of the items, the fields are blank. I'm trying to use a single CRDBGrid to display each...

Thanks for the encouragement. I say the same to you, just keep at it. Keeps the brain from dementia if nothing else! I did eventually solve the problem and it was really weird. Two of the entries right at the start of the Library search path were greyed out and two were missing. I still have...