RE: VFP and MS ACCESS API

2009-06-04 Thread Dave Crozier
Philip, Sorry I hit the send button too soon. Also, using only VFP calls, if you use Automation then CreateObject() will always open a new version of the application whereas GetObject() will open an existing version and you could then always use automation to see if the databases is open already.

RE: VFP and MS ACCESS API

2009-06-04 Thread Dave Crozier
Philip, One obvious and simple answer answer if you know the name of the DB is to temporarily rename it and trap the error. The other way is simply by using API calls. Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Philip Borkhold

Re: [OT] Raising $ to smoke out the BC

2009-06-04 Thread Pete Theisen
Michael Madigan wrote: > Thank God they're stilling keeping his feet to the fire. Hi Michael! I think he will stonewall it because it indeed does say that he was born in Kenya - there is no other possible reason *to* stonewall it. And the school records, he would have something in there about a

Re: [OT] Raising $ to smoke out the BC

2009-06-04 Thread Michael Madigan
Thank God they're stilling keeping his feet to the fire. * Join the OBAMA RESISTANCE MOVEMENT! http://www.cafepress.com/rightwingmike/6181419 --- On Thu, 6/4/09, Pete Theisen wrote: > From: Pete Theisen > Subject: [OT] Raising $ to smoke out

[OT] Raising $ to smoke out the BC

2009-06-04 Thread Pete Theisen
Hi Everybody! http://www.wnd.com/index.php?fa=PAGE.view&pageId=98787 Interesting that some people still want to see it. -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ ___ Post Messages to: ProFox@leafe.com Subscription Maint

VFP and MS ACCESS API

2009-06-04 Thread Philip Borkholder
Hi All, It's been a long time... Is there a way in VFP code to see if MS Access is already running with a DB open? If so, can I capture that instance and assign it to an object variable so I can control it? Thanks, Philip B. ___ Post Messages to: Pro

Re: Imminent eTecnologia goodies

2009-06-04 Thread Stephen Russell
On Thu, Jun 4, 2009 at 2:38 PM, Alan Bourke wrote: > > > On Thu, 04 Jun 2009 15:31 +0100, "Dave Crozier" > wrote: > >> My only comment is that if a small company like eTecnologia can come up >> with >> the goods then why oh why couldn't M$, but lets not flog that old donkey >> to >> death again!

RE: Imminent eTecnologia goodies

2009-06-04 Thread Alan Bourke
On Thu, 04 Jun 2009 15:31 +0100, "Dave Crozier" wrote: > My only comment is that if a small company like eTecnologia can come up > with > the goods then why oh why couldn't M$, but lets not flog that old donkey > to > death again! No, lets! Firstly have they come up with anything usable in t

RE: Connecting To SQL Server 2008

2009-06-04 Thread Rick Schummer
>> Speaking of SQL security, does anyone use application roles here?<< Application Roles are absolutely the best approach in my opinion since you might not have control over security on the server your application data resides. DBAs are a lot more friendly with the access to an application role be

[OT] film titles

2009-06-04 Thread Jean Laeremans
http://www.empireonline.com/crypticcanvas/ A+ jml ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: ht

Re: Connecting To SQL Server 2008

2009-06-04 Thread Stephen Russell
On Thu, Jun 4, 2009 at 1:59 PM, Paul Hill wrote: > On Thu, Jun 4, 2009 at 6:40 PM, Stephen Russell wrote: >> On Thu, Jun 4, 2009 at 12:00 PM, Rafael Copquin >> wrote: >>> You could use ODBC to set up a DSN connection, test it and then use it. For >>> instance, you set up a DSN connection called

Re: Connecting To SQL Server 2008

2009-06-04 Thread Paul Hill
On Thu, Jun 4, 2009 at 6:40 PM, Stephen Russell wrote: > On Thu, Jun 4, 2009 at 12:00 PM, Rafael Copquin > wrote: >> You could use ODBC to set up a DSN connection, test it and then use it. For >> instance, you set up a DSN connection called 'myconnection'. >> >> Then you can use thus: >> >> nHan

Re: [OT] Obama: US one of the largest Muslim nations

2009-06-04 Thread Stephen Russell
On Wed, Jun 3, 2009 at 5:34 PM, Michael Madigan wrote: > > Let's build abortion clinics in the Muslim communities. If they already blow up stores for "progressive" women there will they wait to blow up your clinic when it is full of patients? -- Stephen Russell Sr

Re: Connecting To SQL Server 2008

2009-06-04 Thread Stephen Russell
On Thu, Jun 4, 2009 at 12:00 PM, Rafael Copquin wrote: > You could use ODBC to set up a DSN connection, test it and then use it. For > instance, you set up a DSN connection called 'myconnection'. > > Then you can use thus: > > nHandle = sqlstringconnect([dsn=myconnection;trusted_connection=yes]) >

RE: Connecting To SQL Server 2008

2009-06-04 Thread John
You might want to hit youtube for an instructional video, which will be better than someone trying to type it out. John Harvey -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of W.N. Pew Sent: Thursday, June 04, 2009 10:33 AM To: profox@leafe.

Re: Connecting To SQL Server 2008

2009-06-04 Thread Rafael Copquin
You could use ODBC to set up a DSN connection, test it and then use it. For instance, you set up a DSN connection called 'myconnection'. Then you can use thus: nHandle = sqlstringconnect([dsn=myconnection;trusted_connection=yes]) if nHandle < 0 messagebox('Connection failed') else messagebo

Re: Connecting To SQL Server 2008

2009-06-04 Thread Stephen Russell
On Thu, Jun 4, 2009 at 10:33 AM, W.N. Pew wrote: > Well, here I go again! This time with SQL Server 2008. Can anyone tell me > how I can set up a DSN connection in Windows XP Pro to 2008 (Express). I > figure (I hope) if I can get that far I should be able to use passthrough to > work the database

Connecting To SQL Server 2008

2009-06-04 Thread W.N. Pew
Well, here I go again! This time with SQL Server 2008. Can anyone tell me how I can set up a DSN connection in Windows XP Pro to 2008 (Express). I figure (I hope) if I can get that far I should be able to use passthrough to work the database. Any help will be greatly appreciated! Bill

Re: Imminent eTecnologia goodies

2009-06-04 Thread MB Software Solutions General Account
Dave Crozier wrote: > Mike, > I will be blogging from the sessions as per two years ago and I'll post a > link as soon as I have something to post. All in all it could just be that > Boudewijn's session alone will be worth going for and I'm quite excited > about the possibilities. > > My only comme

RE: Imminent eTecnologia goodies

2009-06-04 Thread Dave Crozier
Mike, I will be blogging from the sessions as per two years ago and I'll post a link as soon as I have something to post. All in all it could just be that Boudewijn's session alone will be worth going for and I'm quite excited about the possibilities. My only comment is that if a small company lik

Re: Imminent eTecnologia goodies

2009-06-04 Thread MB Software Solutions General Account
Dave Crozier wrote: > Guys, > Boudewijn Lutgerink has started this thread on Foxite and released some nice > little titbits about what eTecnologia are about to deliver. Worth a read > > www.foxite.com under 3rd party software with a thread heading of " soon to > be expected (so cool!)" > > I quote:

Re: Fw: profox- THANKS ED THAT WORKED

2009-06-04 Thread MB Software Solutions General Account
TORMEY wrote: > - Original Message - > From: TORMEY > To: Ed Leafe > Sent: Wednesday, June 03, 2009 10:58 AM > Subject: Re: profox- THANKS ED THAT WORKED > > > HI ED AND ALL > I HAVE BEEN READING PROFOX FOR YEARS. IT DISAPEARED JUST AFTER THE FINANCIAL CRISIS. I TRIED REGISTERING SEVERAL TI

Re: Printing report issue

2009-06-04 Thread MB Software Solutions General Account
Alan Bourke wrote: > Or put the BMP in the same location as the report, and copy with the > report to the temporary location when you're furtling the FRX. I think this is the easiest idea...just have the files in the same location. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief

RE: VFP9 SP1 - need to createa statementwith thereportwriter-multipletrxfor a single client on one page. Att:Dave Crozier

2009-06-04 Thread Dave Crozier
Andrew, I'll try to get it done before. I get back from Italy on the Saturday and away to Prague on the Monday and back Wednesday but I'll do my best. I think Adjit wanted it as well. Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of An

Re: VFP9 SP1 - need to create a statementwith thereportwriter-multipletrx for a single client on one page. Att:Dave Crozier

2009-06-04 Thread Andrew Stirling
Dave Please just leave it until you get back from Prague. Andrew Stirling 01250 874580 http://www.calcpay.co.uk HMRC Accredited UK payroll program Dave Crozier wrote: > Andrew and, > Sorry mate I completely forgot about that, well not completely forgot, I > knew I had something to upload but exac

Re: [NF] Are you asked to create best practice documents for clients?

2009-06-04 Thread Stephen Russell
On Thu, Jun 4, 2009 at 7:23 AM, David Smith wrote: > I'm likely being really naïve here, but the whole 'best practices' thing > really turns me off. I can understand if a company doesn't have experienced > IT folks and needs something to help them get a complicated device like a > server up, runni

RE: [NF] Are you asked to create best practice documents for clients?

2009-06-04 Thread David Smith
I'm likely being really naïve here, but the whole 'best practices' thing really turns me off. I can understand if a company doesn't have experienced IT folks and needs something to help them get a complicated device like a server up, running and protected than a BP doc could be really handy. Usuall

RE: VFP9 SP1 - need to create a statementwith thereportwriter-multipletrx for a single client on one page. Att:Dave Crozier

2009-06-04 Thread Dave Crozier
Andrew and, Sorry mate I completely forgot about that, well not completely forgot, I knew I had something to upload but exactly what escaped me. I'll sort it before I go on hols to Italy on Sunday. Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] O

Fw: profox- THANKS ED THAT WORKED

2009-06-04 Thread TORMEY
- Original Message - From: TORMEY To: Ed Leafe Sent: Wednesday, June 03, 2009 10:58 AM Subject: Re: profox- THANKS ED THAT WORKED HI ED AND ALL I HAVE BEEN READING PROFOX FOR YEARS. IT DISAPEARED JUST AFTER THE FINANCIAL CRISIS. I TRIED REGISTERING SEVERAL TIMES HOPING THAT PROFOX HA

Re: VFP9 SP1 - need to create a statement with thereportwriter-multiple trx for a single client on one page. Att:Dave Crozier

2009-06-04 Thread Andrew Stirling
Dave Just to resurrect an old thread, any chance of getting the info? Also I came upon this: http://weblogs.foxite.com/ammarhadi/archive/2009/05/13/8437.aspx Andrew Stirling 01250 874580 http://www.calcpay.co.uk HMRC Accredited UK payroll program Dave Crozier wrote: > Ajoy, > Sorry to be a litt

Imminent eTecnologia goodies

2009-06-04 Thread Dave Crozier
Guys, Boudewijn Lutgerink has started this thread on Foxite and released some nice little titbits about what eTecnologia are about to deliver. Worth a read www.foxite.com under 3rd party software with a thread heading of " soon to be expected (so cool!)" I quote: "eTecnologia just gave me info I