Search results for query: *

This application has a ribbon menu which allows the user to have several forms visible at the same time. For example, a user could be entering a sales invoice for a product, but he may wish to find out what this customer – or another customer – paid last time; or what deliveries of the product...

An application offers a user with ‘Administrative rights’ the ability to browse any of the tables in the application. The application lets the user enter the commands in an editbox. So, for example, the user could enter these commands : SET DELETED OFF USE XSDET (A table of sales order detail...

I am revisiting some old code. There is a 2-digit text box which is to specify a month. So ‘03’ would represent March. What is other users' practice for specifying the properties of such a field on the form, and for validating it? Thanks - Andrew

I have two tables with the same record structure : ENTS with 1235 records and ARCS with 16,800 records. How can I use SELECT SQL to create a single cursor with all 18035 records. I realise there is some information in the VFP Help files, but if anyone has written or can recommend a short...

I am using Office 365 including the use of OneDrive. When I am editing a Word document and click on File, the menu on the left offers Save and Save As. And if I close the document (X in top right), it will ask me whether I want to Save the document. This happens with most of my documents...

When entering a Word document, I often use the 'en-space' — a slightly wider hyphen. To put this into the document, I click Insert on the top ribbon menu, then Symbol on the right, clicking on the drop-down list. This shows some recently used symbols and the 'More symbols'. From there I choose...

I have an application with a textbox in which a customer account code can be entered. (this text box is based on a class used within the application). The Valid() method of this particular control – call it txtCust - will do several things, including helping the user to search for suitable...

I have a table XSORD which has a field ‘Account’ - the customer account number, and have executed the instruction : SET EXACT ON In order to retrieve records for a particular customer, say ‘S100’, I can execute a command : SELECT * FROM XSORD WHERE Account = ‘S100’ This however returns a...

I would like to include a command button within a VFP application, so that the user can refer to a .doc file (just one per customer) which he can maintain in whatever way he likes, and can bring it up when he clicks on a button which I will add to the form. I have Tamar’s helpful book...

I have an A4 .docx file, about 200 pages, which I am reviewing. Have used the ‘Review | Add comment‘ facility to make suggestions; so when I am editing it the comments are shown in a column on the right of the screen, linked to the place in the text to which each comment refers. I would like...

I do not use SELECT-SQL very much (perhaps I should use it more). But I would like to write a command which will detect in a single table where there are entries for a particular key do not add up to zero. The table is XENTN. Three of the fields are tDate (D), Folio C(8) and tValue N(9,2). A...

There is an application which mainly consists of a startup program, several function libraries, a menu system, a set of forms and reports, and a database made up of several tables. The startup program, forms, function libraries and menus are bound together into an executable (say) myapp.exe...

I have an application which has many reports. Each report uses a pair of .frx/.frt files which defines the layout of the report. These report layouts are not bound into the executable program (.exe), because some users may want to modify a report or provide their own layout. So the report...

When an error happens in an application, this may have been trapped by : ON ERROR DO ErrorRoutine WITH ERROR(), MESSAGE(), PROGRAM(), LINENO() NOCONSOLE The code which is then executed includes : LIST MEMORY LIKE * TO <filename> NOCONSOLE That works fine: Local, Public &c variables are...

I have never been sure of the difference between LPARAMETERS and PARAMETERS. Have written a short test program to see if I can detect the difference. CLEAR SET TALK OFf LOCAL X x = 2 SET STEP ON lAns = MyFUNC(x) ? "lAns = " + STR(lAns,2) ? "vParm = " + STR(vParm,2) RETURN FUNCTION MyFunc...

Fermat's last theorem (eventually proved) states that : No three positive integers a, b, and c satisfy the equation : an + bn = cn for any integer value of n greater than 2 Consider the equation ak + bl = bm . .. where a, b, c, k, l, m are all positive integers and k, l, m (may be the...

I have a data-entry text box. When it has focus it shows the date in dd-mm-yy format So the user can perhaps key in new values And when it does not have focus it shows as : To that end it has a PUBLIC variable - zValueD - of type DATE, (which is not itself the value of the control). So...

I have several reports where I offer the chance of printing to paper, to screen, or to a pdf printer. To organise the pdf printing, I include code more or less like this : lfrxname = “<The frx file name for the report>” lName = “<My PDF printer name>” SET PRINTER TO NAME (lname) REPORT FORM...

I have a report (Sales Invoice) which includes information at the end, like the total value(s) and various captions and declarations. I can put this into the page footer, and that works fine in most cases. However, if the document runs to two or more pages, it would be nice if only the last...

An application produces and prints sales invoices, using REPORT FORM. These documents are based on a report format SALINV.FRX/FRT. At present the structure of the report layout is fairly simple. There is a single group consisting of the detail lines of the invoice. The group header (so – at...