how to pass bulk array content to Excel cells ?
In C# can pass this.xlApp.Cells[ nRow, nCol ] = array, how to pass array
values in VFP ?
Currently i loop through the array element and pass array value one by one
into excel cell.
Thanks Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220720
String too long error
Hello,
There is a Editbox that contains a Memo field. In the Fox 6 version you
could type a few lines of text and you can have it print on a report.
In the Fox 9 version however I get the error message String is too long to
fit when I try to print it.
Is there a way to specify a character limit in a memo field? Or any other
way to tackle this problem? Maybe at the report level? Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220712
Resource file version mismatch
Hi Group...
My Executables of VFP show this error once I try to run them...
a Messagebox with title "Error"
"Resource file version mismatch "
Then another messagebox title Microsoft Visual FoxPro
"Visual Foxpro cannot start. Could not load resoures."
I've already tried removing and renaming foxuser.dbf but the problem
persisits.
VFP Versions: 8SP5 and 9SP1
OS: Windows XP Professional
Processor: Pentium 4 HT
Extras: New LapTop
Do you have an idea what is going on?
Any Comment is greatly welcome.
Thanks in advance
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
L.Ortega
El Paso Texas
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220710
MsChart Control 6.0 question
Hi;
would someone be able to tell me what I am doing wrong. I would like to use
the MsChart control (not graph wizard) to create a few charts through either
tables or arrays. Their is a sample in the help file which gives me a clue.
Once I figure it out, I can go more complex. The following code works and
gives a horizontal line at points 10, 20, 30:
thisform.olecontrol1.ChartType = 3
thisform.olecontrol1.ColumnCount = 1
thisform.olecontrol1.RowCount = 3
thisform.olecontrol1.column = 1
thisform.olecontrol1.row = 1
thisform.olecontrol1.Data = 10
thisform.olecontrol1.column = 1
thisform.olecontrol1.row = 2
thisform.olecontrol1.Data = 20
thisform.olecontrol1.column = 1
thisform.olecontrol1.row = 3
thisform.olecontrol1.Data = 30
The following (using an array) gives 3 points at about 2, 72, & 52. Could
someone please let me know what is wrong and where I could find some GOOD
examples. Thanks.
PUBLIC chartarray(3,1)
chartarray(1) = 10
chartarray(2) = 20
chartarray(3) = 30
thisform.olecontrol1.ChartType = 3
thisform.olecontrol1.ColumnCount = 1
thisform.olecontrol1.RowCount = 3
thisform.olecontrol1.dataMember = chartarray
TIA. Mike. Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220709
APPEND FROM does not work as Import wizard
I am trying to import a text file with the following sintax:
APPEND FROM file.txt DELIMITED WITH CHARACTER |
I have VFP with SYSFORMATS ON, witch is the same configuration of the
txt file (point=',' and separator='.').
When I append the file with this command, he imports the numbers
greater the 999 wrong, as they have a dot(.) as group digit. For
example, the number 12.498 will be imported as 12 (small number like
653 is imported as 653). With this command it imports de decimal fields
correctly, for example, 0,9 is imported as 0,9 correctly.
When I use the import wizard for text files, it now imports the
thousands correctly but loses the decimal numbers, for the example
above, we would see something like this: filed 1:12.498; field 2:653;
field 3:0,0.
Can anyone help me? I would like to do it programatically, since i will
have to import several files several times.
Thanks,
Guga
--
gmendes
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------ Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220700
Writting an application to learn chinese in VFP
Hello:
I use VFP7 SP1 and am writing an application which must read chinese
traditional and simplified texts using TTS.
I'd done this in english and spanish using Ms Agent. Now in chinese I dont
know how to do it. I dont know TTS chinese engines as microsoft offers.
Does some one can help me?
With best regards.
Alejandro Fernandez Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220693
Consume SOAP Web Service Without SOAP Toolkit
I understand that the soap toolkit 3.0 is depreciated and all future
development should use the .net framework...
How would I do something like the following from a fox pro consumer using
the .net framework only and not the soap toolkit 3.0 or the psuedo soap 3
tool kit integrated into the current release of fox pro?
objws=CREATEOBJECT('mssoap.soapclient30')
objws.MSSoapInit('http://localhost/SomeWs/myWs.wsdl')
objReturnVal=objws.WebMethod1('DummyOne','DummyTwo',
'Value',"'Value','Value'")
?objReturnVal Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220689
ThumbCtl ActiveX Control
I'd like to use the thunbnail viewer that comes with XP to view a group of
images based on a certain criteria in my distibuted app. I've added the
control to my form but need to know what parameters, methods/events and what
syntax to use to get the results I want. Anyone have an example of it's use?
Thanks so much for your time and help. Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220688
Simple change to FFC resize object
To use the FFC Resize class, you simply add the class to your form, and
call the 'adjustcontrols' method of the Resize object in the form's
"Resize" event. Seems to work well.
How about the alternative: Add the following code to the Init of the
Resize class:
--------------------
DODEFAULT()
BINDEVENT(thisform, "Resize", this, "adjustcontrols", 1)
---------------------
Seems to work just fine. Any reason not to do it this way other than
'inverse coupling' the object to the form, instead of the form to the
object. Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220685
Centering label in a form
In VFP6. I have a label in a form and I change the caption and font
after an action. Is there any way to center the revised caption, similar
to the autocenter property of a form ? There does not seem to be a
similar property for a label.
--
Tim Hobson Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220680
Re: ERROR Creating OLE Object
Ooooooooops! I forgot to specify that I'm working with FPW 2.6
Sorry.
"shmiel" <shmiel@tiscali.co.uk> wrote in message news:...
>I have the following line in my program which worked fine for many years
>until recently.
>
> APPEND GENERAL PICTURE FROM <Name of Bitmap File eg "9999.BMP">
>
> Now I get the the following message "Error creating OLE object"
>
> I have tried this interactively with a new table and get the same result.
>
> Please HELP!!!
>
> Thank you.
> Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220679
ERROR Creating OLE Object
I have the following line in my program which worked fine for many years
until recently.
APPEND GENERAL PICTURE FROM <Name of Bitmap File eg "9999.BMP">
Now I get the the following message "Error creating OLE object"
I have tried this interactively with a new table and get the same result.
Please HELP!!!
Thank you. Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220678
Validating a Date in a Text box
hi again, i am looking for a simple way to Validate the data entered into a
textbox is a valid date.
if they enter 010106 it should stop them and make them enter 01012006
if they enter 01010000 it should evaluate that to be wrong also. is this
possible?
well i know it is, currently i have set century on. My biggest problem is,
this box is used for mostly char entry, so id like to keep it that way.
i thought that using this.value = ctod(' / / ') would do it but no such
luck.
thanks agaiin. Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220676
Doug Henning at Chicago FUDG on 14 Feb 06
The February Chicago FUDG Meeting will be a Webinar on Stonefield Query.
Doug Hennig is the author of Stonefield Query and of the Stonefield Database
Toolkit and a guru of gurus. Doug wrote the Cursor Adaptor builder that is in
VFP 9. Check out his site at <http://www.stonefield.com> Or attend the
February 14th Foxpro Users and Developers Group meeting.
Doug says it's not cold enough in Chicago in February. He'd rather stay home
in Winnepeg Saskatchewan. Instead he'll be available via streaming video and
Skype phone at our meeting.
Here is more on the new release of Doug's Stonefield Query which will be
discussed in detail at our meeting:
The Report Wizard has been replaced with a more powerful and user-friendly
Reports Explorer.
Role-based security is available for report folders, individual reports,
fields, and tables.
The Advanced Report Designer was overhauled and includes a new _Expression
Builder.
Creating a setup executable is now a snap with the built-in setup generation
tool.
http://www.stonefieldquery.com/devedfeatures.html
This is our first meeting where we bring in a guy from another part of the
globe without paying the air fare. Let's see if webinars are the shape of
things to come.
Same time and place. See you there? Tuesday Feb 14th, 5:30 pm. Room 826 in
the Monadnock Building in the Chicago Loop. 53 W. Jackson Boulevard.
http://www.ChicagoFUDG.com
--
Message posted via http://www.dbmonster.com Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220672
[OT] User-Defined string Functions Transact-SQL <-> VFP
Ladies and Gentlemen,
I am pleased to offer, free of charge, the following string functions
Transact-SQL:
AT(): Returns the beginning numeric position of the nth occurrence of a
character expression within another character expression, counting from the
leftmost character.
RAT(): Returns the numeric position of the last (rightmost) occurrence of a
character string within another character string.
OCCURS(): Returns the number of times a character expression occurs within
another character expression (including overlaps).
OCCURS2(): Returns the number of times a character expression occurs within
another character expression (excluding overlaps).
PADL(): Returns a string from an expression, padded with spaces or
characters to a specified length on the left side.
PADR(): Returns a string from an expression, padded with spaces or
characters to a specified length on the right side.
PADC(): Returns a string from an expression, padded with spaces or
characters to a specified length on the both sides.
CHRTRAN(): Replaces each character in a character expression that matches a
character in a second character expression with the corresponding character
in a third character expression.
STRTRAN(): Searches a character expression for occurrences of a second
character expression, and then replaces each occurrence with a third
character expression. Unlike a built-in function Replace, STRTRAN has three
additional parameters.
STRFILTER(): Removes all characters from a string except those specified.
GETWORDCOUNT(): Counts the words in a string.
GETWORDNUM(): Returns a specified word from a string.
GETALLWORDS(): Inserts the words from a string into the table.
PROPER(): Returns from a character expression a string capitalized as
appropriate for proper names.
RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right
search.
ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified
numeric expression (from 1 to 3999).
ROMANTOARAB(): Returns the number equivalent of a specified character Roman
numeral expression (from I to MMMCMXCIX).
AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL
INSTR, LPAD, RPAD, TRANSLATE, INITCAP.
Plus, there are CHM files in English, French, Spanish, German and Russian.
Plus, there are versions for SYBASE ASA, DB2, Oracle, MS SQL SERVER 2005
SQLCLR.
More than 8000 people have already downloaded my functions. I hope you will
find them useful as well.
For more information about string UDFs Transact-SQL please visit the
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
Please, download the file
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
With the best regards. Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220668
Licensing
Folks,
A prime advantage of Fox has always been its licensing policy. Once you
purchased the original development edition you could produce
applications which would run free of any extra charges (royalty free).
My impression is that this has changed in the more recent versions. I
haven't been able to find the information on the official MS site.
Is my summary of VFP licensing correct? Are there changes? If so, what
are the new restrictions?
There is a good chance this discussion has transpired more than once.
If so it would be nice to have a pointer to where I can find those
threads or web pages.
Appreciatively,
John Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220666
Character translation
In order to be able to send Japanese mails from my VFP application, I need
to translate a Japenese string encoded as SHIFT-JIS to ISO-2022-JP. I found
this library iconv.dll that should be able to do that but I can't get it do
anything in VFP. Does anybody have experience with this?
Robert Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220663
timer and report with >1 page
I have a timer working in the background, which is checking for new
messages in table1 -every 30 minutes. If at the same time somebody
preview a report with more than 1 page and is trying to change page -
report preview is disappearing....:-(
I know it's because timer is changing current cursor (reports are used
public dataenvironment), so i try to disable timer before report shows
and enable after - works OK , but in this case if user will open any
report in <30 min will never get messages prepared by timer...
Is there a way to store curent "time to fire" of timer so it could
start not from 0 ?
Or maybe somebody have better idea how to get rid of this report
behavior ? (I don't want to change it to use private dataenvironment)
Thanks,
Adam Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220652
How to determine if a DLL exists or is installed
Hi,
Is there a way to determine if a DLL exists or is installed?
Most reside in Windows\System32 but some others are installed on
WINDOWS\WinSxS subdirectories.
Thanks.
Demetrios, Greece Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220651
February letter posted on the Fox website
http://msdn.microsoft.com/vfoxpro/letters/
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220644
Can't preview 2 reports at the same time?
I know report previewing has always been flaky with VFP, especially in the
IDE, but I just noticed that with VFP9 you still can't preview 2 reports at
the same time if you try to use right mouse to preview them. After spending
a bit of time with this, it appears to be a continuation of the mouse right
click crash bug. Open table. Create 2 reports that run against table. Open
both reports in report editor. Right click a report, select preview. Right
click other report, Menu manager internal consistency error occurs.
Faulting application vfp9.exe, version 9.0.0.3504, stamp 436c14ff, faulting
module vfp9.exe, version 9.0.0.3504, stamp 436c14ff, debug? 0, fault address
0x0021ab95
Happens with VFP9, VFP8, VFP7. Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220642
Field display on report question?
Hi,
Using VFP 9.0. I'm designing a simple report for one of my tables and I'm
seeing something that seems odd to me. The field expression is:
alltrim(lname) + ", " + alltrim(fname)
So I should get 'lname, fname' on my report.
It seems to be working except where fname is null, then I just get .NULL. on
my report. I would have thought that if it were null then I'd just get
'lname, ' out on my report but instead I only get .NULL.. Can anyone shed
some light here?
Thanks,
Linn Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220638
Transforming a number
if i wanted to show on a frinted for the last 4 digits of an account nuber or
a ssno number or any number, what is the best way to do this. Transform does
not seem to be the correct function. Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220633
problems with installshield in 9.0
I am attempting to install build an install exe for vfp 9.0 runtime.
When I run the exe on a machine that does not have 9.0 dev installed it
chokes with the message "Visual Foxpro could not start. Could not load
resources":
I looked through postings here and found several suggestions and
solutions that worked for others, such as
1. don't forget the vfp9r.dll
2. include the c## libraries
3. just copy the runtime dll into the exe directory and that is all
you need.
4. be sure to register the dll
5. don't register the dll.
At this point I am confused. I have tried all of the above and still
it doesn't work.
I have manually registered the dll and that didn't help.
Is this an XP issue??? I have used the installshield with 7.0
distributions with no problems.
Which c## libraries should I be including?
Which boxes should be checked in the redistibutables section??
help??? Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220621
Dialog error message
What would cause the following message to appear when a user is running an
application I've written? I've not had it with other users running it.
The user has an AMD processor with 523,000 KB mem running Windows2000
Professional.
Error message: "Unable to open dialog"
They then click on OK and continue with the program and all appears to work
fine. It seems to have no consistent time it does it.
Rusty
OGES Systems Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220618
FPD and VFP 9 running on Vista - Proof of Concept.
http://blog.jlcconsulting.com/PermaLink,guid,a4c0d684-e0bb-4338-b7c5-5409474
79f72.aspx
Whew! I'm glad Juan's shown it to work - I had scheduled a pass/fail series
of tests for later in the month.
Mondo Cool!
regards [Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220615
Read from text file
I have a text file with e-mail addresses seperated by Return key
(chr13). I need to import the e-mail addresses into a table. To do
this, I created a table with one C(100) field and was able to execute:
append from textfile.txt type SDF with VFP6.0. All data got imported
ok. However, when I do the same command in VFP9.0, all e-mail address
in the table displayed as a square box - unrecognized character. What
did I do wrong?
-jesk Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220612
Attempting to Automate VSS 2005 w/ VFP9
I'm revisiting a problem that stumped me years ago.
I'd like to automate the sharing of project files within the VFP IDE through
VSS Automation, and everything's good to go except for the VSS "add file to
source control" dialog - I'm hoping I might be able to use some of the new
functionality VFP9 to get past this.
Here are some options AFAIK:
VSS's IVSSEventHandler interface - but would have to write a separate DLL.
BindEvent() - to trap windows messages and perhaps get a reference to the
dialog window.
EventHandler() - but so far, I don't have a COM object to attach to.
I think I need to get a reference to the dialog window's hWnd and do
something like a SendKeys or a SendMessage, but the VSS automation doesn't
seem to expose any objects I can grab a hold of.. Would appreciate all
suggestions.
Thanks.
--
William Fields
Code Contortionist
MCSD - Microsoft Visual FoxPro
US Bankruptcy Court
Phoenix, AZ
".dll hell - .rpm hell - whatever.
The grass is always greener" Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220611
How to append a Word doc to a general field and display it as an icon
I need to append a word document to a general field and display it as an
icon and edit it in word when you double-click it.
The default option when you use the command "Append General <generalfield>
From <file>" is to display the file content and edit it inside the
oleboundcontrol. The only way I found to do this, is to check the "Show as
an icon" option of the "Insert Obeject..." menu in the Create from file tab.
Is there a way to do the same but programatically with the "Append General"
command ???
Thanks in Advance !!!
Best Regards,
Geo L. Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220606
IDE annoyance
In the Project Manager, Data tab, with Project Manager docked:
Select a table in a db and double click on it. The Table Designer opens and
operates normally.
Close the Table designer, select a table again and press Enter. The Table
Designer opens, but the window is not movable.
</bitch> Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220596
Even Trigger Library for Monitoring a Folder
This is a multi-part message in MIME format.
------=_NextPart_000_0060_01C629D7.5910D2A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All,
I have an application that will dump a whole bunch of file to a Folder, =
I need to find an ActiveX or a library I can use from VFP9 that will =
monitor this folder and trigger an event whenever a file is being =
dropped in this Folder. =20
I know I can use a VFP timer to do just that but wanted to see if =
somebody know of a better way of doing this with a library instead of a =
VFP Timer.
--=20
Edhy Rijo
www.progytech.com
Bronx NY
------=_NextPart_000_0060_01C629D7.5910D2A0
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.2802" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have an application that will dump a =
whole bunch=20
of file to a Folder, I need to find an ActiveX or a library I can use =
from VFP9=20
that will monitor this folder and trigger an event whenever a file is =
being=20
dropped in this Folder. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I know I can use a VFP timer to do just =
that but=20
wanted to see if somebody know of a better way of doing this with a =
library=20
instead of a VFP Timer.</FONT></DIV><FONT face=3DArial size=3D2>
<DIV><BR>-- <BR>Edhy Rijo<BR><A=20
href=3D"http://www.progytech.com">www.progytech.com</A><BR>Bronx =
NY</DIV>
<DIV> </DIV>
<DIV></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0060_01C629D7.5910D2A0-- Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220586
Upgrade from FPW/DOS 2.6 to VFP6.0
I'm preparing to upgrade an application package that uses Foxpro 2.6 for
Windows/DOS, to a newer package that uses Visual Foxpro Version 6.
I have an opportunity to buy a used Upgrade version of VFP 6. Would
that version consider the old Version 2.6 a qualifying version for
upgrade purposes?
Thanks for your help.
Lakeside Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220575
SHARE_INFO_2
Hi everyone,
I am trying to add a share in my system automatically, does anyone have
a sample of the structure or an example of NetShareAdd
Thanks in advance
Tanya Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220567
Parent Child Data Entry w/ CursorAdapter & SQL Server 2005
Hello,
Environment:
VFP9.1
Using Cursor Adapters to access data on SQL Server 2005 using ADO
Challenge:
When adding a new 'parent' record, how can I get the primary key, so
that I can set a foreign key when adding a new 'child'?
Are we restricted to creating the parent, then attempting to save
before adding child data? Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220566
Simple Changes in VFP
These are a couple of little things that really would simplify my life....
When you open the Class Browser...please open to the same folder as last
time and NOT to the current folder. All my classes are in one folder. I
hate having to scroll back to that folder each time.
The class browser opens in full screen sometimes and to another window size
sometimes. This is annoying.
The report controls toolbar should remain on the screen each time you open
the report designer. Same for the layout toolbar.
Thanks for listening,
John.
p.s. I'm using VFP8, maybe Ver 9 fixes this stuff. Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220562
split a string!
Hi,
I have a string which has the full address in it. It also has a comma (,) to
seperate the address into line. I need to be able to read the string and then
split it up at the comma, but ignore passing the comma over. i.e.
I have:
34 Castle Road, Town, County
I need to split it so that i have:
34 Castle Road
Town
County
can someone please let me know the besh way to do this?
Many thanks in advance
Rob Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220559
display select query in window ?
If I run an query in prg file, say : select * from customers, I see the
result.
How can I view this query text "Select * from customers" after the prg is
run, without opening the prg file.
I actually want to view the last run query, not the result.
I tried following:-
Set talk on
Set talk to window mywindows
but it just give me: Selected 4 records in 0.00 seconds.
I tried using display memory but could not get it. any idea please ?
Best Regards,
Luqman Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220552
Timer in VFP COM DLL
I have written a VFP Multithreaded Com DLL and in my VCX lbrary, I have
created a shutdowntimer class based on the Timer Class. n this class I have
put code into the Timer Event to do what it needs to do.
I have put the folloing into my initianlisation code for the COM DLL:
PUBLIC ShutDownTimer
ShutDownTimer = CREATEOBJECT("ShutDownTimer")
ShutDownTimer.Enabled = .T.
ShutDownTimer.Interval=10000
However, the timer never seems to fire.
What am I doing wrong?
Cheers
David Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220550
VFP to .NET Resources
I keep trying to play with the .NET stuff and get incredibly
frustrated with most everything. Are there any resources out there
for a silly Foxpro guy that wants to learn .NET? I usually try and
learn a new Development environment by rewriting an existing
application, and I get slammed real quick in .NET [2005].
For example, is there a cross reference somewhere that says:
To Edit a PageFrame in VFP, right-Click->Edit. In .NET its a
TabControl and you get at the properties in a much different way.
I really do keep trying this offering from Microsoft, and I ain't
impressed. Seems like things have gotten much more difficult.
What happened to the KISS philosphy?
Thanks for any advice Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220547
How to Terminate a VFP COM DLL
I have a VFP 9 COM DLL which is working fine. However, whenever I go to
replace the DLL, I need to run IIS Reset to remove it from memory. I cant
rely on the calling application to neatly remove it.
I have put a timer into the DLL to check for a shutdown trigger but I am not
sure how to shut it down properly so that it is removed from memory.
If it was a VFP app, I would use omething like Cancel or Quit. Is this the
same for a COM DLL or is there some other way.
Cheers
David Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220546
SQL Query, difference between vfp7 and vfp9
This is a multi-part message in MIME format.
------=_NextPart_000_000E_01C62844.9B774550
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a table of donors, their donations and the dates of donations.
I want to produce a sql cursor of the total amount given by each person =
and the date of the last donation for each person, along with some other =
fields. I remember reading that the command syntax has changed in vfp9, =
something to do with Group By, but can't remember what the change was.
Is the correct sytax in vfp 9 this:
sele cdonor, sum(ndonation) as ntotal, max(dDate) as dLastDate, =
caddress, cgreeting from mytable into cursor printthis group by cdonor
Many thanks
Stephen
------=_NextPart_000_000E_01C62844.9B774550
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.2802" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I have a table of donors, their =
donations and the=20
dates of donations.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I want to produce a sql cursor of the =
total amount=20
given by each person and the date of the last donation for each person, =
along=20
with some other fields. I remember reading that the command syntax has =
changed=20
in vfp9, something to do with Group By, but can't remember what the =
change=20
was.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Is the correct sytax in vfp 9 =
this:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>sele cdonor, sum(ndonation) as ntotal, =
max(dDate)=20
as dLastDate, caddress, cgreeting from mytable into cursor =
printthis=20
group by cdonor</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_000E_01C62844.9B774550-- Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220539
More SQL
here is my code, as you can see i am running these in 2 queries. and then
into a report. my report references the queries TOM AND TOM1. the problem is
this, when i run the report, whch ever query is first, only shows the first
record oover and over. is there any reason for this? i know that the number
of records found could be more in one than the other..could that be the issue?
SELECT AGENCY,DEPT,COUNT(*);
FROM newmem ;
where empdate between gomonth(checkhdr.procdate,-1) and checkhdr.procdate
AND INLIST(dept,24,34,35,38);
Group by 1,2;
into cursor TOM1
SELECT AGENCY,DEPT,Count(*);
FROM newmem ;
WHERE empdate between checkhdr.procdate and gomonth(checkhdr.procdate,1)
AND (INLIST(dept,24,34,35,38));
Group by 1,2;
INTO CURSOR TOM
report form f:\lopvfp\newmem\listing.frx preview Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220531
Syntax error in remote view?
Hi,
I just spent yesterday and this morning defining a remote view on a SQL
database. It was working fine until I just tried to reload the view to
modify it. When I try to modify the view the view designer gives me a
syntax error followed by a "View/Query designer is unable to reload your
changes. Would you like to rebuild content from designer?" If I say, Yes,
it gives me a blank designer screen and if I select No, it displays the SQL
code but it's incomplete. If I run the view it works still even thought the
designer is blank.
Help! How can I recover my work? How can I tell what's wrong with the
syntax of the view and why didn't it warn me when I created the view? VFP 9
sp1.
Thanks in advance,
Linn Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220530
VFP6 Automated emails
Aplogize in advance if this is redundant. Have a program that runs at set
times. Need it to automatically send an email, with attached "csv" using
Outlook already configured. Any sample code?
- Ben Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220529
VFP9: report with PROMPT and Chaining
Hello.
Could somebody help me with a problem:
When chaining different reports in VFP9 into one printout
I'm not able to get printed a range of pages picked by
PROMPT dialog (it always prints all of pages).
I'm using of course NORESET NOPAGEEJECT keywords etc.
When prompted from print preview to print a range of pages - it works.
Another issue is with _PAGETOTAL variable - when chaining
report it never really works for me, when printing from a single
report - again it works.
M.Kujawa Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220526
VFP9: REPORTBEHAVIOR 90 - dot matrix printers major problem
Hello.
Can somebody confirm this?
I think - there is a major problem when printing on dot matrix printers
when using new object based reporting feature of VFP9 (reportbehavior 90).
Printouts are always too small or too large - never really match those
printed on laser or ink printers. Tried several dot matrix printer drivers
with
no success.
M.Kujawa Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220525
unexpected slowdown with many indexes
I have a local view with about 20 fields. For sorting purposes in a grid, I
have created an index tag on most of the fields. My problem is, some
operations become amazingly slow when all those tags exist. For instance, a
simple COPY TO can take 30 seconds, even though the view has at most a
couple thousand records, and usually far less.
If I delete the index tags, operations are as quick as they should be.
Anyone know what's going on?
--
You can reach me at: p one six seven k b r (remove spaces and convert words
to digits) at comcast dot net Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220514
VFP to nTier/ASP.NET 2.0
Hello,
I'm looking for and application framework that will help us migrate to an
nTier world in VFP as well as provide an application design that will ease
the transition/migration to an ASP.NET 2.0/.NET 2.0 world.
I know the Mere Mortals framework has versions for both VFP8 and .NET 2.0,
can anyone comment on these products or other products that may help in the
transition?
Thanks.
--
William Fields
MCSD - Microsoft Visual FoxPro
US Bankruptcy Court
Phoenix, AZ
".dll hell - .rpm hell - whatever.
The grass is always greener" Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220512
Utility to protect VFP6-9 executables from decompilation
Hi, all and especially Josh Assing
I have improved protection mechanism of beta version of Defox so it uses
different keys for each protected file. So, if you know how to unprotect one
protected file, it doesn't mean that you know how to unprotect another
protected file. And I believe, that it is sufficiently difficult to create
general unprotection utility.
Limitation: Every file included in exe must be less than 16Mb
Limitation of beta version: All protected programs will start with the
messagebox stating about protection. This messagebox will be removed in the
final release. Caution: few functions in protected executable may return
different result, so force program to work differently. These are
Program(-1), Sys(16) and may be some else. Except this, protected program
must work absolutely the same as original.
The utility is written in VFP6, so if you have VFP6SP5 runtimes, you may
download only executable (~240Kb)
www.grada.lv/defox/defoxb.exe
If you don't have runtimes, you may download install package (~3.7Mb)
www.grada.lv/defox/defoxb_setup.exe
All feedbacks both negative and positive will be greatly appreciated.
Sincerely,
Leonid Tag: How to do this: MyForm.sc* -> MyForm.vc* ? Tag: 220509
Hello!
Is there any simple method to transform existing form into a reusable class
embedded in the VC* file choosen by me?
Greetings!
--
--< pps >--
Re: How to do this: MyForm.sc* -> MyForm.vc* ? by dave>
dave>
Thu Feb 09 07:39:00 CST 2006
with the form open save as class form the file menu
"pps" <pps@icpnet.pl> wrote in message
news:7c6fc08631278c7fb9ad2459a5a@news.icpnet.pl...
> Hello!
>
> Is there any simple method to transform existing form into a reusable
class
> embedded in the VC* file choosen by me?
> Greetings!
> --
> --< pps >--
>
>
Re: How to do this: MyForm.sc* -> MyForm.vc* ? by Bernhard
Bernhard
Thu Feb 09 07:39:25 CST 2006
Hi pps
> Is there any simple method to transform existing form into a reusable
> class embedded in the VC* file choosen by me?
> Greetings!
Open your form and then try "File / Save as Class"