Re: SPT and Remote Views

You could add a column for the length of varchar(max) content and sort on that descending. Then you will know if the width of Fox cursor is actually getting all of the data. On Wed, Nov 7, 2018 at 2:25 PM Kevin J Cully wrote: > I was looking for an old blog post but I couldn't find it. At

RE: SPT and Remote Views

Haven't run into a problem with CAST(), but I'll add CONVERT() to my notes for further review. Thanks! Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kevin J Cully Sent: Wednesday, November 07,

RE: SPT and Remote Views

+1 Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Charlie-gm Sent: Tuesday, November 06, 2018 2:46 PM To: profoxt...@leafe.com Subject: Re: SPT and Remote Views Just a quick FYI. If using SQL

RE: SPT and Remote Views

I was looking for an old blog post but I couldn't find it. At times there may be a problem with the ODBC connection and using CAST(), especially with VARCHAR(max). If you ever experience problem using CAST() and accessing a field of type VARCHAR(max), take a look at CONVERT(). This will work

Re: IBM to buy RedHat

On Wed, Nov 7, 2018 at 2:14 PM Gene Wirchenko wrote: > OTOH, there is that line about insanity. > Oh, you mean: https://twitter.com/tedroche/status/701896005332168705 -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts ---

Re: GetFile() issue

On Wed, Nov 7, 2018 at 2:13 PM Gene Wirchenko wrote: > > That URL was wrong in your post as it included the closing > paren. Oddly, Eudora excluded it in this reply. > Mayhaps your email reader parsed it wrong, as I sent plain text and it works fine on my end. > >SETs often have global

Re: IBM to buy RedHat

At 08:49 2018-11-07, Ted Roche wrote: On Thu, Nov 1, 2018 at 11:18 AM Ed Leafe wrote: > Hey, I guess it could happen. ;-) Past history is no guarantee of future performance. OTOH, there is that line about insanity. Sincerely, Gene Wirchenko

Re: GetFile() issue

At 07:08 2018-11-07, Ted Roche wrote: On Wed, Nov 7, 2018 at 5:57 AM Dave Crozier wrote: > Unknown to me after all these years, the set default to command has an > effect on the whole of the VFP thread not just the DataSession you are in. To quote my co-author, "Computer language purists

Re: CAN You Hear the Silence???

Thanks for the follow-up Ted. I did notice that you use GMail, although I didn't notice till after I wrote the below reply. Thanks again for the reply - and I'm glad to finally be back here again! -K- On 11/7/2018 10:14 AM, Ted Roche wrote: I've been GMail only for a couple of years now and

Big Changes & Fox Work in SF Bay Area?

Hey there folks, Yeah - I've been MIA for a little while now. I struggled to find work in NYC area - and things just went from Bad to Worse! So - towards the end of Sept. I made a big life change. Packed up my car - putting most of my life in Storage - then hit the road and drove West Old

Re: CAN You Hear the Silence???

I've been GMail only for a couple of years now and it seems to work fine. Some people's emails don't come through (like Yahoo!) because they don't follow the proper rules, but mostly, it works okay. On Wed, Nov 7, 2018 at 1:02 PM Kurt @ Gmail wrote: > Hey there Ted, > > Turns out - it wasn't

Re: CAN You Hear the Silence???

Hey there Ted, Turns out - it wasn't my email reader. It seems that Optonline.net was being Black listed, which I found out - since I reached out directly to Ed about the problem. However, I got busy with looking for work and failed to followup and switch to another email address of mine.

Re: IBM to buy RedHat

On Thu, Nov 1, 2018 at 11:18 AM Ed Leafe wrote: > > Hey, I guess it could happen. ;-) > > Past history is no guarantee of future performance. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain

Re: IBM to buy RedHat

> He’s basically updating the “Apple buys NeXT” story from the mid-90s. Apple was > much bigger and better known, but was having some financial woes after some > management mis-steps. Within a couple of years, nearly every Apple exec was > gone, replaced by people from NeXT. The Mac OS was

Re: GetFile() issue

On Wed, Nov 7, 2018 at 5:57 AM Dave Crozier wrote: > Unknown to me after all these years, the set default to command has an > effect on the whole of the VFP thread not just the DataSession you are in. To quote my co-author, "Computer language purists object to SET commands for a pretty

Re: GetFile() issue

Does the _commonfolder class in _system.vcx help you out? I use it like this: LOCAL loCommonFolder AS _commonfolder OF _system.vcx m.loCommonFolder = CREATEOBJECT("_commonfolder") #DEFINE CSIDL_PERSONAL  0x0005    && My Documents #DEFINE CSIDL_APPDATA  

Re: GetFile() issue

maybe check out the GetSaveFileName() function in the Vfp2c32 library (Github) "Creates a Save dialog box that lets the user specify the drive, directory, and name of a file to save. GetSaveFileName([nFlags [, cFileFilters [, cFileName [, cInitialDirectory [, cDialogTitle [, nFlagsEx [,

Re: GetFile() issue

use locfile() instead? Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ VisitFoxInCloud Blog WatchFoxInCloud Marketing Videos WatchFoxInCloud Technical Videos

GetFile() issue

Hi folks, Just had an issue that has been bugging me for a while and I now why but I haven’t got a solution to hand… so maybe you can help. In lots of places we allow users to export their reports and spreadsheet results onto their own personal “C” drives. And to do this I implement … default

RE: SPT and Remote Views

Chris, Not dealt with FM for a couple of years but I did have similar inconsistency issues with the SPT and ended up using remote views when I wrote a small add-on system for a friend who specialises in FM Pro. One thing is sure it isn't going to be fixed if it is an ODBC issue!!! Dave