definately go with Darrels suggestion
2 tables:
1 with just the donors & a unique ID , then a donation amount table which contains the donors ID linked to their amounts,
then you can filter & sql select away to your heart's content where donor.ID=donation.ID
Mike
thanks - I was just wondering why intellisense was showing the parameter options for set("path") when there are non
I tried it with set("alternate") (which is in the help) which has no parameters and intellisense still showing parameters.
I guess i was expecting intellisense to be a...
OlafDoscke - that's exactly what i meant - THERE IS NO HELP for set("PATH") ( PATH under the set() function help)
ramani - thanks but I can see all that in the help - just that the path explaination is missing - my VFP8 help just goes from notify to printer - missing out path (& the parameters)...
I'm using Visfox 8 & can't find this in the help file
- it goes from SET("NOTIFY") to SET("PRINTER")
With intellisense i get can pass the parameters 1, 2 & 3
but what do they mean?
They all seem to return the same path - even when my SET PATH TO command has multiple paths.
Any Ideas?
MrF
Normally in my main.prg
lcDefpath = CHR(34)+SYS(5)+SYS(2003)+CHR(34)
SET DEFAULT TO &lcdefpath
then maybe pass it to a form & make a form property out of it.
the chr(34) bits are to handle paths with spaces.
It just sets the defa path to the directory the exe runs from
mrF
Try Shell execute (courtesy of Mike lewis http://www.ml-consult.demon.co.uk/foxst-26.htm)
this will open the file c:\mypic.jpg in Internet exporer
DECLARE INTEGER ShellExecute IN shell32.dll ;
INTEGER hndWin, ;
STRING cAction, ;
STRING cFileName, ;
STRING cParams, ;
STRING...
Morning,
This compiles fine in VFP8
REPORT FORM swgdelnt.frx PREVIEW TO PRINTER PROMPT NOCONSOLE
but errors when i recompile in VFP6
(from error err file)
Error in line 38: Missing comma (,)
any ideas of the correct order?
MrF
FIXED!!
it wasn't a macro substition error - i'd already calced the max length of the field.
The error was because i was trying to textwidth() a numeric value (the result of the previously created textwidth)!
amazing what a beer At lunchtime & getting away from work for a bit can do. -
if ur...
thanks
but adding "="
to the cexp didn't work
cexp="thisform.grid1.column" + ALLTRIM(STR(x))+".width="
then
&cexp thisform.TextWidth(arrlen(1,1))
still causes the "not a character expression error"
bTW - my logic goes something like
get all fieldnames,types from a cursor which is a grid...
morning
I'm trying to resize grid columns based on data that the cursor contains
step 1 is an Afields()
AFIELDS(arrfld,"curgrid")
FOR x=1 TO ALEN(arrfld,1)
cFld=arrfld(x,1)
IF arrfld(x,2)="C" && only for char fields
thisform.sizemycolumns(cfld,x)
endif
endfor
step 2 is the...
Try this
in the project
open up the menu you are using in menu designer
from the main foxpro menu choose VIEW
select General options (NOT menu options - strangely)
click the checkbox for TOP LEVEL FORM
click the OK button
then re-generate the menu
mrF
Uploading procedure:
if you want to convert word to pdf etc you can use a pdf printdriver (free GO2PDF download at http://www.go2pdf.com/go2pdf.exe ) - as i said before you could save the path to this pdf in a table or store the entire document in a binary memo field.
the process would be some...
you could, i guess, store the paths+filenames to the docs in a table (using ChrisRChamberlin's recursive search method) then display the contents in a grid on a form. Then when user selects a document from the grid, use Shell execute to 'run'/open the document with their default application...
My startup program would look something like..
*************
* Main.prg *
*************
CLEAR ALL
SET ESCAPE OFF
SET CPDIALOG OFF
SET RESOURCE off
SET DATE DMY
SET CENTURY on
Application.visible = .f.
DO FORM "frmForm" naME frmForm
Read Events
********************
mrF
open up the form (scx) and change the form property from the properties window.
It's probably set to default - 0 (as in the form only appears in the Visfox screen)
mrf
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.