FPD: NTVDM consumes huge memory on XP

You probably use FOXPROX.exe instead of FOXPRO.exe
But FOXPRO.exe comes with another problem:
Sometimes "Insufficient memory" error when generating prg from scx

Related article:
How to control ntvdm.exe memory use?

RegEx support

A Regular Expressions library for Visual FoxPro
www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,91241006-595a-487d-ac06-d0fc1fc71632.aspx

FPD: Change cursor shape

sys(2008,'I',1): Full block shape for Insert

sys(2008,'O',2): Half block shape for Overwrite

FoxPro Debugging related

Productive Debugging
www.dfpug.de/buecher/fundamentals/Hack6/S2C4.HTM

VFX: Where this or that defined

Code ran when Preview toolbar menu is clicked
vfxFormBase.vcx \cDataFormVfxBase \ onPrint

Code launched when toolbar menu is clicked:
Class vfxAppl \ cAppToolbarManager \ onItemClick

Code that launches database selection dialog
vfxAppl.vcx > cFoxApp.setClient:
...
Do Form vfxclien To ACTUALCLIENT
...

Where cConnectionMgr class is defined
vfxfunc.org

Where DataSource for CursorAdapter is defined
vfxCtrl.vcx > cBaseDataAccess.getDataSourcePlatformType

Where "ON ERROR" is defined
vfxappl.vcx > cfoxapp > start

Where 'oRecord' object is created
vfxFormBase > cDataFormVfxBase > Init:
thisform.addobject('oRecord', ALLTRIM(goprogram.ctablemanagerclass))

Where to set date format
Class appl > cFoxAppl > cDateFormat
It the above doesn't work, check vfxmsg.dbf and find Message_ID= [ID_DATESETTING] and alter memo field (Eng)

FPD26: Making smooth switch between screen with PgUp/PgDn

Check the generated prg/spr and ensure that dummy field is the LAST "editable" @GET on each screen.

By "editable" it means that the @GET doesn't bear "when .f." or similar clause

VFX: Determine Visual Extend used for a project

look at \include\vfx.h file

VFX: Activation key is generated...another hardware

Remove the folder corresponds to the version in question on \Documents and Settings\All Users\Application Data\dFPUG\Visual Extend
That will re-enable Activation dialog

VFP: Custom paper size cannot be used at deployment

Issue:
Already setup custom paper size on [Print] Server Properties but it won't come into effect in the program

Solution 1:
- Report Designer > Page Setup > UNcheck Save printer environment
- save and close it
- "use" and "browse" report file (.frx)
- locate record with Objtype=1 and Objcode=53
- edit "Expr" field: remove "PAGESIZE=..." line
- at customer's computer:
Set Paper Size on Printer's Advanced Properties to the one desired

Solution 2:
- Getting PaperSize ID programmatically
http://hermantan.blogspot.com/2008/03/getting-papersize-id-programmatically.html
- Modify report's Papersize at runtime:
USE .frx
LOCATE FOR Objtype = 1 AND Objcode = 53
lcNew = "PAPERSIZE=9"
lcOld = "PAPERSIZE=41"
REPLACE expr WITH STRTRAN(Expr,lcOld,lcNew)
USE

Other useful tip:
Adding Custom Paper Size Programmatically
http://hermantan.blogspot.com/2007/08/adding-custom-paper-size.html

Calculate number of months elapsed

How to calculate the number of months between two dates in Excel
http://support.microsoft.com/kb/214134

FoxPro related websites

FoxPro Archives
Collection of FP utilities

FoxPro Mania
www.foxpromania.co.cc

FPD26: Cannot generate program from many screens

or "Too many files open"

Solution:
1) Add files=100 and buffers=100 to system32\config.nt
Source:
www.techxplore.net/2010/03/23/windows-xp-foxpro-2-6-dos-application-software-error-too-many-files-open/

2) Increase MVCOUNT value in Config.fp to 512

VFX: Prevent database update

Put current exe version on the vfxsys table -> AppVersion field

VFX: Incremental search during lookup won't work

Cause:
Table used in lookup is using Buffering Mode=5

Solution:
Use BufferModeOverride=3 instead

Source:
dFPUG Forum msgid=730145

Alternative solution(s) based on personal experience:
1. Use BufferModeOverride=1
2. If Buffering=5 is inevitable, use a view as lookup source

Error "Cannot resolve backlink"

Another symptom:
Error when validating database "Table xxx is not in database"

Solution:
Make note on:
1. table relation
2. referential intergrity
3. custom database code
4. fields' default value(s)
Remove and re-add table from database

Info on the Net:
What will cause the error "cannot resolve backlink"?
www.tek-tips.com/viewthread.cfm?qid=852849

Cetak struk (Indonesian)

"buat struk dengan Design Report" emang bisa??
http://fox-id.org/smf/index.php?topic=9444.0

PRINT STRUK
www.foxite.com/archives/print-struk-0000037739.htm

VFX: Things to be paid attention

Make pick-dialog optional for a grid column
Set lNullValid to .T.

Click Insert-button on child-grid won't insert new record
Don't click the button while the cursor is positioned in a Calculated-column

2.6: Multiple-window - agar perpindahan antar window lancar (Indonesian)

Pilih field-field sesuai urutan akses dan letakkan invisible-field di urutan terakhir

Pilih "Bring to front"

VFX: Working with free table(s)

Free tables are found with SET PATH only. You can add your path in
cfoxappl.opendatabase after executing dodefault.

Source: http://forum.dfpug.de/bodyframe.afp?!_33L0GNLMNmsgid=728759

Code:
DODEFAULT()
IF __vfx_runtime
SET PATH TO data,kredit
ENDIF

Another scenario:
The free table's filename is using non default extension (ie. DAT instead of .DBF)

Solution:
* Make a copy of the .DAT file (with .DBF extension)
* In development stage, work with this DBF file
* Before last Build for deployment, 'browse' form data (.SCX) and modify Properties field for record(s) with Parent=Dataenvironment to change filename to .DAT

VFX: Forum

http://forum.dfpug.de/

Alle Nachrichtenbereiche = All news section
Antworten = Reply
Antworten mit Zitat = Reply with quote
Baumstruktur = Tree
Dateibereiche = File spaces
Dateien Suchen = Search files
Flatansicht der Messages = Flat view of messages
Löschen = Delete
Nachrichtenbereiche = News section
Nächste Nachricht = Next message
Nachricht erstellen = Create Message
Nachrichten Suchen = News Search
Nachrichtenthemen suchen = News Search Topics
Neuer User = New User

Quick way to find your own posted msg:
- Click Nachrichten Suchen
- Type your e-mail address
- Choose appropriate Sektion