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!

  • Congratulations SkipVought 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. Neil Toulouse

    Grid Coloring Problem

    Hi Olaf It was for a multiple column grid (so I might have done more to it) - but for the life of me I can't find where I implemented it now to find more detail of what I was trying to achieve overall back then. Anyway, looks like you have a better solution :) Neil I like work. It...
  2. Neil Toulouse

    Grid Coloring Problem

    Hi guys Late to the party as always.... but is this similar to the issue i had in this thread? thread184-1743972 Neil I like work. It fascinates me. I can sit and look at it for hours...
  3. Neil Toulouse

    VFP 8 ODBC connection to MySql

    Apologies - just re-read the post - you have already done that. Might be worth double checking though. I like work. It fascinates me. I can sit and look at it for hours...
  4. Neil Toulouse

    VFP 8 ODBC connection to MySql

    Also check if your MySQL server is allowing your IP address in. I had a very similar issue attempting to connect to MySQL on my web server. Not sure it is relevant to you, but I had to add the IP of the machine trying to connect via the "cPanel -> Remote MySQL" menu option and then it all...
  5. Neil Toulouse

    Using Google API for transliteration in VFP

    Hi Not sure if these are of any help, but i cam across this when trying to integrate an HTML editor in our app: https://weblog.west-wind.com/posts/2008/Sep/27/Calling-JavaScript-functions-in-the-Web-Browser-Control My discussion around it: https://www.tek-tips.com/viewthread.cfm?qid=1752388...
  6. Neil Toulouse

    Help with 'TOP 2' query...

    George's solution worked a treat! Olaf - yes indeed the data is not stored as per my example (it comes via three tables) but i am trying to intercept a process with minimal effort, and at the point I want to interfere, the query is returning that result set. Thanks for all the advise! I like...
  7. Neil Toulouse

    Help with 'TOP 2' query...

    Hi guys! Many thanks for the responses, most interesting :) Hopefully I will get chance to properly digest it all today. (And just to clarify, regarding the data, it is as Andrzejek and Olaf interpret it, as in, I want to return the ENRID if the last two sessions have NOT been attended.)...
  8. Neil Toulouse

    Help with 'TOP 2' query...

    Hi guys I'm thinking this should be a straightforward query but I'm at a loss at the mo! Basically, I have an 'Attendance' table, something like this: ENRID DATE ATTENDED 1 24/03/2017 0 1 23/03/2017 0 1 22/04/2017 1 1 21/04/2017 1 2 24/03/2017 1 2 23/03/2017 1 2 22/04/2017 1 2 21/04/2017 1...
  9. Neil Toulouse

    Text to HTLM

    Maybe overkill for what you're trying to achieve, but maybe have the edit box entering HTML in the first place with an editor? thread184-1752388 I like work. It fascinates me. I can sit and look at it for hours...
  10. Neil Toulouse

    CKEditor and VFP

    Interesting info, thanks Olaf :) I like work. It fascinates me. I can sit and look at it for hours...
  11. Neil Toulouse

    CKEditor and VFP

    I found Rick Strahl's article finally! http://weblog.west-wind.com/posts/2008/Sep/27/Calling-JavaScript-functions-in-the-Web-Browser-Control Look specifically at the "A few gotchas for FoxPro" paragraph. Neil I like work. It fascinates me. I can sit and look at it for hours...
  12. Neil Toulouse

    CKEditor and VFP

    Thanks Mike. I just issued a WAIT "Creating Form" WINDOW TIMEOUT 0.5 for the pause. I will have to have a look at the Sleep() API! I came across the case sensitive bug issue from one of Rick Strahl's articles (I think). I read it somewhere at least, and it did prove to be an issue. Also the...
  13. Neil Toulouse

    CKEditor and VFP

    Hi guys Well this turned out a lot easier than I had expected :) I will list my steps here in case anyone else is interested (or for my future reference if I forget what I did!): Step 1: Download the CKEditor ZIP file and decompress it to a folder. Step 2: Create a simple web page containing...
  14. Neil Toulouse

    CKEditor and VFP

    Sorry Mike, yes I see from the documentation now it can be handled in JavaScript, so I may be able to do something with it! I like work. It fascinates me. I can sit and look at it for hours...
  15. Neil Toulouse

    CKEditor and VFP

    Thanks Mike! I am trying to avoid having a web server involved so I can keep it all local, so server side scripting isn't possible in my scenario. However, that may have to change to get a solution! May have to go down Griff's suggestion of dumping the data to a text file or something and...
  16. Neil Toulouse

    CKEditor and VFP

    thread184-1635582 Hi Guys I have a need to integrate the CKEditor HTML Editor tool into a VFP(8) app. I have set it all up fine and have the CKEditor running via an OLE Web Browser control. All this is local, ie no web server involved. My question (hopefully simple!) is how do I get the...
  17. Neil Toulouse

    SQL Table not updating...

    Hi Ralph I tried everything but no avail. I gave up in the end and went down the 'SQL Passthrough' route, rather than trying to get the update method working on the adapter: private void btnSave_Click(object sender, EventArgs e) { // Create an UPDATE command for the...
  18. Neil Toulouse

    SQL Table not updating...

    Hi guys C# noob here. I have been following tutorials and googling this issue to death, and looking at similar issues on this forum, but I just can't get it to work! Basically I have two forms. The first form has a datagrid which displays the results of a query from a single table SQL server...
  19. Neil Toulouse

    Grid Row Highlighting...

    Hi Mike I have found a way round! Quite simple in the end thankfully :) In the AfteRowColChange event, I just added code to change the HighlightBackColor to that of the row by using the same criteria as the DynamicBackColor change for the grid. I now have the frame and no cell selection...
  20. Neil Toulouse

    Grid Row Highlighting...

    Hi Mike Yeah, I fiddled with all the different settings/properties but no combination (unless I have missed one!) seems to do what I need. Oh well, it's not a show stopper just annoying :) Thanks Neil I like work. It fascinates me. I can sit and look at it for hours...

Part and Inventory Search

Back
Top