Search results for query: *

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

Hi All, I have a project where you have a number of RPi's that are collecting data from wireless nodes, data is going into a MariaDB MySQL database held locally on the RPi. I have a VFP app that has a local database and sync the MySQL data to it for analysis etc. I started off with SQL pass...

Have been playing a little, but need to correct something that I stated earlier. Notebook is Win 11, when you go into Bluetooth & devices you turn on Bluetooth and then press the 'Add device' button and it searches for nearby BT devices, and comes up with my phone etc. A little bit further...

Hi Chris, Thank you for your reply and pointers. I have one of the BLE IoT devices that I want to use, it is based on the Renesas chips set, www.renesas.com/us/en/products/wireless-connectivity/bluetooth-low-energy. BLE is a massive jump from traditional Bluetooth where it was just simple...

Hi All, I have a requirement to connect to some BLE IoT devices, I didn't know if anyone had done this in VFP. Did some stuff in the past with traditional Bluetooth using serial connections using the Windows RFCOMM I think from memory. But the world is a different place with BLE at GATT etc...

Hi Tarmar, You are correct, it is pronounced Tay-mar. Had not heard of FoxRockX, but Googled it and see that it is what FoxTalk became, just looked in an old filing cabinet here and found some copied of FoxTalk 2.0 which I think date back to 2005 when I attended the DevUK. Have also just...

Tamar, Sincere apologies, I have a feeling I read some of your articles in Code Magazine some time ago, so have no excuses. I live in the South West of the UK, and used to drive over the Tamar River on a daily basis, no real relevance but an interesting fact maybe, if you were not aware of...