Re: [NF] Android Music player

2011-07-29 Thread Frank Cazabon
I just use the default "Music Player" on mine and it doesn't do that. It's what came with my Samsung Galaxy S (AKA Captivate) running Android 2.1. You could try a few from the marketplace like WinAmp, PowerAmp doubleTwist Player and see if you like any. Frank. Frank Ca

Re: FORMAT AND INPUTMASK IN WITH TEXTBOX

2011-08-04 Thread Frank Cazabon
But you can do that in a dropdown list too :) Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com On 04/08/2011 12:43 PM, Jerry Foote wrote: > It's so much easier to just press the first letter of the desired option > than navigating the combo b

Re: call different browser

2011-08-08 Thread Frank Cazabon
Hi Gary, what's the code in GoURL? BTW, it's better if you do not hard code paths in your code as it makes moving things around a pain. Just call the program like this: DO GoURL WITH "whatever" and make sure GoURL is in your path or compiled into your exe/app Frank.

Re: call different browser

2011-08-09 Thread Frank Cazabon
. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com On 08/08/2011 08:09 PM, Gary Jeurink wrote: > I am self taught and know very little about exe and com. I make forms that > call other forms and store procedures like GoURL in the program directory > and at

Re: VFP9SP2 - Error 2066: Index file "z:\data\costs.cdx" tag "Njobid" is corrupted. Please rebuild it.

2011-09-06 Thread Frank Cazabon
Have you disabled SMB2? http://www.petri.co.il/how-to-disable-smb-2-on-windows-vista-or-server-2008.htm Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com On 06/09/2011 02:50 PM, MB Software Solutions, LLC wrote: > Got a client getting this somew

Re: Report Builder

2011-09-30 Thread Frank Cazabon
Hi Paul, I'm a little late to the conversation and haven't read all the replies, but just in case, an alternative that I use is my code removes the Tag info whenever a report gets run. I copy the FRX to a temp report, remove the tags, then run the temp report, then delete it. Fra

Re: VFP9: Multiple Check Box Clicks

2011-10-21 Thread Frank Cazabon
IF iOwnerid # tiCustId SKIP ELSE EXIT ENDIF ENDDO ELSE LOCATE FOR iOwnerId = tiCustId ENDIF llRetVal = .T. ENDIF RETURN llRetVal Frank. Frank Cazabon On 21/10/2011 02:01 PM, Desmond Lloyd wrote: &

Re: VFP starting message

2011-10-27 Thread Frank Cazabon
Just a WAG: Does your shortcut to start VFP refer to a config.fpw in it that does not exist? The Target would be something like this: "C:\Program Files\Microsoft Visual FoxPro 9\vfp9.exe" -c "MyBadPath\config.fpw" Frank. Frank Cazabon On 27/10/2011 09:29 AM, Euric

Re: Question on storing calculated values in the database

2011-10-31 Thread Frank Cazabon
work is against SQL Server these days I would actually define a calculated field in the table itself, Frank. Frank Cazabon On 31/10/2011 01:34 PM, MB Software Solutions, LLC wrote: > I've always calculating values on the fly but have recently seen an > application where for their case

Re: Report Image

2011-11-04 Thread Frank Cazabon
Hi Jeff, please don't use a public variable unless absolutely necessary. You should be able to use a private one (or even a form property) declared in the same place you call the report from. Frank. Frank Cazabon On 04/11/2011 08:19 AM, Jeff Johnson wrote: > On 11/03/2011 11:26 A

Re: Network Install Problem

2011-11-15 Thread Frank Cazabon
. Exes run faster from the workstation than over the network and this way it makes rolling out updates very easy (which is I think the main reason people leave the exe on the server so there's only one place to copy the new exe to). Frank. Frank Cazabon On 15/11/2011 08:20 AM, Jeff Johnson

Re: Network Install Problem

2011-11-15 Thread Frank Cazabon
7;m confused. Frank. Frank Cazabon On 15/11/2011 09:18 AM, Jeff Johnson wrote: > Frank: I am certain I use the same loader as you do. ;^) I use the > VMP framework for all of my apps. I have set up a couple of sites this > way because the application has an activation code when in

Re: Network Install Problem

2011-11-15 Thread Frank Cazabon
Jeff, coming to think about it I probably did eventually switch over to Drew's loader, but had been using something else before, so I take that back about losing your money :) Agree with you about VMP! Frank. Frank Cazabon On 15/11/2011 09:52 AM, Jeff Johnson wrote: > Frank:

Re: Select speed

2011-11-21 Thread Frank Cazabon
no, SELECT - SQL is not affected by the current order of the table, only by what indexes are available and if they match your filtering/joining clauses Frank. Frank Cazabon On 21/11/2011 04:14 PM, Sytze de Boer wrote: > Hello foxers > Probably a dumb question but I'll risk it &g

Re: [NF] Anyone have a lot of Quickbooks experience?

2011-12-09 Thread Frank Cazabon
the code should still work. Frank. Frank Cazabon On 08/12/2011 01:30 PM, Stephen Russell wrote: > Looking to ask a few Q to anyone who pulls data from QBooks. > > Along the lines of do you use the QB API or ODBC. > > Lots more Q along the API route such as version(s) problems a

Re: Craig Boyd's VFPConnection classes

2011-12-09 Thread Frank Cazabon
Hi Andrew, were you referring to VFPCompression rather than VFPConnection, which is what Mike was asking about? Frank. Frank Cazabon On 08/12/2011 05:19 AM, Andrew Stirling wrote: > Hi Mike > > I've been using it in my payroll product from 6/4/08. > > Never had a proble

Re: Loading a form

2011-12-14 Thread Frank Cazabon
Try using a timer on the form On 14 Dec 2011 19:50, "Sytze de Boer" wrote: You foxperts can have another laugh at this greenie, but I'll risk it I have a simple form In the gotfocus event I store the seconds() to lcSecs and do while/enddo If seconds>lcSecs>2 thisform.release This works fine

Re: date handling in sql server 2005 express

2011-12-15 Thread Frank Cazabon
SQLEXEC(thisform.nHandle,m.lcSQL,'curInvoices') Frank. Frank Cazabon On 15/12/2011 05:11 PM, Rafael Copquin wrote: > My app is client-server (VFP9SP2/SQL SERVER 2008 EXPRESS) > > A typical select statement where dates are involved is: > > local cCmd > > cCmd = [select invdate

Re: Date typed-in problem

2012-01-10 Thread Frank Cazabon
Dave, won't VFP's own date validation kick in before you can try to catch anything in the valid? Frank. Frank Cazabon On 10/01/2012 12:22 PM, Dave Crozier wrote: > Check for the correct date in the Valid() event of the field and return a > messagebox() error and then return

Re: Date typed-in problem

2012-01-10 Thread Frank Cazabon
corner of the screen saying: Invalid Date. So I am guessing that the textbox is actually bound to a character value and there is some validation code in the textbox's valid that displays the "press space bar" message, so maybe you can change that code to work like you need it t

Re: Date typed-in problem

2012-01-12 Thread Frank Cazabon
Did you try various settings using the CURSOR part of SET NOTIFY? What version of VFP is this? Can you send a small sample showing the problem? Frank. Frank Cazabon On 11/01/2012 10:27 PM, Angel Dario Rodriguez wrote: > Hi Frank. > I tried changing the Set Notify parameters and n

Re: Date typed-in problem

2012-01-12 Thread Frank Cazabon
again, I'm just guessing. If you could show us the form or a sample illustrating the problem I think it will be safer than allowing dubious dates into your data by setting StrictDate to 0 Frank. Frank Cazabon On 12/01/2012 02:07 PM, Angel Dario Rodriguez wrote: > Hi Dave. >

Re: RE: Data not updating

2012-01-18 Thread Frank Cazabon
Is a network involved, or is this happening with both apps and data on the same computer? On 18 Jan 2012 19:19, "Kent Belan" wrote: Both old and new apps are have buffering set to 3 on all tables. I have coded the new app to close the table just after the save and just prior to the load. I tho

Re: RE: RE: Data not updating

2012-01-18 Thread Frank Cazabon
Was wondering if smb2 was coming into play. Maybe there's some kind of caching being done by windows? On 18 Jan 2012 19:30, "Kent Belan" wrote: Right now I am testing both apps on the same computer running in the same folder. -Original Message- From: profox-boun...@leafe.com [mailto:p

Re: RE: RE: Data not updating

2012-01-18 Thread Frank Cazabon
Check if disk write caching is on. If it is switch it off On 18 Jan 2012 19:38, "Frank Cazabon" wrote: Was wondering if smb2 was coming into play. Maybe there's some kind of caching being done by windows? > > On 18 Jan 2012 19:30, "Kent Belan" wrote: >

Re: Delimited dilemma

2012-01-18 Thread Frank Cazabon
Try this: TEXT TO m.lctext NOSHOW TEXTMERGE "Frank","1234567.89" ENDTEXT STRTOFILE(m.lcText, "Test.txt") CREATE CURSOR c_Import; (UserName c(10),; UserFee n(10,2)) APPEND FROM test.txt TYPE DELIMITED This should bring the number in as numeric. Frank. Frank Caz

Re: Data not updating

2012-01-19 Thread Frank Cazabon
Kent, did you try my suggestion of switching off the disk write caching? Frank. Frank Cazabon On 19/01/2012 12:14 PM, Kent Belan wrote: > Hello Alan, > > Yes, both old and new apps are accessing the same dbf tables. > > When I exit the new app, all the data magically appears

Re: SQL Syntax

2012-01-20 Thread Frank Cazabon
to ensure you have a particular field width/type. SELECT CAST(IIF(payment > 10 , NULL,NULL) as N(10,2)) AS Result from provider Disclaimer: Written off the top of my head so the syntax may not be quite right. Frank. Frank Cazabon On 20/01/2012 04:10 PM, Sytze de Boer wrote: > I don&#

Re: Using VFP 9 to modify a VFP 7 system

2012-01-31 Thread Frank Cazabon
Dan, You don't use sql in your forms? Why not? On 31 Jan 2012 20:13, "Dan Covill" wrote: John: The main gotcha I know of in going from 7 to 9 is in the SQL logic, which is unlikely to appear in a form method. So you should be able to twiddle the form in VFP9, then run it in 7, so long as you d

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Frank Cazabon
re' is a method of a business object. In other words, it's an n-tier system, UI is one of the tiers, and it does NOT worry its pretty head about data structures or indexes. Another advantage is that my forms are smaller, simpler, and faster. Dan On 01/31/12 17:03, Frank Cazabon wrote:

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Frank Cazabon
Although I would also have an InvoiceBO.GetInvoiceTotal() which would actually go back to the database to calculate the total and use that in other cases. Frank. Frank Cazabon On 01/02/2012 02:00 PM, Dan Covill wrote: > On 02/01/12 02:49, Frank Cazabon wrote: >> Ah, all my systems ar

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Frank Cazabon
yes, it does make development easier, but I still do find instances where I would use SQL in the UI for display purposes, but maybe I should be trying to avoid that more. Frank. Frank Cazabon On 01/02/2012 12:38 PM, MB Software Solutions, LLC wrote: > On 2/1/2012 5:49 AM, Frank Caza

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Frank Cazabon
OK, cool. Of course you need the with (buffering = .T.) clause in your SQL if you use buffered data :) Frank. Frank Cazabon On 01/02/2012 03:12 PM, MB Software Solutions, LLC wrote: > On 2/1/2012 1:20 PM, Frank Cazabon wrote: >> yes, it does make development easier, but I stil

Re: [NF] Sharing a LogMeIn Rescue license

2010-03-03 Thread Frank Cazabon
Yes, GoToMeeting allows you to share desktops and you can easily switch between whose desktop is being shared. Just to mention another option: teamviewer Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone

Re: Epson ActionPrinter 5000 and Windows 7

2010-03-03 Thread Frank Cazabon
d the solution on Google :) Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit from our services, please contact me. We would appreciate the opportunity to work with them. On 03/03/2010 12:

Re: [NF] Sharing a LogMeIn Rescue license

2010-03-03 Thread Frank Cazabon
Paul, LogMeIn is only free for personal use. Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit from our services, please contact me. We would appreciate the opportunity to work with them

Re: general data field

2010-03-11 Thread Frank Cazabon
great. So either use a naming convention for the image names (for example I would name the image the same as the primary key from mytable) or store the path to the image in a memo field and use that to refer to the image. Hope this helps, Frank. Frank Cazabon Samaan Systems Ltd. - Devel

Re: UK English spell check utility

2010-03-12 Thread Frank Cazabon
SweetPotatoSoftware has a spell check with which I believe you can use an English/UK dictionary: http://www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,8800bdb9-a9c2-484f-942f-6a08947d903a.aspx Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals

Re: [NF] an Internet crime story

2010-03-20 Thread Frank Cazabon
Bill, this is definitely a scam. My brother's girlfriend almost got caught. Google it and you will find lots of references Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit fro

Re: Problem with VFP9SP2 form not showing (not respecting modality)

2010-03-29 Thread Frank Cazabon
Just a WAG, but maybe the form that calls this form is set to a Top Level Form? If so I don't think you can show a Modal form in a Top Level form. Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyon

Re: Problem with VFP9SP2 form not showing (not respecting modality)

2010-03-29 Thread Frank Cazabon
project that shows this that I can email to you if you want to see what I am talking about. Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit from our services, please contact me. We would

Re: Find path to winword.exe?

2010-04-19 Thread Frank Cazabon
Why not start it using Automation? Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit from our services, please contact me. We would appreciate the opportunity to work with them. On 19

Re: Find path to winword.exe?

2010-04-19 Thread Frank Cazabon
Just out of interest, what are those switches? I had thought that you could do everything through automation :) Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit from our services

Re: Find path to winword.exe?

2010-04-20 Thread Frank Cazabon
thanks Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit from our services, please contact me. We would appreciate the opportunity to work with them. On 19/04/2010 09:42 PM, Malcolm

Re: [NF] Personal firewall software for limiting access to internet by total time or specific time periods

2010-04-23 Thread Frank Cazabon
I think SafeEyes has a time limit function: http://www.internetsafety.com/safe-eyes-parental-control-software.php Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit from our services

Re: VFP9..CANNOT UPDATE CURSOR..WINDOWS 7

2010-04-27 Thread Frank Cazabon
I would guess the user does not have security rights allowing them to modify files in the folder. Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit from our services, please contact me

Re: [NF] SQL Server 2008 much harder than MySQL in terms of installation and removal

2010-04-27 Thread Frank Cazabon
I've installed the express version twice in the last week without a hitch. One was on a Vista Business PC, next was on Server 2008. Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit

Re: [NF] SQL help: Maybe child, maybe not

2010-06-18 Thread Frank Cazabon
INTO moc VALUES (6, 3, "Work", "facsimile", "507-555-6511") SELECT per_name + " " + NVL(moc_address, SPACE(50)); FROM person; LEFT JOIN moc ON person.person_id = moc.person_id; AND moc_medium = "telephone" Frank. Frank Cazabon Sa

Re: [NF] SQL help: Maybe child, maybe not

2010-06-18 Thread Frank Cazabon
oops, I see Ted answered already, sorry Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit from our services, please contact me. We would appreciate the opportunity to work with them. On

Re: [NF] SQL help: Maybe child, maybe not

2010-06-18 Thread Frank Cazabon
Thanks, the code to create the test data is something I wish everyone would do when posting questions, it makes life so much easier for the helper. Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who

Re: AW: Custom Scrollbar

2019-01-10 Thread Frank Cazabon
Gene, I've knocked up a quick demo which I hope meets your requirements and emailed you the link to the download on google drive. Frank. Frank Cazabon On 09/01/2019 02:52 PM, Gene Wirchenko wrote: At 05:28 2019-01-08, Frank Cazabon wrote: Gene, back in April last year you were aski

Re: AW: Custom Scrollbar

2019-01-10 Thread Frank Cazabon
ng Let me know if there is a problem downloading the file as I generally don't share files this way, so may have made a silly mistake when trying to share it. Frank. Frank Cazabon On 10/01/2019 11:25 AM, Koen Piller wrote: Frank Would you mind to e-mail me the link also? Regards Koe

Re: AW: Custom Scrollbar

2019-01-10 Thread Frank Cazabon
Weird if I have entered 8 in the column text. Is that how it is supposed to work? Regards, Koen Is it that you are getting the message regarding that validation? Frank. Frank Cazabon ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: AW: Custom Scrollbar

2019-01-10 Thread Frank Cazabon
Give me examples of what you are entering. I enter The Text as 5, Even # as 2 and Weird # as 3 successfully because 5 % 2 = 1 and 3 % 2 = 1. Frank. Frank Cazabon On 10/01/2019 04:03 PM, Koen Piller wrote: Yes and still I cannot enter any value in weird Regards Koen Op do 10 jan. 2019 om

RE: AW: Custom Scrollbar

2019-01-10 Thread Frank Cazabon
> >-Original Message- >From: ProfoxTech On Behalf Of Frank >Cazabon >Sent: Thursday, January 10, 2019 3:19 PM >To: profoxt...@leafe.com >Subject: Re: AW: Custom Scrollbar > >Give me examples of what you are entering. I enter The Text as 5, Even ># as 2 and We

RE: AW: Custom Scrollbar

2019-01-10 Thread Frank Cazabon
ters? > >-- > >rk > >-Original Message----- >From: ProfoxTech On Behalf Of Frank >Cazabon >Sent: Thursday, January 10, 2019 3:40 PM >To: profoxt...@leafe.com >Subject: RE: AW: Custom Scrollbar > >What control? The text? > >This is a quick knock up for Gene to

Re: AW: Custom Scrollbar

2019-01-14 Thread Frank Cazabon
On 14/01/2019 07:27 PM, Gene Wirchenko wrote: At 06:06 2019-01-10, Frank Cazabon wrote: Gene, I've knocked up a quick demo which I hope meets your requirements and emailed you the link to the download on google drive. I was beat last week, and did not get to it.  I have a couple

Re: Foxite?

2019-02-21 Thread Frank Cazabon
It was up a couple days ago but seems to be having some trouble now as I get: The server at www.foxite.com is taking too long to respond. Frank. Frank Cazabon On 21/02/2019 08:28 AM, Dave Crozier wrote: Is Foxite still up and running or has it been retired? Can’t seem to get access to a

Re: [NF] Change DVD Internal Player to 0

2019-02-26 Thread Frank Cazabon
Have you googled it? Frank. Frank Cazabon On 25/02/2019 03:15 PM, Charles Hart Enzer, M.D. wrote: Mistake. DVD Player is not a Toshiba. DVD Player is a *DVD+-RW DU-8A5LH* *Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinn

Re: VF9 - Running an app on a schedule....

2019-03-13 Thread Frank Cazabon
When I've had similar issues it's normally somebody has moved the app or supporting files or changed the password of the user who is so to run the task. Does the task scheduler show you an error code for the last run? On 13 March 2019 19:38:49 GMT-04:00, Desmond Lloyd wrote: >Have a small app

Re: [NF] Why don't more folks use RDP?

2019-03-22 Thread Frank Cazabon
I have a client that uses it for running a VFP front end SQL server back end database that is on rackspace that they wanted to have faster response for running large queries. The only issue is the expense of the licences which I don't think was too bad. Frank. Frank Cazabon On 22/03/20

Re: AW: Custom Scrollbar

2019-03-22 Thread Frank Cazabon
Gene, did you ever give this a good testing? Frank. Frank Cazabon On 14/01/2019 07:56 PM, Frank Cazabon wrote: On 14/01/2019 07:27 PM, Gene Wirchenko wrote: At 06:06 2019-01-10, Frank Cazabon wrote: Gene, I've knocked up a quick demo which I hope meets your requirements and emaile

Re: AW: Custom Scrollbar

2019-03-25 Thread Frank Cazabon
Hmm, OK. :( Frank. Frank Cazabon On 22/03/2019 04:54 PM, Gene Wirchenko wrote: At 10:21 2019-03-22, Frank Cazabon wrote: Gene, did you ever give this a good testing? Nope.  Got onto other things. [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server

Re: [NF] Conditions in JOIN clause instead of WHERE

2019-04-04 Thread Frank Cazabon
oins-where-vs-on or this: https://stackoverflow.com/questions/10297231/where-clause-vs-on-when-using-join Frank. Frank Cazabon On 02/04/2019 06:05 PM, Garrett Fitzgerald wrote: Hey, all. I had a general SQL question. Often, I find myself needing to use the syntax: FROM a LEFT JOIN b

Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

2019-04-22 Thread Frank Cazabon
If your clients are anything like my clients, make sure you allow them access to change the historical dates after they've changed the price. Someone is bound to change the price at the wrong time and need to go back in and adjust it. On 22 April 2019 15:33:48 GMT-04:00, "MB Software Solution

RE: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

2019-04-22 Thread Frank Cazabon
l Message- >From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >Frank Cazabon >Sent: Monday, April 22, 2019 4:21 PM >To: profoxt...@leafe.com >Subject: Re: How best to do an audit trail of changes (EASILY WITHOUT >THE NEED FOR A DBA) > >If your clie

Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

2019-04-23 Thread Frank Cazabon
riggers to record the changes and don't let users edit the audit data. Frank. Frank Cazabon On 22/04/2019 10:38 PM, MB Software Solutions, LLC wrote: On 4/22/2019 6:13 PM, Frank Cazabon wrote: Yeah, my succinct point :) was I didn't think it should be a log but a table that allows

Re: ProFox Messages are not showing up

2019-05-03 Thread Frank Cazabon
I never get Paul's or Fletcher's messages unless I go into Gmail and clear them from span. I got the bounces message too. On 3 May 2019 16:27:59 GMT-04:00, Ted Roche wrote: >I did, too. I noticed that Paul Newton posted a bunch of messages >yesterday, and I haven't gotten them in a long time. >

Re: ProFox Messages are not showing up

2019-05-03 Thread Frank Cazabon
I use my Gmail account for this list. I just looked at the archives and I have received all emails from the last few days except for Paul Newton's (which shows up as suspected spam in the archive). His message and Fletcher's consistently eggs up in my spam and I only become aware of them when so

Re: How would you generate this report?

2019-05-15 Thread Frank Cazabon
I do stuff like that using Bookmarks in a Word template and automating their replacement. Frank. Frank Cazabon On 15/05/2019 03:05 PM, MB Software Solutions, LLC wrote: Screenshot of Word document in question (with notations for where content is dynamic; some parts blurred just to protect

Re: How would you generate this report?

2019-05-15 Thread Frank Cazabon
wrote: >How do you dynamically add the rows?  Via Office Automation code?  If >so, care to share? > > >On 5/15/2019 4:54 PM, Frank Cazabon wrote: >> I do stuff like that using Bookmarks in a Word template and >automating >> their replacement. >> >> Frank.

Re: How would you generate this report?

2019-05-15 Thread Frank Cazabon
nRow,1].Range.Font.Bold = .T.                 oTable.Cell[m.lnRow,1].RANGE.InsertAfter("TOTAL")                 oTable.Cell[m.lnRow,2].Range.Font.Bold = .T.                 oTable.Cell[m.lnRow,2].RANGE.InsertAfter(ALLTRIM(TRANSFORM(NVL(m.lnTotalExpense, 0), "@R $,$$$,$$9.99"

Re: Changing VFP menu (during runtime in app) FONT NAME

2019-05-17 Thread Frank Cazabon
it won't have any effect anyhow. I believe if you want special fonts for your menus you will need to make your own special menu which is not a menu :0). Frank. Frank Cazabon On 17/05/2019 12:27 AM, MB Software Solutions, LLC wrote: VFP9SP2 on Win7/8/10 I see in VFP Help that if you

Re: Changing VFP menu (during runtime in app) FONT NAME

2019-05-17 Thread Frank Cazabon
Of course having said that, I googled and found this: https://www.tek-tips.com/faqs.cfm?fid=6328 Frank. Frank Cazabon On 17/05/2019 08:48 AM, Frank Cazabon wrote: When you adjust the MPR then regenerate, the code is not in the MNX so it will not add it into the MPR. You can try to use one

Re: Visual MaxFrame Professional

2019-05-17 Thread Frank Cazabon
Russ Swall sold the business (Vision Pace) in 2015 but I don't know to whom and if they support VMP. You can ask Art Bergquist (abergquist AT sbcglobal DOT net) more about the business status of VMP. If you have specific questions about VMP maybe I can help. Frank. Frank Cazabon On 17/05

Re: [NF] Fun with Table of Contents in MS Word 2016 (...NOT FUN)

2019-06-04 Thread Frank Cazabon
Sounds like someone changed the format of the table of contents. This might help: https://support.office.com/en-us/article/format-or-customize-a-table-of-contents-9d85eb9c-0b55-4795-8abb-a49885b3a58d Frank. Frank Cazabon On 03/06/2019 03:48 PM, MB Software Solutions, LLC wrote: Inherited

Re: [NF] Fun with Table of Contents in MS Word 2016 (...NOT FUN)

2019-06-04 Thread Frank Cazabon
This could also help: https://www.microsoft.com/en-us/microsoft-365/blog/2012/01/18/customize-5-table-of-contents-tricks/ Frank. Frank Cazabon On 03/06/2019 03:48 PM, MB Software Solutions, LLC wrote: Inherited somebody's document, needed to make edits, but when I rebuild the content

Re: [NF] What would you miss from VFP, when migrating

2019-06-28 Thread Frank Cazabon
To make your code safer, ensure you use parameters: m.CompanyID = ALLTRIM(thisform.CoCode.value) m.lcWhereClause = "WHERE emp.CpnyID = ?m.CompanyID" Frank. Frank Cazabon On 28/06/2019 11:14 AM, Paul H. Tarver wrote: I've never doubted the benefits of stored procedures and

Re: [NF] What would you miss from VFP, when migrating

2019-06-28 Thread Frank Cazabon
I've never heard that. If you can find any references to that please let me know Frank. Frank Cazabon On 28/06/2019 01:20 PM, MB Software Solutions, LLC wrote: That's always been my approach to avoiding SQL injection but I thought Steve or somebody else here LONG ago had deb

Re: [NF] What would you miss from VFP, when migrating

2019-06-28 Thread Frank Cazabon
  AERROR(laError)     SET STEP ON     STRTOFILE("Error: " + laError[2] + " Unable to execute:" + m.tcSQL + CRLF, "Convert DivChqs to Stars.log", 1) ELSE     IF NOT EMPTY(m.tcMessage)         STRTOFILE(m.tcMessage + CRLF, "Convert DivChqs to Stars.log", 1)     END

Re: [NF] What would you miss from VFP, when migrating

2019-06-28 Thread Frank Cazabon
; >"1 = 1; drop table deleteMe ; --" > >" or 1 = 1; drop table deleteMe ; --" > >On Fri, Jun 28, 2019 at 1:34 PM Frank Cazabon >wrote: > >> I created a database SQL Server called junk and added a table called >> deleteme with one column called test n

Re: [NF] What would you miss from VFP, when migrating

2019-07-01 Thread Frank Cazabon
Stephen, just in case you missed my question: Do you mean change this line: m.CompanyID = "1 = 1; drop table deleteMe ; --" To this: m.CompanyID = "or 1 = 1; drop table deleteMe ; --" Frank. Frank Cazabon On 28/06/2019 04:23 PM, Stephen Russell wrote: I believe that

Re: [NF] What would you miss from VFP, when migrating

2019-07-01 Thread Frank Cazabon
you can take my code and adjust it to show what the issue is? Frank. Frank Cazabon On 01/07/2019 02:40 PM, Stephen Russell wrote: Actually, in the textbox of your form, you would put it there. ' or 1 = 1; Drop table deleteMe ; -- The closing quote mark, the Or condition with the semic

Re: [NF] What would you miss from VFP, when migrating

2019-07-02 Thread Frank Cazabon
Ah, I was concerned that all these years of me using parameters for safety you had some proof that they were unsafe. Frank. Frank Cazabon On 01/07/2019 03:54 PM, Stephen Russell wrote: 25 years ago as a guess. I probably didn't use the ? operator. On Mon, Jul 1, 2019 at 2:39 PM MB Sof

Re: [NF] What would you miss from VFP, when migrating

2019-07-02 Thread Frank Cazabon
avoid SQL Injection (using parameters) had a problem. I thought you were trying to illustrate that problem but it appears to be some mis-communication as you were not referring to using parameters. All the testing has been done years ago so I don't need to go over that again. Frank. Fra

Re: Super bizarre page.init bug on form.pageframe -- it never runs! (VFP9SP2)

2019-07-03 Thread Frank Cazabon
Are you sure that what you are running is what you are editing? On 3 July 2019 16:03:21 GMT-04:00, "MB Software Solutions, LLC" wrote: >I added 2 pages to my existing pageframe so that I could add more >functionality to this form.  There are pages that I conditionally >instantiate based on use

Re: Super bizarre page.init bug on form.pageframe -- it never runs! (VFP9SP2)

2019-07-03 Thread Frank Cazabon
se11.Caption = "Differences" >Pagbase11.PageOrder = 11 >Pagbase11.ToolTipText = "Factor/Rate differences across the job >(checking for outdated pricing)" >Pagbase11.Name = "pagDifferences" >Pagbase12.Caption = "Released" >Pagbase12.PageOrder

Re: Missing messages....

2019-07-17 Thread Frank Cazabon
I never get yours or Paul Newton's, they always end up in spam in gmail. I'm only made aware of them when someone replies to your messages. However in this case Paul's original message isn't even in spam! Frank. Frank Cazabon On 16/07/2019 11:34 AM, Fletcher Johnson wr

Re: [NF] Inadvertent Movement of Documents Folder

2019-07-22 Thread Frank Cazabon
Hey Ken, you can move a folder using drag and drop if you hold down the Ctrl key while dragging and dropping. I have known experienced users to do this by mistake. I've even done it a couple times, thankfully I realised quite quickly that I had moved the wrong folder. Frank.

Re: [NF] Inadvertent Movement of Documents Folder

2019-07-22 Thread Frank Cazabon
. (at leats I think those are the corresponding keys to move or copy) Frank. Frank Cazabon On 22/07/2019 03:33 PM, Ken Dibble wrote: Hey Ken, you can move a folder using drag and drop if you hold down the Ctrl key while dragging and dropping. I have known experienced users to do this by mi

Re: [NF] Inadvertent Movement of Documents Folder

2019-07-24 Thread Frank Cazabon
I guess depending on the size of the files and the speed of the PC/drives involved you may get the notification window showing files being copied. Frank. Frank Cazabon On 22/07/2019 03:47 PM, Ken Dibble wrote: Presumably, though, if you did that with a folder that contains, say, a few

Re: [NF] SQL - search all fields in all records in all tables

2019-07-29 Thread Frank Cazabon
Or you could use the free SQL Search tool from red gate: https://www.red-gate.com/products/sql-development/sql-search/ Frank. Frank Cazabon On 26/07/2019 04:20 PM, M Jarvis wrote: I didn't write this, nor do I know it's source. But some of our devs are treating it like a new toy so

Re: Working with multi-page PDF files and automatically labeling and later extracting select pages

2019-08-01 Thread Frank Cazabon
PDF toolkit might let you split a PDF into separate PDFs. But it really sounds like you should keep the original PDFs as separate entities and deal with each component as you wish. On 1 August 2019 16:19:10 GMT-04:00, "MB Software Solutions, LLC" wrote: >Customer has a single PDF ("document")

Re: Working with multi-page PDF files and automatically labeling and later extracting select pages

2019-08-02 Thread Frank Cazabon
This is the PDF Toolkit I have used: https://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/ which allows you to merge and split (and more) PDFs Frank. Frank Cazabon On 02/08/2019 08:02 AM, MB Software Solutions, LLC wrote: Ideally, these would be the tables: MyComponents.dbf  * iid int

Re: Working with multi-page PDF files and automatically labeling and later extracting select pages

2019-08-02 Thread Frank Cazabon
+ CHR(13) +;                 'Would you like to open it now?',36,'PDF Merge Successful') = 6             X8ShellExecute(m.lcFilledForm)         ENDIF     ELSE         MESSAGEBOX("The system encountered a problem creating the PDF.",64,"Problem Encountered")     ENDIF Fr

Re: SQL server connection

2019-08-20 Thread Frank Cazabon
work now in VFP I would probably use CursorAdapters but I have never actually used them for more than playing with to learn about them. I believe they give you enough flexibility while hiding some of the technical details. If you want absolute control, then go with SPT. Frank. Frank Cazabo

Re: SQL server connection

2019-08-20 Thread Frank Cazabon
Yes, agreed using stored procedures is a good way, however I believe you still need SPT or CursorAdapters to access those stored procedures, so they are not necessarily mutually exclusive. Frank. Frank Cazabon On 20/08/2019 09:42 AM, Stephen Russell wrote: Considering they are flipping over

Re: SQL server connection

2019-08-21 Thread Frank Cazabon
I use SQL native client (which is an option to install when installing SQL server): https://www.microsoft.com/en-us/download/details.aspx?id=50402 And then I use a connection string like: ConnectionString=DRIVER=SQL Server Native Client 11.0;Trusted_Connection=Yes;DATABASE=GoldBuy;SERVER=MySer

Re: Easiest/best way to create an email using local MS Outlook with file attachments?

2019-08-21 Thread Frank Cazabon
Mike, along with Alan's code you can use loMsg.Display() to display the email on screen before sending. Frank. Frank Cazabon On 21/08/2019 04:17 AM, Alan Bourke wrote: If you want to use Outlook: loOutlook=CreateObject("Outlook.Application") loMsg = loOutlo

Re: SMB

2019-08-27 Thread Frank Cazabon
G_DWORD0 = disabled1 = enabled 4. Set the value to 0 to disable SMB 2.0, or set it to 1 to re-enable SMB 2.0. 5. Reboot the server. This paper may also be of some assistance: https://www.dataaccess.com/KBasePublic/Files/2476.Tuning%20Microsoft%20Networks%20for%20the%20Legacy%20Embedde

  1   2   3   4   5   6   7   8   >