Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Baldur3635

    Highlight a list of words in an rtf file

    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
  2. Baldur3635

    Highlight a list of words in an rtf file

    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...
  3. Baldur3635

    I thought that I had it sorted out.

    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...
  4. Baldur3635

    Changing a Query at Runtime

    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...
  5. Baldur3635

    Changing a Query at Runtime

    Delphi XE7
  6. Baldur3635

    Changing a Query at Runtime

    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.
  7. Baldur3635

    How to open an Editor Form at a particular record.

    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...
  8. Baldur3635

    Changing a Query at Runtime

    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...
  9. Baldur3635

    Changing a Query at Runtime

    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...
  10. Baldur3635

    Changing a Query at Runtime

    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...
  11. Baldur3635

    Combo Boxes question

    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...
  12. Baldur3635

    Changing a Query at Runtime

    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...
  13. Baldur3635

    Changing a Query at Runtime

    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...
  14. Baldur3635

    Changing a Query at Runtime

    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...
  15. Baldur3635

    The regular programmer had a stroke

    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...
  16. Baldur3635

    The regular programmer had a stroke

    The regular programmer had a stroke, he's not coming back and my friend is looking for a replacement. In the meantime, I'm stand-in. Not bad when you get a chance at 80 to re-hone your programming skills, I suppose. Problem is that things have moved on so I'm playing catch up for a while. I was...
  17. Baldur3635

    Combo Boxes question

    The solution was so simple, I could hardly believe that it took me so long to think of it. It just takes ONE line : cxDBComboBox2.ItemIndex := cxDBComboBox1.ItemIndex; There's just a small snag that eludes me. If I select an item in Box1 and then move to the next field (not entering the...
  18. Baldur3635

    Combo Boxes question

    I have 2 x ComboBoxes. CB1 has a list of items. CB2 has a list of matching item codes. My idea is that the user select an Item from the DB1. I find the ItemIndex (no problem) and then use this number to select the corresponding Item Code. Ive been looking at doing this. It seems so easy, but...
  19. Baldur3635

    Now I really DO have a problem, - Sorting

    It wasn't QString. I put it on the Watch list and stepped through. The value was correct. I was using the standard DBGrid from XE7. I've tried a dozen different things but still no sort. I did solve the problem. Cheating, I know, but at 80. I'm allowed to cheat! I found a dbGrid that DOES...
  20. Baldur3635

    Now I really DO have a problem, - Sorting

    I have a MyDataModule. In it I have MyConnection1, a query and this is a second Query. I have a MyDataSource2 and a MyQuery2. On the form I'm busy with, there is a ListBox, populated with the fields that I want to sort on. The idea is, the user selects a field and then the code (below) displays...

Part and Inventory Search

Back
Top