Recent content by D-Ward

Merry Christmas Mike, and to everyone else.

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

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

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

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

Am having another issue with this one; I don't seem to be able to clear up after myself when I am opening and closing the connections, have tried it a couple of different ways but something is not getting released so I end up getting a 'too many connections' error from the server if the...

Started off with GW Basic back in the 80's and then onto QuickBasic writing accounts software and later CAD software for about 10 years. Used Visual Basic for 20 years do all sorts of stuff but mainly graphical based, CAD, ray tracing etc. Started working for a company in 1999 that ran on a...

Have recently looks at both Servoy and Alaska XBase, and like Joe above got excited about Polar Fox as it seemed to be exactly what I was looking/hoping for, but not sure if it is going to happen or not. Had a very quick play with FoxInCloud about a year ago, but struggled as was either beyond...

I jumped into VFP9, but use FP2.6 to support an old DOS application that runs in one department, have been trying for years to get them to give it up, have it on my list to re-write in VFP just to get rid of it and the old XP machine that run a DOS emulator so they can use it !

Hi Chriss, My reply crossed over with yours, thanks for the link, will take a look. Darren

Thanks for the reply. Sounds a bit like a sledge hammer to crack a walnut as the functions are purely math based. Had the option of re-writing the functions in VFP but wanted them in a single location as are security related. Will convert to C++ and create an unmanaged DLL to use in VFP.

Hi, I need to access a C# DLL, but can not get it to work. I have access to the C# source code and the author, having been trying for a couple of days and just cannot get it to work. Have tried compiling it both ways, so you use DECLARE (preferred method) or as a COM object so you have to...

Hi Chriss, In terms of fondness, it would be like picking a favorite child :). The DE is so powerful, but the combination of working with the CA (which I had not used before) opened up new possibilities in terms of interacting with external data sources, previously had done all the work...

Hi Chris, Not meaning to misled, merely showing the limitation of my knowledge. My assumption on getting to this point was that I had created a CA with 3 child cursors, but following what you say, which makes sense, this is not what I have, it is in fact a data environment with 3 CA's each...

Hi Chris, I am using the cursoradapter to read and write data, I sync in both directions. The remote MySQL database and the local VFP database are duplicates, same tables and fields. All the data fields for example "Data1, Data2, Data3 ....' have corresponding time stamp fields...