The have not implemented SqlExec() yet, but Robert says that will happen.
That's the easy part... It will be the FoxPro SQL that is the hard one to implement.
*Matt Slay*, President Jordan Machine Co. 355 Clow Lane PO Box 170339 Birmingham, AL 35217 Ph: 205-849-5050 Fx: 205-849-5075 mattslay@jordanmachine.com mailto:mattslay@jordanmachine.com http://www.JordanMachine.com
On 12/10/2019 3:36 PM, Stephen Russell wrote:
When I glanced over the functions it seems to me that you cannot have any non VFP data. All of the SQL query, insert, update delete was not applicable.
Or was ai multitasking on it when I glanced at it?
On Tue, Dec 10, 2019 at 11:51 AM Matt Slay mattslay@jordanmachine.com wrote:
MB Software Solutions - I feel the same exact way about Scatter/Gather.
To me, these two command are at the same level as the FoxPro SQL syntax and SqlExec(), both of which are also Not implemented yet.
At this point with X#.VFP, there is sort of an all-or-nothing bar they have to hit before any further testing or consideration can be justified. And that's just at the language level... not to mention the UI piece which alone will be a huge wall given the proposed FoxPro.SCX - to WinForms transformation.
I posted your reply to the XSharp board so the X# Dev Team can see your comment:
https://www.xsharp.info/forum/public-vfp/1651-foxpro-function-list-updated#1...
*Matt Slay*, President Jordan Machine Co. 355 Clow Lane PO Box 170339 Birmingham, AL 35217 Ph: 205-849-5050 Fx: 205-849-5075 mattslay@jordanmachine.com mailto:mattslay@jordanmachine.com http://www.JordanMachine.com
On 12/10/2019 9:38 AM, MB Software Solutions, LLC wrote:
Thanks for that. The one that caught my eye is SCATTER/GATHER not (yet) supported. I used those commands in everything I do in my VFP apps, especially in single record Add/Edit screens. My objects have a controlsource like "thisform.oRecord.MyField" which gets populated via something like:
DO FORM frmEditRecord NAME loFrm NOSHOW SELECT MyTable SCATTER MEMO NAME loFrm.oRecord loFrm.Show()
IF loFrm.lSaveChanges THEN thisform.obiz.UpdateRecord(loFrm.oRecord) ENDIF
IF VARTYPE(loFrm) = "O" THEN loFrm.release() ENDIF
On 12/10/2019 1:21 AM, Johan Nel wrote:
Hi all,
A list of the current status of VFP function/procedure support was published on the X# website.
https://www.xsharp.info/itm-help/foxpro-compatibility-list
Hope this is of interest to most.
Johan Nel George, South Africa.
[excessive quoting removed by server]