Re: SQL Server Shared Management Objects (SMO)

2020-04-29 Thread Stephen Russell
I have a huge application built in sometime 2009-10 for managing SQL Server stored procedures as well as submitting standard daily statements to the variety of servers and instances I manage. I don't know if you are going to be able to create all of the container objects that are necessary to work

RE: SQL Server Shared Management Objects (SMO)

2020-04-29 Thread Paul Newton
Thanks Tracy - my mistake we are in fact currently using loDMO = CreateObject("sqlDMO.Application") Paul -Original Message- From: ProfoxTech On Behalf Of Tracy Pearson Sent: 29 April 2020 16:59 To: profoxt...@leafe.com Subject: RE: SQL Server Shared Management Objects (SMO) Sent by an

Re: [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April

2020-04-29 Thread Alan Bourke
Thanks Eric -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ 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/prof

SQL Server Shared Management Objects (SMO)

2020-04-29 Thread Paul Newton
Hi all We have been using the following to get a list of available servers loDMO = CreateObject("sqlSMO.Application") loServerList = loDMO.ListAvailableSQLServers However SQL-DMO was apparently deprecated with SQL Server 2005 and succeeded by SQL-SMO. Has anybody used SQL Server Shared Manageme

RE: GoFish problem

2020-04-29 Thread Richard Kaye
Well, if I was really going to engage in a conversation about sentence construction, the original answer would have been that awful mas modifying "lot" and not "work". But this is more fun... -- rk -Original Message- From: ProfoxTech On Behalf Of John Weller Sent: Wednesday, April 29,

RE: SQL Server Shared Management Objects (SMO)

2020-04-29 Thread Tracy Pearson
The COM object you are creating is named "sqlSMO", are you sure this isn't already the object you are looking for? Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton Sent: Wednesday, April 29, 2020 11:56 AM To: profoxt...@leafe.com Sub

RE: GoFish problem

2020-04-29 Thread John Weller
No - awful is correct! The amount of work Doug has done is enough to fill anyone with awe 😊 John Weller 01380 723235 07976 393631 -Original Message- From: ProfoxTech On Behalf Of Richard Kaye Sent: 29 April 2020 16:31 To: profoxt...@leafe.com Subject: RE: GoFish problem I knew I shoul

RE: GoFish problem

2020-04-29 Thread Richard Kaye
I knew I should have written "tremendous"... 😊 -- rk -Original Message- From: ProfoxTech On Behalf Of Tracy Pearson Sent: Wednesday, April 29, 2020 11:20 AM To: profoxt...@leafe.com Subject: RE: GoFish problem Are you saying his work was awful or that he did a lot of work? Tracy ---

RE: GoFish problem

2020-04-29 Thread Tracy Pearson
Are you saying his work was awful or that he did a lot of work? Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, April 29, 2020 11:10 AM To: profoxt...@leafe.com Subject: RE: GoFish problem IIRC Doug Hennig has do

RE: GoFish problem

2020-04-29 Thread Richard Kaye
IIRC Doug Hennig has done an awful of work with treeviews and released pure VFP based classes and many whitepapers about using them. -- rk -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: Tuesday, April 28, 2020 10:28 PM To: profoxt...@leafe.com Subject: Re: GoFish

Re: [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April

2020-04-29 Thread Eric Selje
I know it's not what you're looking for, but I just uploaded my whitepapers from last year's Southwest Fox up to my website . The X# paper is meant for us VFP devs that are trying to get a grip on what this X# thing is all about. There's als

RE: GoFish problem

2020-04-29 Thread Paul H. Tarver
Matt, it looks like with your tip, I got it going. I knew MSCOMCTL.ocx was on the computer I was testing on (Win7 64bit), but I decided to try to ty to re-register it manually just to make sure. Ran CMD as Admin and it dropped me into C:\Windows\System and without thinking I ran REGSVR32 MSCOMCTL.o

[NF] X# Live 30 April and weekly from now

2020-04-29 Thread Johan Nel
We have scheduled another online event, this time using Zoom. During this meeting we will look at the XSharp Runtime State. Topic: Exploring XSharp Runtime State Time: Apr 30, 2020 04:00 PM Amsterdam, Berlin, Rome, Stockholm, Vienna We plan for 30 minutes, but our schedule allows to extend that

Re: GoFish problem

2020-04-29 Thread Alan Bourke
FWIW I just ran the .APP for the current version of GoFish under Windows 10 x64 and it's fine. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listin

Re: [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April

2020-04-29 Thread Alan Bourke
Eric I'd probably do it in X# from scratch thanks. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http

Re: GoFish problem

2020-04-29 Thread Alan Bourke
On Wed, 29 Apr 2020, at 8:34 AM, Koen Piller wrote: > Are you sure? I believe GF is to be distributed f.o.c where DBI you have to > pay You can redistribute DBI Controls with your built COM-compatible application (VFP, VB6 etc). If you supply the source to your application, and a form uses a DBI

Re: GoFish problem

2020-04-29 Thread Koen Piller
Are you sure? I believe GF is to be distributed f.o.c where DBI you have to pay Koen Op wo 29 apr. 2020 om 04:18 schreef Eric Selje > DBi makes some great controls. :) They can be distributed runtime for free > but anyone who wants to work on GoFish would need a dev license for them. > > E > > O