about backup
hi 2 all
sir how i zip *.dbf files in vfp 7.0 / 9.0 for backup is there any classes
or utility for this propose
--
Qaiser Me Tag: Web Service Tag: 227780
Can Win2003 restrict the rights to call a COM method? (C++ and simple component created by Visual FoxPro 6)
Sorry, if it is not the right channel. However, I need someone who knows
Windows, C++, COM and possibly FoxPro...
Summary: We have observed a situation, when the application can create
instance of the component but it fail when a method of the component is
called. It happens when the application is executed on one specific Windows
2003 R2 Small Business Server. However, it runs on another Win2003 SBS
without problems. Are there any rights that could restrict calling methods
of components?
Our application is written in C++ (MS VC++ 7.1, but does not use .NET
extensions) and it calls a COM component that was created using Visual
FoxPro 6. Both the application and also the component are compiled from our
sources. The component is registered using regsvr32 utility in the simplest
possible way. The application need not to be installed in any special way --
just executed.
Here are the important lines from the C++ source:
long GetAPSfoxVersion()
{
FOX::ItstfoxclassPtr spTstFox; // The instance was not created yet.
long result = -1; // The value to be obtained by
calling the component -- init.
HRESULT hr = spTstFox.CreateInstance( __uuidof(FOX::TSTfoxClass) ); //
THIS SUCCEEDS!
...
_variant_t v(spTstFox->dllversion());
// THIS FAILS
result = v.lVal; // remember the result
...
spTstFox = NULL; // i.e. Release() the instance
return result;
}
To reproduce the problem, I have created the bare-bone component (FoxPro)
that contains only the called method, and the console application (C++),
that calls the method and checks for the success/catch exceptions.
The FoxPro source contains just the following lines.
------------------
DEFINE CLASS TSTfoxClass AS CUSTOM OLEPUBLIC
PROCEDURE DllVersion()
RETURN 1
ENDPROC
ENDDEFINE
------------------
The complete FoxPro/C++ sources and compiled binaries can be downloaded from
URL http://www.skil.cz/test/tstFoxDll.zip.
I did not include the FoxPro 6 runtime and text dll (vfp6r.dll and
vfp6renu.dll) to make the zip smaller (about 120 kB). The tstFox.dll must be
placed to the directory where the vfp6r.dll is and then registered. You can
use the regTstDll.bat for the registration. Then execute the tstFoxApp.exe.
If it works, you will observe this:
D:\Tools\tstFoxDll>tstFoxApp.exe
tstFoxApp: Before the call.
tstFoxApp: After the call.
tstFoxApp -- version 1
press Ctrl+C ...
However, on the nasty computer, you would observe the following:
tstFoxApp: Before the call.
tstFoxApp: Unhandled exception.
SE_exception: code = 0xc0000005 (EXCEPTION_ACCESS_VIOLATION)
tstFoxApp -- version -1
press Ctrl+C ...
It seems that Windows 2003 can restrict calling the component somehow.
However, I am completely stupid in this area. We run such component and the
application several years on say hundreds computes (servers and desktops)
and nobody reported the problem. It could be the case that the problem is
well known and they have better administrators to set the rights. Could you
help, please?
Thanks for your time and experience.
pepr
--
Petr Prikryl (prikryl at skil dot cz) Tag: Web Service Tag: 227773
Killing a Process second attempt
I posted a script a few weeks back which attempted to use WMI scripts to
kill all occurances of an exe for a specific user. Unfortunatly if you are a
User on Terminal server this fails with a C005 when attemptting to use the
method to find the user of a process, and i found it next to impossible to
trap this. So i went back to the Drawing board to try again.
Now in my case the processes i am interested in are seperate executables
created by a main process. I found that the following is possible.
PROCEDURE kill_server
LOCAL
oWMI,cQuery,oEncoreResult,oEncoreProcess,oOtherEncoreResult,oResult,oProcess,oOtherEncoreProcess
oWMI = GETOBJECT('winmgmts:{impersonationLevel=impersonate}')
cQuery = "select * from win32_process where processid='"
+alltrim(str(application.processid)) +"'"
oEncoreResult = oWMI.ExecQuery(cQuery)
For Each oEncoreProcess in oEncoreResult && should be only one i know
cQuery = "select * from win32_process where name='" +oEncoreProcess.Caption
+"' and processid <> " + alltrim(str(oEncoreProcess.processid))
oOtherEncoreResult = oWMI.ExecQuery(cQuery)
cQuery = "select * from win32_process where name='encorephoneserver.exe'"
oResult = oWMI.ExecQuery(cQuery)
FOR EACH oProcess IN oResult
if oOtherEncoreResult.count = 0 && great no more encores
oProcess.Terminate(0)
else
m.llisfound = .f.
For each oOtherEncoreProcess in oOtherEncoreResult
if oProcess.ParentProcessid = oOtherEncoreProcess.processid
m.llisfound = .t.
Exit
endif
next
if m.llisfound = .f. && it has no active parent so try to kill it
oProcess.Terminate(0)
endif
endif
next
Next
endproc
in my case the object i am trying to kill is encorephoneserver.exe. So the
above finds the Caption of the current running process via the
Application.processid. Finds all other processes of this type (i am running
this prior to starting a new encorephoneserver for this process). and then
finds all running encorephoneservers and compares the parentprocessid on it,
to the processid's of the main application processes. if it's not found its
an orphan, and we can call the terminate method. I have not completed
testing this, and i suspect that Users on the terminal server will not be
able to terminate processes that they did not start. however at least i do
not get an error when i run the code which is nice. i will of course put up
a posting if i have any problems on an extended test run. But i hope that
people will find this useful as is. Tag: Web Service Tag: 227766
xfrx versus frx2any
Hi,
Besides the price where frx2any is more expensive.
And both help files are "looking good".
Is there a good reason which one to choose ?
Anybody has some experience with one of them.
Thanks in advance
regards
christophe Tag: Web Service Tag: 227765
VFP 9: Non-RW Printing: Line Spacing
Is there any way to adjust the line spacing in non-RW printing?
My printer crunches lines together somewhat more closely than the
printer at the office. There is nothing under set printer.
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices. Tag: Web Service Tag: 227756
VFP9 SP1: Debugger: Watch Bug?
I have an array of lines to be printed on a page: this.pageline.
If I enter this into the Watch window, it shows with a boxed plus
showing that it is expandable to show the array elements, and it does
do that. However, on a subsequent run, the box is not there. If I
enter it again into the Watch window, the new entry has the box and
can be expanded. On the next run, the second entry for this.pageline
also no longer has its box.
Is this a bug, or am I overlooking something?
I do seem to be finding some interesting oddities. Where should
I report suspected bugs?
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices. Tag: Web Service Tag: 227755
Passing chinese charater to a stored procedure
I try to call a command to execute a stored procedure by passing some
chinese
character (unicode).
variable mu_measure is chinese character, eg: =E5=8F=AA
When I use the below command, value ? will stored instead of the
chinese
character.
b=3DSQLEXEC(ma, [exec multiprice ?mitem_no,?mprice,?mu_measure,?mdate])
so i tried to add N in front of the variable, the chinese charater
still
didn't display correctly, the value stored become N@P9
b=3DSQLEXEC(ma, [exec multiprice ?mitem_no,?mprice,N?mu_measure,?mdate])
What should I do in order to pass in the character correctly to my
stored
procedure?
Please advise and thanks in advance.
Regards,
jong Tag: Web Service Tag: 227750
How to remove print button on Print Preview w/ SET REPORTBEHAVIOUR 90?
Hi all,
Until now, I've been successfully use customize resource file to display
the Print Preview toolbar without the Print button. Problem arise
because in VFP9 (with SET REPORTBEHAVIOUR 90), looks like the
ReportListener object takes control and disregard the toolbar settings.
Question:
Anybody knows how to easily remove the print button on Print Preview
toolbar while running the report with SET REPORTBEHAVIOUR 90?
Thanks in advance!
Willianto
P.S: Of course the easy solution would be SET REPORTBEHAVIOUR 80.
Problem is, my client already sees how VFP9 render the preview window
beautifully. See, most reports are using Draft fonts and printed on dot
matrix printer. Thus, in the old VFP8, the preview looks miserable. Now,
they want the nice looking _and_ the suppressed-print-button one. Oh
well, you know, _clients_ :P Tag: Web Service Tag: 227747
VFP9: Printer Margins
And now, for the next stirring episode of "Gene Converts a Report
to Allow PDF Output":
I have now established that what I intend to be output is output,
but somehow, it is not coming out right. Other printer output, even
in VFP, works normally. I am wondering if there is a setting that I
am missing.
The guts of the printing (after setting printer and font) is:
set printer on
set console off
?? pagetext
set console on
set printer off
pagetext contains a page of text. Naturally, it has embedded
CRLF. I get crazy output. The text is indented about two inches on
the first page which then line wraps nearly every line and takes two
pages to output. My second page is indented about six inches!
I decided to try breaking up pagetext into lines and printing
line-by-line, and that worked.
Am I overlooking something, or is this a nasty VFP bug? (It
certainly has slurped up a bunch of my blood^Wtime.)
(Once I have the buffering all working right, then it will be
time for testing the PDF output. That was the whole point of this
exercise in the first place. I hate large changes that can not really
be tested until mostly complete.)
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices. Tag: Web Service Tag: 227746
calculated field in remote data
I need a calculated field in a remote view. What are the costs/benefits of
defining that field in the back end vs. in my SQL statement or remote view?
Is one method preferred over the other? Tag: Web Service Tag: 227743
Order of records in a grid
I want to allow users to set the order of records in a grid. I realize
that grid order is based upon the underlying records, so I have a
lineorder field that theoretically could set the order of the records.
Changing that field should automatically reorder the grid.
That would work, except that the grid is a child grid of a parent
record. The parent is a purchase order. The child is items on the
purchase order. To get the right child items, the order of the child
table needs to be set to ponumber. But to get the record order
correct, the index has to be set to lineorder. So I'm rather confused
as to how this would be done, if it can be done.
Any help would be appreciated.
Kevin Clark
Seton Home Study School Tag: Web Service Tag: 227741
Mobile 5 and VFP
Hi everyone,
Does anyone know of any libraries for Visual foxpro for Mobile 5 that I
could use on a handheld module.
Thanks in advance
Tanya Tag: Web Service Tag: 227730
Migrating dbf tables to SQL Server
I am beginning to think about migrating my free tables to SQL Server. My
idea is to use as many remote views as tables there are in the database.
This means, that if in a program I have "USE table1" I will change it now to
"USE view_table1 NODATA", and then use a REQUERY() to fetch the data of the
parametrized view. The rewrite of code I think is minimal with this
approach, and I have all the advantages of a client/server.
Or mabye it would be better not to use remote views at all and use instead
of them SQL pass-through sentences? Then at the beginning of the programm I
would make a SQLEXEC(Select....) into a local cursor. And when transaction
finishes, I would UPDATE the database from that local cursor (because there
are 1 to many relationships).
I would like to hear your comments on both approaches, since many of you
have already done this migrating process.
TiA
Walter Tag: Web Service Tag: 227728
VFP 9: Debugging: Checking Multiline Values
I am in the last stages of a programming change, and I am getting
unexpected results. I do not know why yet.
Part of the awkwardness is that the values that I want to check
are long multiline strings. These do not show well or accurately in
the debugger. The pieces that I am concatenating seem to be correct,
but somehow, the long strings are going pear-shaped. I do not know if
the erroneous results I am getting are due to a bug of mine or an
artefact of VFP's.
What is a good way to interrogate the values of multiline
strings?
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices. Tag: Web Service Tag: 227719
I am having a problem tying a grid to a cursor.
I started out with a regular database called labels.dbf. I open a form and on
that form there is a grid showing the contents of the labels.dbf.
I decided to use a cursor instead. I create the cursor in the load of the
form. When the form opens it says it can't instaniate the labels.dbf cursor.
How do you tell a grid to wait till the dbf is available? DO I have to
create the grid after I create the cursor? Sounds like alot of work.
Is there a way to have the grid on the form and then tell it what cursor to
use after during the init or load? Tag: Web Service Tag: 227711
Creating Help Files
OK, I know this is basic and the answer is right before my eyes, but my eyes
are old and I can't find it....
I want to create a *&^%*&() help file and I'm looking for a
tutorial....where can I find how to info
Thank you Tag: Web Service Tag: 227709
Report Listener
can someone give me an example of using the report listener with multiple
report, with varying orientation? Tag: Web Service Tag: 227705
Import csv file and keep trailing spaces - URGENT REQUEST
I have an urgent need to import a csv file and some of the data has
trailing spaces which I have to retain and later use this data intact
by sending it to a printer.
Every time I import the data I lose the trailing spaces.
An example of the file with 6 fields is below:
IDNO, LNAME, FNAME, code1, code2, code3
1033501, ALEXANDER, JOHN,1,PAQVSBUJA0 .9W20.WPSUG8J7P9YA,15071
1007267, ALEXANDER, BILL,1,PA1QSBUJA0 .9W-.V0PSUG8J7P7ZU,31910
1032692, ALEXANDER, JEAN,2,PAQVSBUJA0 .9W-9.-ZSUG8J7RGT9,32216
1032027, ALEXANDER, PAUL,1,PAQVSBUJA0 .9W2ERYPSUG8J7R - ,12386
Note that the code 3 field sometimes has a record with a trailing space
(see last record)
Can anybody advise how I should go ?
Thanks. Tag: Web Service Tag: 227700
More on Data Sessions for a Function
Josh, Thanks.
I've been playing and it seems that the following are true:
CLOSE DATABASE will close table in the current session
RELEASING a session will close the tables in that session
DISPLAY STATUS will show you open tables in the current session
DISPLAY OBJECTS will show you sessions (and other objects)
Do I seem to have it correct?
My functions that want private data should simply save the session coming
in, create a new one, release the created session, and then restore the
saved one prior to returning. I don't need to close tables. Releasing the
session does it for me. Correct?
Also, my SET EXCLUSIVE and SET DELETED seem to be preserved across
datasessions created in code as you outlined so they do not need to be coded
again when a new session object is created. Is that correct?
Thanks again.
Jeff
"Josh Assing" <XjoshX@jassing.com> wrote in message
news:cvksj2teihmhvc5kirr1avc3gr197kkuvb@4ax.com...
> >Is there an easy way to do the same thing for a function?
>
> yes.
>
> it's called a (ready?) data session
>
>
> Here's how to do it in code.
>
> lnCurrentSession = SET("datasession")
> loSession=CREATEOBJECT("session")
> SET DATASESSION TO losession.DataSessionId
>
> * do your stuff here
>
> set datasession to lnCurrentSession
>
> * Back to where you were.
>
>
>
> --- AntiSpam/harvest ---
> Remove X's to send email to me. Tag: Web Service Tag: 227677
Copy cut paste hotkeys not working in zoomed memo window
I have a Zoom button class that opens a given memo field in a separate window
and allows edit. My problem is the copy cut paste hotkeys don't work inside
this window - you just get a little blob appearing. Using the menu option to
copy cut paste inside the window works fine. The hotkeys work fine insdie the
edit box on the main screen ok, it's just inside the defined window that they
don't.
Any ideas how to fix this?
Thanks,
Bernie Beattie Tag: Web Service Tag: 227674
MDAC
I am currently running with MDAC version 2.53.6306.0 in Windows 2000.
Can you suggest a reference that would outline any problems I may have
working with Foxpro V 6.0 if I upgraded MDAC to 2.6 or higher?
Thanks Tag: Web Service Tag: 227669
CloneObject
hi,
I want to create a new copy of object instead of using the
reference of the object like
objA=objB.
When I tried to search for this I encountered with
NewObject(),
cloneobject(),
AMembers()
could be used for this purpose. But I couldn't understand how the
NewObject could be used.
For the CloneObject, since it is available at only the design time it
is not going to serve my purpose.
For the AMembers() method it was giving errors when I was copying for
the read only properties, so if I try to use the filter, it is giving
me an error of Incorrect argument even though I use it as specified in
the Microsoft help.
Here the object toForm is also present. It gives the error for the
last argument of [P | H | G] , but really astonishing thing is that it
will not give any error if I use [P] only here.
=AMEMBERS(laArray,toForm,1,[P | H | G])
Please suggest me an example with code of how a copy of an object could
be done in VFP9.
Thanks Tag: Web Service Tag: 227664
Capturing Right Clicks on a Menu
can any one tell me how i can capture CTRL+SHIFT + a right mouse on a menu
item...
specifically in our security design, we have enabled the CTRL+SHIFT+Right
Mouse Click to add a form or a control into the security structure so access
can be defined for it....
rather than have to manually create entries, i would also like to capture
the CTRL+SHIFT+Right Mouse Click when their on a menu to add the menu item
into the security mix....
any ideas? suggestions? Tag: Web Service Tag: 227663
run not registered dll made with VFP on internet server
VFP7 XPSP2
Is there a way of running a DLL compiled with VFP on internet server without
rigistering the DLL On the server?
Samir Ibrahim Tag: Web Service Tag: 227661
How to output to Word format?
Anyone know of an easy way to take an existing system and output existing
reports in Word format? This system generates about 40 reports. Is there any
type of printer driver setup that outputs in Word/RTF? Any ideas? Tag: Web Service Tag: 227652
Need to print certain pages for a copyright regsitration.
Some of you have been through this. I am in the process of copyrighting a
program I have written. The copyright office wants the first 25 and last 25
pages of the program.
You used to be able to see the entire application in one file. Can you stil
do this? How do I see the entire program code in one file? The App is made up
of over 50 programs and forms and reports, etc.
TIA Tag: Web Service Tag: 227649
MS Access ODBC driver (VFP 9.0)
When I use sqlconnect() and choose MS Access the driver prompts for the
location of the MDB. However, the file dialog does not include Application
data. How can this be avoided? Tag: Web Service Tag: 227642
Handling apostrophes in strings?
Hi,
I'm using VFP 9.0 and have run into a little problem when storing names in
strings. If I have a contact's address with a street name like, O'Keefe
Ave, do I have to do anything with the apostrophe to keep it from
premeturely terminating the string?
What I'm doing is scaning a table and exporting records to an Access
database using ODBC and SQLEXEC(). To do this I'm building a string for the
values component of an INSERT statement. Like this...
myString = myString + "', '" + myTable.addr_1 + "', '" + myTable.addr_2 +
"', '" + myTable.city + "'"
What would be the best way to handle this on the fly? Or, is there a better
way to perform my task?
Any help is greatly appreciated,
Linn Tag: Web Service Tag: 227633
Launching Internet link from memo fields
I find this works in VFP 7.0 and 9.0, but when running from runtime it
doesn't work. Is it only available when run from the development
environment? Thanks.
Dan Tag: Web Service Tag: 227625
strange behaviour of form environment
I have a form with three tables in the environment, standord, accounts,
and utility.
The INIT selects standord and creates an array which fills a listbox.
This is OK and the form appears as it should, If I then SUSPEND and ?
ALIAS() it tells me that utility has been selected. If I then SELECT
STANDORD it tells me that standord does not exist. I have even made a
temporary textbox which INIT fills with the alias in its last line,
which show standord. But without any other action except suspending it,
the table changes.
There is nothing in the INIT which calls utility and there is no coding
in ACTIVATE or anywhere else that I can find (for example in the class
structure) which could select utility. Nowhere (until much later in the
calling prg) do I remove standord from being used.
Can anyone suggest what might be happening ? I need to select standord
for the form to do some processing.
--
Tim Hobson Tag: Web Service Tag: 227624
Meta-Data or Actual Data
Hey All,
I want to fetch the number of records in a given table via the ODBC
driver. This is not related to any particular query... Just some
"statistical" information. (IE, you have 10,000 contacts in your database)
I know I can use the RECCOUNT() function in FoxPro "native"... Which I
assume pulls from the metadata of the table. Is there an equivilant for
the ODBC driver (other than a SELECT COUNT() FROM Table, which I assume
reads every record in the table)
Thanks!
Matt Tag: Web Service Tag: 227623
setall() & .Nulldisplay
I'd like to use thisform.SetAll to set all the nulldisplay properties to a
value that makes control.values look blank, but I can't find the right combo
of equal signs, quotation marks and square brackets to do it. =space(1) in
the property sheet and similar just move the insertion point to the end of
the invisible space when the control gets focus. I'd rather not use set
nulldisplay since a global setting has effects elsewhere.
-Lew Tag: Web Service Tag: 227621
Quicken or Money to VFP
What's the shortest programmatic route from either of these to VFP? Are
there free api's? Any good?
--
-Lew
The workers took the robot for Maria. Tag: Web Service Tag: 227614
updates?
Anyone know the scheduled release date for the "official" SP2 for VFP9? I
hear there are problems with the current beta SP2.
What about Sedna? When? Are there good things in there that make it worth
spending the time to look at the beta? Tag: Web Service Tag: 227606
Registration or Activation Code engine
Does anyone know where I can get some kind of Registration or Activation
Code generator and engine for my VFP 9.0 applications?
Thanks.
-Paul Tag: Web Service Tag: 227604
What else is there like VFP?
The original dbase and to some extent all of the xbase descendants like VFP
are interactive, adhoc, one-command-at-a time, data creation, data
examination, and data manipulation languages.
Starting with a few commands in the Command Window, you can feel your way
into a problem and eventually build a program with reports, queries,
screens, etc. xbase is like a giant calculator with a ton of functions.
My question is, is there any product or environment out there that has the
same simplicity and flexibility as xbase?
Should one be learning or experimenting with some other programming
environment? (esp. if VFP wanes). What would it be? Tag: Web Service Tag: 227600
Rotation tab
How come I don't see a "Rotation" tab when I select a label on the report
header and choose property?
I use VFP9 SP1
thanks
HME
--
---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"
Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com Tag: Web Service Tag: 227599
send CTRL and "+" to application
VFP7 XPSP2
I have known lately that sending CTRL and "+"' to a grid or listview will
automatically adjust column width in the grid (Windows Shortcut).
how i can send CTRL and '+' using KEYBOARD in VFP?
I found this code to for C
SendKeys.Send ("^{+}");
http://www.codeproject.com/cs/miscctrl/AutoResize.asp
Thanks in advance Tag: Web Service Tag: 227589
Updating Balance Field
Hi,
Just want some suggestions on the following issues. I currently have a
Balance Field in
my Invoice.DBF that gets updated with every payment. In a multi-user
environment,
I encountered a problem when the balance field was updated by two different
user, with
both user entering different payment amount. The balance was incorrect
because the
calculation was based on the user that last saved the data.
eg.
Invoice amount : $1,000
Invoice Balance : $1,000
User 1 - Entered $400 as Payment
User 2 - Entered $500 as Payment
Both user was entering their data at the same time, User 2 being the last
to click the save button.
Invoice Balance : $500 (which should be $100 only)
I really need to maintain the Balance Field so I could trace which invoice
is still unpaid.
There are times that the clients pays only the latest invoice so I could not
implement
a running balance on the program.
Thanks for any ideas or comments you can give. Tag: Web Service Tag: 227588
Table buffering issues VFP 7 SP1
Hi all,
One of my forms is using table buffering and the records are filtered using
SET KEY. If two users are adding records in a grid, users A data may show
on users B screen. I remember hearing somewhere this may be a bug. If it
is, is it fixed in VFP 8 or 9.
I am thinking this is a bug since the data is being filtered and the key
value for the filter is different on both machines, also table buffering is
involved here so why would one user see another users. Though I am not sure
if user A saved before user B saw the data or not.
VFP 7 SP1 on WinXP Sp2 and Win2K workstations.
And yes we are thinking of going to version 9 sometime.
Thanks for any input
Tom Tag: Web Service Tag: 227582
SAPI Memory Leak
I am using SAPI V5.1 speech recognition in my VFP8 based application. I
have noticed that this automation server (sapisvr.exe) keeps using more
and more memory. Is this a memory leak or is this normal? The only way
to release this memory is to re-start this process.
Some of the details are as follows...
1. My OLE, implementing the SAPI events, is session based. I have also
ensured that all 'CreateObject()' based objects are made NULL before
the object references are released.
2. I have created one Public variable that references a 'container'
class based object. All the objects that are required for this SAPI
(and created thru createobject command) are referenced thru the custom
'properties' of this container object.
3. The application uses CFG only for short periods but is in dictation
mode for most of the time.
Thanks
Sati Tag: Web Service Tag: 227581
DEFINE WINDOW
This is a multi-part message in MIME format.
------=_NextPart_000_000E_01C6F9C9.60C9F9F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
When I used in FPW 2.6:
DEFINE WINDOW bro at 12,2 SIZE WROW()-13,1.09*WCOL() noclose FLOAT =
NOZOOM GROW
I got a window with three pull-down options on the upper left corner:
Move Ctrl+F4
Size Ctrl+F8
Next Window Ctrl+F6
but in VFP 9 the same command just gives
Move (wihout CTRL)=20
Size (without CTRL)
and there is no "Next Window"
How come this different behaviour. How can I achieve my old FPW 2.6 =
behaviour?
------=_NextPart_000_000E_01C6F9C9.60C9F9F0
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.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>When I used in FPW 2.6:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>DEFINE WINDOW bro at 12,2 SIZE=20
WROW()-13,1.09*WCOL() noclose FLOAT NOZOOM GROW</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I got a window with three pull-down =
options on the=20
upper left corner:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Move Ctrl+F4</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Size Ctrl+F8</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Next Window Ctrl+F6</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>but in VFP 9 the same command just=20
gives</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Move (wihout CTRL) </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Size (without CTRL)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and there is no "Next =
Window"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>How come this different behaviour. How =
can I=20
achieve my old FPW 2.6 behaviour?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_000E_01C6F9C9.60C9F9F0-- Tag: Web Service Tag: 227579
Varchar mapping, varchars & sql
I'm having difficulty with the following concept. Does anyone have the
patience to explain it?
Situation: I have a table in which all of the char fields are type varchar
and my app runs with varcharmapping on and set exact off . When it comes
time to run a few simple queries I get rows with blank values when the where
clause compares one of these fields to a character literal like
where extension = "PJX"
I have already determined that I can get the results I expect if I change
this to:
where extension == "PJX"
but I can't understand how or why comparing an empty column value to a
non-empty string can return .t. since the command line statements:
? "" = "PJX" && -> .f.
and
? "PJX" = "" && -> .t.
both make perfect sense to me, but the query suggests that "" = "PJX" is
true. (VFP9/sp1, enginbehavior 90 if that makes a difference).
-Lew Tag: Web Service Tag: 227574
Calling a form in a do while statement
If I am calling a do while statement on a command button in the Click event
and say I'm processing 6 records and I insert a case statement that calls a
form based on a case statement does the do while stop at that point then
continue after the form is executed or continue? I do make the form
enabled=.f. before I call the new form. How can I control the program code
if at all if it does not stop?
Thanks
--
Rusty Gallo
OGES Systems Tag: Web Service Tag: 227572
[VFP 5] Enabling cut-and-paste without set sysmenu on
Can it be done?
--
iTech Consulting Co., Ltd.
Website: http://www.itech.com.hk (IE only)
Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: Web Service Tag: 227561
date format
now the date format is 23-10-2006,
my client want it to be 23-Oct-2006
Any simple method to do ??
Thanks a lot Tag: Web Service Tag: 227558
setup in genmenu.prg: grrr!
I have a prg, setup.prg, which I run at the beginning of every application.
Every now and then, however, the nasty, little setup function in genmenu.prg
runs in it's place. I haven't a clue as to why this happens. Genmenu's
location isn't in my path statement and I don't have any rogue set procedure
statements. Any ideas?
-Lew Tag: Web Service Tag: 227552
Porting FoxPro 2.6 Windows app to VFP 9
I can find references to porting to VFP 6 but not with VFP 9. I guess
it is not very common. I wonder how much work is involved?
Does anyone have any experience with this or can offer a suggestion on
what to watch out for?
Thx,
Long Tag: Web Service Tag: 227549
Can I Intercept List.Click Before Pointer Moves
VFP9
When the user clicks in my list (object), the record pointer changes
and the new record is displayed just fine. Here's the setup code for
the list:
WITH .List1
.ControlSource = 'Jobs'
.RowSourceType = 6 && 6=Fields
.RowSource = 'Jobs.ModelName'
ENDWITH
Is there some event that occurs after the click but before the record
pointer moves? Here's why I ask:
I want to "intercept' the Click event and/or the Up/Dn arrow keys
before the pointer moves so I can detect if any changes were made to
the original record.
I tried code in the InteractiveChange & Click events, but it seems
these events occur only AFTER the record pointer moves to the new
record. I also tried using the Valid event, but Valid doesn't seem to
fire at all.
I eventually kludged it to return to the original record to detect the
changes, then back to the newly selected record, but I feel there must
be a better way. Is there?
Steve M. Tag: Web Service Tag: 227548
Hi All
How Can I Return Xml Web Service Written In FoxPro To Using In Vb.Net
I mean Return Xml ADO.NET Dataset Using XMLAdapter,.TOXML()