mutex, criticalsection, threading issues???
Hi,
I have an app which has as one of its components an activex control which is
constantly processing data from the serial port. I need the event handler
for this code to be able to interrupt anything else I'm doing so that I
don't lose any data.
I also have a timer which I need to run once a second and do some processing
of the data.
I also of course have a form with which the user can interact.
Because of the serial port handler, I have the application autoyield
property set to .f.
My problem arises from the unfortunate need for all three of these "threads"
to access some of the same data structures and objects.
I'm wondering if I can use some of the
Windows control structures such as critical sections mutexes or semaphores
to handle this? In trying to read about them, it seems important that the
various items which are competing for the resource be either in different
threads or different processes (or the WaitForSingleObject() function won't
wait).
Can someone tell me if these components are running in different threads,
and then could someone recommend which of these Windows features might be
best suited to allowing short exclusive use of resources?
thanks for any help,
Chip Tag: including a header file in reports? Tag: 186131
Converting FPW2.6 reports to *.jpg, *.doc, *.xls
Well, I would like to generate my FPW2.6a reports as jpg, doc or xls. I
found frx2any, but it works only for VFP. Any hint? Tag: including a header file in reports? Tag: 186127
Help cannot access program from new xp client
I copied the VFP6r.dll and VFP6rEnu.dll files from the
server onto the XP client folder where a copy of the
setup files was stored. I was able to launch the program
but it does not run. the following error occurs:
Error loading file- record No. 9 Vprostandard form 1 <or
one of it members> Loading form or the data environment:
Connectivity error[MS ODBC drivermanager]
Data source name not found&no default driver specified.
ANY SUGGESTIONS Tag: including a header file in reports? Tag: 186124
Help cannot access program from new xp client
I copied the VFP6r.dll and VFP6rEnu.dll files from the
server onto the XP client folder where a copy of the
setup files was stored. I was able to launch the program
but it does not run. the following error occurs:
Error loading file- record No. 9 Vprostandard form 1 <or
one of it members> Loading form or the data environment:
Connectivity error[MS ODBC drivermanager]
Data source name not found&no default driver specified.
ANY SUGGESTIONS Tag: including a header file in reports? Tag: 186123
ODBC vs. OLEDB
I have posted a comment before stating a problem I was having with VB and
updatebatch method and getting the error "Row Cannot Be Located for
Updating...." I have found that if I use an Update SQL statement instead
though it works fine (to do this though would be a hell of alot of extra
programming). It also used to work before and I think it was the change
from VFP 6 to VFP 7 that brought the error. Anyway, what I'm wondering is,
the VB code uses a DSN ODBC connection to VFP. I'm wondering if I use the
OLEDB connection, would this make any difference? I am also wondering what
the difference between ODBC and OLEDB is. Also I'm wondering if maybe
moving to VFP 8 would fix this problem. Tag: including a header file in reports? Tag: 186118
Unable to release form..
Hi
I use VFP7. I have a top level form and top level menu.
A form is displayed for each meu item. I run a programme
to release the displayed form when another menu item is
chosen.
When a "grid" in the form has the "focus", I am unable to
release the form. I have tried all the commands like
release window, object.release etc.. None works. But there
is no problem with other controls like combo,text boxes
etc..
Please help me ..
Thanks in advance.
Bala
. Tag: including a header file in reports? Tag: 186114
old annoying bug or a feature?
Hi,
In order to validate user's imput, I place in Valid Event
of Textbox some code, wich calls a form for data lookup or
entering new data in related tables. Depending on lookup
results, the focus stays in the Texbox or jumps to other
controls with a help of RETURN n command. This seems to be
very clear and convenient, but...
If in some other form, launched from Valid Event, there is
a SetFocus Method - the error comes: SetFocus method can
not be called within Valid Event.
But SetFocus is called in other form! And what more, in a
way can be several more form calls that has nothind to do
with the first one, but the error comes nevertheless :(
I wonder, if MS will ever fix this annoyance or it is
treated like a feature?
Vitas Tag: including a header file in reports? Tag: 186113
VFP8 Command window - Expression builder
I have recently upgraded from VFP6 to VFP8 (although at
the moment I feel as if I have stepped backwards)and am
not a programmer or developer in any way. XP/SP1 is the OS.
Keyboard macros are much used in my hobby. Could anyone
spare the time and trouble to tell me how to get rid of
the expression builder that pops up as soon as the macro
issues the Locate or Seek command etc. This slows up
things tremendously, especially where the Locate command
is used in Memo fields, by comparison with VFP6.
Searson Tag: including a header file in reports? Tag: 186112
Bug? The InteractiveChange Event in a combobox in a grid cannot be trigged?
I found the InteractiveChange Event in a combobox in a
grid cannot be trigged properly if
1) RowSourceType is 6 and you hold the left button of
a mouse and move to the row you want and release the mouse.
2) RowSourceType is 1 and you click the down arrow
and release the mouse and then move to the row you want
and release the mouse.
RecordSourceType in the grid is the default value 1.
It works if you use method 1) when RowSourceType is 1 or
you use method 2) when RowSourceType is 6.
Any ideas?
TIA Tag: including a header file in reports? Tag: 186111
InstallShield and MSDE
Hya Folks,
I've tried to create a setup via installshield (the free 3.5 Express with
VFP8).
Right now, i've got a big problem with my MSDE2000 merge module. Everything
runs fine with the build of the disk image, but when installing, the setup
stops either with either "not enough free space on drive MSSQL" or "cannot
find drive MSSQL".
Anyone knowing this problem and able to help?
Pierre Tag: including a header file in reports? Tag: 186103
VFP to VC++
I'm wondering if creating interfaces in VC++,populating
list boxes and grids is similar and as easy and as
flexable as VFP.
I'm thinking of developing the same app I developed with
VFP in VC++ so I can say I did it in VC++ as well.
Are the VC++ controls similar to VFP controls with
methods and properties etc. Are classes just as easy to
work with?
Thanks in advance Tag: including a header file in reports? Tag: 186095
Controler Print
hi, everybody.
Please, i need controler the number is send to print in
XP?.
for example, in the morning i send to one print but this
print is with two paper.
I need registration in my database the number of
impresion and the number of pages.
But this impresion no is only the vfp, is also send word,
excel, or other program.
Thanks my friend. Tag: including a header file in reports? Tag: 186087
Can't print from memo field in VFP 5.0a
I have a little application I created for someone which is simplicity
itself. One screen, one table with two fields - a character field and
a memo field. The screen has 3 buttons:
Search
New
Exit
Problem is, although Print is enabled on the File menu when viewing
the memo field, executing the Print function does not activate the
printer! Is there a way I can fix this?
The application was originally created in FPW 2.6a and converted in
VFP 5.0a and otherwise seems to run OK.
Thanks for any help!
Dan Tag: including a header file in reports? Tag: 186083
FPW 2.6a, closing DOS window after RUN command
Hello,
I'm running a batch file from FPW with the RUN command. I have the
"Close program on exit" option enabled in foxrun.pif but the DOS window
stays on the screen if I use RUN /N. It disappears with just RUN - I
actually want to use just RUN but for some unknown reason that produces "RUN
/ ! command failed". RUN /N works fine except for this window being left
behind..
Any ideas?
Maybe shellexecute API call would fix this but I've no idea [not entirely
true but for the purposes of explaining I have no idea..] how to call this
function from FPW2.6
--
TIA
Andrew Howell Tag: including a header file in reports? Tag: 186069
foxprow2.6a exe
Hello
Could anyone please send me or give a link to where I could download patched
files of foxprow 2.6a so than could run in XP.
I downloaded patches themselves but they state the file is not the right
size, internation patch does not work either.
After playing with them, I do not have 'divide by zero' message anymore, but
fox crashes after 'invalid path or filename' message.
I do not have any installation disk anymore so I cannot follow the official
patching procedure.
Maybe I could download installation kit form somewhere?
Best regards and thanks for any help,
Piotr Tag: including a header file in reports? Tag: 186065
cursoradaptor and updategrams when using XML
Hullo,
I'm trying to get a cursoradaptor, which has retrieved its data via xml, to
generate an xml updategram from updates made to its attached cursor.
I've followed all the instructions that VFP's help lists (I think) but
cursoradaptor.updategram remains empty.
Does anyone know of sample code or other documentation relating to
cursoradaptors using xml and producing updategrams?
Thanks.
Yours faithfully
Paul S. Elliott
(Senior Developer)
4technology Ltd
P.O. Box 1681
Christchurch
New Zealand
ph : +64 3 3771170
fax : +64 3 3771172 Tag: including a header file in reports? Tag: 186062
Error when trying to open class
This one is driving me nutty. The problem cropped up when I tried to MODI
CLASS on one of the classes in a VCX. VFP says "Error loading file - record
number 73. lblReplaces <or one of its members>. Parent: Not a table". I
tried deleting record 73. Same error. I packed the VCX. Same error on record
73, but now it reported the object as a grid object (the one that used to be
record 74 before the pack).
I use Cryptor for encryption of the data in this app and I get a "Not a
table" error if I forget to load Cryptor and register the data files, so I
thought it was something related to the encryption (though I had the library
loaded and set up properly). So I decrypted all the data even though VFP
shouldn't be attempting to open the tables when it opens this class.
Unfortunately, that did not do the trick.
I've checked out the label base class that record 73 is based on and it
seems fine as do all of my other base classes. I'm checking the VCX for
corruption, but so far I haven't turned up anything. Anybody seen this
before. This happens under VFP 7 SP 1 and VFP 8 SP 1.
Thanks,
Russell Campbell Tag: including a header file in reports? Tag: 186055
'System.InvalidOperationException
When using OleDbDataAdapter.Fill method to transfer the
table from the fox .dbf file to the DataSet, I get the
following error, I don't have a clue what could cause
this error.
An unhandled exception of
type 'System.InvalidOperationException' occurred in
system.data.dll
Additional information: The provider could not determine
the Decimal value. For example, the row was just created,
the default for the Decimal column was not available, and
the consumer had not yet set a new Decimal value. Tag: including a header file in reports? Tag: 186054
Must be an easy way to do this...
Given that Adobe Acrobat 5 is installed on the PC running
my VFP 6 SP5 application, and given that there is a specific
PDF file sitting somewhere on the PC's hard drive, I want
to gracefully print a hard copy of that PDF to the current
Windows printer.
I have looked through the Acrobat SDK and see the DDE calls
such as FilePrintSilent but have only been able to use this
by first starting up Acrobat *Reader*, establishing the DDE
connection to it, then printing the desired PDF. This is very
clunky and visually ugly with Reader popping up. I am
extensively using Acrobat itself through OLE automation which
is completely invisible to the user, but I see no way to use
an Acrobat OLE object
to print a hard copy of a specific PDF file. You can print
a PDF file within the Acrobat application itself, but not
via OLE? Seems odd. Has anyone had success with printing
a hard copy of a PDF file invisibly from within VFP? Perhaps
a third-party tool?
-- TRW
_______________________________________
My e-mail: t r w 7
@ i x . n e t c o m . c o m
_______________________________________ Tag: including a header file in reports? Tag: 186050
Finding the last record in a table
How would you go about locating the last of one or many records for an
account in a table.
The table can have just one or many and the account identifier is in a memo
field.
The format of the account number is easy enough to find in that it will have
the syntax, for example:
account = 12345.00
I'm assuming I should create a logical field called last that I can then
populate with .t. for last.
I can open the table twice, scan (for not reviewed-explained later) , flag
as last upon finding a perform a loca for the field in the second, with a
continue. I can also create a reviewed field that will be set to .t. after
either being hit in the scan, or located.
That's as far as I get with it.
--
Thank you,
Louis Tag: including a header file in reports? Tag: 186046
Exchange 2000 public folders access problem
Hi all,
I write this,
**--------------------------------------------------------------------
oOutlook = CreateObject("Outlook.Application")
oNameSpace = oOutlook.GetNameSpace("MAPI")
oCNoDeseado = oNameSpace.Folders("Carpetas públicas").Folders("Todas las
carpetas públicas").Folders("Correo no deseado")
_ClipText = ''
FOR lnumX = 1 TO oCNoDeseado.Items.Count
oItem = oCNoDeseado.Items(lnumX)
FOR lnumY = 1 TO oItem.ReplyRecipients.Count
oItemP = oItem.ReplyRecipients.Item(lnumY)
IF lnumY = 1 THEN
_ClipText = _ClipText + TEXTMERGE("<<lnumY>>, ")
ELSE
_ClipText = _ClipText + ', '
ENDIF
_ClipText = _ClipText + OItemp.Address + CHR(13)
ENDFOR
ENDFOR
KEYBOARD '{CTRL+V}'
MODIFY COMMAND
**--------------------------------------------------------------------
The result for this commands is like this:
1 Charlene Cope, l98kuewp@hotmail.com
4 Holiday Gifts, opuvavmnogtvp@pgqexeikn.dealofalifetime.net
8 Breast Booster, Info11ljtnodjb@breastbooster.com
10 Franquicia Internacional, catterine@international.com
11 Franquicia Internacional, catterine@international.com
13 Tapia, zixwqusgmxkro@hongkong.com
15 Adeline Bryson, j74qatmcdh@yahoo.com
Wath I need:
I need the list of address of email sender, stored in a public folder.
Questions:
- Why the items (2,3,5,6,7,9,12,14) report oItem.ReplyRecipients.Count = 0
- There is another way to access the field from (This don't appear in the
properties list)
- How Outlook show this field and I don't access?
Thank's a lot.
Mauricio Mesa G. Tag: including a header file in reports? Tag: 186042
COM information in DLL
Installshield is complaining a little when creating setup files.
How do I place COM information in the files to avoid this?
** Warning: -4354: The build was unable to extract COM information from the
file N:\foxn\rmlbiz.dll in component rmlbiz.dll. Please ensure that the file
is self-registering and verify that the self-registration process does not
fail.
** Warning: -4354: The build was unable to extract COM information from the
file N:\foxn\rmldata.dll in component rmldata.dll. Please ensure that the
file is self-registering and verify that the self-registration process does
not fail.
** Warning: -4354: The build was unable to extract COM information from the
file N:\foxn\rmlexe.exe in component rmlexe.exe. Please ensure that the file
is self-registering and verify that the self-registration process does not
fail. Tag: including a header file in reports? Tag: 186036
dimension array as object
In Visual Basic, you can do something like this:
type MyType
var1 as string
var2 as integer
end type
dim MyVar(20) as MyType
I'm trying to do something similar in FoxPro. It seems like you
should be able to use CreateObject('Empty'), then add the properties
to it you want, then dimension an array of the object like. Something
like this:
MyType = CREATEOBJECT("EMPTY")
ADDPROPERTY(MyType,"Var1","")
ADDPROPERTY(MyType,"Var2","")
DIMENSION MyVar(20) as MyType
However, this doesn't dimension MyVar as MyType. It dimensions it the
same as if you didn't use "as MyType".
Is there any way to dimension an array as an object like I want to do?
Kevin Clark
Seton Home Study School Tag: including a header file in reports? Tag: 186029
Capture data from printer port
I have a dedicated PC running in MSDOS 6.22 with a customised software (I
think it was written in C laugauge) that control a machine through interface
cards. While the machine is operating, the software will print report of
data to the printer port attached with a Epson Dot matrix printer.
Is there a way that I can tap the output data from the printer port
(parallel port) to another PC as a ASCII text file? My purpose is to make
use of the output text file to import into foxpro so that I can manipulate
the data using foxpro.
Anyone has any idea? Please help.
Thanks Tag: including a header file in reports? Tag: 186015
How can operate such low-level file in vfp?
Hi,everyone,
The attachment file was not created by vfp, I want to create and operate
such file in vfp. I can't create it in vfp by fcreate & fwrite function,
also I can't read the right information from the attached file by fread. The
attached file includes two continuous digits: 0000000001 and 0005183372,
you can see it by debug. Anyone can give me ideas?
thks in advance?
chuen
begin 666 m.t
+J@`````!``48,W(`
`
end Tag: including a header file in reports? Tag: 186010
Cannot Locate VFP Support Library in Windows XP
Hi,
I created a VFP application along with the run time file and distributed to
a client who is running Win XP.
After they install the application, when they login as Administrator to that
computer, they can run the app without a problem. But when they login as a
restricted user they are getting an error saying "Cannot locate Microsoft
Visual Foxpro Support Library"
Any ideas?
Best Regards,
Y. Sivaram Tag: including a header file in reports? Tag: 186003
Foxpro freezes up
I developed a vfp 6.0 application that previews a report
to the screen and that works fine. However, when I close
the report and open a new form, the tool bar across the
bottom, seems to work fine until I press the 'FIND'
button. The system locks up without any recovery except
to restart the computer.
I am have a windows 98 OS with 128 meg Ram.
Question: How do I clear the report form from memory? I
have read all the help articles, including release, close
all, etc. I am relatively new to vfp programming, so I am
hopeful someone will give me the information I need.
Any suggestions would be most appreciated..
Thanks Tag: including a header file in reports? Tag: 186002
Automatic adaptation to different screenresolutions
Hi all!
I´m struggling with my code for automatic adaptation to different
screenresolutions. Can someone give me a hint about what is wrong. An
editbox does not keep its proportional placing when changing the
screenresolution.
I have made it simple for you, just copy and paste as below.
Any help would be very appreciated.
Regards
Christina
Give an empty form
- two propertys (pyHeightratio and pyWidthratio)
- a methode (mdResizecontrols)
* COPY THE CODE BELOW INTO THE FORMS INIT:
* the form itself
this.Width = 400
this.height = 200
* the bottompageframe
WITH This
.addobject('bottomPgFr','pageframe')
.bottomPgFr.top = 0
.bottomPgFr.height = this.height
.bottomPgFr.width = this.width
.bottomPgFr.pagecount = 2
ENDWITH
* the toppageframe inside the bottompageframe´s page 1
WITH This.bottomPgFr.page1
.addobject('topPgFr','pageframe')
.topPgFr.top = 0
.topPgFr.height = This.bottomPgFr.pageheight
.topPgFr.width = This.bottomPgFr.width
.topPgFr.pagecount = 2
ENDWITH
* an editbox inside the toppageframe´s page 1
WITH This.bottomPgFr.page1.topPgFr
.page1.addobject('edtNote','Editbox')
.page1.edtNote.height = 70
.page1.edtNote.width = .Width/2
.page1.edtNote.left = .Width/2
.page1.edtNote.top = .pageheight - .page1.edtNote.height
ENDWITH
* make all added objects visible
WITH This.bottomPgFr
.visible = .T.
.page1.topPgFr.visible = .T.
.page1.topPgFr.page1.edtNote.visible = .T.
ENDWITH
* code for different screenresolutions (form designed in 800x600)
this.pyHeightRatio = SYSMETRIC( 2 ) / 600
this.pyWidthRatio = SYSMETRIC( 1 ) / 800
this.height = this.height * this.pyHeightRatio
this.width = this.width * this.pywidthRatio
LOCAL loControl
FOR EACH loControl IN Thisform.Controls
Thisform.mdResizeControls(loControl)
ENDFOR
* COPY THE CODE BELOW INTO THE FORMS METHODE MDRESIZECONTROLS:
LPARAMETERS toControl
LOCAL loPage, loControl
IF PEMSTATUS( toControl, 'Width', 5 )
toControl.Width = toControl.Width * Thisform.pyWidthRatio
ENDIF
IF PEMSTATUS( toControl, 'Height', 5 )
toControl.Height = toControl.Height * Thisform.pyHeightRatio
ENDIF
IF PEMSTATUS( toControl, 'Top', 5 )
toControl.Top = toControl.Top * Thisform.pyHeightRatio
ENDIF
IF PEMSTATUS( toControl, 'Left', 5 )
toControl.Left = toControl.Left * Thisform.pyHeightRatio
ENDIF
IF PEMSTATUS( toControl, 'Fontsize', 5 )
toControl.Fontsize = INT( toControl.FontSize * Thisform.pyWidthRatio )
ENDIF
DO CASE
CASE ALLTRIM(UPPER( toControl.BaseClass )) == 'PAGEFRAME'
FOR EACH loPage IN toControl.Pages
Thisform.mdResizeControls( loPage )
ENDFOR
CASE ALLTRIM(UPPER( toControl.BaseClass )) == 'PAGE'
FOR EACH loControl IN toControl.Controls
Thisform.mdResizeControls( loControl )
ENDFOR
ENDCASE
** PS
** Gregory I know you have solved this before but the solution is gone - a
disccrash
** DS Tag: including a header file in reports? Tag: 186000
pccharge VS icverify question
Hi Everyone;
I hope this question is OK for this newsgroup. Does
anyone have any experience/comments about either pccharge
or icverify SDK for credit card integration. We have a
test client since March using PCCharge payment server
integrated with their SDK. Integration was quite easy
with their activeX control but every day the client gets
one to two communication errors (not captured - connect
failure). There old POS system was flawless for 10 years.
We have tried everything under the sun but this seems to
be a random error. Has anyone else experienced this with
either PCCharge or ICVerify. I am thinking of switching
to ICVerify but am hesitant to try another product. Any
input would be appreciated
TIA
Mike Tag: including a header file in reports? Tag: 185998
Kill the program
Hi fellow coders:
I want the program to quit completely if there is an
error when the user clicks on save button at the time of
the error. I have an on error routine that intercepts
the error with error info. I know I can code error
handling, however I want to program to be killed in the
error rountine - no questions asked for now until I get
the time to do the error handling for buffered table
conflicts.
I do issue a 'QUIT' in the error routine.
When there is an error it does call the error routine,
then it returns to the saves button on click method and
continues with the program code and then quits.
I want the program to be killed immediately in the error
routine.
How is this done or wher hav I gone wrong?
Thanks in advance.
I have an on error routine that is called etc... Tag: including a header file in reports? Tag: 185994
Finding Memory Problems
Hi all,
I'm trying to clean up memory problems in a somewhat involved app and
looking for ways of measuring the problems. Can anyone point to maybe a
white paper on finding and addressing such things?
So far I've just put statements in various areas of the code that write a
record to a table indicating the current memory usage (as told by SYS(1016))
at that point. This seems to be a pretty ineffective--at least at
diagnosing a technique that might cause the problem. For example, I found
one interval that consistently increased in memory usage by around 2600
bytes most times it executed (a few thousand). Trying to recreate the
problem in an isolated setting, I put
together a small prg that just did those same steps in a loop. In this
case, though, the memory change was 0.
I've tried adding SYS(1104) in varying locations/timings in the program, but
no change to speak of occurs in any case. I had some suspicion that
printing was causing it but have found little to back this (at least not
with SYS(1016)) and I am somewhat restricted in my driver options.
Next up is tweaking memory w/ SYS(3050), but that still will only extend the
time before running out of memory. Are there better ways of pinpointing
where memory leaks occur w/in an app or are these pretty much all we have?
Even like shell commands?
TIA,
John Tag: including a header file in reports? Tag: 185986
Foxpro running under Windows 2000 Server Sp4
Users are not happy with the slow response they are
getting from a new server install of Windows 2000 running
FoxPro 2.5, 2.6 and FoxPro for windows. The system was
running on a Windows 3.51 server that was upgraded to 4.0
and now, the server need to be retired and the application
needs to run under windows 2000 any help on performance
increase would be great. Tag: including a header file in reports? Tag: 185982
VFP80 - Header Backcolor
Can anybody tell me why these commands are not working? All I am trying to
do is change the backcolor of the grid headers. Thank you in advance.
THISFORM.grdAccounts.Column1.Header1.BackColor = 255
THISFORM.grdAccounts.Column2.Header1.BackColor = 65535
THISFORM.grdAccounts.Column3.Header1.BackColor = 32768 Tag: including a header file in reports? Tag: 185971
vfp 8.0 menu error
i have a Visual FoxPro 8.0 app that works perfectly on
computer 1. i copied the source code to a second pc and
now I am getting errors like this "procedure _2b231j80 not
found" when clicking on menu choices. searching for this
procedure i found it in the menu files.
so i copied over new versions of the menu files - mnx,
mpr, etc - recompiled everything and it worked fine for a
bit. but now the errors have started again. help!
nancy Tag: including a header file in reports? Tag: 185968
Authentication
Hi,
i would like to know if it is possible to implement
,with a foxpro application, a authentication
against:
windows nt/2000 or
openldap server or
novell nds
if im on the wrong list please excuse me and do point me
to the correct list,
thanks in advance
sake. Tag: including a header file in reports? Tag: 185965
CLOSE DATABASE
I HAD USE THE DATABASE, AND THEN USE 'CLOSE DATABASE " TO CLOSE IT.
HOWEVER, THERE IS STILL AN ERROR SAID 'FILE IN USE'
I NEED TO QUIT THE EXE FILE, AND THEN RUN IT AGAIN .
PLESASE HELP.
--
Thanks For Your kind Attention.
Best Regards,
Miss. Agnes Cheng
Dynamic Tech Consultants Ltd. Tag: including a header file in reports? Tag: 185952
class icon not appearing
I have specified a toolbar icon and a container icon on my class but it is
not showing in the project manager. Any ideas ? Tag: including a header file in reports? Tag: 185949
cursortoxml() and chr(13) in memos
Hullo,
I have a table with a memo field that contains, amongst other things,
occurances of chr(10) and chr(13) .
If I convert this to an XML string using CursorToXML() and then convert it
back to a table using XMLToCursor() then all occurances of chr(13) are
stripped from the memo.
I've used the various flag settings for the two functions but the chr(13)'s
are always stripped.
How can I keep the carriage returns?
Thanks in advance.
Yours faithfully
Paul S. Elliott
(Senior Developer)
4technology Ltd
P.O. Box 1681
Christchurch
New Zealand
ph : +64 3 3771170
fax : +64 3 3771172 Tag: including a header file in reports? Tag: 185948
Suppressing PDF Writer screen output
VFP 6 SP5 on WinXP Pro
I do some PDF production in one of my VFP apps. I have no
problems getting the app to use the PDF Writer printer without
involving the user (using the registry setting trick). One of
my routines customizes a Word file via OLE automation, then
prints the result to a PDF. I'd like to suppress the little
dialog that pops up while it is printing this Word
doc. The one that says "Printing" at the top and shows a count
of the pages being printed. I use the Windows LockWindowUpdate
API call at other times to hide UI changes, but this does
not work in this case. I assume this is because Word is the
application originating the PDF Writer activity.
Does anyone know of another way to suppress this little dialog
in a situation like this?
-- TRW
_______________________________________
My e-mail: t r w 7
@ i x . n e t c o m . c o m
_______________________________________ Tag: including a header file in reports? Tag: 185940
OT: Creating a .lnk file
Hi all,
Sorry, this is tangentally VFP related at best. I'm trying to figure out
how to programatically drop a shortcut to a vfp executable into the startup
programs. The format of such a file seems to escape me, but looks more like
a table header than a text file. Has anyone done this?
TIA,
John Tag: including a header file in reports? Tag: 185937
INSERT during transaction - trigger failed
This used to work, so I'm not sure what I did to screw it up (might have
something to do with my SET EXCLUSIVE setting), but here's what's
happening:
I have two tables: USERS and USERPROMOS. The primary key of USERS,
userid, is also a foreign key in USERPROMOS. The relational integrity
procedures are set to stop inserts into UP without a corresponding userid
in U.
When I get a batch of records to import in, I get the record from my
input file using a SCATTER NAME, INSERT the record into U, then go to UP
and insert a record there, too, referencing Users->Userid as the userid
for the new record in UP. Like so:
SELECT _INCOMING
BEGIN TRANSACTION
ON ERROR DO "Err_CannotAddRec"
DO WHILE !EOF()
SCATTER NAME oRec
WITH oRec
* Add record to USERS
INSERT INTO Users (...a bunch of fields...);
VALUES (...a bunch of values...)
* Add record to UserPromos
INSERT INTO UserPromos (userid, initcontact) ;
VALUES (Users->UserID, DATE())
ENDWITH
oRec = NULL
SKIP
ENDDO
END TRANSACTION
The problem I'm having right now is that the second INSERT is failing in
the INSERT trigger. It goes and opens up the USERS table in a new
workarea and SEEKs the userid to verify it's there. For some reason,
though, it's NOT there. If I go over and look at the USERS workarea, it
IS there, but it doesn't come into the area where the RI procedure opened
it up using USE USERS AGAIN.
I'm thinking it's my transaction. If I go and do an END TRANSACTION when
the program stops at the second insert, then retry that insert, it works
because the new instance of USERS actually does find the new userid.
Problem is, I'm not willing to dispense with the transaction in my code.
I can't risk something screwing up during the import because a partial
import would be real problematic.
Could I solve this with some kind of buffering change, or anything like
that? Another idea I had was to separate the two inserts into two
separate loops, with a TRANS surrounding each of the loops. That's a
pain, though, thanks to having to locate the new userid's.
TIA for any help.
--
Michael Kellogg
CC3 West DP Programming
Running VFP 6-SP4 Tag: including a header file in reports? Tag: 185934
FORMS FREEZE UP
When I run my applicatioon and preview a report, which
works fine (and I shut it down), when I open another form
in my application, the toolbar features all work except
the 'FIND' button. When I press this button, my system
freezes up..
I am running vfp 6.0 on a windows 98 OS with 128 meg of
ram.
I am relatively new to vfp, but any assistance would be
greatly appreciated. I have read all the help screeens
that I believe will solve my challenge, but I still need
help.
Suggestions ?
Thanks Tag: including a header file in reports? Tag: 185931
Migrating from FoxPro 2.6 to FoxPro 8.0
We have an old FoxPro 2.6 app which runs on Win 95/98/ME printing to a CITOH
5000 impact printer using a TTY driver. These machines are to be replaced
with WinXP which seems to have dropped support for TTY. When we use the
native Windows driver some rows are shifted to the right by a few
characters.
Is doing a migration to VFP 8 the best solution to this issue? I have
access to the source and my first attempt ended with an error:
Fatal Error in Converter:
Error: Alias name is already in use.
Error Number: 24
Method: openfile
Offending Code: USE ...
File being processed: basw110.scx
I'm quite familiar with other IDE's (VB, PowerBuilder, .NET) and databases
(SQL Server, Oracle, Access) but haven't used FoxPro before. Program
functionality hasn't changed in years so we're not looking to do any coding
changes.
--
Neil Negandhi
negandhi@vex.net Tag: including a header file in reports? Tag: 185929
Pull down menu question
How do I change disabled menu items in the pull down
menus.
Thanks in advance Tag: including a header file in reports? Tag: 185928
How to refresh a remote view
I've setup a remote view to a MySQL database. It refreshes fine if I reopen
the database, but how do I force a refresh when the database is open? Using
VFP7.
Thanks for any help,
Neil Tag: including a header file in reports? Tag: 185927
A fox in the bookstore !!!
Nop, couldn't find one :-(
Last night I went to the bookstore and there was not a single copy of a =
fox related book
I remember the times when there were two or three at the most, good ol' =
times.
Plenty of python, ruby, php and other not-so-known languages are now =
filling the shelves.
The fox is dead, long live the fox! Tag: including a header file in reports? Tag: 185912
Suppress Fatal Error dialog box in Visual Foxpro 8
In a compiled VFP8 program I have experienced a fatal error.
I'm less concerned about the error than in the user
prompt. I want the application to close without
throwing up a prompt. I believe this behaviour started in VFP version 7 or
8.
Is there an environment setting that can be set to modify this.
The exact error message is
Fatal error: Exception code=C0000005 @ 11/21/2003 02:19:40
PM. Error log file: E:\Omreport\VFP8Rerr.log
Called from - companionsproc line 871
{E:\Omreport\omreport.prg e:\omreport\omreport.exe}
Called from - omreport line 30
{E:\Omreport\omreport.prg e:\omreport\omreport.exe}
The offending line is:
if sqlexec(cadhandle, m.cirssql, "compcirs") < 1
A connection was made and then a network outage occurred
which caused the error during the SQLEXEC.
----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
NewsOne.Net prohibits users from posting spam. If this or other posts
made through NewsOne.Net violate posting guidelines, email abuse@newsone.net Tag: including a header file in reports? Tag: 185911
header file
I have several forms that I invoke using programs similar
to this:
#include "c:\business\mess.h"
helpeditor = SYS(2015)
PUBLIC &helpeditor
&helpeditor = CREATEOBJECT("helpform")
tmp = &helpeditor
tmp.SHOW
return
DEFINE CLASS helpform AS helpfrm
All class definitions have their include file set
to "c:business\mess.h".
There are a few constants in mess.h that define paths to
tables. Unfortunately, if I change these pats to point to
dummy tables and recompile, the program ignores the
changes and still uses the real tables.
If I instead, 'touch' the program file and recompile, it
works. Despite that it appears to be recompiling all
files, the compiler seems to be ignoring changes in mess.h.
Any suggestions? Tag: including a header file in reports? Tag: 185910
retrieve file compiled in exe ?
Hi,
I have some default_ini_files (.ini) that I include in myproject.
but the user can override these default values with
his own one so first on startup I want to copy those default_ini_file to
there
local drive if that file doesn't exist and then collect the values.
So how can I copy those files that are included in the exe to the same place
as the exe.
christophe
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º Tag: including a header file in reports? Tag: 185906
"Zakaria al Azhar" <abracadabra@hocuspocus.com> wrote in message
news:eFeKSVftDHA.2880@tk2msftngp13.phx.gbl...
> Hi all,
>
> Is there a way to use header files for reports?
>
> Help would be appreciated.
>
> Greetings,
> Zakaria al Azhar
>
>