Prompting before closing project window?
Is it possible to have VFP9 confirm that you want to close the project
window?
Reason: Using SourceSafe takes about 5 minutes to load my project
window up, and when I mistakenly close the project window, it's quite
annoying having to wait for it to come up again. Tag: Keybord Tag: 218541
long wait for "attempt to lock ..."
This is a multi-part message in MIME format.
------=_NextPart_000_002E_01C5F140.B7C41890
Content-Type: text/plain;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable
Hi,
Sometime my VFP exe happens in network environment "attempt to lock ..." =
and users have to wait long. I usually code this way , eg :-
sele 0
use dbf1 index dbf1
set order to tag tag1
seek cVar
do while !eof() .and. ref=3DcVar
if ...
replace ...
endif
skip
enddo
use
I never apply any USE .. EXCL nor RLOCK()/FLOCK().
How suppose I code to allow all dbfs in sharing mode by many users and =
avoid this annoying locking message ?
Regards
Hoe
------=_NextPart_000_002E_01C5F140.B7C41890
Content-Type: text/html;
charset="windows-874"
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=3Dwindows-874">
<META content=3D"MSHTML 6.00.2900.2668" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Sometime my VFP exe happens in =
network=20
environment "attempt to lock ..." and users have to wait long. I usually =
code=20
this way , eg :-</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>sele 0</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>use dbf1 index dbf1</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>set order to tag tag1</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>seek cVar</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>do while !eof() .and. =
ref=3DcVar</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> if ...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> replace =
...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> endif</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> skip</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>enddo</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>use</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I never apply any USE .. EXCL nor=20
RLOCK()/FLOCK().</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>How suppose I code =
to allow all dbfs=20
in sharing mode by many users and avoid this annoying locking message=20
?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV></BODY></HTML>
------=_NextPart_000_002E_01C5F140.B7C41890-- Tag: Keybord Tag: 218533
Database Corrupt ( please help)
my client PC had been infected with virus and when he/she using the visual
foxpro application,
the PC always hang , now the database seems corrupt and need to be indexed.
Does any msdn web site talking about database index problem when PC hangs ?
I need to show some supporting to my client/
thanks in advance Tag: Keybord Tag: 218531
Carriage return in Edit Box
I want to put a string into edit box ( I am a boy. I live in China)
becomes,
I am a boy
I live in China
Does anyone know the carriage return ??
Thanks a lot Tag: Keybord Tag: 218522
"USE" commands in Visual Foxpro
Hi All,
This is Sam. I'm new to Visual Foxpro.
I'm now having troubles about sharing .exe file and seeking for any
professional help from all of you.
I have developed a system and now expecting to share my compiled .exe
file(inventory.exe) to other computers.
My system are placed in computer "A" and logon to it, and using B computer
to try access into same system in "A" computer.
It generated an error message "Invalid operation of reading files". The
system was closed after hit "cancel".
I debugged and found an error message was from using the word "USE".
I often use "select 1" (workarea) and "use sysid"(open table "sysid").
I already placed the command "SET EXCLUSIVE OFF" in Main Program and the
first command of each form designer "init()".
I had also tried "use sysid shared" it still doesn't work.
So what's wrong with my program?
Please help,
Many thanks,
Sam. Tag: Keybord Tag: 218519
How can I know if a table is in use by another user
Hello:
I have a project when I share tables with some users. But, I don´t know
how can I be sure if a table is in use or not.
I open tables EXCLUSIVE and when a user is using them, FoxPro says an
error, but I want to avoid this error.
Someone can help me?
Regards in advance
--
rod_esq
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------ Tag: Keybord Tag: 218517
iSeries Connection
I need to talk to an iSeries and have setup an ODBC connection and
connect in the following way: ConnHandle =
SQLStringConnect('DSN=iSeriesODBC;UID=&myUserID;PWD=&myPassword')
While this does work well 99% of the time, once in a while I see the
iSeries Logon Screen and once this screen appears I can only kill the
foxpro application. There is a Cancel button on the iSeries screen,
but it never works. The iSeries ODBC is setup with a specific UserID
and to never prompt for SQLConnect. Is there any way to trap for this
situation and not have to tell users to kill the application.
Anyone have any ideas on why this happens??
Thanks for your assistance Tag: Keybord Tag: 218516
ComboBox in a Grid - Using selstart will not work - Help??
Hey All,
I have a combobox that has the following code in the KEYPRESS method.
This code will functionally highlight and give you quick searching
(Typeahead) on your combobox items as you type. The only problem is
when I put it in a grid, I can no longer use .SelStart because it and
.SelLength are always set to 0. Any idea of why a grid would behave
different than a form? Any workarounds for this? I am simply trying
to do "typeahead" within a combobox and a grid. If someone has some
other code which works in a combobox, I would be happy to use that
too!!
Any help would be appreciated.
Thanks,
Sean
********************************************************************************************
*Combobox Example Code:
********************************************************************************************
Rowsource: one,two,three,four,five,six,seven (example data)
*//*KEYPRESS METHOD:
LPARAMETERS nKeyCode, nShiftAltCtrl
WITH THIS
IF nKeyCode = 127 and .SELLENGTH = 0 AND .SELSTART = 0
NODEFAULT
RETURN
ENDIF
ENDWITH
if between(nKeyCode, 32, 122)
for x = 1 to this.ListCount
if upper(subs(this.list(x), 1, this.selstart+ 1)) = ;
upper(subs(this.text, 1, this.selstart)+chr(nKeyCode))
nCurPos = this.selstart + 1
this.Value = this.list(x)
this.DisplayValue = this.list(x)
this.SelStart = nCurPos
if len(allt(this.list(x))) - nCurPos > 0
this.SelLength = len(allt(this.list(x))) - nCurPos
endif
nodefault
exit
endif
next x
endif
********************************************************************************************
*Combobox END OF Example Code:
********************************************************************************************
What is so strange is that if I add this control into a grid, it will
not select any more as I type unless I turn SPARSE to .T., but then I
cannot see the data anymore. HELP??? Tag: Keybord Tag: 218503
Future of VFP (yet again)
I have had a potential client raise the issue of VFP's future. He says
he has heard that it won't be supported past 2009, etc.
I have been working with Fox since Foxbase, and hope to continue
working with it forever. I wonder if I could get some developers and
Microsoft people to chime in with the best and most convincing reasons
that this should not be a concern to this potential client.
Joshua Rubin Tag: Keybord Tag: 218502
Question for someone who has Visual Studio 6
I have been using VisualFoxpro 6 with VisualStudio 6 for years. I need to
install everything on a new computer. In my CDs I have 2 disks for
VisualStudio 6 Library and 4 disks for Visual Studio 6.0 Plus Pack. Also,
there is VisualStudio 6.0 SP3. I am quite sure there is supposed to be 2
more disks for Visual Studio 6 itself, but I can't seem to locate them .
Can someone verify whether there are supposed to be 2 more disks and if so,
what is the number of the CD SET which identifies them (I think I will need
that number in order to try to purchase them from Microsoft).
Thanks for any help you can offer.
-E. Myron
--
To reply, change "invalid" to "net" Tag: Keybord Tag: 218493
Image control
I am using the image control to show drawings in a form. So far it works
fine.
If the picture is bigger than the form scrollbars appear and the drawings
can be viewed by using the scroll bars, ... hmmm .. also fine.
Anyhow, I would like to provide a hand icon to move the drawing around and
not the scrollbars.
Any idea how to do this?
Thanks
Wolfgang Tag: Keybord Tag: 218488
Thank you!!
i might not ever get to meet any of you, but i wish to say Thank you!!
without your help i might still be trudging in the mud. i want to let all
those know who have helped this rookie out in the past....THANK YOU. you
knowldge sharing is greatly appreceiated. i hope some day i can help others
the way you all have responded to my calls.
From my family to all of yours...Happy Thanksgiving.
Tom Tag: Keybord Tag: 218487
Email Body Message
Do i have any options when i create emails in VFP for outlook.. or do i just
have to use Text with no options for Color fonts or the like. Tag: Keybord Tag: 218480
The .exe load but the form disappear after a second
Hi, i'm using VFP7.0 and i made a program that works fine but when i build
the exe file and execute it in the same pc, the form load and shows data in
the grids also but disappear after a second and shows no error or warning.
Please if somebody knows what is happening. Tag: Keybord Tag: 218476
Buffer Overrun in VC++ using VFP9
Every so often I get a a dialogue displaying a message stating:
Buffer Overrun Detected!
Program: c:\ASM GeMS\Sapphire.exe
A buffer overrun has been detected which has corrupted the program's
internal state. The program cannot safely continue execution and must
now be terminated.
The application, Sapphire.exe was originally written in VFP8 and was
upgraded. It will run quite happily for several weeks and then, when it is
started up sometimes throws the above error. Does anyone have any
suggestions on how to go about debugging this? I notice that SP 1 contains
changes that prevent this error with large Scan loops but there is no such
construct in this application.
The environment is Windows 2000 Server SP4 with latest hotfix. The machine
has 512 MB of RAM and a 2.4 GHz processor.
This never occurred when the app was in VFP8. Nothing has changed other than
a recompile. Leaving the application in VFP 8 is not a viable option due to
company support policies.
TIA
John Tag: Keybord Tag: 218475
MsMapi and html
Hi,
I'm using MsMapi to retrieve messages.
but how can I know when a received messagebody is a html text ?
regards
thanks in advance
christophe
--
\|||/
(o o)
----ooO-(_)-Ooo------------- Tag: Keybord Tag: 218474
New table --> HELP FAST!!!
When I run the following statement in FoxPro (versions 6.0 and 8.0), it
creates a new table. The new table cannot be opened using Excel and a
couple other DBF viewers. If you view the DBF file in a text viewer, the
header looks corrupted.
SELECT * from tableName.dbf INTO TABLE test.dbf
Any help with this issue is appreciated.
Thanks
KT Tag: Keybord Tag: 218453
Progress Bar Help.
this is my first attempt at this, i have it working somewhat but ive still
screwed it up. i have taken the advice of a few folks and put that together.
the bar now acts like a crazed dog..and my loop does not complete or grab the
data i need. Please advise this rookie on his mistakes.
Code Below
PUBLIC othermometer
othermometer = CreateObject('thermometer')
othermometer.Visible = .T.
i=0
SET CONSOLE OFF
DO WHILE i<100
WAIT TIMEOUT 1 && Place application-specific code here
othermometer.update(i)
set century on
set deleted on
set exclusive on
wsproc=ctod(thisform.text1.value)&&date she enteres
nagent = val(thisFORM.text2.value)
wsprev = gomonth(wsproc,-1)
wsdate = dtoc(wsprev)
wsdate2 = substr(wsdate,1,3)+"01"+substr(wsdate,6,5)
wsprevdt = ctod(wsdate2)
select 0
use f:\foxpro25\lopfi\dbases\fulopmas shared
wsag = 0
wsdpt= 0
set order to key
i=0
x=reccount()
go top
scan
if (fulopmas.agency=nagent)
if (wsag = 0) or (wsag<>fulopmas.agency) OR (WSAG=FULOPMAS.AGENCY AND
WSDPT<>FULOPMAS.DPT)
wsag = fulopmas.agency
WSDPT=FULOPMAS.DPT
select bwagefile
append blank
replace bwagefile.agency with fulopmas.agency
replace bwagefile.dpt with fulopmas.dpt
replace bwagefile.employee with 999999
replace bwagefile.name with "ZZZZZZZZZZZZ"
replace bwagefile.fullname with "ZZZZZZZZZZZZ"
replace bwagefile.filedate with wsproc
ENDIF
select fulopmas
if ((fulopmas.iactcode<>"T" and fulopmas.iactcode<>"D") or
(fulopmas.iactcode="T" and fulopmas.mdfbal<>0 and fulopmas.inactdt>wsprevdt)
or (fulopmas.iactcode="T" and year(fulopmas.inactdt)=year(wsproc) and
month(fulopmas.inactdt)=month(wsproc))) and ((fulopmas.termcd < 60 and
(fulopmas.termcd<>30 and fulopmas.termcd<>31 and fulopmas.termcd<>50 and
fulopmas.termcd<>20)) or ((fulopmas.TERMCD >= 60 and fulopmas.termcd<>98) AND
fulopmas.RETWAGES <> 0) or (fulopmas.termcd=98 and fulopmas.mdfbal<>0) or
(fulopmas.termcd=30 and month(fulopmas.dtref)=month(wsproc) and
year(fulopmas.dtref)=year(wsproc) and fulopmas.currwg <> 0))
select bwagefile
append blank
replace bwagefile.agency with fulopmas.agency
replace bwagefile.dpt with fulopmas.dpt
replace bwagefile.employee with fulopmas.employee
if (fulopmas.termcd >= 60) and (fulopmas.termcd<>98)
replace bwagefile.wage with fulopmas.retwages
replace bwagefile.newwage with fulopmas.retwages
else
replace bwagefile.wage with fulopmas.currwg
replace bwagefile.newwage with fulopmas.currwg
endif
if fulopmas.dpt = 24 or fulopmas.dpt=34 or fulopmas.dpt=35
replace bwagefile.wage with 1.00
replace bwagefile.newwage with 1.00
endif
if fulopmas.retwages >= 1093.00
replace bwagefile.service with 1
else
replace bwagefile.service with 0
endif
replace bwagefile.fileterm with fulopmas.termcd
replace bwagefile.name with alltrim(fulopmas.lname)+",
"+alltrim(fulopmas.fname)
replace bwagefile.fullname with
alltrim(fulopmas.lname)+alltrim(fulopmas.fname)
replace bwagefile.filedate with wsproc
select fulopmas
endif
endif
SELECT FULOPMAS
x=x+1
i=i+1
othermometer.update(recno()/reccount()*100)
endscan
select bwagefile
set order to lagkey
messagebox("Finsihed!!")
thisform.release()
ENDDO
othermometer.Release
DEFINE CLASS thermometer AS form
Height = 73
nshapemaxwidth = 300
Width = 349
DoCreate = .T.
AutoCenter = .T.
Caption = ""
Closable = .F.
ControlBox = .F.
MaxButton = .F.
MinButton = .F.
Movable = .F.
Name = "Form1"
ADD OBJECT shape2 AS shape WITH ;
Height = 25, ;
Left = 24, ;
Top = 24, ;
Width = 300, ;
Name = "Shape2"
ADD OBJECT shape1 AS shape WITH ;
BackColor = RGB(0,0,255), ;
Height = 25, ;
Left = 24, ;
Top = 24, ;
Width = 0, ;
Name = "Shape1"
ADD OBJECT timer1 AS timer WITH ;
Top = 0, ;
Left = 0, ;
Height = 23, ;
Width = 23, ;
Interval = 100, ;
Name = "Timer1"
PROCEDURE update
LPARAMETERS nPercent
Local lnPercent
lnPercent = iif(npercent<0,0,iif(npercent>100,100,npercent))
This.shape1.Width=This.nshapemaxwidth*lnpercent/100
ENDPROC
ENDDEFINE Tag: Keybord Tag: 218447
Pull Hard Disk Serial, Processor Serial etc.
Nov 22, 2005
Hi
What is the easiest way to pull the Hard Disk Serial Number, Processor
Serial Number or any other unique code from a PC through Visual Foxpro. I am
using VFP version 9.
Thank you in advance.
Regards
Tanveer Tag: Keybord Tag: 218446
Include Files in Forms
Hello and thanks in advance for the help.
How do you specify include files in a form?
I seem to have done this at some point in the past but I don't remember how.
When I search for the header file that is giving me a problem I find that it
is in the RESERVED1 and RESERVED8 fields of several of my forms. I don't
remember what I did a long time ago to get it there.
Thanks,
Jeff Tag: Keybord Tag: 218440
Contract position opening in Downtown Seattle
(Opening is with the City of Seattle, City Light, Budget Office)
Ciber is currently looking for a Visual FoxPro Developer for a 6 month
contract, located in Seattle, WA.
Scope of assignment:
Maintain Visual FoxPro 6.0 applications used to plan, schedule, and budget
capital projects. Use a combination of FoxPro applications and standalone
programs to support a $150 M capital program. Applications are provided
online to over 70 active users and involve OLE automation links to MS
Project.
The immediate need is to provide a bridge during scheduled personnel
reassignments. The transition work will involve stabilizing and documenting
existing application code. The remainder of the contract will involve
maintenance and enhancement of the applications during the upcoming budget
season.
Required Qualifications:
a.. Three years experience with Visual FoxPro 6.0 in a Windows XP
environment
b.. Demonstrated experience to write complex FoxPro SQL statements and the
FoxPro report writer
c.. Good interpersonal skills and the ability to write well; ability to
prepare procedures and related documentation
Desired Qualifications:
a.. Experience in business analysis (budgeting, accounting) in a Municipal
environment
b.. Ability to prepare ad hoc queries, analyze results in Excel, and
prepare management reports
c.. Experience with object-oriented development, and Source Safe.
jobs-seattle@ciber.com Tag: Keybord Tag: 218425
date updates and interactivechange
It sometimes happens that I have a control, a checkbox for instance, tied to
a field via a control source, and I have to run a procedure when the value
is changed.
So I put a function call in checkbox.interactivechange to do whatever.
Unfortunately, code that runs here, if it looks at the underlying table,
does not yet see the change that the checkbox is supposed to have made.
For instance, suppose the checkbox is tied to a logical field, and there are
three .T. and the rest false. If I COUNT FOR logfield TO myvar, then myvar
is 3. But if I uncheck one of the checkboxes and put COUNT logfield TO myvar
in .interactivechange, I still get 3. It doesn't change to the correct 2
until after interactivechange is completed.
I find this very annoying. Anyone have a good way to force the field update
before .interactivechange is called?
--
You can reach me at: p one six seven k b r (remove spaces and convert words
to digits) at comcast dot net Tag: Keybord Tag: 218424
Web vs Classic Explorer View
How can I prevent the "WEB" version of the
explorer window from opening when I want the "CLASSIC" view? The idea is to
prevent access to the other directories commonly seen in the WEB BAR on the
left side of explorer window such as Network Neighborhood, My Computer, etc.
Thanks in advance.
Craig Farrel Tag: Keybord Tag: 218421
grid.column.container.image caused refresh problem
I have a grid with a column that uses a container with an image. I used
grid;dynamicfontbold to refresh the container. Now when I scrolled the
grid horizontally into the container, the grid became a mess. Needed to
go back and forth a few times on the horizontal scroll bar to clean
things up.
Is there a way to avoid that?
--
.~. Might, Courage, Vision. Sincerity. http://www.linux-sxs.org
/ v \
/( _ )\ (Ubuntu) Linux 2.6.14
^ ^ 22:19:01 up 23 days 5 min load average: 1.44 1.38 1.29 Tag: Keybord Tag: 218416
Terrafox Announcements for November
TerraFox Publishing Announces the Call for Info to fill the first edition of
The FoxGuide! Ok Ok - what's the FoxGuide? It's a resource book for
everything about VFP and VFP developers - a list of independent consultants,
consulting companies, 3rd party vendor tools, accounting software written in
VFP, MRP systems written in VFP, plus display advertising!! (We can't say
the YP word, thats copyright title) .
First Edition Due out on 15 December 2005, both in Print and Electronic
Format. Deadline for entries on 10 December 2005. Primary audience - New
Clients of VFP Custom Development Services.
Independant Consultants and shareware authors can post for free - for
everyone else, rates are SuperMondoLow!
http://www.terrafox.net
----
TerraFox Publishing Announces the TerraFox Video Magazine and Call for
Content Authors! Published every two weeks - you retain copyright -and we
pay for material! Most Content shot in Camtasia with VFP 9. 5 to 10 minute
features, 30 sec to 2 minute tips, Video Advertising, and that Newest
Feature - FoxSpotting! www.terrafox.net
----
TerraFox Publishing Announces the TerraFox VFP UG Video Report and Call for
UG Video Content! to be published monthly - you retain copyright and we pay
for material! It's a great way to get your user group noticed. Monthly Video
Mag, deadlines are 5 days prior to first of the month, each month.
www.terrafox.net
----
TerraFox Publishing Announces New VFP Print/Electronic Magazine, to be put
out biweekly! Content Authors wanted - you retain your copyrights and we pay
for material! www.terrafox.net
----
Are you a good VFP trainer? Want to create your own training segments on
video for publication and resale? TerraFox Publishing is compiling video
training segments on VFP for resale and publication. You retain all
copyrights, and we pay for usage! Most Content shot in Camtasia, 5 minute to
2 hours. www.terrafox.net
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net Tag: Keybord Tag: 218413
Security - C2 rating
Hi,
We have a customer requirement that "the dbms should be capable of being
secured to 'C2' level". Am I correct in thinking that Visual Foxpro 8.0 is
NOT C2 compliant?
I believe SQL Server 2000 is C2 compliant, is SQL Server 2005?
Thanks in advance,
Pauline Tag: Keybord Tag: 218410
grid column changes
Is there a way to detect grid column changes - width, column order? Is there
a way to prevent the user from making such changes? lockcolums prevents
moving but not resizing. allowautoresize doesn't help either.
--
You can reach me at: p one six seven k b r (remove spaces and convert words
to digits) at comcast dot net Tag: Keybord Tag: 218394
PageFrame and Controls collection
I'm writing a method that set the size of a form at runtime and I've just
noticed that the form's page frame doesn't appear in the forms controls
collection. Minor bummer, but why isn't it there?
-Lew Tag: Keybord Tag: 218392
Need to create a new DBF file using dbase driver.
Hi,
I'm trying to create a new DBF file using dbase driver but error is coming
while i run the command that is
"[Microsoft][ODBC dbase driver] Syntax error in field defination"
I'm using syntax as follows:
"Create Table E:\KPSFeesN\Korangi\FeeSlip.dbf (Challan_No N(10), Computer
N(5), Org C(1), Branch C(1), Session N(4), IssueDate D, StartMonth N(2),
NoOfMonth N(2), TuiPrevMth N(10), BusPrevMth N(10), BusEndMth N(10), Tuition
N(10), TuiArrear N(10), Term N(10), TermNo N(2), Late N(10), LateNo N(2),
Bus N(10), BusArrear N(10), Arrears N(10), DueDate D, Status C(1), TuiEndMth
N(2), Term_Beg N(2), Term_CNT N(2), AnualFee N(10))'
Please help..
Thanx
Ammar Tag: Keybord Tag: 218388
Maximize child form
I have a top level form that is maximized (windowstate = 2)
_Screen is hidden.
Why won't the child forms that I open in my top level form open maximized if
I set their windowstate = 2?
The child form is modeless.
I am using VFP 9.0
Thanks. Tag: Keybord Tag: 218378
VFP9 limit to the number of joins per SELECT statement?
VFP8 Help says "The limit to the number of joins that you can use per SELECT
statement is nine. "
Does VFP9 handle more than this?
Regards,
Bernie Beattie Tag: Keybord Tag: 218374
_screen.windowstate = max
Hi,
If I set this, I set all forms also maximized.
no problem so far but the size is to heigh ?
all forms are underneath the Windows(XP) taskbar.
Is this called normal behaviour ?
or should I make all forms not so high
and shrink it with the height of the taskbar
but then how heigh is this ?
thx in advance
christophe
--
\|||/
(o o)
----ooO-(_)-Ooo------------- Tag: Keybord Tag: 218365
A4 size report - A3
all my a/c report are written in A4 size standard,
Now , my new client got a A3 printer only and she want all report print as
A3 size, all font should be 'enlarge ' .
I don't want to re-redraw all the report.
Any simple method can enlarge it ?
Thanks a lot Tag: Keybord Tag: 218361
PDF Creator
Anyone try the PDF Creator ??
I just d/l it and use it as printer driver, However , the pdf is blank after
'generation'.
Do I need to install ghostscript printer driver also ?
thanks Tag: Keybord Tag: 218359
Huge speed difference
USE mytable EXCLUSIVE && about 5000 records
REPLACE ALL myfield WITH .T. && instant
UPDATE mytable SET myfield = .T. && 0.1 seconds
USE mytable SHARED
REPLACE ALL myfield WITH .T. && 0.5 seconds
UPDATE mytable SET myfield = .T. && > 90 seconds !
Is that to be expected?
The presence of an index on myfield makes no difference.
--
You can reach me at: p one six seven k b r (remove spaces and convert words
to digits) at comcast dot net Tag: Keybord Tag: 218344
VFP 6: Memo Wrapping Problem
If I ever thought about the internals of memos, I supposed that
memowidth controlled the output only or that there were soft returns
in the memo. I have been rudely disabused of this notion. Is there
any way to distinguish between the returns inserted because of
memowidth and those entered by the operator? I am thinking not, but
hope to be wrong.
The trouble is that mline() stops when it reaches a return. I
have memos entered with a shorter memowidth in effect than I now wish
to print with. I can do
thememo=chrtran(thememo,chr(13)," ")
but this is a kludge. It would also mess up a memo that was formatted
into a table or into paragraphs.
I am considering setting memowidth to 8192 and hoping that
nothing else inserts returns into my memos. Is this safe?
What do you folks do?
Sincerely,
Gene Wirchenko Tag: Keybord Tag: 218343
data access question
I want to make sure I understand how the private datasessions and data access
in general works. If I open a table, am I correct in assuming that I do not
see some one else's changes until they do a tableupdate?
situation:
I append 3 records. I need to udate a few fields on those records but have
not done a tableupdate. I change the field on the three records and then do a
tableupdate.
Person2 appends 2 records without doing a tableupdate while I am in the
process of update some other fields.
Is it correct that I do not see the two records they append because they
have not done a Tableupdate yet? Tag: Keybord Tag: 218333
SQL question
This seems too simple to call a "puzzle", yet I haven't figured out how to
do it.
I want to set a field in one table to .T. or .F. depending on the existence
of certain records in another table.
I can do this in one pass using SET RELATION, or in two passes using SQL.
Can someone come up with an SQL statement that will do it in one pass?
UPDATE mytable SET myfield = <?> WHERE ... ???
--
You can reach me at: p one six seven k b r (remove spaces and convert words
to digits) at comcast dot net Tag: Keybord Tag: 218324
UNION same table doesn't work?
FPW2.6, just ran into an unexpected error.
CREATE CURSOR temp (temp C(10))
INSERT INTO temp (test) VALUES ('test')
SELECT * FROM temp ;
UNION ALL ;
SELECT * FROM temp ;
INTO CURSOR temp
That select statement will throw a file requester asking for "temp.dbf". At
this point, the cursor temp is now a table in some work area with the
default single letter alias.
If any of those 3 aliases in the SELECT are different, it works fine, just
doesn't like all 3 the same.
--
Regards
Andrew Howell Tag: Keybord Tag: 218317
Add hyperlink in Word document
Hi,
I am using VFP 6 OLE to hyperlink some selected text in Word document.
Then save the document as
webpage. My problem is how do I insert the hyperlink in Word with
target="_parent" using programatically?
For example, I need the link to be like this :
http://www.xyz.com/123.htm target="_parent"
Thanks. Tag: Keybord Tag: 218315
FRX2ANY
We have a FRX2ANY class that was intially purchased bought for VFP 6.
Now when we tried to use it on VFP 9, it erred with the message
"UNLOCK.VCT is not an object".
Is this a known problem?
--
.~. Might, Courage, Vision. Sincerity. http://www.linux-sxs.org
/ v \
/( _ )\ (Fedora Core 4) Linux 2.6.14-1.1637_FC4
^ ^ 18:44:01 up 1 day 9:34 load average: 0.00 0.00 0.00 Tag: Keybord Tag: 218302
Industry standard encryption algorithm for passwords
We have recently been asked to implement an industry standard encryption
algorithm for our passwords. At the moment we have password encrytion
implemented which we have written ourselves.
Does anyone have any information of industry standard encryption for Foxpro?
Thanks in advance,
Pauline Tag: Keybord Tag: 218301
A PCCharge Pro for "hire" - A PCC Yahoo! Group Created
I am an experienced "former" PCCharge Tech Rep... 3+ years with
GOSoftware/Verifone - 10+ in the support field... Know PCCharge in and
out... Warts and all...
Runtime Errors? Reporting Issues? Processor Setup Information?
Settlement problems?
I set up a PCCharge Yahoo! Group... Initially. it will be moderated
heavily, but I aim to please... Gotta keep the facts straight, and the
spammers away... I can't have people yelling at me because I let a
spammer in to clog your mailboxes :)
http://groups.yahoo.com/group/APCChargePro/join
I am working on a half decent FAQ (in Databases) that I alone will post
to, and update. I will later add a Member FAQ Area for integration and
POS-related FAQ's, and let you post tips, tricks and information as
well... I will eventually open a free forum for all users to
communicate that will be unmoderated.
I know this software in and out, and know what to do to fix the problem
- or to answer your questions... I am a great source of information,
and happy to assist... No sense in wasting all of this valuable
information when I can share it...
And it's free information (of course)...
It's a very new group - just created within the last week... Already 6
members and counting... I moderate, approve all members, and at first
will moderate all messages, but after a period of time, I will allow
members free run after a period of posting on-topic subjects... I just
want to keep things clean, and keep the group free of spammers and junk
mail messages...
PCCharge topics will be top priority, POS issues should be referred to
POS specific groups such as this - but simple integration-related
issues can probably be handled in some way or another...
If I don't know I'll tell you I don't know. If you need to call, I'll
tell you to call PCC Support, otherwise ask away!
If there are resellers, integrators or PCCharge installers, IT folks,
etc, please specify these things in your "application" profile... I
will accept anyone who wishes to join, and later may appoint additional
moderators, and so forth to assist with the group. I would love to
hear from anyone who may be able to provide input on integrations, and
so forth. Especially simple POS setups, and POS information I may not
be able to provide...
Please join... I can help... We can help each other...
http://groups.yahoo.com/group/APCChargePro/join
"A PCCharge Pro" Tag: Keybord Tag: 218298
Menu icons doesn't appear in the app
In VFP7 creating a menu I see icon's paths are garbled as
"..bmp\bmp\newtable.bmp"
I use native genmenu.prg which appears with the right path in file
locations.
Any idea of this behaviour?
Thanks.
Alejandro Fernandez Tag: Keybord Tag: 218289
Quitting VFP
My VFP8 app uses pass-through for all data access. All machines are W2K.
Most machines exit gracefully, a few give a nasty message 'Cannot Quit Visual
FoxPro' when the users quits the app. Suspect I need to release something
but it is not clear what. Any suggestions?
tnx. Tag: Keybord Tag: 218281
Hi 2 all
How can i hook keyboard Interrupt ,. means when software is minimize the
key stroke are captured in to a table or array
--
Qaiser Me
QaiserMehmood wrote:
> Hi 2 all
> How can i hook keyboard Interrupt ,. means when software is minimize the
> key stroke are captured in to a table or array
form.keypress() and form.keypreview?
--
.~. Might, Courage, Vision. Sincerity. http://www.linux-sxs.org
/ v \
/( _ )\ (Fedora Core 4) Linux 2.6.14-1.1637_FC4
^ ^ 17:49:01 up 8:53 0 users 0.05 0.01
If the app is minimized, and more importantly is not the foreground windows
app, you can't. Keystrokes will not be sent to it to be captured.
"QaiserMehmood" <qaiserme@fastmail.fm> wrote in message
news:61C2E8AB-F24F-4420-A53A-D213D0591F64@microsoft.com...
> Hi 2 all
> How can i hook keyboard Interrupt ,. means when software is minimize the
> key stroke are captured in to a table or array
> --
> Qaiser Me
>
>
Try bindevent
"Matthew Reed" <matty don't send me any freaking spam at zootal dot com
remove the don't send me any freaking spam> wrote in message
news:eUeoLkf8FHA.2816@tk2msftngp13.phx.gbl...
> If the app is minimized, and more importantly is not the foreground
windows
> app, you can't. Keystrokes will not be sent to it to be captured.
>
>
> "QaiserMehmood" <qaiserme@fastmail.fm> wrote in message
> news:61C2E8AB-F24F-4420-A53A-D213D0591F64@microsoft.com...
> > Hi 2 all
> > How can i hook keyboard Interrupt ,. means when software is minimize
the
> > key stroke are captured in to a table or array
> > --
> > Qaiser Me
> >
> >
>
>
try inkey()
***************************************************************
*ox = NEWOBJECT("form1","form1.vcx") && form1 includes text1 textbox
*ox.show
DO WHILE .T.
x = ""
a = INKEY(0, "H")
DO WHILE .T.
IF !BETWEEN(a, 1, 255)
EXIT
ENDIF
IF a = 13 && Enter pressed
EXIT
ENDIF
IF a = 107
EXIT
ENDIF
x= x + CHR(a)
a = INKEY(0, "H")
ENDDO
IF a = 107 && ALT+F4 pressed
EXIT
ENDIF
IF LEN(x) > 0
*ox.text1.value = x
*ox.show
?x
ENDIF
ENDDO