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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DDPL

  1. DDPL

    Using cursor adaptor to update blob data in MySQL

    I have never had any code in he CA, I entered that line of code in the BeforeInsert method today when trying to find a resolution" The fields names that I have added are DContent and Notes, the first being the BLOB and the second being the MEMO field. I will have a play with this, thank you...
  2. DDPL

    Using cursor adaptor to update blob data in MySQL

    Hi Chriss, I get all of that, was trying to give you the technicalities, not a story. I understand that the cursor has no relation to the MySQL database until you write back any changes to it, the mechanism I am using was demonstrated in the first post. I establish a connection to the MySQL...
  3. DDPL

    Using cursor adaptor to update blob data in MySQL

    Hi Chriss, I am happy with the concept of the CA, have been using it for a while, you kindly offered advice a year or so ago in heling me set this up. Have taken what I believe to be the correct steps in added these two new fields into both tables, the VFP and MySQL. I use the CA in different...
  4. DDPL

    Using cursor adaptor to update blob data in MySQL

    Hi Dylim, I used FILETOSTR() to get the data into the BLOB field in the VFP table, the issue I am getting is copying the table record through the CursorAdaptor into the MySQL data table.
  5. DDPL

    Using cursor adaptor to update blob data in MySQL

    I have a MySQL database that I am uploaded data from a VFP database via a cursor adaptor, everything has been working fine, but now need a BLOB and MEMO field in one of the tables, didn't previously have any so was just do something simple like this; SELECT &oSource SCAN SELECT &oSource...
  6. DDPL

    Snap points on form

    Thanks Chriss, I looked everywhere for that and missed it somehow !! Darren
  7. DDPL

    Snap points on form

    I have a project that I have been working on for ages, and all of a sudden a couple of the form have developed custom snap points, the dots on the form that you align objects against when you drag them around. One has gone quite small in both direction the other has retain the 'normal'...
  8. DDPL

    Custom class in a custom class

    Thank you Chriss / Joe, Think I have it working now, came across some of the limitations that Chriss mentioned while playing with it a little earlier. Also get the hierarchy now, the first time I couldn't work out why there was no code inside the methods of the shape class, so was trying to...
  9. DDPL

    Custom class in a custom class

    Thanks or the replies. Chriss, apologies for not being more specific with the question, which is; I create a custom class based on a container, I can drop a shape object on it from the form controls toolbar but can not see how I drop my custom shape from a VCX onto it? Darren
  10. DDPL

    Custom class in a custom class

    Hi all, I have a custom shape class, it has added properties and methods. These are dynamically created in the application, I am now looking at adding some additional detail to the shape in the GUI. I want to add a couple of labels that will display information about the shape, so was looking...
  11. DDPL

    MerryWotsit

    Merry Christmas Mike, and to everyone else.
  12. DDPL

    Curosor adapter right padding with spaces

    Hi Chris, Looks like it was me mixing VARCHAR on the MySQL end and the legacy database in VFP using CHAR and expecting MySQL to look after the VARCHAR at the back end. Found this from Mr Lewis http://www.ml-consult.co.uk/foxst-36.htm that describes the issue. Thank you for your help and...
  13. DDPL

    Curosor adapter right padding with spaces

    Hi all, Am updating a MySQL database with a CA, when I open the VFP table the string fields show as being trimmed, when I call the CA and insert the data remote cursor shows the data as trimmed, but when I do the update the MySQL data on the server shows the string fields as being right padded...
  14. DDPL

    Cursor Adapter

    I agree it makes sense to keep the connection open permanently, but if I explain the use case a little more it may make sense why I need to keep closing it. A project has a central PC that has a master VFP database, it also has an unknown number RPi's that have a local MYSQL databases. The...
  15. DDPL

    Cursor Adapter

    Hi Chriss, I appreciate that the connection handle is not a count, but I am cycling though the loHubSend.Objects.Count which is, looking at each object within the DE and closing the connection if the object has a valid one. The issue is it's reporting there are 4 objects, 2 of them have active...
See more

Part and Inventory Search

Back
Top