VFP9 KillFocus
Hello everyone !
How can I kill the CommandButton's focus except for calling other
control's SetFocus event when MouseLeave Event occured after I clicked the
CommandButton in VFP9?
Thanks a lot!
Holy Tag: .fxp is not an object file Tag: 215134
declare DLL call caused an exception
Halo..Im using the vfp6.0 SP5+ VPMe6 to compile a setup ...its successfull
install in the PC windows server 2003 SP1 but when running the program exe
its prompt error "declare DLL call caused an exception"..
Anyone can help me..please advice..thanks a lot
regard,
orange Tag: .fxp is not an object file Tag: 215131
Checkbox in grid
Hi
I would like to use a checkbox in a column of a grid but I am not sure how
to do this and also what type of field would the checkbox require.
Help appreciated,
warrenjw
warrenjw@internode.on.net Tag: .fxp is not an object file Tag: 215129
Add Method Problem
I am having something wierd going on in VFP 9. I have a formset and go to
form -> new method to create a method. I type in the name "testMethod" and
hit add. This then adds the method to the currently active form in my
formset, and not to the formset. I can go into the form.testMethod and add
code to it. When I save and close out of the formset and then go back in,
the method does not show up under the form nor does it show up under the
formset. My workaround is to go to edit property method in the menu and
then do add method there. Then everything works fine. Is anybody else
having this same issue?
P.S. I know formsets are not the best way to do things but I am working
with old code and it would be alot of work to get them out of formsets.
--
TIA
Altman
VFP9 Tag: .fxp is not an object file Tag: 215124
Landscape reports
Hi. In one of my applications I have a couple of Landscape reports. I
send these reports to the windows spooler. Sending characters strings
and using SET PRINT FONT. To do this, I test PRTINFO(1) = 0. If true,=
SYS(1037) to allow the user to switch the landscape mode.
Couple of problems with this technique. One, the user might not switch
to landscape. Two, that print device stays in landscape mode until he
switches back or exits FoxPro.
Question. Is there a way my code could switch the print device back and
forth from landscape mode? Without the need of SYS(1037). Any advice
would be appreciated...Dennis Tag: .fxp is not an object file Tag: 215119
VFP7 view with uncommitted changes - weird behaviour
I have a situation, reproducable very occasionally but not consistently,
where a requery after tableupdate fails with uncommited changes. I've looked
at the view cursor in Debug and it looks really strange. This is the
scenario (code that creates the view is below).
The view is of a child table and has a filter in place equal to the id of
the parent table. The view is in item number order. Add 5 records (items 1
to 5) to the view, delete the 3rd one (causes item 4 and 5 to resequence to
item 3 and 4) and then save. Save scans the file (with set deleted off) and
issues a tableupdate on each record. The subsequent requery sometimes fails.
Browsing the cursor shows why it has failed but I can't see a reason for the
cursor being in the state it is in!
Debug says these are 8 records. Browsing displays 5. 2 records belonging to
the previous header even though there is a filter in place so I don't know
why these are showing. The 2nd item of the added items does not display.
After setting the filter off and setting deleted off, 6 records display, the
same 5 as above plus the deleted one. I then set the order off and 8 records
then appeared. The 8th record was full of zeroes and characters that look
like a thick letter I in some of the fields. Where this came from I have no
idea.
I have no idea where to go from this point as it seems to be VFP7 doing
something outwith my control. Has anyone had this kind of problem before?
Thanks for any help.
Bernie Beattie
Here is the code that creates the view:
CREATE SQL VIEW V_NLJDTL AS ;
SELECT NLJDTL.nljdtl_id AS nljdtl_id,;
NLJDTL.nljhead_id AS nljhead_id,;
NLJDTL.item_no AS item_no,;
NLJDTL.acctno AS acctno,;
NLJDTL.db_or_cr AS db_or_cr,;
NLJDTL.tran_amt AS tran_amt,;
IIF(nljdtl.db_or_cr='D',tran_amt,0000000000000.00) AS Debit,;
IIF(nljdtl.db_or_cr='C',tran_amt,0000000000000.00) AS Credit,;
NLJDTL.property AS property,;
NLJDTL.REFERENCE AS REFERENCE,;
NLJDTL.reconc_id AS reconc_id,;
NLJDTL.added_dt AS added_dt,;
NLJDTL.changed_dt AS changed_dt,;
NLJDTL.vatst_pr AS vatst_pr, ;
nljdtl.rcveble_id as rcveble_id,;
nljdtl.plinv_id as plinv_id,;
NLACCD.COMPULSPRP AS COMPULSPRP,;
NLACCD.ACCTYPE_ID AS ACCTYPE_ID ;
FROM NLJDTL,NLACCD ;
WHERE NLJDTL.acctno=NLACCD.acctno AND NLJDTL.acctno<>0 AND
nljdtl.nljhead_id=?pnhead_id
*make the view updatable
DBSETPROP('v_nljdtl','View','Tables','nljdtl')
DBSETPROP('v_nljdtl.nljdtl_id','Field','KeyField',.T.)
DBSETPROP('v_nljdtl.nljdtl_id','Field','UpdateName','nljdtl.nljdtl_id')
DBSETPROP('v_nljdtl.nljhead_id','Field','UpdateName','nljdtl.nljhead_id')
DBSETPROP('v_nljdtl.item_no','Field','UpdateName','nljdtl.item_no')
DBSETPROP('v_nljdtl.acctno','Field','UpdateName','nljdtl.acctno')
DBSETPROP('v_nljdtl.db_or_cr','Field','UpdateName','nljdtl.db_or_cr')
DBSETPROP('v_nljdtl.tran_amt','Field','UpdateName','nljdtl.tran_amt')
DBSETPROP('v_nljdtl.property','Field','UpdateName','nljdtl.property')
DBSETPROP('v_nljdtl.reference','Field','UpdateName','nljdtl.reference')
DBSETPROP('v_nljdtl.reconc_id','Field','UpdateName','nljdtl.reconc_id')
DBSETPROP('v_nljdtl.added_dt','Field','UpdateName','nljdtl.added_dt')
DBSETPROP('v_nljdtl.changed_dt','Field','UpdateName','nljdtl.changed_dt')
DBSETPROP('v_nljdtl.vatst_pr','Field','UpdateName','nljdtl.vatst_pr')
DBSETPROP('v_nljdtl.nljdtl_id','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.nljhead_id','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.item_no','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.acctno','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.db_or_cr','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.tran_amt','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.property','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.reference','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.reconc_id','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.added_dt','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.changed_dt','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.vatst_pr','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.rcveble_id','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.plinv_id','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.compulsprp','Field','Updatable',.T.)
DBSETPROP('v_nljdtl.acctype_id','Field','Updatable',.T.)
DBSETPROP('v_nljdtl','View','SendUpdates',.T.)
*open the view
SELECT SELECT(1)
USE V_NLJDTL EXCL
INDEX ON STR(nljhead_id)+STR(item_no,3) TAG UNIQUE_KEY
INDEX ON item_no TAG item_no
INDEX ON acctno TAG acctno
INDEX ON Debit TAG Debit
INDEX ON Credit TAG Credit
INDEX ON UPPER(property) TAG property
INDEX ON UPPER(REFERENCE) TAG REFERENCE
CURSORSETPROP("buffering",5) &&optimistic table buffering Tag: .fxp is not an object file Tag: 215118
Multi-Lingual in VFP
I've got to make a multi lingual application in VFP 9.0, exept the Steven
Black INT'L component, does someone have a native and free soluton.
Thanks.
Patrick Tag: .fxp is not an object file Tag: 215115
Bugg? in tableupdate - VFP8-SP1
I have problems with tableupdate. Tableupdate returns F even after success.
It happens if the field below is of type memo and the corespondending .fpt
file is quite large (10M). Small files - no problems.
* write to table
SET REPROCESS TO 3 SECONDS && 10 seconds is not better
IF CURVAL(lcFieldName,lcAlias) == OLDVAL(lcFieldName,lcAlias)
llUpdated = tableupdate(1,.F.,lcAlias)
IF llUpdated = .T.
wait 'Saved' nowait window
ELSE && i.e. unother user has removed the record
TABLEREVERT(.F.,lcAlias)
MESSAGEBOX('Save failed, record removed by unother user', ;
0+48,'Securityinformation')
ENDIF
ENDIF
The code above fires the messagebox. But if I continue to use the app I can
see that the view´s sourcetable is updated after all.
Hints about this should bee very appreciated.
Best regards
Christina Tag: .fxp is not an object file Tag: 215108
Excel automation
I'm getting an "Unknown COM status error" on the second line of code below
(owb is an Excel Workbook object). This works fine in the development
environment, but not on the end user deployment. I'm guessing that VFP being
installed might help. Does anyone know what I need to install to make this
work? Briefly, the code populates a worksheet, creates a graph from it,
saves the graph as HTML and displays it in a browser.
lcWeekChart = sys(5) + curdir() + "graphs\" + sys(2015) + ".htm"
with owb.PublishObjects.Add(xlSourceChart, lcWeekChart, "Chart1", "",
xlHtmlChart, "Weekly Sales", "")
AFAIK, the development and production environments are using the same Office
2003 install.
Thanks for any help,
Neil Tag: .fxp is not an object file Tag: 215098
Help Files
I have made a chm help file called scgHelp.chm
I have "set help on"
Set help to scgHelp.chm
It works great on my system XP Home, however my customers with XP Home,
nothing happens, help doesn't work.
Any Suggestions ?
Loren Tag: .fxp is not an object file Tag: 215097
seek
I have tables with compound indexes. Performing a seek seems to require the
padding of the fields (at least the first field of the index). The index in
not based on the padding. Am I missing something? Do I need to pad the
variables I am seeking? Tag: .fxp is not an object file Tag: 215076
Image name with image oddity on forms and reports.
I have an app done for somebody else where photos shown on form
and report. I have never got this, myself but the client
sometimes reports strange image titles included with the image.
For example it would show or print the image and right underneath
it it would print the name of the image file.
--------
| |
| |
|(Image) |
| |
| |
| |
--------
Logo.bmp
Anybody seen this and a solution?
-----------------------------------------------------------------
Paul Lee ........... Abri Technologies ......... http://abri.com/
'Recover' - top rated FoxPro file repair utility.
----------------------------------------------------------------- Tag: .fxp is not an object file Tag: 215072
VFP9 report anomalies with picture
I'm adding a gif picture to a VFP9 report (REPORTBEHAVIOR = 80, non-GDI+). I
don't know whether this matters, but it's a label printer, 1" x 3",
landscape mode.
1. When I tap the arrow keys to move the picture, it shrinks instead of
moving, as if it were moving only the left or top sides.
2. When I double-click the object to edit the properties manually, the path
to the picture gets corrupted. For example, if the path is
c:\folder\mypic.gif
it gets changed to
c:\folder\folder\mypic.gif
Anyone else seen this, or is my computer going crazy? Tag: .fxp is not an object file Tag: 215069
COPY TO FIELDS x,x,x TYPE SDF - Erratic Integer translations!
Does anyone know what FoxPro is doing when it writes out SDF files and
converts integer fields? I am attempting to copy out an SDF file for BULK
INSERT into SQL. I need only a subset of fields, so I am using the FIELDS
x,x,x parameter, and this seems to throw FoxPro's Integer column conversion
into a bit of a tailspin.
For example:
CREATE CURSOR Mewp (char1 c(10), char2 c(10), int1 I, int2 I)
INSERT INTO mewp (char1, char2, int1, int2) VALUES ('asdf','qwer',1,2)
INSERT INTO mewp (char1, char2, int1, int2) VALUES ('zxcv','zxcv',3,4)
INSERT INTO mewp (char1, char2, int1, int2) VALUES ('tyui','ghjk',5,6)
COPY TO C:\Temp\Temp1.txt TYPE SDF
^ the above reacts as it should, integer columns are 11 characters long,
right justified. Now:
CREATE CURSOR Mewp (int1 I, int2 I, char1 c(10), char2 c(10))
INSERT INTO mewp (char1, char2, int1, int2) VALUES ('asdf','qwer',1,2)
INSERT INTO mewp (char1, char2, int1, int2) VALUES ('zxcv','zxcv',3,4)
INSERT INTO mewp (char1, char2, int1, int2) VALUES ('tyui','ghjk',5,6)
COPY TO c:\temp\temp2.txt FIELDS Int1, Int2, Char1, Char2 TYPE sdf
^ Field order in the source is different, but same field names and
datatypes. In Temp2.txt, the integer columns are LEFT justified, and only 10
characters.
In the table I first tested on and discovered the erratic behavior, I have a
much wider field layout, a much wider integer range, and a much larger
dataset, and in that instance, the integer column (first in the FIELDS list,
last in the table structure) in the SDF file is 11 characters, right
justified, followed by 10 spaces. In another large test I ran with a
slightly smaller field layout and dataset, it was 11 characters right
justified, followed by 4 spaces. I haven't been able to reproduce either of
these outside of the tables i'm using, so I'm not sure if the field types,
field names, integer values, table size, or what is causing the change in
conversion.
Anyone have any experience on this that might lend some insite? Tag: .fxp is not an object file Tag: 215068
Citizen CBM1000 Type II receipt printer
How to open the cash drawer model POSIFLEX CR4100 connect with Citizen CBM
1000 Type II receipt printer ?
thank you. Tag: .fxp is not an object file Tag: 215061
Localhost
VFP7 application. Need to connect to web service, which is running locally
on the same PC. I have some sample code (I think it's .net) that I need
help converting to VFP for the objSdk and objError objects.
Dim sHandle As String
Dim objSdk As New localhost.SmpSdk
Dim objError As New localhost.clsSdkError
sHandle = objSdk.SdkZLogin (cUser,cPassword, objError)
If (sHandle = "")
MsgBox ("Invalid Login")
Else
MsgBox ("Login Success")
End if
TIA Tag: .fxp is not an object file Tag: 215054
Get file from URL in VFP 5.0
Our application sends data to a third party's website who will manipulate it.
I've got this part working just fine by opening an instance of IE and
sending our data in the address.
But now we need to retrieve the data back from their server. Any clues on
how to get the file to our hard drive? We asked them to drop a cookie, but
they don't want to go that route. Since I'm working in 5.0 I'm not sure what
options are available. I might be able to convince them to display the data
in the browser window if that makes a difference.
Thanks very much in advance, Tag: .fxp is not an object file Tag: 215046
Find
I most often use the "All objects" on Find. Is there any way to make that
the default instead of the current procedure?
TIA Tag: .fxp is not an object file Tag: 215044
frx2word
I use for my reports frx2word.
All reports works. But by some windows 2000 Computer with office 2000 it
dosnt work.It comes no Error Messages. But the doc file is empty.
Thanx
--
Cengiz Zengin
CZ Computer Tag: .fxp is not an object file Tag: 215034
installshield
The InstallShield of VFP 9 really `scared` me.. So much complicated than
VFP6's setup wizard...
--
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 8:48pm up 37 min 5 users 1.57 1.66 Tag: .fxp is not an object file Tag: 215029
FPW2.6 check if report available programmatically
I'm writing a program that uses a report. This program is usually compiled
into .exes, and when building, the project manager finds the report and
includes it in the .exe.
However, this program is sometimes called from a standalone prg I run in the
IDE. The report almost certainly won't be visible at run time and I don't
want to make an identical copy elsewhere (although that would work.) What I
would like to do is something like
IF isexe()
REPORT FORM report.frx TO PRINTER PROMPT
ELSE
REPORT FORM <full path to report>\report.frx ...
ENDIF
The best I've thought of is an ugly error trap:
m.lno_frx=.F.
ON ERROR m.lno_frx=.T.
REPORT FORM report.frx TO PRINTER PROMPT
ON ERROR
IF m.lno_frx
REPORT FORM <full path>....
ENDIF
Any other ideas?
--
TIA
Andrew Howell Tag: .fxp is not an object file Tag: 215019
How to update characte(binary) field on dbf table using cursoradap
i create a dbf table that have some binary char fields and i want to use
cusroradaptier via ADO to update.
it cannot update when execute tableupdate() command.
aerror() get the error as following
error : 1435
Microsoft Cursor Engine : Multiple-step operation generated errors. Check
each status value.
it is same error either set mapbinary property on cursoradapter object to
.t. or .f.
sample code :
********************
IF !file("c:\test\test.dbf")
CREATE TABLE c:\test\test.dbf (testval c(10) nocptrans)
APPEND BLANK
USE
endif
set multilocks on
oca=createobject("cursoradapter")
oca.alias="catest"
oca.buffermodeoverride=5
oca.cursorschema="TESTVAL M"
oca.datasourcetype="ADO"
oca.keyfieldlist="TESTVAL"
oca.mapbinary=.T.
oca.selectcmd="Select * From test"
oca.tables="test"
oca.updatablefieldlist="TESTVAL"
oca.updatenamelist="TESTVAL test.TESTVAL"
loConnDataSource = createobject('ADODB.Connection')
loConnDataSource.ConnectionString = [Provider=VFPOLEDB.1;Data
Source=c:\test;Password="";Collating Sequence=MACHINE;]
loConnDataSource.Open()
oca.DataSource = createobject('ADODB.RecordSet')
oca.DataSource.CursorLocation = 3 && adUseClient
oca.DataSource.LockType = 3 && adLockOptimistic
oca.DataSource.ActiveConnection = loConnDataSource
oca.cursorfill()
SELECT catest
replace testval WITH "test"
IF TABLEUPDATE(1)
else
=AERROR(amessage)
=MESSAGEbox(amessage(2))
endif
********************
i'm using vfp9.
--
Ray Tag: .fxp is not an object file Tag: 215018
Third party tool required
I need a third party tool to repair a corrupt dbf file.
Thanx in advance
Regards
Nishu Tag: .fxp is not an object file Tag: 215012
What does this mean ?
I have come across a code snippet which I am unable to understand - the
color statement - Can anybody help me understand this thing ? What does
these so many RGB means in the deffinition ?
MODIFY WINDOW lw_invoice NOGROW ;
COLOR RGB(0,0,0,192,192,192), ;
RGB(0,0,0,255,255,255),,,,,,,, ;
RGB(0,0,0,192,192,192) ;
FONT "Courier New", 9 Tag: .fxp is not an object file Tag: 215011
Replace question and table precision
* make sure there are no DBCs open
create cursor zoot (zz n(3,1))
append blank
replace zz with 9.9
? zz && prints 9.9
replace zz with 999
? zz && prints 999
The last replace command should not work, but it does. Why? I've learned
from experience that VFP is pretty sloppy about numeric fields if the table
is not associated with a DBC, but I figured they would have fixed this by
now? Is this left in for legacy purposes? Tag: .fxp is not an object file Tag: 215004
[OT] User-Defined string Functions Transact-SQL <-> VFP
Ladies and Gentlemen,
I am pleased to offer, free of charge, the following string functions
Transact-SQL:
AT(): Returns the beginning numeric position of the nth occurrence of a
character expression within another character expression, counting from the
leftmost character.
RAT(): Returns the numeric position of the last (rightmost) occurrence of a
character string within another character string.
OCCURS(): Returns the number of times a character expression occurs within
another character expression (including overlaps).
OCCURS2(): Returns the number of times a character expression occurs within
another character expression (excluding overlaps).
PADL(): Returns a string from an expression, padded with spaces or
characters to a specified length on the left side.
PADR(): Returns a string from an expression, padded with spaces or
characters to a specified length on the right side.
PADC(): Returns a string from an expression, padded with spaces or
characters to a specified length on the both sides.
CHRTRAN(): Replaces each character in a character expression that matches a
character in a second character expression with the corresponding character
in a third character expression.
STRTRAN(): Searches a character expression for occurrences of a second
character expression, and then replaces each occurrence with a third
character expression. Unlike a built-in function Replace, STRTRAN has three
additional parameters.
STRFILTER(): Removes all characters from a string except those specified.
GETWORDCOUNT(): Counts the words in a string.
GETWORDNUM(): Returns a specified word from a string.
PROPER(): Returns from a character expression a string capitalized as
appropriate for proper names.
RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right
search.
ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified
numeric expression (from 1 to 3999).
ROMANTOARAB(): Returns the number equivalent of a specified character Roman
numeral expression (from I to MMMCMXCIX).
AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL
INSTR, LPAD, RPAD, TRANSLATE, INITCAP.
More than 4000 people have already downloaded my functions. I hope you will
find them useful as well.
For more information about string UDFs Transact-SQL please visit the
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
or http://nikiforov.developpez.com/ (the beautiful French language)
Please, download the file
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
With the best regards. Tag: .fxp is not an object file Tag: 215002
VFP 6: clear events with Nonmodal Forms
You might recall my question not too long ago about
copy-cut-paste with toolbars. I am now looking at using nonmodal
forms. I have a couple of problems.
1) Where do I put the clear events command? If I do not have it, my
program does not terminate when all forms are closed. Since any form
might be the last, what is the best placement?
If I am using a menu, then presumably, I put it in the exit
selection, but if I am not using a menu, what do I do?
I suppose that I can have
if _screen.formcount=0 && or 1, I am not sure
clear events
endif
in a suitable event's (.unload()?) code, but it looks kludgy.
2) What is the best way to store the object references (so the forms
stay in scope)? A global array? Do you have hardcoded references to
array elements, search for a free element, or do something else?
Sincerely,
Gene Wirchenko Tag: .fxp is not an object file Tag: 215001
VFP8 Intellisense issue
I'm writing an ActiveX control (non-attributed ATL project in VS7). I've
noticed a problem when testing this ActiveX control in Visual FoxPro 8 and
9.
If I type "ThisForm.oleCtrl.", the trailing "." which triggers the
intellisense code completion, causes vfp to shut down with a Buffer Overrun
error message shown below.
Anyone encountered this problem?
Thanks,
Greg
...
Microsoft Visual C++ Runtime Library
Buffer overrun detected!
Program: ...ogram Files\Microsoft Visual FoxPro 8\vfp8.exe
A buffer overrun has been detected which has corrupted the programs'
internal state. The program cannot safely continue execution and must
now be terminated.
... Tag: .fxp is not an object file Tag: 214997
Connecting To DBF Using vfpoledb
I have the need to connect to a remote DBF table across the network.
Currently, I able to do this using a mapped drive which maps to the remote
system where the DBF is stored, as such.
Provider=vfpoledb;Data Source= \\remoteserver\dbffiles\;
Mode=ReadWrite;Collating Sequence=MACHINE;
However, mapped drives can be finicky. Now, the purpose of this post is to
ask; "Is there a better way to do this, without the need for a mapped drive?" Tag: .fxp is not an object file Tag: 214982
Printing on a dot matrix with vfp9
When I set report behavior 90, The fonts no longer print out correctly on a
dot matrix printer. When I set report behavior 80 everything is fine.
What Can I do to insure the fonts print out correctly? I tried saving the
printer environment and it did not help. Sending output to generic text
printer driver does not work well either. Tag: .fxp is not an object file Tag: 214979
Migration from XBase++ to Visual FoxPro 9
Hi,
I am working on a project in Visual FoxPro 9 which will eventually replace
the existing software written in XBase++.
During this migration process, I will use the existing XBase++ tables with
cdx indexes.
Does anyone have any recommendations or any data recommendations during this
migration.
I seem to have random index problems. The problem will not be there and then
it shows up. I then delete the index file and reindex with the XBase++
software and the VFP9 software will still show the error. I then open the
free table and the index in VFP9 and then issue reindex (This is done
without trying to browse the table). All is cured. The table is still
accessable from XBase++ software and VFP9 software. Anybody know what is
going on here and what I need to start doing in order to make this work?
Thank you,
Mike Tag: .fxp is not an object file Tag: 214973
Change colors of the Window Globaly ?
I want all the windows in my application - which is already running and
using different back ground colors - to have a specific color say blue -
irrespective of the colors the windows are defined with - ? Is it possible
either ?
I am looking for a solution like a hook which keeps on looking whenever a
user defined window becomes visible OR no matter is defined its back ground
color changes to that specific color. Tag: .fxp is not an object file Tag: 214963
CREATE OBJECT
I develop application in vfp9 using the command CREATE OBJECT for link ole
application and work fine with EXCEL, WORD and PP, but i cant do the same to
link with WORDPAD or NOTEPAD, i will appreciate if could help to to fix these
problem.
Thanks. Tag: .fxp is not an object file Tag: 214962
writing map software
Not sure if this is the right place or not, but does anyone know how
mapping software is written? i'd like to write a baby program to map
out my building and where the different meeting rooms are located (time
and distance to each room from a disgnated spot, etc).
if anyone has any suggestions please send me an email. Tag: .fxp is not an object file Tag: 214960
Keypress event F2 works in VFP6 but not VFP7 onwards
I am converting an application from VFP6 to VFP9 and have discovered an
issue that I hope someone can help with.
I am trying to capture the F2 key being pressed within a textbox on a form
in the keypress event (nKeyCode=-1). This would not work in VFP9 so after
trying many things I built a basic form with one text control and a capture
of the key press events to screen. It appears that in VFP6 the textbox
keypress event happily tells me that F2 has been pressed, however in VFP7
onwards it appears that the F2 is not captured and nothing happens. The ON
KEY LABEL is not active and F3, F4 etc are all working e.g. nKeyCode=-2,
nKeyCode=-3 etc. This happens only with F2 (nKeyCode=-1).
Does anyone know why? Is there something I am missing?
This seems too simple an issue to be a bug?
Thanks
John R. Tag: .fxp is not an object file Tag: 214955
DOS Filenames
I am integrating an ActiveX control into my app. One of the properties is
'FileName'. Works fine till the property is set to a string containing the
'~1' characters one gets from SYS(2023).
Is there a utility/command that will convert the DOS path to a the real
pathname?
tnx,
Howard Tag: .fxp is not an object file Tag: 214953
Foxpro dll and Installshield
I built a multithreaded com server (dll) in FoxPro 9 and put it into my
installshield to install. When it tries to build the installer I get this
message.
The build was unable to extract COM information from the file <my dll file>
in component <my dll file>. Please ensure that the file is self-registering
and verify that the self-registration process does not fail.
I can register it fine manually with regsvr32 but I do not want to manually
register it. Is there any way around this or do I have to manually register
this?
--
TIA
Altman
VFP9 Tag: .fxp is not an object file Tag: 214948
Predict Page Count
When printing out a report, is there a way of counting the pages
before you print them so that you can print something like
Page 1 of 20. page 2 of 20 etc: on each page in the header?
TonySper Tag: .fxp is not an object file Tag: 214945
VFP6: open excel file and dump to .dbf
Need to open a spreadsheet (Excel 2k) and dump contents to .dbf file using
VFP6. Pretty generic really, sorry if this request isn't a challenge! Any
sample type code would be appreciated.
- Ben Tag: .fxp is not an object file Tag: 214942
Rounding question and trig functions
set decimals to 4
? SIN(1)*COS(1)
0.45464871
? .5*sin(2)
0.45465
VFP rounds the result, but why does the first get rounded to 8 digits, and
the second get rounded to 5? SIN(1)*COS(1) is the same number as .5*sin(2),
but VFP somehow treats the above calculations differently. If I put them in
the watch window, they display the same as what is printed to _screen, with
the same inconsistent rounding. Tag: .fxp is not an object file Tag: 214938
sys(1500)
This is a multi-part message in MIME format.
------=_NextPart_000_0006_01C5A28A.658070B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am just experimenting with this command. On a form with an editbox and =
a commandbutton I have this code in the commandbutton click()
_CLIPTEXT =3D "Hello world"=20
ThisForm.Edit1.SetFocus()
SYS(1500, '_MED_PASTE', '_MEDIT')
thisform.Refresh()
The first time I click the button the edit cursor appears in the edit =
box but nothing else. Thereafter every time I click the commandbutton, =
the phrase appears as expected in the edit box, concatenating with the =
previous paste..
Can somebody explain why it doesn't appear the first time?
Many thanks
Stephen
------=_NextPart_000_0006_01C5A28A.658070B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I am just experimenting with this =
command. On a=20
form with an editbox and a commandbutton I have this code in the =
commandbutton=20
click()</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>_CLIPTEXT =3D "Hello world"=20
<BR>ThisForm.Edit1.SetFocus()<BR>SYS(1500, '_MED_PASTE',=20
'_MEDIT')<BR>thisform.Refresh()</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The first time I click the button the =
edit cursor=20
appears in the edit box but nothing else. Thereafter every time I click =
the=20
commandbutton, the phrase appears as expected in the edit box, =
concatenating=20
with the previous paste..</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Can somebody explain why it doesn't =
appear the=20
first time?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0006_01C5A28A.658070B0-- Tag: .fxp is not an object file Tag: 214931
Append data into excel file
Dear All,
Do anyone know how to append data into excel file from dbf file.
Thanks for any reply or solution
Choi Tag: .fxp is not an object file Tag: 214926
MYSQL Database
Has anyone converted a MySql database to a VFP table? I have a guy who
has his database on MySql and would like me to enter it into a VFP
Database table. I have not looked at it yet so do not know what to
expect. Any ideas??
TonySper Tag: .fxp is not an object file Tag: 214922
won't stay docked
every time I open vfp8 I need to uncheck the dockable on all windows. How do
I make it permanent?
thanks
sherry Tag: .fxp is not an object file Tag: 214918
Using custom PAGE objects in a custome PAGEFRAME
Hi
I have been reading 1001 Things which seems to mainly reference VFP 6.
I am trying to create a base _PAGE class for use in my base _PAGEFRAME class
with some custom methods and properties.
I can't work out how to trick my _PAGEFRAME to use my _PAGE class rather
than the standard VFP Page object.
In 1001 we are told that you cannot visually create a Page object - clearly
this is no longer the case with VFP 9 so can anyone tell me how i can
implement my visual _PAGE object?
--
Kind regards
Phil Hollingworth
phil@wrltd.co.uk
System spec: Win2k3 / VFP 9 (All fully service packed / updated etc) Tag: .fxp is not an object file Tag: 214912
Derfining a color Scheme ?
How can I define a Color scheme at runtime based on the color scheme of
certain control ?
Want to have separate values for Red, Green and Black instead of using a
single color value ? Tag: .fxp is not an object file Tag: 214908
Custom window Color ?
I want to set the color of a window which is to be determined at run time ..
will be picked from the property of a color ? Don't know how to set it up
like this ? Tag: .fxp is not an object file Tag: 214905
Define a Window with Custom Color ?
I want to define a window which should borrow a color from another controls
Back Color Property to be determined at run time ? Not aware how to set it
up ?
Urgent pls help ? Tag: .fxp is not an object file Tag: 214904
SOme strange reason, today I get this when trying to RUN
/ DEBUG a small pgm.
I did not see any help from microsoft's KB articles.
fxp files compiled prg files. Delete the fxp file and recompile your PRG.
Make a copy of these two files first!
<shall@uaex.edu> wrote in message
news:1124810600.544205.212170@g47g2000cwa.googlegroups.com...
> SOme strange reason, today I get this when trying to RUN
> / DEBUG a small pgm.
>
> I did not see any help from microsoft's KB articles.
>
> Suggestions?
>
> Thanks.
> Steve
>
If it is too large, you have to split it. Is it larger than 64K?
<shall@uaex.edu> wrote in message
news:1124822430.568769.307210@z14g2000cwz.googlegroups.com...
> Thanks!!!
> I tried to recompile, then I got the message
> " Program is too large"
>
> After adding a few extra lines of code must have pushed it over the
> top.
> I know what I need to do now.
>
> Thanks.Again
>