some advice again
again thank you for all you help on previous items. again, i have hit the
WALL!!
in your eyes i am not doing anything tough, i just cant seem to think past it.
please advise.
ok, I open a table, get data from it and place it into a new one.
Now I will open the New table, add to fields to itâ?¦(2 fields manually) no
big deal..
Open a third tableâ?¦scan it for the 2 fields, I need and place them in the
proper place. My code is below.
It keeps telling me I have no table open but I do (I thought)
clear all
set default to f:
USE f:\foxpro25\lagers\dbases\lagchk.dbf IN 0 shared
copy to f:\foxpro25\lagers\dbases\forauditors.dbf for checkdte >=
ctod('06/01/04') and checkdte <= ctod('06/01/05')
use f:\foxpro25\lagers\dbases\forauditors.dbf shared
use f:\foxpro25\lagers\dbases\fulagmas.dbf in 0 shared
select 0
set order to PADL(agency,6,"0")+PADL(dpt,3,"0")+PADL(employee,6,"0")
go top
scan
if !eof()
if fulagmas.agency = forauditors.agency and
fulagmas.dpt = forauditors and fulagmas.employee = forauditors.employee
replace forauditors.brthdt with
fulagmas.brthdt, forauditors.benprgflg with fulagmas.benprgflg
endif
endif
endscan Tag: IRC User group for Foxpro Tag: 212934
TEXTMERGE problem
Hi,
What's the problem (tested with VFP 8 + 9) with following textmerge?
----8<----
#DEFINE myConst "myText"
TEXT TO lcStmt TEXTMERGE NOSHOW
select * from myTable where field = "<<myConst>>"
ENDTEXT
---->8----
Ok, this would be a workaround, but it's not that nice :(
----8<----
#DEFINE myConst "myText"
TEXT TO lcStmt TEXTMERGE NOSHOW
select * from myTable where field = <<'"' + myConst + "'">>
ENDTEXT
---->8----
Thanks
Marco Tag: IRC User group for Foxpro Tag: 212926
replace a word in all SCX ?
hi
how can i replace a specific word by another
in all Forms without having to open everyone ?
thanks
--
atte,
Hernán Castelo
SGA - UTN - FRBA Tag: IRC User group for Foxpro Tag: 212920
make a copy of "Scatter"ed object ?
hi
my proc receives a parameter of type object
that object is product of SCATTER NAME
i need to make a LOCAL copy
in a local variable, i can't do it with
Lparameters and Local var combination
Yes, everything works if i get a parameter
of "other kind of object", like custom, form, text......
but not with Scattered Objects
I need something like "CloneObject"
but the Scattered Objects has not methods
In the case of an array,
it can be achieved with ACOPY
how can I make my local copy ?
( a kind of C's memcpy ? )
thanks IA
--
atte,
Hernán Castelo
SGA - UTN - FRBA Tag: IRC User group for Foxpro Tag: 212917
Changing Fontcharset in report...
aGkgYWxsLA0KYWZ0ZXIgY2hhbmdpbmcgZm9udCBzY3JpcHQgaW50byBCbGF0aWMgKHdpbmRvd3Mg
IHNldCB1cCB0byBkaXNwbGF5IG5vbiB1bmljb2RlIGFzIGN5cmlsbGljKSBpbiBSZXBvcnQgZGVz
aWduZXIgbGV0dGVycyBhcmUgc2hvd24gaW4gQmFsdGljIChPSykgLCBidXQgYWZ0ZXIgY29tcGls
aW5nIGV4ZSBmaWxlIGFuZCBydW5uaW5nIGl0IC0gbGV0dGVycyBpbiBteSByZXBvcnQgYXJlIHNo
b3duIGFzIGN5cmlsbGljLi4uIGhvdyBjYW4gaSBtYWtlIG15IHJlcG9ydCBkaXNwbGF5IGJhbHRp
YyBsZXR0ZXJzIGNvcmVjdGx5IHdoaWxlIHdpbmRvd3MgaXMgdXNpbmcgbm9uLXVuaWNvZGUgbGFu
Z3VhZ2UgY3lyaWxsaWM/DQoNClZGUCA5DQo= Tag: IRC User group for Foxpro Tag: 212914
Table Activity trace Log.
is there a way to keep a log of all transaction for
specific table ? (updates that could come from multiple
modules that performing delete, add and change of data)
using Foxpro Database. Tag: IRC User group for Foxpro Tag: 212913
Expression Validity Tester
I am looking for a cheap or free expression tester for my application. I
have various parts in my application where the user is allowed to freeform
enter an expression and I need a way to ensure the expression is valid so
the program does not error out when it is miskeyed etc.
Any help is appreciated,
Scott Tag: IRC User group for Foxpro Tag: 212907
Click and DblClick conflict? (VFP6)
I have a form which contains a grid. I want the user to be able to
(left)Click on a row of the grid to perform a Click method; and to
DoubleClick to do a different, DblClick method.
I can't get them to work together, even when I increase the _DBLCLICK value
to its maximum (about 5.5 seconds). The form seems to respond to a
doubleclick as if it were a singleclick.
I *am* able to get Click and RightClick to coexist.
I can also code for a DblClick by itself.
But the bottom line is: I can't get Click, DblClick, and RightClick all to
function in the same control or object.
Why is this?
(By the way, I think the explanation of _DBLCLICK in the VFP 6.0 Language
Reference is wrong. It says the syntax is _DBLCLICK = nTicks, but it should
say _DBLCLICK = nSeconds, where 0 < nSeconds <= 5.5)
--
Peter Rooney
magnetix@ix.netcom.com Tag: IRC User group for Foxpro Tag: 212903
Store (obj.ref) to (local var) ???
hi
i need to make a local object
from an object reference ...
how can i do ?
the reference to the object
is received into a LParameters variable
but it does not work...
not even assigning other the argument
to a local variable ....
thanks
--
atte,
Hernán Castelo
SGA - UTN - FRBA Tag: IRC User group for Foxpro Tag: 212902
Windows XP - Cannot find dll entry point
Hi There,
I have a problem with the following code:
cSEntry = REPLICATE(CHR(0),8)Thisform.dregister = ; && register foxpro as an
shell api event handler
SHChangeNotifyRegister(_vfp.hWnd, 2, SHCNE_ALLEVENTS,
WM_USER_SHNOTIFY,1,@cSEntry)
BINDEVENT(_VFP.hWnd, WM_USER_SHNOTIFY, Thisform, "DragNDropFiles")
SHChangeNotifyRegister:
On some computers it cannot find the entry point to the api call. Why is
this? I am having the problem on Windows XP (no SP) but works fine on SP2.
Thanks Glenn Tag: IRC User group for Foxpro Tag: 212891
Browses on Pocket PC
You may download a working demo of Harbour and FiveWin for Pocket PC using
browses from here:
http://www.fivetechsoft.com/files/fwce10.zip
This is how browses look:
http://www.fivetechsoft.com/files/fwce10.jpg
The source code is as simple as this:
#include "FWCE.ch"
REQUEST DBFCDX
function Main()
local oWnd, oBrw
USE "storage card\Customer" VIA "DBFCDX"
DEFINE WINDOW oWnd TITLE "Tutor10"
@ 1, 1 LISTBOX oBrw FIELDS SIZE 220, 167
@ 12, 2 BUTTON "Done" SIZE 80, 30 ;
ACTION oWnd:End()
ACTIVATE WINDOW oWnd ;
ON CLICK MsgInfo( "Click!" )
return nil
regards,
Antonio Linares
www.fivetechsoft.com Tag: IRC User group for Foxpro Tag: 212889
FoxPro, Clipper and dBase for Pocket PC and SmartPhone!
FoxPro, Clipper and dBase applications development for Pocket PC is already
available from:
http://www.fivetechsoft.com/english/fwppc.html
FWPPC uses Harbour (www.harbour-project.org), the open source Clipper
compatible compiler, already ported to Windows Mobile operating system.
Full DBFs, Indexes (CDXs, NTXs) support, plus all the Clipper language
features.
Lars Tag: IRC User group for Foxpro Tag: 212882
combobox
I created a combobox in a form (style=dropdown combo). user can input
his own text or select from an existing one.
I entered some text into it. After a thisform.refresh(), the
combox.value was cleared. Why? how could I keep the user-inputted value
persistent?
As a result, I couldn't save the value to the combobox.controlsource.
The underlying table is having buffering=5. Tag: IRC User group for Foxpro Tag: 212881
report form
1. How could print a logo on a report form with transparent background?
Must I use a gif?
2. Could I use a variable in path property of a PictureOLE Bound object? Tag: IRC User group for Foxpro Tag: 212880
universalthread.com Not Up-to-date?
There is no news today. The date at the top of the page is
Bathurst, June 23, 2005 17:44 AST. Is anyone else seeing this?
Sincerely,
Gene Wirchenko Tag: IRC User group for Foxpro Tag: 212866
Data session issues - VFP9
Has anyone come across any quirks with VFP9 forms and reports with respect
to using private data sessions? Several of us are running into intermittent
issues. I've not yet been able to duplicate it 100%, but I'm working on
that.
Issue: You run a report from a program, and the find file dialog appears. No
apparent reason. Suspend program immediately before report form is run. Open
debugger, add set('datasession'). Edit report. Preview. Previews fine,
datasession stays at 1. Immediately preview again. Datasession changes, find
file dialog appears. Cancel. Preview again, previews fine. Preview again,
find file dialog appearrs and datasessions is changed. Every other time we
previewed the report, it would change datasession and error out, and every
other time it would preview fine.
Issue: Modify report. Ensure private data session is not selected. Save
report. Edit report. Private datasession is selected. Unselect it. Save
report. Edit report. Private datasession is selected.
Issue: Create form. Set to private datasession. Add tables to DE. Save.
Edit, set to default datasession. Save and run. Form opens in private
datasession, even though you set it to default.
We are seeing enough of these to establish a pattern, but not enough to
duplicate it 100%.
(and, no, I'm not the only one here that is seeing this :-P ) Tag: IRC User group for Foxpro Tag: 212862
VFP 8: Grids (bug problem)
I have a container class that contains a grid. The grid was setup to have
specific column names. I set the grid to point to a cursor during runtime.
This allows me the ability to have multiple instances of the container using
different cursors. The container is loaded onto a form at runtime as the
user needs this interface. The code below is my standard way of "binding"
the data to the grid.
cTempFile1 = "somecursor"
this.Grid_Codes.recordsource = 1 && Alias
this.Grid_Codes.recordsource = cTempFile1
this.Grid_Codes.col_code.controlsource = cTempFile1 + ".cCode"
this.Grid_Codes.col_desc.controlsource = cTempFile1 + ".cDesc"
The problem I am having is, sometimes (hard to repeat), I get errors because
the code is referring to the col_code column. VFP errors out stating
"Unknown member COL_CODE".
It turns out, that the grid has lost the names of the grid, and now has the
names Column1 and Column2 instead of col_code and col_desc.
Has anyone else seen this problem, and does anyone have a resolution?
Thanks,
Dan Tallent Tag: IRC User group for Foxpro Tag: 212853
Passing Macro Output Value to a Variable or TextFile ?
I am using TextMerge on Memo Field in Foxpro 2.6 for Dos.
use customer
set textmerge on
a="/ Dear <<Name>>"
&a 'This will produce Dear Luqman
Now, I need to print result of &a to report, how can I save this result into
a table or cursor ?
Best Regards,
Luqman Tag: IRC User group for Foxpro Tag: 212848
Using Fields within Memo Text and use in Report ?
Is it possible in Foxpro 2.6 for Dos, to use Fields within Memo Text, and
then print that Memo in Report, which should replace the field names with
their values.
Something like TextMerge option in foxpro.
For example:
I put following in Memo Field.
My Name is <<<cName>>>
When I print this field in report, it should display following.
My Name is Luqman
My Name is Usman
My Name is Aman
Is it possible ?
Best Regards,
Luqman Tag: IRC User group for Foxpro Tag: 212841
VFP6 exception
Falal Error Exception code = C00000FD
called from -
ar_invoice.apppageframe.page2.g_recordmaintenance.cmd_save.click (line 0)
Windows\system32\vfp6r.dll
Any hint? Tag: IRC User group for Foxpro Tag: 212839
text search in a class lib
Is there a good tool to do text search on classlib, listing the
object.method containing the text? I tried class browser, but the find
function doesn't quite work. Tag: IRC User group for Foxpro Tag: 212832
VFP 9 Report gibberish
Has anyone else had trouble with SET REPORTBEHAVIOR 90 printing gibberish
either to a printer or to a PDF print driver? I was able to make the printer
work by changing to a generic HP LaserJet III driver, but I still get black
boxes instead of text for the Amyuni 2.50 PDF print driver and random
alphanumerics for the Adobe Acrobat 4.0 print driver. I've turned off the
Save Printer Settings checkbox, but no difference. The reports work fine with
SET REPORTBEHAVIOR 80. Any suggestions? Tag: IRC User group for Foxpro Tag: 212828
Controlling the Size of a TIF File
I have a process that uses the report listener to output a TIF file. It
works great except for one thing: The size of the TIF file.
I set up the report to be only 6 in. high by 6 in. wide, but when the report
is output as a TIF, the image has the actual report (6 x 6) in the upper
right of an image that is 8.5 in by 11 in.
How do I make the size of the TIF file be 6 in. by 6 in.?
Thanks.
Charlie Parker Tag: IRC User group for Foxpro Tag: 212827
MSXML 4.0 merge modules
The VFP9 Help file says there are two of these, and they are described,
along with the VFP runtime, as required. However, I have inadvertently left
them out of setups I've built, and gotten no problems (so far).
Does anyone know what these things do? Something with XML apparently (which
this app doesn't use), but if that's the case, why are they listed as
required? Tag: IRC User group for Foxpro Tag: 212826
CURSORADAPTER DOES NOT COMMIT DATA in MYSQL DATABASE
Hi guys
I am using a code that I have found in internet (CURSORADAPTER.ZIP)
and I am using it to retrieve data from MYSQL database
but after I change the data and use an "TABLEUPDATE(0, .F., 'cursor')"
just the cursor data is changed adn MYSQL does not reflect the changes,
I know I have to send an COMMIT command to MYSQL but
How can I do this (send a commit to mysql) using this cursoradapter.
Thanks. Tag: IRC User group for Foxpro Tag: 212825
create a date field in a select stmt???
How do you create a date field in a select statement. In other words, I
could create a numeric field called age by the following:
select name, id, 000 as age from <table> order by name into <newtable>
What if I wanted to also create a date field called birthdate. How would I
do that? Tag: IRC User group for Foxpro Tag: 212813
cursors
Hi All
How do I transfer the contents of a cursor created by an sql select into a
table?
SELECT * FROM issues WHERE keyfld=Tfind INTO cursor toutput
I have got the select in a do while loop to pick-up steel issued to jobs
(there can be multilple).
I could probably do it with a join, but its tooooo hot and my brain packed
in two hours ago!
Phwew
Steve Tag: IRC User group for Foxpro Tag: 212812
Cursor position in EditBox
VFP 8
I've defined a class derived from the EditBox. This class is used is a grid.
The cursor behind the grid is "artliens_liens"
define class editbox_artliens as editbox
procedure interactiveChange
modif_artliens=.T.
modif_stock=.T.
select artliens_liens
replace modif with .T.
endproc
enddefine
In this edibox, when simply imputing text; the cursor is always in position
0. (Input abcd and see in the editbox : dcba)
If i remove the line with "replace", the problem does not occur.
Is there a solution to this problem ?
Thanks in advance for help,
Regards,
Guy Tag: IRC User group for Foxpro Tag: 212810
Content of <A:Rtf> - Tag
Hi Folks,
ActiveSync compresses the content of the <A:Rtf>-Tag with (I mean) an
LZ-compression Format. So then this output will base64-coded.
First (Base64-coded) Data:
ygEAAJoDAABMWkZ1zkgjmwMACgByY3BnMTI1gjIDQ2h0bWwxAzA/AQMB9wqAAqQD4wIAY2jBCs
BzZXQwIAcTAoD/EAMAUARWCFUHshHVDlEDAd0Q1zIGAAbDEdUzBEYQ2fkS72Y0A8YRhRHjCO8J
9/Y7Gh8OMDUbPxsREeEMYM5jAFALCQFkMzYRYAulZDQgEAIqXA6yAZBnAR/wMyA8IURPQwBUWV
BFIEhUTQBMIFBVQkxJQwAgIi0vL1czQ5EisERURCHENC4RYORUcgBydGkCIAdAIrAwRU4iPhHj
IGcxOUMhICHTRElSPSCwcp8lACBzACEDMCbBZG8A4PMmwQqxXHEaACbBEPADMDcnJRFgICszIA
AmIEVBykQlDTQO8DwvKt8g0II1EWA8Qk9EWSUN7Dk2ISAmgFYm+QAAKTcZIEk2NC9/KY8xNDiB
ISBGT05UIGYA0EhlPScHEycgGZM9VCMwNZMgAJB6NIAy9y9rGDADMGMT8AOyAdApH/UlhjUvAS
80Aib5JwcprYI4IAAmbmJzcAKA+ScYJ2EBQDA/IMEBwCcH7wqiOtgKgCUsMCqhIxAvS7c63y0W
M9EvLc8g0TcsIgsh4SUAfUaQ
Base64-decoded Data (Hex-View):
0000:0000 ef bf 8a 01 00 00 ef be 9a 03 00 00 4c 5a 46 75 ï¿....ï¾....LZFu
0000:0010 ef bf 8e 48 23 ef be 9b 03 00 0a 00 72 63 70 67 ï¿.H#ï¾.....rcpg
0000:0020 31 32 35 ef be 82 32 03 43 68 74 6d 6c 31 03 30 125ï¾.2.Chtml1.0
0000:0030 3f 01 03 01 ef bf b7 0a ef be 80 02 ef be a4 03 ?...ï¿·.ï¾..ﾤ.
0000:0040 ef bf a3 02 00 63 68 ef bf 81 0a ef bf 80 73 65 ï¿£..chï¿..ï¿.se
0000:0050 74 30 20 07 13 02 ef be 80 ef bf bf 10 03 00 50 t0 ...ï¾.ï¿¿...P
0000:0060 04 56 08 55 07 ef be b2 11 ef bf 95 0e 51 03 01 .V.U.ï¾².ï¿..Q..
0000:0070 ef bf 9d 10 ef bf 97 32 06 00 06 ef bf 83 11 ef ï¿..ï¿.2...ï¿..ï
0000:0080 bf 95 33 04 46 10 ef bf 99 ef bf b9 12 ef bf af ¿.3.F.ï¿..￯
0000:0090 66 34 03 ef bf 86 11 ef be 85 11 ef bf a3 08 ef f4.ï¿..ï¾..ï¿£.ï
0000:00a0 bf af 09 ef bf b7 ef bf b6 3b 1a 1f 0e 30 35 1b ¿¯.￷￶;...05.
0000:00b0 3f 1b 11 11 ef bf a1 0c 60 ef bf 8e 63 00 50 0b ?...ï¿¡.`ï¿.c.P.
0000:00c0 09 01 64 33 36 11 60 0b ef be a5 64 34 20 10 02 ..d36.`.ï¾¥d4 ..
0000:00d0 2a 5c 0e ef be b2 01 ef be 90 67 01 1f ef bf b0 *\.ï¾².ï¾.g..ï¿°
0000:00e0 33 20 3c 21 44 4f 43 00 54 59 50 45 20 48 54 4d 3 <!DOC.TYPE HTM
0000:00f0 00 4c 20 50 55 42 4c 49 43 00 20 22 2d 2f 2f 57 .L PUBLIC. "-//W
0000:0100 33 43 ef be 91 22 ef be b0 44 54 44 21 ef bf 84 3Cï¾."ï¾°DTD!ï¿.
0000:0110 34 2e 11 60 ef bf a4 54 72 00 72 74 69 02 20 07 4..`￤Tr.rti. .
0000:0120 40 22 ef be b0 30 45 4e 22 3e 11 ef bf a3 20 67 @"ï¾°0EN">.ï¿£ g
0000:0130 31 39 43 21 20 21 ef bf 93 44 49 52 3d 20 ef be 19C! !ï¿.DIR= ï¾
0000:0140 b0 72 ef be 9f 25 00 20 73 00 21 03 30 26 ef bf °rï¾.%. s.!.0&ï¿
0000:0150 81 64 6f 00 ef bf a0 ef bf b3 26 ef bf 81 0a ef .do.ï¿ ï¿³&ï¿..ï
0000:0160 be b1 5c 71 1a 00 26 ef bf 81 10 ef bf b0 03 30 ¾±\q..&ï¿..ï¿°.0
0000:0170 37 27 25 11 60 20 2b 33 20 00 26 20 45 41 ef bf 7'%.` +3 .& EAï¿
0000:0180 8a 44 25 0d 34 0e ef bf b0 3c 2f 2a ef bf 9f 20 .D%.4.ï¿°</*ï¿.
0000:0190 ef bf 90 ef be 82 35 11 60 3c 42 4f 44 59 25 0d ï¿.ï¾.5.`<BODY%.
0000:01a0 ef bf ac 39 36 21 20 26 ef be 80 56 26 ef bf b9 ￬96! &ï¾.V&
0000:01b0 00 00 29 37 19 20 49 36 34 2f 7f 29 ef be 8f 31 ..)7. I64/.)ï¾.1
0000:01c0 34 38 ef be 81 21 20 46 4f 4e 54 20 66 00 ef bf 48ï¾.! FONT f.ï¿
0000:01d0 90 48 65 3d 27 07 13 27 20 19 ef be 93 3d 54 23 .He='..' .ï¾.=T#
0000:01e0 30 35 ef be 93 20 00 ef be 90 7a 34 ef be 80 32 05ï¾. .ï¾.z4ï¾.2
0000:01f0 ef bf b7 2f 6b 18 30 03 30 63 13 ef bf b0 03 ef ï¿·/k.0.0c.ï¿°.ï
0000:0200 be b2 01 ef bf 90 29 1f ef bf b5 25 ef be 86 35 ¾².ï¿.).￵%ï¾.5
0000:0210 2f 01 2f 34 02 26 ef bf b9 27 07 29 ef be ad ef /./4.&'.)ï¾ï
0000:0220 be 82 38 20 00 26 6e 62 73 70 02 ef be 80 ef bf ¾.8 . .ï¾.ï¿
0000:0230 b9 27 18 27 61 01 40 30 3f 20 ef bf 81 01 ef bf ¹'.'a.@0? ï¿..ï¿
0000:0240 80 27 07 ef bf af 0a ef be a2 3a ef bf 98 0a ef .'.￯.ï¾¢:ï¿..ï
0000:0250 be 80 25 2c 30 2a ef be a1 23 10 2f 4b ef be b7 ¾.%,0*ﾡ#./Kï¾·
0000:0260 3a ef bf 9f 2d 16 33 ef bf 91 2f 2d ef bf 8f 20 :ï¿.-.3ï¿./-ï¿.
0000:0270 ef bf 91 37 2c 22 0b 21 ef bf a1 25 00 7d 46 ef ï¿.7,".!ï¿¡%.}Fï
0000:0280 be 90 ¾.
How can I decompress this last (Base64-decoded) Data?
Sincerely yours
Nico Roßwinkel Tag: IRC User group for Foxpro Tag: 212809
frx2any
Anyone heard of this tool? Can it export correctly to Excel newer than
97? Or was it because I was using an old version of it?
--
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.30
^ ^ 8:10pm up 41 days 8:19 load average: 0.31 0.55 0.45 Tag: IRC User group for Foxpro Tag: 212803
wait after shellexecute ?
Hi,
Is it possible to wait after a process, which is started with ShellExecute()
?
I'm calling a program and would like that myapp waits until that program has
finished.
regards
christophe
--
\|||/
(o o)
----ooO-(_)-Ooo------------- Tag: IRC User group for Foxpro Tag: 212801
high-lighting current record in grid
If the grid is in focus, the current record will always be high-lighted
as I moved the record pointer programmatically (SKIP, GO, SEEK, ...).
Is there a way to keep the high-lighting to follow the record pointer
without grid.setfocus() first? Tag: IRC User group for Foxpro Tag: 212795
Word.Application
I have the following code to call a word document in a readonly mode, which
works fine.
x1=CREATEOBJECT("Word.Application")
WITH x1
.documents.open ("f:\test1.doc",,.t.)
.visible = .t.
ENDWITH
Once in word, can someone point me to a right direction or show me how i can
change the default drive in file "Save as" from drive f: to drive c: and
preferrable to the user's "my documents folder"?
Many thanks
Shahriar Tag: IRC User group for Foxpro Tag: 212793
Wanted: Genifer for FoxBASE+
Hello!
An old client has decided to come out of retirement and restart his
business. Although he retained copies of his in-house developed programs, he
did not keep any of his old commercial software. To modify his old programs
we have need of Bytel's Genifer with templates for FoxBASE+ v2.1.
Does anyone have a copy that they would be interested in selling?
If so, please let me know at ojn@zoominternet.net.
Thanks,
O.J. Tag: IRC User group for Foxpro Tag: 212790
Is grid.AfterRowColChange broken?
I posted on a related topic yesterday. See Subject: RowColumnChange
property always 0
It seems that the AfterRowColChange event doesn't behave as documented. It
appears to fire BOTH before AND after a row change even though the docs are
clear that it only fires after the chage. This can be seen by setting a
breakpoint anywhere in user code in that event.
Also, and contrary to the docs, the RowColChange property seems to always
be zero.
Am I missing something? Has this been discussed before?
VFP9.
Thanks, Frank Tag: IRC User group for Foxpro Tag: 212789
VFP 6: Erroneous Error to Watch Out For
I was just updating the application I support and ran into an
error. I could not open tables on the other workstations. I kept
getting "File is in use by another."
The actual cause of the error is that the volumes are
password-protected. I recently rebuilt my system and no longer had
the passwords saved. Once I connected through Windows Explorer which
asked for the passwords, there was no problem getting through using
VFP.
This leads to the question: Is there a way in VFP to specify a
password for accessing a file on a password-protected volume?
Sincerely,
Gene Wirchenko Tag: IRC User group for Foxpro Tag: 212788
Ken Levy's July letter posted
http://msdn.microsoft.com/vfoxpro/letters/
--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden Tag: IRC User group for Foxpro Tag: 212779
VFP90: Help file
Why when I press F1 or from menu "Help -> Help" the Help doesn't open?
The file "dv_foxhelp.chm" exists and is set in "Tools->Options->File
Locations->Help File".
Meskis Tag: IRC User group for Foxpro Tag: 212778
Send using OE but prompt Outlook profiles.
i use msmapi32.ocx to send e-mail from my program.
it seems to works perfectly on XP & 9x machines,
but recently i found few 9x machine have problem.
system will prompt to choose Outlook profiles when try to sent.
those machine do not use outlook, and should not prompt this.
as my default mail program already set to OE.
any ideas to resolve this problem? Tag: IRC User group for Foxpro Tag: 212761
buffering and sql
I have a table opened in buffering mode = 5. I appended a record with
table.amount=4. then I execute select sum(amount) on the table. It
returned 0, not 4. Could I make the sql query to take into account of
the pending changes? Tag: IRC User group for Foxpro Tag: 212754
RowColumnChange property always 0
VFP9.
I'm having trouble with the rowcolumnchange property.
I have some code in the afterrowcolumnchange event that needs to fire if
a row, not a column has changed.
Problem is, the property always seems to resolve to zero so my code never
executes.
Here's a piece of the code in the afterrowcolumnchange event for the
grid:
IF This.RowColChange = 1 OR This.RowColChange = 3
RecSymb = RECNO("Symbols")
SELECT se.Institutio, ac.ACName, se.Totshares, ;
*** additional code
ENDIF
I have a breakpoint at the IF statement so that I can check the property.
Also, the event seems to fire twice every time I change rows.
What am I doing wrong?
Thanks, Frank Tag: IRC User group for Foxpro Tag: 212752
command + properties = ??
in vFP 9, when the command windows and properties are combined into each
other, what's its window name? I found that my
hide_all_vFP_system_toolbars router didn't work for the combination. Tag: IRC User group for Foxpro Tag: 212748
Foxpro 9 SQL Select
OK, what the heck am I doing wrong. The below statement returns a
cursor if I Take Out everything after the WHERE h.lFinalized. I
ultimately need to UNION, but need to get this working first...
Thanks for your help
SELECT d.cTick, h.cName, h.cPlant, h.dDate, h.dShpDate, d.cItemNr, +
; d.cDistNr, d.cItmDesc, d.nQty, d.cItmSize, d.eTotDlvPrice,
d.nDlvDist, + ;
h.cVPNo, d.cSuppNo, d.nPrcMdl, d.nItmWght, d.cSupItem, d.nAmt,
d.ePAmt, + ;
h.cSOGrPoNo, h.dSoInvDate, d.eSupFobCs, d.nSOtWeight,
d.eVPDPAAmt, d.eDstShlAmt ;
FROM SO_HEAD h ;
INNER JOIN SO_DETL d ON d.csoTickno = h.csoTickNo ;
WHERE h.lFinalized AND h.dsoDate BETWEEN
CTOD(THISFORM.Text1.Value) AND CTOD(THISFORM.Text1.Value) AND ;
d.cItemNo <> '999999' AND ;
d.nSOQty <> 0 AND ;
h.cSOType = '2' INTO CURSOR curReport Tag: IRC User group for Foxpro Tag: 212744
Cannot access CHM on a network drive with XP
I have CHM for my application that I have been using for years. Today I
discovered that I can open the CHM that is on a network drive with XP but
cannot read any of the contents. The 'find' works and the table of contents
is working but none of the pages are displayed. I have opened the file on
the network drive in the recent past. If I copy the file to my local hard
drive I can open it. I can open the file using WIN98 or WIN2K on the network
drive without copying the file. None of my XP computers can read the
contents of the file. What could have changed to cause this behavior? Tag: IRC User group for Foxpro Tag: 212717
problem with a report logic
hi all.
this is a pretty difficult question to ask so i hope to
describe it in the right way.
i have a reprt to print that is causing me some problems.
the cursor that i have when it is the time to print my detail is kind of
this:
cust #doc value #doc rif
mrx 10 10 1a
mry 20 25 1b
mry 20 25 1c
mrz 30 12 1d
what i woul like to obtain is something like this:
customer value doc number
mrx 10 10
doc ref 1a
tot val for mrx 10
mry 25 20
doc ref 1b
doc ref 1c
tot val for mry 25
mrz 12 30
doc ref 1d
tot val for mrz 12
my problem is that with mry that has 2 records the value
for the total is double (25 + 25 = 50) so i have for this customer
something like this
mry 25 20
doc ref 1b
doc ref 1c
tot val for mry 50 (<--------WRONG!!!)
the total value is defined as the sum of the cursor single value.
so this is the reason why it is double in the case of mry...i am able not to
print twice the row of the document but the sum counts every record (even if
not
printed).
Is there a way to let the sum works in the same way as the print (do not
show
repeated values -- do not count in the sum repeated values)?
or is there a better way to solve this?
thanks in advance and bye. Tag: IRC User group for Foxpro Tag: 212716
PNG file to BMP file
I need to programatically convert a PNG file to a BMP file.
Anyone have a a method, routine, process, 3rd party control or whatever that
will do this?
Thanks.
Charlie Parker Tag: IRC User group for Foxpro Tag: 212713
Default Cap Lock on
I know i can set the format of textbox is "!".
However, Once i set it, i cannot change the textbox into small letters.
So , Can I set the keyboard 's default "cap lock on" ???
Thanks Tag: IRC User group for Foxpro Tag: 212693
Folder cannot be deleted
Why is folders on my harddisk created from my program using MD command
cannot be delete until i quit my Foxpro even the program has already ended ?
my program use MD and copy files command. Tag: IRC User group for Foxpro Tag: 212688
Rookie Questions - Emailing and FTPing with VFP
I have VFP 7.0 SP1
How can I email and ftp programmatically with VFP?
That is, I want to create some prgrams that email or ftp whenever the
program calls for it. Is this possible?
How are other people doing it if VFP does not give these capabilities?
BTW when I say "email or ftp", I actually have two separate needs for
communication.
1. I need to automatically email messages based on some triggers in
my data.
2. Separate from the email, I have VFP creating some web pages, and I
would like these to be automatically FTPed or transfered to my web
site.
On the last point of FTPing, I do know how to automatically FTP using
scripts in WS-FTP. I was just wondering if there is a feature
internal to VFP for doing this.
Thanks.
Best regards,
Al
http://www.affordablefloridainsurance.com
http://www.americanbestmortgages.com Tag: IRC User group for Foxpro Tag: 212684
A Touch OT: C++ App on PDA talking to VFP data
Hi,
Has anyone tried the above. The idea is an embedded Visual c++ app running
on a Windows CE .NET 4.2 PDA talking to remote VFP tables or a DBC. Have had
a look at ADOCE, but it doesn't want to play. To be honest, I'm not sure
where to start here, but I can't run VFP natively, and have tried a web
based app with FoxISAPI which works OK, but is less than ideal as I can't
control focus well enough for the built-in barcode scanner.
The PDA doesn't support the .NET compact framework, even though it is the CE
.NET 4.2 OS (guess I assumed too much there?).
If anyone's tried and succeeded along these lines, I'd be very happy to hear
from you. I know the VFP OLEDB provider would be a nice way to go, and it
works fine with c#.net, but this overly priced heap of crap (Symbol MC3000)
won't take it. (sorry, frustrated and wondering if it really will take that
number of drops onto concrete from that height).
Regards,
Neil Tag: IRC User group for Foxpro Tag: 212683
Hi,
Come join us on irc at irc.freenode.net on the #vfp channel, for help and
general foxpro chat.