If you are still using the Project Manager and are on a High DPI screen. When you move the window around it is not a very pleasant experience.
This code will put the window in an outer window that does not have the border issue.
DEFINE WINDOW MyProjectWIndow ; FROM 0,0 ; TO WROWS("Project Manager"),WCOLS("Project Manager") ; CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ; TITLE "Project Manager" ; FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager") SHOW WINDOW MyProjectWindow ACTIVATE WINDOW "Project Manager" IN MyProjectWindow MOVE WINDOW "Project Manager" TO 0,0
And if you want the Project Manager to live outside the VFP window, and be available in the Windows Task Bar change the SHOW WINDOW command to this.
SHOW WINDOW MyProjectWindow IN macdesktop
If you do not need it in the Windows Task Bar, you could change the DEFINE WINDOW line to include this.
IN DESKTOP
The project manager needs to be open before you run this. You could add a this before it.
MODIFY PROJECT 'TheAwesomeProject' NOWAIT
Do you sometimes maximize windows you don't mean to? Change ZOOM to NOZOOM.
Works in VFP 9 and VFP Advanced.
OR
You could use Doug Hennig's Project Explorer https://github.com/DougHennig/ProjectExplorer
Happy Coding! Tracy
"This just in....Visual FoxPro 9 support for *Mac Desktops*!"
LOL!
On 12/28/2021 3:06 PM, Tracy Pearson wrote:
If you are still using the Project Manager and are on a High DPI screen. When you move the window around it is not a very pleasant experience.
This code will put the window in an outer window that does not have the border issue.
DEFINE WINDOW MyProjectWIndow ; FROM 0,0 ; TO WROWS("Project Manager"),WCOLS("Project Manager") ; CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ; TITLE "Project Manager" ; FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager") SHOW WINDOW MyProjectWindow ACTIVATE WINDOW "Project Manager" IN MyProjectWindow MOVE WINDOW "Project Manager" TO 0,0And if you want the Project Manager to live outside the VFP window, and be available in the Windows Task Bar change the SHOW WINDOW command to this.
SHOW WINDOW MyProjectWindow IN macdesktopIf you do not need it in the Windows Task Bar, you could change the DEFINE WINDOW line to include this.
IN DESKTOPThe project manager needs to be open before you run this. You could add a this before it.
MODIFY PROJECT 'TheAwesomeProject' NOWAITDo you sometimes maximize windows you don't mean to? Change ZOOM to NOZOOM.
Works in VFP 9 and VFP Advanced.
OR
You could use Doug Hennig's Project Explorer https://github.com/DougHennig/ProjectExplorer
Happy Coding! Tracy
Post Messages to:ProFox@leafe.com Subscription Maintenance:https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive:https://leafe.com/archives This message:https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@powerchurch... ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
LOL
It's fun to find a keyword that is in the product for backward compatibility that actually does something useful.
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, December 29, 2021 2:21 PM To: profoxtech@leafe.com Subject: Re: ProTip: Still using the Project Manager?
"This just in....Visual FoxPro 9 support for *Mac Desktops*!"
LOL!
On 12/28/2021 3:06 PM, Tracy Pearson wrote:
If you are still using the Project Manager and are on a High DPI screen. When you move the window around it is not a very pleasant experience.
This code will put the window in an outer window that does not have the border issue.
DEFINE WINDOW MyProjectWIndow ; FROM 0,0 ; TO WROWS("Project Manager"),WCOLS("Project Manager") ; CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ; TITLE "Project Manager" ; FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager") SHOW WINDOW MyProjectWindow ACTIVATE WINDOW "Project Manager" IN MyProjectWindow MOVE WINDOW "Project Manager" TO 0,0And if you want the Project Manager to live outside the VFP window, and be available in the Windows Task Bar change the SHOW WINDOW command to this.
SHOW WINDOW MyProjectWindow IN macdesktopIf you do not need it in the Windows Task Bar, you could change the DEFINE WINDOW line to include this.
IN DESKTOPThe project manager needs to be open before you run this. You could add a this before it.
MODIFY PROJECT 'TheAwesomeProject' NOWAITDo you sometimes maximize windows you don't mean to? Change ZOOM to
NOZOOM.
Works in VFP 9 and VFP Advanced.
OR
You could use Doug Hennig's Project Explorer https://github.com/DougHennig/ProjectExplorer
Happy Coding! Tracy
Post Messages to:ProFox@leafe.com Subscription Maintenance:https://mail.leafe.com/mailman/listinfo/profox OT-free version of this
list:https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive:https://leafe.com/archives This
message:https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@pow erchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of
the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
I was curious if the same thing could be done to the Command window so I took Tracy's code and replaced "MyProjectWindow" with "MyCommandWindow" and "Project Manager" with "Command". It did not seem to work as I wanted. Is the command window referenced by something other than "Command" or is it just a special window so it can't be manipulated the same way the "Project Manager" window can?
On Wed, Dec 29, 2021 at 1:32 PM Tracy Pearson tracy@powerchurch.com wrote:
LOL
It's fun to find a keyword that is in the product for backward compatibility that actually does something useful.
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, December 29, 2021 2:21 PM To: profoxtech@leafe.com Subject: Re: ProTip: Still using the Project Manager?
"This just in....Visual FoxPro 9 support for *Mac Desktops*!"
LOL!
On 12/28/2021 3:06 PM, Tracy Pearson wrote:
If you are still using the Project Manager and are on a High DPI screen. When you move the window around it is not a very pleasant experience.
This code will put the window in an outer window that does not have the border issue.
DEFINE WINDOW MyProjectWIndow ; FROM 0,0 ; TO WROWS("Project Manager"),WCOLS("Project Manager") ; CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ; TITLE "Project Manager" ; FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager") SHOW WINDOW MyProjectWindow ACTIVATE WINDOW "Project Manager" IN MyProjectWindow MOVE WINDOW "Project Manager" TO 0,0And if you want the Project Manager to live outside the VFP window, and
be
available in the Windows Task Bar change the SHOW WINDOW command to this.
SHOW WINDOW MyProjectWindow IN macdesktopIf you do not need it in the Windows Task Bar, you could change the
DEFINE
WINDOW line to include this.
IN DESKTOPThe project manager needs to be open before you run this. You could add a this before it.
MODIFY PROJECT 'TheAwesomeProject' NOWAITDo you sometimes maximize windows you don't mean to? Change ZOOM to
NOZOOM.
Works in VFP 9 and VFP Advanced.
OR
You could use Doug Hennig's Project Explorer https://github.com/DougHennig/ProjectExplorer
Happy Coding! Tracy
Post Messages to:ProFox@leafe.com Subscription Maintenance:https://mail.leafe.com/mailman/listinfo/profox OT-free version of this
list:https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive:https://leafe.com/archives This
message: https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@pow erchurch.com https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of
the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
-- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
You can turn Docking off on the Command window. You do not need to wrap it. WDockable("COMMAND", .F.) OR Right click the title bar of the Command window and unselect Dockable
That works for the Document View, Properties and Data Session windows.
Have fun! Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Jeff Roberts Sent: Wednesday, December 29, 2021 2:54 PM To: profoxtech@leafe.com Subject: Re: ProTip: Still using the Project Manager?
I was curious if the same thing could be done to the Command window so I took Tracy's code and replaced "MyProjectWindow" with "MyCommandWindow" and "Project Manager" with "Command". It did not seem to work as I wanted. Is the command window referenced by something other than "Command" or is it just a special window so it can't be manipulated the same way the "Project Manager" window can?
On Wed, Dec 29, 2021 at 1:32 PM Tracy Pearson tracy@powerchurch.com wrote:
LOL
It's fun to find a keyword that is in the product for backward compatibility that actually does something useful.
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, December 29, 2021 2:21 PM To: profoxtech@leafe.com Subject: Re: ProTip: Still using the Project Manager?
"This just in....Visual FoxPro 9 support for *Mac Desktops*!"
LOL!
On 12/28/2021 3:06 PM, Tracy Pearson wrote:
If you are still using the Project Manager and are on a High DPI screen. When you move the window around it is not a very pleasant experience.
This code will put the window in an outer window that does not have the border issue.
DEFINE WINDOW MyProjectWIndow ; FROM 0,0 ; TO WROWS("Project Manager"),WCOLS("Project Manager") ; CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ; TITLE "Project Manager" ; FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager") SHOW WINDOW MyProjectWindow ACTIVATE WINDOW "Project Manager" IN MyProjectWindow MOVE WINDOW "Project Manager" TO 0,0And if you want the Project Manager to live outside the VFP window, and
be
available in the Windows Task Bar change the SHOW WINDOW command to
this.
SHOW WINDOW MyProjectWindow IN macdesktopIf you do not need it in the Windows Task Bar, you could change the
DEFINE
WINDOW line to include this.
IN DESKTOPThe project manager needs to be open before you run this. You could add
a
this before it.
MODIFY PROJECT 'TheAwesomeProject' NOWAITDo you sometimes maximize windows you don't mean to? Change ZOOM to
NOZOOM.
Works in VFP 9 and VFP Advanced.
OR
You could use Doug Hennig's Project Explorer https://github.com/DougHennig/ProjectExplorer
Happy Coding! Tracy
Post Messages to:ProFox@leafe.com Subscription Maintenance:https://mail.leafe.com/mailman/listinfo/profox OT-free version of this
list:https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive:https://leafe.com/archives This
message: https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@pow erchurch.com
https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@powerchurc h.com
** All postings, unless explicitly stated otherwise, are the opinions of
the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
-- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
If the command window is dockable you get the odd frame issue and if not dockable you cannot move it outside the main Visual Foxpro window, correct? -Jeff
On Wed, Dec 29, 2021 at 2:01 PM Tracy Pearson tracy@powerchurch.com wrote:
You can turn Docking off on the Command window. You do not need to wrap it. WDockable("COMMAND", .F.) OR Right click the title bar of the Command window and unselect Dockable
That works for the Document View, Properties and Data Session windows.
Have fun! Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Jeff Roberts Sent: Wednesday, December 29, 2021 2:54 PM To: profoxtech@leafe.com Subject: Re: ProTip: Still using the Project Manager?
I was curious if the same thing could be done to the Command window so I took Tracy's code and replaced "MyProjectWindow" with "MyCommandWindow" and "Project Manager" with "Command". It did not seem to work as I wanted. Is the command window referenced by something other than "Command" or is it just a special window so it can't be manipulated the same way the "Project Manager" window can?
On Wed, Dec 29, 2021 at 1:32 PM Tracy Pearson tracy@powerchurch.com wrote:
LOL
It's fun to find a keyword that is in the product for backward compatibility that actually does something useful.
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, December 29, 2021 2:21 PM To: profoxtech@leafe.com Subject: Re: ProTip: Still using the Project Manager?
"This just in....Visual FoxPro 9 support for *Mac Desktops*!"
LOL!
On 12/28/2021 3:06 PM, Tracy Pearson wrote:
If you are still using the Project Manager and are on a High DPI
screen.
When you move the window around it is not a very pleasant experience.
This code will put the window in an outer window that does not have the border issue.
DEFINE WINDOW MyProjectWIndow ; FROM 0,0 ; TO WROWS("Project Manager"),WCOLS("Project Manager") ; CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ; TITLE "Project Manager" ; FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager") SHOW WINDOW MyProjectWindow ACTIVATE WINDOW "Project Manager" IN MyProjectWindow MOVE WINDOW "Project Manager" TO 0,0And if you want the Project Manager to live outside the VFP window, and
be
available in the Windows Task Bar change the SHOW WINDOW command to
this.
SHOW WINDOW MyProjectWindow IN macdesktopIf you do not need it in the Windows Task Bar, you could change the
DEFINE
WINDOW line to include this.
IN DESKTOPThe project manager needs to be open before you run this. You could add
a
this before it.
MODIFY PROJECT 'TheAwesomeProject' NOWAITDo you sometimes maximize windows you don't mean to? Change ZOOM to
NOZOOM.
Works in VFP 9 and VFP Advanced.
OR
You could use Doug Hennig's Project Explorer https://github.com/DougHennig/ProjectExplorer
Happy Coding! Tracy
Post Messages to:ProFox@leafe.com Subscription Maintenance:
https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this
list:https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive:https://leafe.com/archives This
message: https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@pow erchurch.com
< https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@powerchurc h.com https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions
of
the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
-- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Yes. That is true. So you can use "COMMAND" in the place of "PROJECT MANAGER". Or make it Procedure you call passing in what the Title of the Outer window and what Window it should hold.
Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Jeff Roberts Sent: Wednesday, December 29, 2021 3:08 PM To: profoxtech@leafe.com Subject: Re: ProTip: Still using the Project Manager?
If the command window is dockable you get the odd frame issue and if not dockable you cannot move it outside the main Visual Foxpro window, correct? -Jeff
On Wed, Dec 29, 2021 at 2:01 PM Tracy Pearson tracy@powerchurch.com wrote:
You can turn Docking off on the Command window. You do not need to wrap
it.
WDockable("COMMAND", .F.)OR Right click the title bar of the Command window and unselect Dockable
That works for the Document View, Properties and Data Session windows.
Have fun! Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Jeff Roberts Sent: Wednesday, December 29, 2021 2:54 PM To: profoxtech@leafe.com Subject: Re: ProTip: Still using the Project Manager?
I was curious if the same thing could be done to the Command window so I took Tracy's code and replaced "MyProjectWindow" with "MyCommandWindow"
and
"Project Manager" with "Command". It did not seem to work as I wanted. Is the command window referenced by something other than "Command" or is it just a special window so it can't be manipulated the same way the "Project Manager" window can?
On Wed, Dec 29, 2021 at 1:32 PM Tracy Pearson tracy@powerchurch.com wrote:
LOL
It's fun to find a keyword that is in the product for backward compatibility that actually does something useful.
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, December 29, 2021 2:21 PM To: profoxtech@leafe.com Subject: Re: ProTip: Still using the Project Manager?
"This just in....Visual FoxPro 9 support for *Mac Desktops*!"
LOL!
On 12/28/2021 3:06 PM, Tracy Pearson wrote:
If you are still using the Project Manager and are on a High DPI
screen.
When you move the window around it is not a very pleasant experience.
This code will put the window in an outer window that does not have
the
border issue.
DEFINE WINDOW MyProjectWIndow ; FROM 0,0 ; TO WROWS("Project Manager"),WCOLS("Project Manager") ; CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ; TITLE "Project Manager" ; FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager") SHOW WINDOW MyProjectWindow ACTIVATE WINDOW "Project Manager" IN MyProjectWindow MOVE WINDOW "Project Manager" TO 0,0And if you want the Project Manager to live outside the VFP window,
and
be
available in the Windows Task Bar change the SHOW WINDOW command to
this.
SHOW WINDOW MyProjectWindow IN macdesktopIf you do not need it in the Windows Task Bar, you could change the
DEFINE
WINDOW line to include this.
IN DESKTOPThe project manager needs to be open before you run this. You could
add
a
this before it.
MODIFY PROJECT 'TheAwesomeProject' NOWAITDo you sometimes maximize windows you don't mean to? Change ZOOM to
NOZOOM.
Works in VFP 9 and VFP Advanced.
OR
You could use Doug Hennig's Project Explorer https://github.com/DougHennig/ProjectExplorer
Happy Coding! Tracy
Post Messages to:ProFox@leafe.com Subscription Maintenance:
https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this
list:https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive:https://leafe.com/archives This
message: https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@pow erchurch.com
<
https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@powerchurc
h.com
https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@powerchurc h.com
** All postings, unless explicitly stated otherwise, are the opinions
of
the author, and do not constitute legal or medical advice. This
statement
is added to the messages for those lawyers who are too stupid to see the obvious.
-- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Happy New Year !!
I have a client trying to upgrade their SQL 2012 server to 2016 but we are having a problem with the TEXT data type only returning 400 characters. We tried to change to VARCHAR(Max) but that returns the same 400 character limit. I am not an SQL expert so I am not sure what is causing the problem, but I suspect it is the ODBC driver we are using??
Has anyone had this problem and found a solution or a new updated ODBC driver that works with SQL 2016?
Thanks, Kent
Can you provide some more context, Kent? Compiled EXE? Ad-hoc queries via SQL pass-through? Remove views?
--
rk
From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of kbelan@mchsi.com Sent: Tuesday, January 4, 2022 4:54 PM To: profoxtech@leafe.com Subject: VFP9 and SQL memo fields
Happy New Year !!
I have a client trying to upgrade their SQL 2012 server to 2016 but we are having a problem with the TEXT data type only returning 400 characters. We tried to change to VARCHAR(Max) but that returns the same 400 character limit. I am not an SQL expert so I am not sure what is causing the problem, but I suspect it is the ODBC driver we are using??
Has anyone had this problem and found a solution or a new updated ODBC driver that works with SQL 2016?
Thanks, Kent
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
Yes it is a compiled EXE for a legacy app that has been running great for years.
I am using West-Wind wwSQL class to execute Queries and Stored procedures. I don't think it is remote views.
I call the method and it returns a cursor or an oData object.
I hope that helps as I am not an SQL expert.
----- Original Message ----- From: "Richard Kaye" rkaye@invaluable.com To: "ProFox Email List" profox@leafe.com Sent: Tuesday, January 4, 2022 6:37:05 PM Subject: RE: VFP9 and SQL memo fields
Can you provide some more context, Kent? Compiled EXE? Ad-hoc queries via SQL pass-through? Remove views?
--
rk
From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of kbelan@mchsi.com Sent: Tuesday, January 4, 2022 4:54 PM To: profoxtech@leafe.com Subject: VFP9 and SQL memo fields
Happy New Year !!
I have a client trying to upgrade their SQL 2012 server to 2016 but we are having a problem with the TEXT data type only returning 400 characters. We tried to change to VARCHAR(Max) but that returns the same 400 character limit. I am not an SQL expert so I am not sure what is causing the problem, but I suspect it is the ODBC driver we are using??
Has anyone had this problem and found a solution or a new updated ODBC driver that works with SQL 2016?
Thanks, Kent
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
Do you know what SQL driver your EXE is currently using?
--
rk
From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of kbelan@mchsi.com Sent: Tuesday, January 4, 2022 8:48 PM To: profoxtech@leafe.com Subject: Re: VFP9 and SQL memo fields
Yes it is a compiled EXE for a legacy app that has been running great for years.
I am using West-Wind wwSQL class to execute Queries and Stored procedures. I don't think it is remote views.
I call the method and it returns a cursor or an oData object.
I hope that helps as I am not an SQL expert.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
I am pretty sure we are using Microsoft ODBC Driver 11 for SQL Server
I think they tried to install ODBC Driver 17 and had the same results
----- Original Message ----- From: "Richard Kaye" rkaye@invaluable.com To: "ProFox Email List" profox@leafe.com Sent: Wednesday, January 5, 2022 8:43:26 AM Subject: RE: VFP9 and SQL memo fields
Do you know what SQL driver your EXE is currently using?
--
rk
From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of kbelan@mchsi.com Sent: Tuesday, January 4, 2022 8:48 PM To: profoxtech@leafe.com Subject: Re: VFP9 and SQL memo fields
Yes it is a compiled EXE for a legacy app that has been running great for years.
I am using West-Wind wwSQL class to execute Queries and Stored procedures. I don't think it is remote views.
I call the method and it returns a cursor or an oData object.
I hope that helps as I am not an SQL expert.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
Tm90IHRyeWluZyB0byBiZSBvYm5veGlvdXMgaGVyZSBidXQgaW5zdGFsbGluZyBhIGRyaXZlciBvbiBpdHMgb3duIHdvbuKAmXQgY2hhbmdlIGFueXRoaW5nLiDwn5iKDQoNCkhhcyB0aGUgY29ubmVjdGlvbiBzdHJpbmcgZm9yIHRoZSBhcHBsaWNhdGlvbiBiZWVuIGNoYW5nZWQgdG8gdXNlIDE3Pw0KDQpJIGRvbuKAmXQgdGhpbmsgdGhlcmUgaXMgYW4g4oCcT0RCQyBEcml2ZXIgMTEgZm9yIFNRTCBTZXJ2ZXLigJ0gYnV0IEkgY291bGQgYmUgd3JvbmcuIFRoZXJl4oCZcyBkZWZpbml0ZWx5IGEgMTMgYW5kIGEgMTcuIFRoZXJlIGlzIGFsc28g4oCcU1FMIFNlcnZlciBOYXRpdmUgQ2xpZW50IDExLjDigJ0uDQoNCklzIGl0IHBvc3NpYmxlIHRvIHVzZSBPREJDIE1hbmFnZXIgaW4gdGhlIGVudmlyb25tZW50IGluIHF1ZXN0aW9uIHRvIGNyZWF0ZSBhIGNvbm5lY3Rpb24gdG8gdGhlIFNRTCBTZXJ2ZXIgdGhlIEVYRSB1c2VzPyBJZiB0aGF0IHdvcmtzLCB0aGVuIHlvdSBrbm93IHRoZSBwcm9ibGVtIGxpZXMgaW4gdGhlIGFwcGxpY2F0aW9uIGNvbmZpZ3VyYXRpb24uDQoNCi0tDQoNCnJrDQoNCkZyb206IFByb2ZveFRlY2ggPHByb2ZveHRlY2gtYm91bmNlc0BsZWFmZS5jb20+IE9uIEJlaGFsZiBPZiBrYmVsYW5AbWNoc2kuY29tDQpTZW50OiBXZWRuZXNkYXksIEphbnVhcnkgNSwgMjAyMiA1OjM5IFBNDQpUbzogcHJvZm94dGVjaEBsZWFmZS5jb20NClN1YmplY3Q6IFJlOiBWRlA5IGFuZCBTUUwgbWVtbyBmaWVsZHMNCg0KSSBhbSBwcmV0dHkgc3VyZSB3ZSBhcmUgdXNpbmcgTWljcm9zb2Z0IE9EQkMgRHJpdmVyIDExIGZvciBTUUwgU2VydmVyDQoNCkkgdGhpbmsgdGhleSB0cmllZCB0byBpbnN0YWxsIE9EQkMgRHJpdmVyIDE3IGFuZCBoYWQgdGhlIHNhbWUgcmVzdWx0cw0KDQoNCg0KLS0tLS0gT3JpZ2luYWwgTWVzc2FnZSAtLS0tLQ0KRnJvbTogIlJpY2hhcmQgS2F5ZSIgPHJrYXllQGludmFsdWFibGUuY29tPG1haWx0bzpya2F5ZUBpbnZhbHVhYmxlLmNvbT4+DQpUbzogIlByb0ZveCBFbWFpbCBMaXN0IiA8cHJvZm94QGxlYWZlLmNvbTxtYWlsdG86cHJvZm94QGxlYWZlLmNvbT4+DQpTZW50OiBXZWRuZXNkYXksIEphbnVhcnkgNSwgMjAyMiA4OjQzOjI2IEFNDQpTdWJqZWN0OiBSRTogVkZQOSBhbmQgU1FMIG1lbW8gZmllbGRzDQoNCkRvIHlvdSBrbm93IHdoYXQgU1FMIGRyaXZlciB5b3VyIEVYRSBpcyBjdXJyZW50bHkgdXNpbmc/DQoNCi0tDQoNCnJrDQoNCkZyb206IFByb2ZveFRlY2ggPHByb2ZveHRlY2gtYm91bmNlc0BsZWFmZS5jb208bWFpbHRvOnByb2ZveHRlY2gtYm91bmNlc0BsZWFmZS5jb20+PiBPbiBCZWhhbGYgT2Yga2JlbGFuQG1jaHNpLmNvbTxtYWlsdG86a2JlbGFuQG1jaHNpLmNvbT4NClNlbnQ6IFR1ZXNkYXksIEphbnVhcnkgNCwgMjAyMiA4OjQ4IFBNDQpUbzogcHJvZm94dGVjaEBsZWFmZS5jb208bWFpbHRvOnByb2ZveHRlY2hAbGVhZmUuY29tPg0KU3ViamVjdDogUmU6IFZGUDkgYW5kIFNRTCBtZW1vIGZpZWxkcw0KDQpZZXMgaXQgaXMgYSBjb21waWxlZCBFWEUgZm9yIGEgbGVnYWN5IGFwcCB0aGF0IGhhcyBiZWVuIHJ1bm5pbmcgZ3JlYXQgZm9yIHllYXJzLg0KDQpJIGFtIHVzaW5nIFdlc3QtV2luZCB3d1NRTCBjbGFzcyB0byBleGVjdXRlIFF1ZXJpZXMgYW5kIFN0b3JlZCBwcm9jZWR1cmVzLiBJIGRvbid0IHRoaW5rIGl0IGlzIHJlbW90ZSB2aWV3cy4NCg0KSSBjYWxsIHRoZSBtZXRob2QgYW5kIGl0IHJldHVybnMgYSBjdXJzb3Igb3IgYW4gb0RhdGEgb2JqZWN0Lg0KDQpJIGhvcGUgdGhhdCBoZWxwcyBhcyBJIGFtIG5vdCBhbiBTUUwgZXhwZXJ0Lg0KDQoNCg0KDQotLS0gU3RyaXBNaW1lIFJlcG9ydCAtLSBwcm9jZXNzZWQgTUlNRSBwYXJ0cyAtLS0NCm11bHRpcGFydC9hbHRlcm5hdGl2ZQ0KdGV4dC9wbGFpbiAodGV4dCBib2R5IC0tIGtlcHQpDQp0ZXh0L2h0bWwNCi0tLQ0KDQpbZXhjZXNzaXZlIHF1b3RpbmcgcmVtb3ZlZCBieSBzZXJ2ZXJdDQoNCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQpQb3N0IE1lc3NhZ2VzIHRvOiBQcm9Gb3hAbGVhZmUuY29tPG1haWx0bzpQcm9Gb3hAbGVhZmUuY29tPg0KU3Vic2NyaXB0aW9uIE1haW50ZW5hbmNlOiBodHRwczovL21haWwubGVhZmUuY29tL21haWxtYW4vbGlzdGluZm8vcHJvZm94PGh0dHBzOi8vcHJvdGVjdC11cy5taW1lY2FzdC5jb20vcy9rRUVzQ2pSdmswSWxtUFh1blVDX2k/ZG9tYWluPW1haWwubGVhZmUuY29tPg0KT1QtZnJlZSB2ZXJzaW9uIG9mIHRoaXMgbGlzdDogaHR0cHM6Ly9tYWlsLmxlYWZlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3Byb2ZveHRlY2g8aHR0cHM6Ly9wcm90ZWN0LXVzLm1pbWVjYXN0LmNvbS9zL2E2dkFDa1J3bHJJWUIxamZrcUNpUz9kb21haW49bWFpbC5sZWFmZS5jb20+DQpTZWFyY2hhYmxlIEFyY2hpdmU6IGh0dHBzOi8vbGVhZmUuY29tL2FyY2hpdmVzPGh0dHBzOi8vcHJvdGVjdC11cy5taW1lY2FzdC5jb20vcy91SkdMQ2xZdm0ydU9FcDhpZy01R0M/ZG9tYWluPWxlYWZlLmNvbT4NClRoaXMgbWVzc2FnZTogaHR0cHM6Ly9sZWFmZS5jb20vYXJjaGl2ZXMvYnlNSUQvMTk2MTEwNzI0My4xMDIyMDUyMzguMTY0MTQyMjMyMDc0Mi5KYXZhTWFpbC56aW1icmFAbWNoc2kuY29tPGh0dHBzOi8vcHJvdGVjdC11cy5taW1lY2FzdC5jb20vcy9lRXNFQ21aMm5ZYzFsRDNDNFdZLW4/ZG9tYWluPWxlYWZlLmNvbT4NCioqIEFsbCBwb3N0aW5ncywgdW5sZXNzIGV4cGxpY2l0bHkgc3RhdGVkIG90aGVyd2lzZSwgYXJlIHRoZSBvcGluaW9ucyBvZiB0aGUgYXV0aG9yLCBhbmQgZG8gbm90IGNvbnN0aXR1dGUgbGVnYWwgb3IgbWVkaWNhbCBhZHZpY2UuIFRoaXMgc3RhdGVtZW50IGlzIGFkZGVkIHRvIHRoZSBtZXNzYWdlcyBmb3IgdGhvc2UgbGF3eWVycyB3aG8gYXJlIHRvbyBzdHVwaWQgdG8gc2VlIHRoZSBvYnZpb3VzLg0KDQpSZXBvcnQgW09UXSBBYnVzZTogaHR0cDovL2xlYWZlLmNvbS9yZXBvcnRBYnVzZS8xOTYxMTA3MjQzLjEwMjIwNTIzOC4xNjQxNDIyMzIwNzQyLkphdmFNYWlsLnppbWJyYUBtY2hzaS5jb208aHR0cHM6Ly9wcm90ZWN0LXVzLm1pbWVjYXN0LmNvbS9zL0FXSnhDbjVZb2dJbERqMnVQbXdGTj9kb21haW49bGVhZmUuY29tPg0K--- StripMime Report -- processed MIME parts ---multipart/alternative text/plain (text body -- kept) text/html---
-
Jeff Roberts -
kbelan＠mchsi.com -
MB Software Solutions, LLC -
Richard Kaye -
Tracy Pearson