Re: Handling multipile Container classes

2024-07-16 Thread Joe Yoder
ase for the SetAll() method. You can set a property > (e.g. Enabled) of all instances of a class in one swoop. > > See The Hacker's Guide <https://hackfox.github.io/section4/s4g394.html> > for > details. > > Eric > > > On Fri, Jul 12, 2024 at 6:17 PM Joe Yoder wrote: > &

Handling multipile Container classes

2024-07-12 Thread Joe Yoder
First of all - Thanks very much for all the help in my quest to really understand classes. I am finally at the place that I can make a change and expect it to work. BTW = I was able to run the code version of my class and find my issues. I will have multiple instances of a container class on a

Re: Class code issue

2024-07-11 Thread Joe Yoder
p = 30 > > ENDDEFINE > > > * define the customized form > DEFINE CLASS formclass as Form >WindowType = 1 > >ADD OBJECT spotpick1 as spotpick1 > >PROCEDURE init > This.AddSecondContainer() >ENDPROC > >

Class code issue

2024-07-10 Thread Joe Yoder
I am developed a custom class based on a container that worked properly when it was on a form but when I converted it to a class I have issues I can't resolve. I have only one installation of VFP and sometimes I wonder if it might be corrupt. In order to avoid any corruption of the visual tools

Form designer to first time use of class designer

2024-07-04 Thread Joe Yoder
I have just completed developing a form with a container that has embedded controls. I want to convert the container to a class so I can use multiple instances on a form. I spent a good bit of time getting things to look and work right in the container on the form designer with the

Combo box issues

2024-06-26 Thread Joe Yoder
I am looking for a way to have a combo box display its dropdown programmatically. I want to do this to make it obvious that the user needs to make a choice. I have read that 'thisform.combobox.dropdown()' should do the trick but the form comes up with the proper information in the dropdown which

Re: Combobox followup

2024-06-18 Thread Joe Yoder
t; wOOdy > > -----Ursprüngliche Nachricht- > Von: ProFox Im Auftrag von Joe Yoder > Gesendet: Dienstag, 18. Juni 2024 02:33 > An: profoxt...@leafe.com > Betreff: Combobox followup > > Thanks Eric for the input. I think I have correctly made the changes you > sugge

Combobox followup

2024-06-17 Thread Joe Yoder
Thanks Eric for the input. I think I have correctly made the changes you suggested but the code fails with "Unknown member oComboBox" Here is the code as I have it now: * Procedure to add a ComboBox to the form PROCEDURE AddComboBoxToForm(toForm, nTop, nLeft, cname) LOCAL oComboBox

Programatically generated Combo boxes

2024-06-17 Thread Joe Yoder
I have been trying to come up with simple code to let me generate and configure ComboBoxes in code. I have succeeded in creating one combo and controlling its top and left properties by passing parameters but when I try to pass in a name things don't work. Here is the procedures code in a file

Re: List box issues

2024-04-24 Thread Joe Yoder
vChange? > > Thanks, > > Joe > > On Wed, Apr 24, 2024 at 10:00 AM Tracy Pearson > wrote: > > > Should the code in the Lost Focus event actually be in the Interactive > > Change event? > > > > -Original Message- > > From: ProfoxTec

Re: List box issues

2024-04-24 Thread Joe Yoder
event? > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe > Yoder > Sent: Tuesday, April 23, 2024 9:53 PM > To: profoxt...@leafe.com > Subject: Fwd: List box issues > > Thanks to Fletcher for the cursor clue I am closer t

Fwd: List box issues

2024-04-23 Thread Joe Yoder
Thanks to Fletcher for the cursor clue I am closer to what I want. I have 2 files: Spaces with fields space_id and descript Units with fields : unit_id, space_id, and descript I have a form with a list box for each the Spaces list box has the row source set to 6 (Fields) of Spaces the

List box issues

2024-04-23 Thread Joe Yoder
I have 2 files: Spaces with fields space_id and descript Units with fields : unit_id, space_id, and descript I have a form with a list box for each the Spaces list box has the row source set to 6 (Fields) of Spaces the Units list box has the Row Source type set to 3 (SQL Statement) and

Re: [ADMIN] Email issue

2024-04-23 Thread Joe Yoder
This time when I checked it was in spam so I should be good to go Thanks very much! Joe On Tue, Apr 23, 2024 at 1:12 PM Ed Leafe wrote: > On Apr 23, 2024, at 11:22, Joe Yoder wrote: > > > > I no longer get any of the list emails. The only way for me to get > answers &

Email issue

2024-04-23 Thread Joe Yoder
I no longer get any of the list emails. The only way for me to get answers to my questions is by going to the archive. Does anyone know how to restore delivery? I can't reply to an email I don't get so here is a big THANK YOU to Tracy for the quick solution to my display issue! Joe ---

VFP Form designer display issue

2024-04-23 Thread Joe Yoder
The form designer allows a user to select a screen area by clicking on a corner of the target area and dragging to the opposite corner. This works correctly but during the drag, the selected area is incorrectly shown above and to the left. This behavior occurs when selecting an area on screen to

Programatically placing text boxes on a form - continued

2023-10-30 Thread Joe Yoder
Tracy, Thanks for the help - the first line makessence and executes just fine but the "oTextbox = evaluate" line errors with variable "TEXTBOX11" is not found. Do I need something in my code or on my form to have this work properly? BTW - sorry for not doing this as a reply. My email no longer

Programatically placing text boxes on a form

2023-10-29 Thread Joe Yoder
I know I had code years ago that did this but it apparently got mangled during computer transitions. The code below runs in the load event of a form but results in a blank form. The ,"parent = thisform line" is commented out because it causes a "Property PARENT is read-only" error.. FOR i = 1

Classlib setting in VFP

2023-10-23 Thread Joe Yoder
Something has happened to my VFP configuration When I do a ?set("classlib" ) I get nothing When I try Set Classlib to "C:\Program Files (x86)\Microsoft Visual FoxPro 9\Wizards\" the system reports "file c:\program files (x86)\microsoft visual foxpro9\wizards.vcx does not exist. This seems to

Installing VFP 9.0 on Windows 10

2023-06-03 Thread Joe Yoder
Im getting "This App can't run on your PC when I try to run Setup. Does someone have a sharable installation cheat sheet with the details of steps and service packs to use? I have a laptop with VFP 9.0 working just fine but I believe it was installed before the machine was upgraded to Windows 10.

Re: Passing parameters to an external program run from fox

2023-05-08 Thread Joe Yoder
at 2:12 AM Joe Yoder wrote: > I'm pretty sure I have done this before but now I can't figure out the > syntax to make this happen. I finally substituted a batch file to display > the parameters passed in and to pause to allow reading time. The batch > file reports parameters passed in

Passing parameters to an external program run from fox

2023-05-05 Thread Joe Yoder
I'm pretty sure I have done this before but now I can't figure out the syntax to make this happen. I finally substituted a batch file to display the parameters passed in and to pause to allow reading time. The batch file reports parameters passed in from the command linre but none from VFP. Can

Byte Arrays in VFP

2023-05-01 Thread Joe Yoder
I want to pull a 3.5 meg file into a Byte Array in Fox, make some changes to individual bytes, and write the array back to another file. The only way I have found to do so is to build the array one character at a time. Is there a better way to do this? Thanks in advance for any input , Joe

Re: .csv file imports to VFP

2023-04-17 Thread Joe Yoder
roblem rows have any weird non ASCII > characters ir anything? > > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > > On Sun, 16 Apr 2023, at 3:35 AM, Joe Yoder wrote: > > I have an accounting system data dump that I export each year at tax > time, > &g

.csv file imports to VFP

2023-04-15 Thread Joe Yoder
I have an accounting system data dump that I export each year at tax time, I think I have always had a few records that got mangled but this year I would like to solve the problem. My preferred technique is to create a cursor with the fields I need to import along with any required place holders.

Nulls and generated HTML

2022-09-27 Thread Joe Yoder
I have a table deliberately created with null values in numeric fields. This allows browsing the table and seeing zero value fields as blank rather than zero.. i want to print the table and expected to use the HTML generator on the file menu but it turns out that the nulls mess up the formatting

Fwd: Issues with referencing an array in a form

2022-04-25 Thread Joe Yoder
This works fine but I prefer the more elegant solution suggested by Jurgen which eliminates the array and substitutes the SQL select statement' (Row Source Type 3). Thanks again, Joe -- Forwarded message ----- From: Joe Yoder Date: Sat, Apr 23, 2022 at 7:00 PM Subject: Issues with r

Issues with referencing an array in a form

2022-04-23 Thread Joe Yoder
I want to call a form to select the year for a report and then print the report. I do a select into array to get the list of choices into array YearArr in the load procedure of the form but when the form attempts to load a combo box using the array as the list of choices I get the message YearArr

Combining PDFs for printing multiple images on a sheet

2021-10-18 Thread Joe Yoder
I have G-code that produces PDF images of labeled charts one chart per day. I want to combine seven daily charts into a weekly sheet that will be printed from Acrobat Reader. As near as I can tell there is no straightforward code in the Google scripting world to combine multiple pdfs into a

Re: Data transfer design Data transfer design (VFP to Google Sheets)

2021-09-20 Thread Joe Yoder
d > protected and insured and identified as the seller's property but shall be > entitled to resell or use the goods in the ordinary course of its business. > Until such time as the property in the goods passes to the buyer the seller > shall be entitled at any time > -Original Me

Data transfer design Data transfer design (VFP to Google Sheets)

2021-09-17 Thread Joe Yoder
I have VFP code that combines multiple events recorded on a phone app into a single Timeline table. The final step in the code is to copy to type XL5. Each time the code is run to include new data, the output file is written with the same name I opened the resulting file in Google sheets with

Time variables

2021-07-26 Thread Joe Yoder
I want to build a cursor of time fields for export to Excel. The DateTime format allows a simple for next loop to increment the time value by a specified number of seconds. Is there a function that allows the extraction of the time portion of a DateTime variable as a time value not as a string?

Re: Formset goofy

2021-05-26 Thread Joe Yoder
t; -Original Message----- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe > Yoder > Sent: Wednesday, May 26, 2021 5:29 PM > To: profoxt...@leafe.com > Subject: Formset goofy > > I have been working with two forms in a formset for the first time. All >

Formset goofy

2021-05-26 Thread Joe Yoder
I have been working with two forms in a formset for the first time. All has worked out well as the two forms are simply two perspectives on the underlying data. I switch between them by turning visible on and off. One of the forms somehow got set to max width in the development environment.

Re: Form designer rules?

2021-05-23 Thread Joe Yoder
load or init methods of the form it works without error so the code is okay Is there a different syntax needed here or do I need to handle this in a different way? Thanks, Joe On Sun, May 23, 2021 at 7:23 PM Joe Yoder wrote: > Tracy, > > I did another test form using days of the week like yo

Re: Form designer rules?

2021-05-23 Thread Joe Yoder
I added the "distinct" clause > and it still works. > > I tested in VFP 9 SP2 Hotfix 3 > > HTH, > Tracy > > -Original Message----- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe > Yoder > Sent: Saturday, May 22, 2021 3:04

Form designer rules?

2021-05-22 Thread Joe Yoder
I want to use an sql select statement as the row source for a combo box.. - When I set the row source type to 3-SQL and enter the row source as "select space distinct from map into cursor T1" attempting to run the form results in "Program error Unrecognized command verb" - If I set

Re: Navigating structure using list boxes?

2021-05-21 Thread Joe Yoder
each part. > > The other might be an <> ActiveX control. The ProjectExplorer > project Doug Hennig has made available uses the TreeView ActiveX control. > https://github.com/DougHennig/ProjectExplorer > > > HTH, > Tracy > > -Original Message- > From: Prof

Navigating structure using list boxes?

2021-05-19 Thread Joe Yoder
I am an infrequent user of VFP and have never mastered the GUI. I need to allow a user to choose storage locations from the structure below for several fields on a screen where the possible choices are in a structure several layers deep. Is there a control to handle this or a simple way to

_reportlistener.vcx

2019-10-09 Thread Joe Yoder
I have some code that uses the report listener to create PDF report files using XFRX. In May it was functioning properly but now when I load the program I get the following message: "File 'C:\...\common files\microsoft shared\vfp\ffc\_reportlistener.vcx' does not exist" The code runs without

Re: Landscape PDFs using XFRX

2019-04-23 Thread Joe Yoder
I reread what what I wrote and realize that The first sentence should have been "Using XFRX in VFP to convert Reports to create PDF files" - sorry - Joe On Tue, Apr 23, 2019 at 1:33 PM Joe Yoder wrote: > I have an older version of XFRX that I am converting to create PDF fi

Landscape PDFs using XFRX

2019-04-23 Thread Joe Yoder
I have an older version of XFRX that I am converting to create PDF files instead of printing reports directly. All reports are working well except the one that requires Landscape output. Apparently XFRX just ignores the printer orientation information in the Tag1 and Tag2 fields in the Report.frx

[NF] Recomendations for VFP to Python language reference?

2019-03-11 Thread Joe Yoder
I'm starting a Raspberry Pi project involving lots of temperature sensors along with some flow meters etc. I expect to work in Python and realize that a language reference assuming experience in VFP would be a good idea. Any recommendations? Thanks in advance, Joe --- StripMime Report --

Re: Numbering Scheme

2018-10-11 Thread Joe Yoder
How about converting to base 26 and printing alpha characters (A-Z)? This would allow easy sequencing and a simple program could convert an alpha string to a base 10 number when needed.- Joe On Thu, Oct 11, 2018 at 2:39 PM Frank Cazabon wrote: > They have that already. This is a physical

Unexpected results from a group by clause

2018-03-29 Thread Joe Yoder
I have an SQL select statement that includes a group by clause to order the output for reporting. It gets its data from a table that potentially includes legitimate duplicate records. SELECT account, date, memo, paid_amoun; FROM QB; GROUP BY account, date, memo, paid_amoun; INTO

Re: Automated email utility recommendations

2018-03-05 Thread Joe Yoder
inquiry that they can handle a zipped batch for a fee. That would be fine by me. - Joe On Mon, Mar 5, 2018 at 2:14 PM, Joe Yoder <j...@wheypower.com> wrote: > John - I think you mean SweetPotatoSoftware.com. It looks like there are > a lot of options there. Care to share which one y

Re: Automated email utility recommendations

2018-03-05 Thread Joe Yoder
John - I think you mean SweetPotatoSoftware.com. It looks like there are a lot of options there. Care to share which one you are using or started from? - Joe On Mon, Mar 5, 2018 at 1:33 PM, John Weller wrote: > I use a piece of code from sweetpotato.com which works

Re: Automated email utility recommendations

2018-03-05 Thread Joe Yoder
gt; > -Original Message----- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Joe Yoder > Sent: Monday, March 05, 2018 12:24 PM > To: profoxt...@leafe.com > Subject: Automated email utility recommendations > > This could be VFP or otherwise - not sure if there shoul

Automated email utility recommendations

2018-03-05 Thread Joe Yoder
This could be VFP or otherwise - not sure if there should be [NF] in the header? I have two tasks I would like to automate: 1. Send several hundred .JPG files in a local folder as email attachments one at a time. 2. Convert an Email to an image and send it to an email address as an

Re: [NF] Scanned images and Quick Books

2018-01-18 Thread Joe Yoder
integration with the online version of Quickbooks the images and > the transaction amounts can be pushed across to the accounting system from > Hubdoc. > > Contact me directly at, if you want further info at 514 885 4257 > > Regards, > > Richard Mertl > > On

[NF] Scanned images and Quick Books

2018-01-16 Thread Joe Yoder
. Does someone know if there is a way to store and retrieve scanned images from within Quick Books? If not - have another product to recommend? Thanks in advance, Joe Yoder --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html

Fwd: [NF] Syslog server advice

2017-01-30 Thread Joe Yoder
-- Forwarded message -- From: Joe Yoder <j...@wheypower.com> Date: Sun, Jan 29, 2017 at 10:55 PM Subject: [NF] Syslog server advice To: profoxt...@leafe.com I'm thinking to setup a syslog server on my workstation to catch entries from a remote machine over the internet.

[NF] Syslog server advice

2017-01-29 Thread Joe Yoder
I'm thinking to setup a syslog server on my workstation to catch entries from a remote machine over the internet. Does anyone have a free favorite to recommend or warn against? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text

Re: Processing a long character string one character at a time

2016-09-12 Thread Joe Yoder
t; string s = FromYourTextfile; > >> // Split string on spaces. > >> // ... This will separate all the words. > >> string[] words = s.*Split*(' '); > >> foreach (string word in words) > >> { > >> // parse yo

Importing a CSV with carriage returns embedded in fields

2016-09-10 Thread Joe Yoder
When one imports a .CSV file with carriage returns embedded in a field that is delimited by quotation marks, Foxpro ignores the quotation marks and assumes any carriage returns it finds indicate the end of a record. The file I am working with ends up with several hundred extra (garbled) records

Processing a long character string one character at a time

2016-09-09 Thread Joe Yoder
I have a routine that processes each character in a file. The file I am working with is over 2 million characters long. I pull it into a memory variable with filetostr and then process each character with the substr command. Apparently substr has problems when dealing with a long string as the

Re: Report label caption expression

2016-08-24 Thread Joe Yoder
; > On Wed, Aug 24, 2016 at 6:14 PM, Joe Yoder <j...@wheypower.com> wrote: > > > I want the header on a report to display the year from a variable along > > with some text. When I set the value to "str(m.Year) + 'Auto Mileage > > Report'" that string is display

Report label caption expression

2016-08-24 Thread Joe Yoder
I want the header on a report to display the year from a variable along with some text. When I set the value to "str(m.Year) + 'Auto Mileage Report'" that string is displayed rather than "2015 Auto Mileage Report." I think I solved this years ago with the use of a special character or syntax but

Re: Updating a listbox

2016-08-23 Thread Joe Yoder
rst form from the second. > > Once you have added all the records you require in the second form you and > issue an Thisform.oCallingform.<>.Requery immediately before the > Thisform.Release which should display the added records on the first form. > > Dave > > >

Re: Too simple report?

2016-08-23 Thread Joe Yoder
;tr...@powerchurch.com> wrote: > Joe Yoder wrote on 2016-08-23: > > I have a report that amounts to simply printing each record from a > table. > > There is no subgrouping of the data. All that is needed is a grand > total > > at the bottom. How does one setup the report write

Re: Updating a listbox

2016-08-23 Thread Joe Yoder
Yes Laurie - both forms are modal. Alan - your suggestion that there may be a timing issue has prompted my addition of another test button on the form with the listbox. The button code consists of: thisform.list1.click thisform.list1.Refresh thisform.refresh When I add a record it does not show

Too simple report?

2016-08-23 Thread Joe Yoder
I have a report that amounts to simply printing each record from a table. There is no subgrouping of the data. All that is needed is a grand total at the bottom. How does one setup the report writer to get and print the total? TIA - Joe --- StripMime Report -- processed MIME parts ---

Updating a listbox

2016-08-23 Thread Joe Yoder
I have a form that displays records from a table in a listbox. A "New" button adds a record to the table and calls a detail form that allows entering data to the blank record. When the detail form closes I want the listbox on the original form to display the new record. Its not

Re: Flat file to Excel....but it's got more than 255 columns!

2016-08-18 Thread Joe Yoder
How about using the string functions to convert the file to Comma Separated Values and just having Excel open the .CSV? Joe On Thu, Aug 18, 2016 at 12:32 PM, Fred Taylor wrote: > Use 2 queries to break up the number of columns. You can then set the > active cell and do 2

Re: Scrambled environment?

2016-08-17 Thread Joe Yoder
Dragging it off was the solution. What I can't figure out is how it ended up on the toolbar but I'm back in business. Thanks everyone - Joe On Tue, Aug 16, 2016 at 11:55 AM, Tracy Pearson <tr...@powerchurch.com> wrote: > Joe Yoder wrote on 2016-08-16: > > Thanks Richard, >

Re: Scrambled environment?

2016-08-16 Thread Joe Yoder
ech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe > Yoder > Sent: Tuesday, August 16, 2016 10:48 AM > To: profoxt...@leafe.com > Subject: Scrambled environment? > > I'm running VFP 9.0 sp2. When I try to modify a project, unselected tabs > for "All", "Data

Scrambled environment?

2016-08-16 Thread Joe Yoder
I'm running VFP 9.0 sp2. When I try to modify a project, unselected tabs for "All", "Data", "Documents", "Classes", "Code", and "Other" appear. When I click on one of the tabs the appropriate items display but I don't have the buttons on the right that let me manage the components and compile the

Handling POP3 Email in folder structures

2016-08-03 Thread Joe Yoder
I have a situation where an old Email client is being retired. That client stored email in folder structures. Each Email is a separate file which I believe remains in the POP3 format in which it was downloaded. The goal is to treat the Email as a company resource that can be accessed by anyone

Re: API to find the size of an entire folder structure?

2016-07-30 Thread Joe Yoder
I was planning to go the recursive ADIR route but am intrigued by the WSH approach. I had read about it in the past but always assumed it was only available on machines that have been configured to run it. A quick check of the environments I work in now shows they all have it. I ran the sample

Re: API to find the size of an entire folder structure?

2016-07-30 Thread Joe Yoder
Thanks - I suspected that. On Sat, Jul 30, 2016 at 9:12 AM, Gérard LOCHON <g-loc...@wanadoo.fr> wrote: > There isn't such a thing in the Win API. > > You have to it by yourself, even if it is in C. > > > Gérard. > > > > Le 30/07/2016 à 13:04, Joe Yoder a

API to find the size of an entire folder structure?

2016-07-30 Thread Joe Yoder
Is there a programatic shortcut to finding the size of an entire folder/subfolder structure without recursing through it in VFP? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

Re: [NF] Windows 10 upgrade out to lunch

2016-07-22 Thread Joe Yoder
I bet the problem is that there is not enough disk space! There are only 1.3 gigs of 219 gigs free. I read somewhere that one can check a hidden $Windows.~BT folder to see if the installation files are present. I looked for

[NF] Windows 10 upgrade out to lunch

2016-07-22 Thread Joe Yoder
I have a small laptop with Windows 7 that I would like to upgrade to Windows 10. The machine has the Get Windows 10 icon in the system tray. Every time I click the icon, a Get Windows 10 window opens and after a brief pause at "Please wait", the screen displays sections "About Windows 10" and

Re: GETFILE and SET DEFAULT

2016-07-20 Thread Joe Yoder
ack with > > set default to > > or > > set default to (m.SaveDef) > > Rafael Copquin > > > On 20/07/2016 16:50, Joe Yoder wrote: > >> I need to have a user choose a file with a specific extension from a >> specific folder. I assumed I could sim

GETFILE and SET DEFAULT

2016-07-20 Thread Joe Yoder
I need to have a user choose a file with a specific extension from a specific folder. I assumed I could simply pass a file skeleton to GETFILE like one does to ADIR. When I try that FoxPro seems to navigate to the proper folder but does not show any contents in the folder. I looked up the docs

Re: Checking for All-Different Characters

2016-07-18 Thread Joe Yoder
Here is a simple brute force approach with the same count m.cnt = 0 m.Cdate = {^1900-01-01} DO WHILE m.Cdate < {^-12-31} m.str = dtos(m.cdate) FOR m.x = 1 TO 8 IF OCCURS(SUBSTR(m.str, m.x, 1), m.str) > 1 EXIT ENDIF ENDFOR IF m.x = 9 m.cnt = m.cnt + 1 * WAIT window

NF - Does anyone have experience with Wyse thin terminals?

2016-06-01 Thread Joe Yoder
I have 15 identical Wyse VX0 V90L XPEdevices that I purchased used on Ebay. I have been trying to get all the parts lined up so the terminals can connect to an FTP server and download their configuration but I keep going in circles. I'm thinking to connect with an expert on JustAnswer.com or a

Re: Finding which code is executing

2016-05-25 Thread Joe Yoder
on of the table. > > If this isn't the case, can you set a breakpoint that will trip when > the code in question starts to run, for example, > > "MyInputTable.DBF" $ DBF() > > If this is the only place that the MyInputTable is opened. > > On Wed, May 25, 2

Re: Finding which code is executing

2016-05-25 Thread Joe Yoder
<ge...@telus.net> wrote: > At 08:23 2016-05-24, "Tracy Pearson" <tr...@powerchurch.com> wrote: > >> Joe Yoder wrote on 2016-05-24: >> > I have a small procedure file, visa.prg. in my current project folder >> that >> > imports dat

Finding which code is executing

2016-05-24 Thread Joe Yoder
I have a small procedure file, visa.prg. in my current project folder that imports data from .csv files. I need to support a slightly different format so I added some debugging code but it does not run. When I made a copy with a different name it worked as expected. Is there a way to have the

Re: Help with SQL optimization

2016-05-15 Thread Joe Yoder
o AND > Receipts.cSplit_id = Master.cSplit_id > ) > INTO CURSOR Batch READWRITE > > should work in subsecond time with 1350 records. > > On Sun, May 15, 2016 at 4:05 PM, Joe Yoder <j...@wheypower.com> wrote: > > I have a process that starts out with a

Help with SQL optimization

2016-05-15 Thread Joe Yoder
I have a process that starts out with a table of about 4300 records. An SQL select yields a cursor of only the records not already in a master table for processing and gradual addition to the master table. When the master table was empty my SQL results were sub second. Now that the master table

Re: Shortcut to generalized click column for sort order browse?

2016-05-13 Thread Joe Yoder
is code > > set order to ... in .(the table or cursor) > > this.parent.parent.refresh > > Those two lines of code will do what you want. Of course, we are talking > of a grid here, not a browse > > Rafael Copquin > > > > > On 13/05/2016 13:21, Peter

Shortcut to generalized click column for sort order browse?

2016-05-13 Thread Joe Yoder
I need to present information from several tables. I want to enable the user to click on a column header to control the order in which the records are displayed. At this point it does not need to be very polished so a simple browse with scrolling, column resizing and repositioning, with control

Re: Strange " File access is denied" message

2016-05-06 Thread Joe Yoder
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Joe Yoder > Sent: 05 May 2016 22:05 > To: Foxpro forum <profox@leafe.com> > Subject: Re: Strange " File access is denied" message > > Thanks Tracy, > > I tried using with the share clause and it w

Re: Strange " File access is denied" message

2016-05-05 Thread Joe Yoder
, Thanks again, Joe On Thu, May 5, 2016 at 2:20 PM, Tracy Pearson <tr...@powerchurch.com> wrote: > Joe Yoder wrote on 2016-05-05: > > I have a situation where "File Access is denied" shows up any time I try > to > > open the main form in my current project.

Strange " File access is denied" message

2016-05-05 Thread Joe Yoder
I have a situation where "File Access is denied" shows up any time I try to open the main form in my current project. I'm running Windows 10 and when I get into File Explorer I can open both the .SCT and the .SCX files from notepad without a problem. If I double click on either one VFP opens,

Re: Using the when event in a command button

2016-03-05 Thread Joe Yoder
Thanks Tracy - it's been to long since I did any screen coding! On Sat, Mar 5, 2016 at 12:49 AM, Tracy Pearson <tr...@powerchurch.com> wrote: > The line should be > Return NOT EMPTY(thisform.combo1.Value) > > > > On March 4, 2016 10:55:39 PM EST, Joe Yoder &l

Re: Using the when event in a command button

2016-03-04 Thread Joe Yoder
No - just the one line or the .f. On Mar 4, 2016 10:28 PM, "Tracy Pearson" <tr...@powerchurch.com> wrote: Is there a RETURN statement in front of the NOT? On March 4, 2016 10:20:09 PM EST, Joe Yoder <j...@wheypower.com> wrote: >I have a command button on a form that

Using the when event in a command button

2016-03-04 Thread Joe Yoder
I have a command button on a form that should not be accessible unless there is a table selected. I am attempting to use a expression that will evaluate to false in the WHEN event when no table is selected: NOT EMPTY(thisform.combo1.Value) The message I get is "Error in line 7 of

Re: Best way to have multiple projects open simultaneously?

2016-03-04 Thread Joe Yoder
Thanks guys for all the advice! Ted's warning is good to know - the possibility of tangled memo fields resulting from what I anticipate doing for this project tells me that I will want to use a different approach for future projects! I have now successfully opened multiple projects in a single

Best way to have multiple projects open simultaneously?

2016-03-03 Thread Joe Yoder
I have code in several projects that I want to drop into a new one. I assume there is a way to have multiple VFP projects open at the same time, Multiple instances of foxpro? Somehow with a single instance? Also - I have a two monitor setup - is there a way to have each project on a separate

Using an expression for the RowSource of a textbox

2016-03-01 Thread Joe Yoder
I am almost certain that I have successfully used an expression as the field to display in a listbox but I can't figure out the syntax I used or which RowSourceType needs to be selected. Can someone help me out? Thanks in advance, Joe --- StripMime Report -- processed MIME parts ---

Re: Suggestions for closing out simple applications?

2016-03-01 Thread Joe Yoder
ailto:profoxtech-boun...@leafe.com] On Behalf Of Joe > Yoder > Sent: Wednesday, 2 March 2016 9:49 AM > To: profoxt...@leafe.com > Subject: Re: Suggestions for closing out simple applications? > > My application is so simple that it has no menu. Is there an advantage to > hav

Re: Suggestions for closing out simple applications?

2016-03-01 Thread Joe Yoder
d, etc.) That will cause the main program to pick up after the READ > EVENTS and go from there. > > Fred > > On Tue, Mar 1, 2016 at 2:43 PM, Joe Yoder <j...@wheypower.com> wrote: > > > I have never used a framework and often just execute my stuff in the VFP > >

Suggestions for closing out simple applications?

2016-03-01 Thread Joe Yoder
I have never used a framework and often just execute my stuff in the VFP environment. When I do an exe for others to use I am never sure what commands to include to shut things down. Sometimes I end up with applications that can't be shut down without killing them in Task Manager and sometimes I

Re: How to allow multiple forms to update the same record pointer in a table

2016-03-01 Thread Joe Yoder
gt; > > Tel. +1-212-747-9100 > www.GlobeTax.com > > > -Original Message----- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe > Yoder > Sent: Tuesday, March 01, 2016 1:30 PM > To: profoxt...@leafe.com > Cc: profoxt...@leafe.com

Re: How to allow multiple forms to update the same record pointer in a table

2016-03-01 Thread Joe Yoder
like the > Init or Load of the form. I think that May solve your problem... > > Regards, > Kurt Wendt > Consultant > > > Tel. +1-212-747-9100 > www.GlobeTax.com > > > -Original Message----- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of

Re: How to allow multiple forms to update the same record pointer in a table

2016-03-01 Thread Joe Yoder
age- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe > Yoder > Sent: Tuesday, March 01, 2016 7:48 AM > To: profoxt...@leafe.com > Subject: Re: How to allow multiple forms to update the same record pointer > in a table > > Darren and Rafael > <http

Re: How to allow multiple forms to update the same record pointer in a table

2016-03-01 Thread Joe Yoder
m.au> > escribió: > > > Joe if you want it zip it all up and send it to me I'll have a look see > for > you. > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe > Yoder > Sent: Tuesday, 1 March 2016 4:33 PM > To: pro

  1   2   3   4   5   6   >