RE: DBC copier
There's one provided with VFP? (Tools\Gendbc\GenDBC.prg) Don't know how robust it is. m.v.g. Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Alan Bourke Verzonden: donderdag 4 december 2008 11:26 Aan: [EMAIL PROTECTED] Onderwerp: DBC copier Anyone know of a robust, free DBC copier app/routine/class that will take care of SPs, triggers etc, backlinks, the whole nine yards ? TIA ... -- Alan Bourke [EMAIL PROTECTED] [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: stored procedures in SQL
Also, you could download and install the MS SQL Server Management Studio Express This is the SQL management studio for the express editions, where you can manage the SQL-express DB http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D- 94B8-5A0F62BF7796displaylang=en Regards, Sietse SW-Software -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rafael Copquin Sent: 19 November 2008 00:19 To: Profox Subject: stored procedures in SQL Perhaps this qualifies as NF, but then, it is a pure VFP question. I am doing my first steps in SQL Server, using SQL Server 2005 Express edition. I just want to create a stored procedure in SQL Server, so I can do the following: Create a connection in a VFP form call the stored procedure (passing for instance a customer PK), so the procedure will return the customer name, address, email, etc. A very simple sql call. But how do you create the procedure in the SQL engine? Or should I ask this question in a SQL forum? TIA Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Does VFP have a Go To Definition feature like Visual Studio?
Found that the option of 'Create symbol definition table during search' in code reference options can affect search performance significantly. To increase speed I always uncheck it. What are your experiences? Regards, Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Stephen Russell Verzonden: woensdag 19 november 2008 16:10 Aan: [EMAIL PROTECTED] Onderwerp: Re: Does VFP have a Go To Definition feature like Visual Studio? On Tue, Nov 18, 2008 at 3:19 PM, Paul McNett [EMAIL PROTECTED] wrote: I like the Find All References as well. When your are testing a change, how do you quickly find all of the calls to this method and make sure that these calls are not messed up after the change. You have unit tests set up, of course! :) Oh yeah I do. In my case I am in itterative change work where I am adding functionality to the app for the new reason of the day. When I click on Find All references I can see all of the calls to this method across the entire solution. I always use multi projects in my solutions so this is great to see if this method is used outside of the area that your manager thinks. :) -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP 9 is starting off screen
Select Move from the context-menu then press an arrow key. The window will bind to the mouse-cursor allowing you to place it where you want. Regards, Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Garry Bettle Verzonden: dinsdag 4 november 2008 18:09 Aan: [EMAIL PROTECTED] Onderwerp: VFP 9 is starting off screen Howdy, Hope this email finds you all well. When I start VFP - 9.0 SP1 - it starts minimized. If I right-click and select, Restore nothing happens. I have to select, Maximize to get VFP to show. Move or Size don't work either. Is there a command to recover the screen? Cheers, Garry [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: PDF Watermarks
In an application of mine I use the pdftoolkit (http://www.pdfhacks.com/pdftk/) to split and combine PDF docs. In the manual it says it can also place a watermark or a stamp, but I've not used that functionality. Regards, Sietse Wijnker SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Graham Brown Verzonden: vrijdag 17 oktober 2008 12:51 Aan: [EMAIL PROTECTED] Onderwerp: PDF Watermarks Hi all I'm still trying to figure out a simple method to stamp a watermark onto an existing pdf via fox code Has anyone seen anything which will do this please. Cheers Graham --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP9 - ADIR
How about gnfile = ADIR(gafiles, ADDBS(cLocation) + '*.JPG') Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Sytze de Boer Verzonden: donderdag 9 oktober 2008 7:38 Aan: [EMAIL PROTECTED] Onderwerp: VFP9 - ADIR I'm having a brain fade at the moment (senior moment ?) In an app of mine, i need to find certain files. At design time, I may not know the location of these files, so I want to store this to a variable In help, it says gnfile = ADIR(gafiles, '*.DBC') In my case, this represents gnfile = ADIR(gafiles, '*.JPG') Assume, the variable reads K:\FILELOC\*.JPG I can't find a way for this to work SdB -- Regards Sytze de Boer Kiss Systems Ph: 64-7-8391670, Mob:021 937611, Skype: kissman2 www.kiss.co.nz --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP9 String too long
Hi, So if I'm reading your code correct you're adding the current content of the wofhist memofield twice? Repla wofhist With !!wofhist + /!! Inv # +Alltrim(Str(thinv))+' on '+Dtoc(invdate) + Chr(13) !! AddIt /!! Regards, Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Sytze de Boer Verzonden: woensdag 8 oktober 2008 3:14 Aan: [EMAIL PROTECTED] Onderwerp: VFP9 String too long Some of you may remember a problem I had a few weeks ago where I suddenly had error String too long to fit Many of you tried to assist but it now seems we were looking in the wrong area. I have now located the line in my program that does it It is Repla wofhist With wofhist + Inv # +Alltrim(Str(thinv))+' on '+Dtoc(invdate)+Chr(13) AddIt wofhist is a memo field thinv is an invoice number When I checked the len(wofhist) in the table, it returned some humongous number. i.e. it was filled with crap (about 20 records were so effected) Gosh, I feel a lot better now Sytze -- Regards Sytze de Boer Kiss Systems Ph: 64-7-8391670, Mob:021 937611, Skype: kissman2 www.kiss.co.nz --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP9
Hi Sytze LINENO() will not return a result in a compiled application where debug information was excluded (checkbox on the Project Info form) Regards, Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Sytze de Boer Verzonden: dinsdag 7 oktober 2008 8:20 Aan: [EMAIL PROTECTED] Onderwerp: VFP9 Why does the system report LINENO() only intermittantly ? (Within my error routine) I can't identify a pattern -- Regards Sytze de Boer Kiss Systems Ph: 64-7-8391670, Mob:021 937611, Skype: kissman2 www.kiss.co.nz --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Memory compaction/clean up
Ehrm... You are aware that using a variable to hold the contents of the file and then parsing it into an array will use two times the filesize? IMHO LLF functions are a better option. You can even display some progress message then. Regards, Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Lew Verzonden: donderdag 2 oktober 2008 5:01 Aan: [EMAIL PROTECTED] Onderwerp: RE: Memory compaction/clean up Oops. I wasn't paying attention to your statements. It has nothing to do with the array. Even though my original code used alines(aArray,filetostr(bigfile)), I broke it down to isolate the problem, so now I'm using cBuffer = filetostr(bigfile), then alines(aArray, cBuffer) ie 2 statements. It's the filetostr() that's failing as I originally stated. Nothing to do with the array. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Newbee - Best practice for ComboBox control with a list from an outside source
Hi Joe, You've missed one property: Style. Set it to 2 (Drop-down list box) in stead of 0 (Drop-down combobox) From the help: 'Drop-down combo box, which includes a list box and an edit box. (Default) The user can select from the list box or type characters in the edit box.' Regards, Sietse Wijnker SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Joe Yoder Verzonden: vrijdag 19 september 2008 1:04 Aan: [EMAIL PROTECTED] Onderwerp: Newbee - Best practice for ComboBox control with a list from an outside source My application builds a cursor, Customers, of customer names and ids from QuickBooks. I want my user to select a valid customer from that cursor via a ComboBox. That seems to work with ComboBox properties : BoundColumn = 1 ControlSource = Customers.Fullname RowSource = Customers.Fullname RowSourceType = 6 - Fields The form should initialize with the ComboBox initialized to the same customer as the previous transaction. I have tried initializing the ComboBox.value with the old customer name saved from the previous transaction and it appears to work but if the old customer name is no longer in the Customers cursor, some random? record gets overwritten with the old value. I will probably index the Customer cursor and have the initialization code set near on to seek for the old customer name, but I thought someone with experience might suggest a better/simpler approach. Thanks in advance for any comments - Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Helpful dual screen tips
An additional VFP tip: Show the project manager outside your VFP IDE on the 2nd monitor: ACTIVATE WINDOW 'Project Manager - Projectname' IN MACDESKTOP Regards, Sietse Wijnker SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens David Smith Verzonden: dinsdag 2 september 2008 17:21 Aan: [EMAIL PROTECTED] Onderwerp: [NF] Helpful dual screen tips I recently took the plunge into using dual screen monitors and thought I'd pass along a couple of hopefully-helpful tips . Screen resolutions: change the monitor driver from whatever the manufacturer driver is to Generic PnP monitor. This pretty much doubled the available screen resolutions available to me and allowed me to set the monitors at a comfortable setting. Background images: check out http://www.binaryfortress.com/displayfusion. there is a free version here that allows you to use single or multiple background images, have them automatically resize according to resolutions, and more. Just a nice tool for setting up dual screens that Vista doesn't have anything close to already built in. David Smith Systems Administrator Doan Family of Dealerships (585) 352-6600 ext.1730 [EMAIL PROTECTED] www.upstatedigitools.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: parse xml alternative ways
Why not use STREXTRACT()?
Following code loops through all section-node id's in the
specialInstruction-node
Then for each found ID it retrieves the node value and the calls the
FoundValue function
(Code is not tested, so syntax errors are possible/included)
HTH,
Sietse Wijnker
Code:
lcSectionXML = STREXTRACT(lcFULLXML, specialInstruction,
/specialInstruction, 1, 1)
lnPos = 1
DO WHILE .T.
lcID= STREXTRACT(lcSectionXML, [section id=], [], lnPos, 1)
IF EMPTY(lcID)
EXIT
ENDIF
lcValue = STREXTRACT(lcSectionXML, [section id=] + lcID +
[], [/section], 1, 1)
FoundValue(lcID, lcValue)
lnPos = lnPos + 1
ENDDO
FUNCTION FoundValue(cID, cValue)
*- Do your stuff
? cID, EVL(cValue, --empty node--)
ENDFUNC
/Code
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Namens Joerg Arand
Verzonden: woensdag 30 juli 2008 10:12
Aan: [EMAIL PROTECTED]
Onderwerp: Re: parse xml alternative ways
You own parser?
Find in a do while loop with
ATCatc('section id=production.shipping',lcXML)
all needet sections and extract them.
lcXML= your_xmlString
Lnstart=atc('section id=production.shipping',lcXML)
lni=1
Do While Lnstart#0
.. find end of this section and extract the value
lni=lni+1
Lnstart=atc('section id=production.shipping',lcXML,lni)
EndDo
Joerg Arand MD
assistant medical director
Neonatology
Children's Hospital
University Tuebingen
Calwer Str. 7
D-72076 Tuebingen
Tel.+49-(0)7071-2982211
Tel.+49-(0)7071-2980895 (office)
E-mail:Joerg.Arand(AT)med.uni-tuebingen.de
Stephen Russell [EMAIL PROTECTED] 29.07.2008 16:29
I have a column in a table that is like a vfp memo.
I have XML data stored there that will pull off and use all over the
place in our apps. I have to identify there is any value in the
production.shipping attribute.
XML data looks like so:
specialInstruction
section id=customerSuppliedShippingAccount/section
section id=customerCare/section
section id=finance/section
section id=production.general/section
section id=production.inventory/section
section id=production.packaging/section
section id=production.prePress/section
section id=production.printJob/section
section id=production.shippingPackage in Non-Mimeo Packaging; Use
appropriate FedEx Packaging/section
/specialInstruction
Currently I pull the data into ram, stuff it into the DOM and then do this:
XmlNode packageNode =
Node.SelectSingleNode(/specialInstruction/[EMAIL
PROTECTED]'production.shipping'
]);
if (packageNode.ChildNodes.Count 0)
sishipping.ShippingText = packageNode.ChildNodes[0].Value;
I may have 3, or 5 rows of this type of data to iterate through, in
that I can have 5 different Special Instructions attached to a single
order.
I just need the shipping data. This is the same extraction I use for
the top line customerSuppliedShippingAccount
Any other ideas?
TIA
--
Stephen Russell
Sr. Production Systems Programmer
Mimeo.com
Memphis TN
901.246-0159
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL
PROTECTED]@sw-software.nl
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
RE: parse xml alternative ways
Actually not really. My code offers you the possibility to react to each section, where yours only gives the 1st node. For exactly matching your example: cValue = STREXTRACT(cXML, [section id=production.shipping], [/section],1,1) cValue will be empty if the xml node doesn't exist or actually is empty. Regards, Sietse SW-Software -Oorspronkelijk bericht- That is similar to mine: XmlNode packageNode = Node.SelectSingleNode(/specialInstruction/[EMAIL PROTECTED]'production.shipping' ]); if (packageNode.ChildNodes.Count 0) sishipping.ShippingText = packageNode.ChildNodes[0].Value; ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
AllowCellSelection oddity was RE: Can I programattically set method code?
Hi Christof, I was recently working with a grid using the AllowCellSelection=.F. approach. In the grid, keyboard input of enter would confirm the selection. The escape should 'cancel' The enter comes in on the KeyPress event, but the escape doesn't. Any insights on that? Regards, Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Christof Wollenhaupt Verzonden: vrijdag 25 juli 2008 7:21 Aan: [EMAIL PROTECTED] Onderwerp: RE: Can I programattically set method code? Hi Rafael, but I disagree with your statement Admittedly, I worded this a little strong and provocative. g It's not just black and white. BTW, in your scenario of a grid I'd go with AllowCellSelection=.F. Then you only need code in the DblClick and KeyPress event of the grid, not in every single column. -- Christof [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Can I programattically set method code?
Hi Vince, The point that's made in the previous post about the bindevent, is that you write the code to bind to the dblClick once in the grid(class) and the never have to worry about it again, because when the grid runs, all controls in the grid delegate their dblclick to the grids method you specified. That way you don't have to visit each and every control to place your code there, or write a 'builder' to put the code you've otherwise put there manually. There's just no need any more to code the controls. Regards, Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Vince Teachout Verzonden: donderdag 24 juli 2008 16:03 Aan: [EMAIL PROTECTED] Onderwerp: Re: Can I programattically set method code? Ed Leafe wrote: On Jul 24, 2008, at 8:23 AM, Vince Teachout wrote: The binding happens at run time, but you code it at design time. That's what I thought it sounded like. What I was looking for was something that happens completely at design time. The goal being not to do anything for the user, but to automate some of my tedious design-time coding. ie, I want the code in the dblclick() method permanently, I just don't want to have to hunt down and code each one. In any event, I've saved the messages, and will play with Bind Events later tonight, as obviously my VFP knowledge is sadly lacking BTW, this is the way that most GUI toolkits work: controls emit events, and you explicitly bind to them. VFP simply gives you a shortcut of binding the event to the method of the same name. This is handy, but also leads to abominations such as putting tons of logic in the Click() method of a button. Cough. Cough. Oh, I'd never do that.. cough. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: How to create a .TXT
And missing in your list: SET TEXTMERGE TO And TEXT...ENDTEXT Maybe combined with FCREATE()/FOPEN into the _TEXT variable The TEXT...ENDTEXT option is imo a good solution if the formatting is important, because WYSIWYG. m.v.g. Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Allen Verzonden: vrijdag 18 juli 2008 14:11 Aan: [EMAIL PROTECTED] Onderwerp: RE: How to create a .TXT 1/ Create a var with your text and StrToFile it 2/ fcreate / fopen / fwrite or fputs fclose 3/ textmerge For formatting you don't say if its char fields or what. For numbers I prefer padl and date/datetime ttoc Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eurico Chagas Filho Sent: 18 July 2008 13:57 To: [EMAIL PROTECTED] Subject: How to create a .TXT Hi I have to create a formatted .txt, some data in specified columns, with pre-determinate sizes. What is a good way of doing it ? TIA, E. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Simple app questions
Is it a top level form? If not, make it so. Regards Sietse Wijnker SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Joe Yoder Verzonden: donderdag 17 juli 2008 1:32 Aan: [EMAIL PROTECTED] Onderwerp: RE: Simple app questions Okay - so now I get an app that displays nothing. I can see it is running with the task manager and kill it there. What do I need to do to get the form to display? TIA - Joe On Wednesday, July 16, 2008 7:02 PM, Sietse Wijnker wrote: Date: Thu, 17 Jul 2008 01:02:51 +0200 From: Sietse Wijnker To: [EMAIL PROTECTED] cc: Subject: RE: Simple app questions Hi Joe, Compile to an .exe to run standalone. When you compile to an .app the IDE is loaded prior to running the app. The included config.fpw in the .app is then ignored by the IDE ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Simple app questions
Place the Clear events in the same click-event code. Due to the Read events, the form is released, and all events are handled, but the event polling-'loop' isn't ended. This way the program is still running without any visual interface to actually end it. Furthermore, because it's a standalone exe now the QUIT command isn't needed in the main program. Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Joe Yoder Verzonden: donderdag 17 juli 2008 14:32 Aan: [EMAIL PROTECTED] Onderwerp: RE: Simple app questions Okay - I finally caught on that the API calls I'm making are messing with the system. When I disable the code that calls the APIs I can get the form to display but when I exit the form via Quit (thisform.release) the form disappears from the screen but Task Manager reveals that my simple app shows up as an application and as a process still running in memory. I need to kill both the app and the process before I can overwrite the .exe with a new compile. Here is the main program: DO FORM form1.scx READ events CLEAR events QUIT form1 has a Quit button with Thisform.release in the click event. What do i need to do to have the code exit cleanly? TIA - Joe What needs to be in the On Thursday, July 17, 2008 5:49 AM, Sietse Wijnker wrote: Date: Thu, 17 Jul 2008 11:49:27 +0200 From: Sietse Wijnker To: [EMAIL PROTECTED] cc: Subject: RE: Simple app questions Is it a top level form? If not, make it so. Regards Sietse Wijnker SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Joe Yoder Verzonden: donderdag 17 juli 2008 1:32 Aan: [EMAIL PROTECTED] Onderwerp: RE: Simple app questions Okay - so now I get an app that displays nothing. I can see it is running with the task manager and kill it there. What do I need to do to get the form to display? TIA - Joe On Wednesday, July 16, 2008 7:02 PM, Sietse Wijnker wrote: Date: Thu, 17 Jul 2008 01:02:51 +0200 From: Sietse Wijnker To: [EMAIL PROTECTED] cc: Subject: RE: Simple app questions Hi Joe, Compile to an .exe to run standalone. When you compile to an .app the IDE is loaded prior to running the app. The included config.fpw in the .app is then ignored by the IDE [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Simple app questions
Hi Joe, Compile to an .exe to run standalone. When you compile to an .app the IDE is loaded prior to running the app. The included config.fpw in the .app is then ignored by the IDE Regards Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Joe Yoder Verzonden: donderdag 17 juli 2008 0:40 Aan: [EMAIL PROTECTED] Onderwerp: Re: Simple app questions I have included a config.fpw file with the SCREEN=OFF line in the project. When I run the .app in a directory where the config.fpw exists, the form comes up as desired. If thee is no config.fpw file, the VFP environment comes up. I opened the .app with notepad and see that config.fpw shows up there. TIA - Joe ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP9 and Recno(0)
I've tested it and can reproduce your results in two ways: 1. The table is empty 2. The SEEKed valus exceeds the values in the table. F.i. the range in the table goes from 1 to 99, and the seek tries to find the value 100 HTH. Regards, Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Sytze de Boer Verzonden: woensdag 25 juni 2008 0:52 Aan: [EMAIL PROTECTED] Onderwerp: VFP9 and Recno(0) I don't know what I've done but I've upset my system where an unsuccessful SEEK does not give me a recno(9) i.e. recno(0)=0 my test code goes If !found() mf1=recno(0) mf2=recno() endif It returns mf1 with 0 -- Regards Sytze de Boer Kiss Systems Ph: 64-7-8391670, Mob:021 937611, Skype: kissman2 www.kiss.co.nz ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP9 and Recno(0)
Confirmed Here's my test-code CREATE CURSOR csrTest (cField C(15)) INDEX ON UPPER(cField) TAG cField lcValue = REPLICATE(F,15) SeekValue(lcValue) Returns 0 INSERT INTO csrTest VALUES (REPLICATE(A,15)) INSERT INTO csrTest VALUES (REPLICATE(C,15)) INSERT INTO csrTest VALUES (REPLICATE(D,15)) INSERT INTO csrTest VALUES (REPLICATE(E,15)) INSERT INTO csrTest VALUES (REPLICATE(G,15)) lcValue = REPLICATE(F,15) SeekValue(lcValue) Returns 5 lcValue = REPLICATE(A,15) SeekValue(lcValue) Returns found, 1 lcValue = REPLICATE(Q,15) SeekValue(lcValue) Returns 0 lcValue = REPLICATE(A,16) SeekValue(lcValue) Returns 0 lcValue = REPLICATE(F,16) SeekValue(lcValue) Returns 0 FUNCTION SeekValue(tcValue) ?seek ' +lcValue + ' IF SEEK(tcValue) ?FOUND, RECNO() ELSE ?NOT FOUND!,RECNO(0) ENDIF ENDFUNC Regards, Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Sytze de Boer Verzonden: woensdag 25 juni 2008 11:05 Aan: [EMAIL PROTECTED] Onderwerp: Re: VFP9 and Recno(0) Yippee, I think I got it I found that my form allows for a search string of 30 chars (lcSearch) After closing the form, my module said lcSearch is upper(alltrim(lcSearch)) The field on which the SEEK was done is C(15) Seek lcSearch returned recno(0) as 0 But, if I say lcSearch is upper(left(lcSearch,15)), the seek returns the nearest find in recno(0) Sietse (I have difficulty spelling that name), would you confirm my findings ? Thanks for the help On Wed, Jun 25, 2008 at 8:04 PM, Sietse Wijnker [EMAIL PROTECTED] wrote: I've tested it and can reproduce your results in two ways: 1. The table is empty 2. The SEEKed valus exceeds the values in the table. F.i. the range in the table goes from 1 to 99, and the seek tries to find the value 100 HTH. Regards, Sietse SW-Software -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Sytze de Boer Verzonden: woensdag 25 juni 2008 0:52 Aan: [EMAIL PROTECTED] Onderwerp: VFP9 and Recno(0) I don't know what I've done but I've upset my system where an unsuccessful SEEK does not give me a recno(9) i.e. recno(0)=0 my test code goes If !found() mf1=recno(0) mf2=recno() endif It returns mf1 with 0 -- Regards Sytze de Boer Kiss Systems Ph: 64-7-8391670, Mob:021 937611, Skype: kissman2 www.kiss.co.nz [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP8: Listbox Row Colors
Actually, using the RowSourceType of Popup it is possible. You can define the popup with DEFINE POPUP and then define the items with DEFINE BAR where you've got control over the colouring. Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens tanvir ahmad Verzonden: vrijdag 7 december 2007 6:17 Aan: [EMAIL PROTECTED] Onderwerp: Re: VFP8: Listbox Row Colors hi Friends i think alter net diffrent colour is not posible in list but it's posible in grid, in grid column dynamic back colour u give iif(condition, rgb(255,255,255), rgb(128,128,128)) On Dec 6, 2007 2:11 PM, Jack Skelley [EMAIL PROTECTED] wrote: Good Afternoon All: Is there anyway to make the rows of a list box alternate different colors to simulate green bar type paper and keep all the rows enabled? I can make the row disabled color green then I can't click on that row to get a more detailed view of the data displayed. Thanks! Regards, Jack Skelley [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: CHR() code for TAB character ?
I always type in ?INKEY(0) in the command window and then press the key/character I want Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Ed Leafe Verzonden: woensdag 21 november 2007 19:48 Aan: [EMAIL PROTECTED] Onderwerp: Re: CHR() code for TAB character ? On Nov 21, 2007, at 2:33 PM, Ailsom F. Heringer ((OSKLEN)) wrote: What is the CHR code for the TAB character ? You can find out the code for any character (well, at least those below 255) using the ASC() function. So: * There is a tab between the quotes ?ASC( ) = 9 -- Ed Leafe -- http://leafe.com -- http://dabodev.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: setting a form to autocenter based on a condition
Why not open up the property screen for the form, select the AutoCenter property and click the fx button. Then compose the expression _VFP.StartMode 0 This will result in the AutoCenter property that's evaluated when starting the form based on the StartMode. 0 = APP/EXE Regards, Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Grigore Dolghin Verzonden: donderdag 22 november 2007 10:53 Aan: [EMAIL PROTECTED] Onderwerp: Re: setting a form to autocenter based on a condition If _Vfp.StartMode 0 ThisForm.AutoCenter = .T. Else ThisForm.AutoCenter = .F. ThisForm.Top = 0 ThisForm.Left = 0 EndIf This goes in form's init. - Original Message - From: Jeff Roberts [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 22, 2007 12:13 AM Subject: setting a form to autocenter based on a condition Hi all, I've been doing a lot of development on my laptop lately, and screen space is tighter there. I've got an app that most all the form's autocenter property is set to true, and I'd like for that to be false when I'm running the app or form under the vfp ide. That way the form pops up in the middle of the customer's screen when they are running the exe but when I am working on the form it stays in the upper left, not underlapping with my command window, debugger, etc. Is there any way to set a form's autocenter property before it runs, or is there an alternative way to center the form? Thanks, Jeff [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: TRY CATCH
Hi, My guess is that you're having an illegal character in your code, because it's all screwed when reading your mail. In the Reply however it shows ok. I would code it like this: LOCAL llReturn Try *- If an error occurs, the rest of the code until the catch is ignored Open Database mydata Exclusive Set Database To mydata Pack Database llReturn = .T. Catch =Messagebox(Other users are currently logged in.,64,c_messagetitle) Endtry Return llReturn Regards, Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Ajoy Khaund Verzonden: dinsdag 23 oktober 2007 8:55 Aan: [EMAIL PROTECTED] Onderwerp: TRY CATCH In the INIT of a form I need to check if the dbc can be opened exclusively. If Yes proceed else a message to try later as other users are logged in. I am not sure of this TRY CATCH snippet. Try Open Database mydata Exclusive Set Database To mydata Catch lcFlag = .T. =Messagebox(Other users are currently logged in.,64,c_messagetitle) Endtry If lcFlag = .T. Return .F. Else Pack Database Endif Can anyone just help me. Something similar in Vfp6 was not a problem. A direct rebuild with Vfp8/9 did not work well. I wonder why. TIA Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785 001 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: [EMAIL PROTECTED] Mail: [EMAIL PROTECTED] Walking on water and developing software from a specification are easy if both are frozen. - Edward V. Berard, Life-Cycle Approaches [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Enforce width of column returned from SQL SELECT
Just to prove the theory that in VFP there are more ways to skin a fox; SELECT CAST(ADDBS(field) AS C(50)) AS myfield Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Paul Newton Verzonden: dinsdag 23 oktober 2007 13:40 Aan: [EMAIL PROTECTED] Onderwerp: Re: Enforce width of column returned from SQL SELECT Thanks Peter - I suspected something like that. In fact SELECT padr(ADDBS(field),LEN(field)) AS myfield works just fine ! Paul Newton - Original Message - From: Peter Cushing [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 23 October 2007 12:35:01 o'clock (GMT) Europe/London Subject: Re: Enforce width of column returned from SQL SELECT Paul Newton wrote: Hi all I have a table in which one field contains folder paths but if I do something like this SELECT ADDBS(field) AS myfield . the returned myfield column is much narrower than the original field width and so the paths get truncated. What is the best way to avoid this ? Try SELECT padr(ADDBS(field),50) AS myfield (or whatever width you want it) Peter [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: PRG vs VCX based classes for non-visual objects
Hi Dave, A bit of a sidetrack for printing out source code: For Visual Classes/Forms (but also prg's) a rightclick on the View Source Code button: Colored source code. Not exactly the colors-set in the IDE, but it's better than plain black source code. Also IMO the biggest problem in programming classes in a prg is the lack of intellisense for the 'this' memvar. This naturally can be overcome by the LOCAL This As thisclass of thisfile but it's more work. Anyone has build an intellisense script for that? Regards, Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Dave Crozier Verzonden: maandag 1 oktober 2007 16:41 Aan: [EMAIL PROTECTED] Onderwerp: RE: PRG vs VCX based classes for non-visual objects Of course printing out (does anyone still do that??) is easier with .prg classes and you do get to see the Whole of the code at once, but you can do this using the document view for both vcx and prg glasses by using #defines in the .prg classes to act as placeholders. Guess it's going to be one of those top/bottom post, spaces/tabs arguments that is never fully resolved! You may have opened a complete bag of worms here Mike. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael J. Babcock, MCP Sent: 01 October 2007 15:29 To: profox@leafe.com Subject: PRG vs VCX based classes for non-visual objects (I asked this recently but didn't get a responsevfp9) I thought Bo Durban had changed his GDI+ classes from VCX-based to PRG-based but I couldn't learn the reason why he did so...I thought it had something to do with performance but that didn't seem to make sense since once it's loaded in memory, it should be the same imo. Can someone comment as to why you would want to design a NON-VISUAL class in a VCX (other than preferring the GUI look for seeing the methods/events in dropdowns)? tia, --Michael [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: PRG vs VCX based classes for non-visual objects
Actually, yes (good point). Most of my work in prg-based classes involves invisible classes. The visual classes I do develop in a prg are involved in a factory that builds the form datadriven so no need for visually placing the controls. Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Paul McNett Verzonden: maandag 1 oktober 2007 22:23 Aan: [EMAIL PROTECTED] Onderwerp: Re: PRG vs VCX based classes for non-visual objects Sietse Wijnker wrote: Also IMO the biggest problem in programming classes in a prg is the lack of intellisense for the 'this' memvar. This naturally can be overcome by the LOCAL This As thisclass of thisfile but it's more work. Anyone has build an intellisense script for that? You don't find the lack of a visual layout designer to be a bigger problem than the (solvable) intellisense problem? -- pkm ~ http://paulmcnett.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: SET STEP ON in customer container method
Are there any lines that are executed after the SET STEP ON in the method or the calling event? If not, that's your answer. If there are, I know about as much as you do... Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Michael J. Babcock, MCP Verzonden: dinsdag 11 september 2007 20:13 Aan: [EMAIL PROTECTED] Onderwerp: SET STEP ON in customer container method I've got a SET STEP ON in a custom method of a container. I press Step Into after that and the trace screen (and all other screens in the debugger) go blank, as though I had resumed execution. My coworker has the same behavior. Anyone seen this kind of weird behavior in the debugger before? tia, --Michael [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: INT(15.0000) = 14 VFP8
Hi Ajoy, Here's my take on it: *- Calculate the time based today at 00:00 by adding the seconds to the datetime ltDateTime = DTOT(DATE()) + lnSec lcDiff = Padl(HOUR(ltDateTime),2,'0') + : + Padl(MINUTE(ltDateTime),2,'0') B.t.w. I didn't see the lnMin part change to 14. Regards, Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Ajoy Khaund Verzonden: woensdag 5 september 2007 5:18 Aan: [EMAIL PROTECTED] Onderwerp: INT(15.) = 14 VFP8 Hi All I have a function to convert seconds to hours minutes. Sending a value of 22500 Lparameters tValue *Converting seconds to Hours Minutes Local lnHour,lnMin,lcDiff lnHour = INT(tValue/3600) lnMin = INT((tValue - (lnHour*3600))/60) lcDiff = Padl(lnHour,2,'0') + : + Padl(lnMin,2,'0') lnHour comes 9 (OK), lnMin comes 14 (Must be 15) lnHour = INT(tValue/3600) lnMin = (tValue - (lnHour*3600))/60 lnMin = INT(lnMin) Here in Step lnMin is 15. In step 4 it becomes 14. Where am I going wrong. Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785 001 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: [EMAIL PROTECTED] Mail: [EMAIL PROTECTED] Walking on water and developing software from a specification are easy if both are frozen. - Edward V. Berard, Life-Cycle Approaches --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: More web services
Hi Al, I've got a possible solution for you, if you're using COM+. It's kind of a stretch if you've never used COM+ but it has some huge benefits. Try installing the COM-component IN COM+ on the DATA/File-server using local pathing. Then export the class from COM+ as an Application proxy Install this export on your web server. Now when calling the COM-object from ASP, the call is automagically routed through DCOM to the DATA-server where the actual code is run locally. Then the result is ported back through DCOM to the webserver/ASP-page. The benefit here is that the VFP COM object doesn't need to retrieve all the indexes/data over the network cable but is run locally. There's a slight overhead on the network for the call marshalling but in my experience this is far less thn retrieving all the indexes/data over the network for execution on the web-server. There's still a security issue because the settings for execution on the COM+ application are all done on the data-server. Most of the settings are disabled on the COM+proxy application on the web server. Maybe it's a trick to investigate on a dark rainy day...;) Regards, Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Al Verzonden: dinsdag 28 augustus 2007 14:32 Aan: [EMAIL PROTECTED] Onderwerp: More web services Hi Foxgang I seem to be getting a new problem every time the last one gets solved. Its web services again and Im getting to grips with it but the next bit Im stuck at. I can access the dll from the local user and see network drives but not from the web service. In fact all my assigns do not appear if I do drivetype. I assume this is rights but Im not sure how best to deal with it. It really a matter that the data is on another server and I need to access it. I have tried the RevertToSelf() api and it doesn't work. Can anyone please point me in the right direction. Maybe a setting on IIS to allow access ? TIA Allen No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.10/976 - Release Date: 27/08/2007 18:20 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Running a batch file from VFP MTDLL
What kind of OS is running your website? Can you instanciate the COM+ component using VFP? My guess is that the COM+ is securing the COM+ Application One extra step is needed: Go into the Roles section of your COM+ application. If there's a role present, edit it. If not create one. Then add the User/groups Everyone, ASPNET, IWAM_... to the Users section of the role Then try again from VFP and web-page Regards GL, Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Robert Jennings Verzonden: woensdag 15 augustus 2007 11:43 Aan: [EMAIL PROTECTED] Onderwerp: RE: Running a batch file from VFP MTDLL Sietse, I've carried out your instructions and the web page isn't working at all. I've given the component a admin account to run under. If I unload it and go back to the original dll it works. Only when it goes inside component services it fails. These are the steps I took before putting the dll into component services 1, I Stopped the WWW publishing service 2, I ran regsvr32 /u support.dll which succeeded. (checked that support.server was removed from registry) 3, I carried out your instructions below to the letter (Named the com+ application as support 4, I then started up the WWW publishing service 5, opened my browser and pointed it to the website. The browser reports a http 500 error. The webpage called is an asp page that contains %set oserver=server.createobject(support.server) Response.write(oserver.main())% That worked ok before I put the dll into the com+ applications I checked support.server properties and the CLSID, ApplicationID and DLL all look correct. What have I done wrong? Kind Regards Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sietse Wijnker Posted At: 14 August 2007 16:43 Posted To: Profox Archive Conversation: Running a batch file from VFP MTDLL Subject: RE: Running a batch file from VFP MTDLL Actually, it's suprisingly easy IMO. 1. Start Component Services (in administrative tools) 2. Drill down to Console Root/Componen Services/Computers/My Computer/COM+ Applications 3. Right Click on COM+ Applications, select New, Application 4. Click Next on the intro screen of the wizard 5. Click the 'Create an empty application' button 6. Enter a name for your COM+ app, click next 7. Specify the user (this is the user the application uses the credentials of), click next 8. Click Next, Next, Finish 9. Open the application you named, select 'Components' 10. Drag the DLL From Explorer into the left of the screen. This will register the COM classes of the DLL inside COM+ That's it. There are some possibilities for tweaking, but for the first usage this is all. Good Luck Regards, Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Robert Jennings Verzonden: dinsdag 14 augustus 2007 17:00 Aan: [EMAIL PROTECTED] Onderwerp: RE: Running a batch file from VFP MTDLL Ouch, That sounds complicated although getting that to work could help me out in other ways (like getting an application to protect data files from users) I'll have a look into the permissions and try to see what exactly is getting denied. Thanks Regards Robert Jennings -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sietse Wijnker Posted At: 14 August 2007 15:02 Posted To: Profox Archive Conversation: Running a batch file from VFP MTDLL Subject: RE: Running a batch file from VFP MTDLL The MTDll in ISS is instanciated uner the credentials of the IWAM_... user. This user has no rights outside the inetpub folder. Try putting the MTDLL inside a COM+ application, setting it up to impersonate. That way the MTDLL gets called from within IIS but runs under credentials you can specify (and during debugging it's not needed to reset IIS when updating the dll file) Regards, Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Robert Jennings Verzonden: dinsdag 14 augustus 2007 10:58 Aan: [EMAIL PROTECTED] Onderwerp: Running a batch file from VFP MTDLL Hi all, I've been banging my head against the screen for 2 days trying to solve this one:- I'm creating a batch file to create self extracting zip files which is working fine. This will package up Workstation, Application and Data files into a self extracting zip for application installation. I can run the following command from the command window ! c:\test\setup.bat 110 I can also run this ! lccommand (Where lccommand=c:\test\setup.bat 110 110 is a parameter for the batch file.) Both work fine. However, when I compile the code up as a MTDLL and create an object of the DLL and get IIS to run it the ! command doesn't seem to work. It causes a HTTP500 error. I've tried Shellexe to no avail. That returns error code 5 which is Access Denied, but everyone has full control in C:\test\ (for testing purposes) and the DLL can
RE: Running a batch file from VFP MTDLL
Actually, it's suprisingly easy IMO. 1. Start Component Services (in administrative tools) 2. Drill down to Console Root/Componen Services/Computers/My Computer/COM+ Applications 3. Right Click on COM+ Applications, select New, Application 4. Click Next on the intro screen of the wizard 5. Click the 'Create an empty application' button 6. Enter a name for your COM+ app, click next 7. Specify the user (this is the user the application uses the credentials of), click next 8. Click Next, Next, Finish 9. Open the application you named, select 'Components' 10. Drag the DLL From Explorer into the left of the screen. This will register the COM classes of the DLL inside COM+ That's it. There are some possibilities for tweaking, but for the first usage this is all. Good Luck Regards, Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Robert Jennings Verzonden: dinsdag 14 augustus 2007 17:00 Aan: [EMAIL PROTECTED] Onderwerp: RE: Running a batch file from VFP MTDLL Ouch, That sounds complicated although getting that to work could help me out in other ways (like getting an application to protect data files from users) I'll have a look into the permissions and try to see what exactly is getting denied. Thanks Regards Robert Jennings -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sietse Wijnker Posted At: 14 August 2007 15:02 Posted To: Profox Archive Conversation: Running a batch file from VFP MTDLL Subject: RE: Running a batch file from VFP MTDLL The MTDll in ISS is instanciated uner the credentials of the IWAM_... user. This user has no rights outside the inetpub folder. Try putting the MTDLL inside a COM+ application, setting it up to impersonate. That way the MTDLL gets called from within IIS but runs under credentials you can specify (and during debugging it's not needed to reset IIS when updating the dll file) Regards, Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Robert Jennings Verzonden: dinsdag 14 augustus 2007 10:58 Aan: [EMAIL PROTECTED] Onderwerp: Running a batch file from VFP MTDLL Hi all, I've been banging my head against the screen for 2 days trying to solve this one:- I'm creating a batch file to create self extracting zip files which is working fine. This will package up Workstation, Application and Data files into a self extracting zip for application installation. I can run the following command from the command window ! c:\test\setup.bat 110 I can also run this ! lccommand (Where lccommand=c:\test\setup.bat 110 110 is a parameter for the batch file.) Both work fine. However, when I compile the code up as a MTDLL and create an object of the DLL and get IIS to run it the ! command doesn't seem to work. It causes a HTTP500 error. I've tried Shellexe to no avail. That returns error code 5 which is Access Denied, but everyone has full control in C:\test\ (for testing purposes) and the DLL can create a text file in that folder. Any idea's? TIA Robert -- This email was sent to profox@leafe.com Unless otherwise agreed expressly in writing by Marine Software Limited, this communication and attachments are to be treated as confidential and the information in it may not be used or disclosed except for the purpose for which it was sent. If you are not the intended recipient of this communication you should notify the sender immediately [EMAIL PROTECTED] , then destroy it without copying, disclosing or otherwise using its contents. Marine Software Limited. Registered in England Wales. No 2576494 Regsitered Office. Unit3, Aylesham Business Pk, Aylesham. Kent. UK -- --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP-9 Grid column colors, revisited
Or, the same example using an array:
code
Local testform
testform = CreateObject(colorform)
testform.show(1)
Define Class colorgrid as Grid
DIMENSION aColors[3,2]
aColors[1,1] = Rgb(255,0,0)
aColors[2,1] = Rgb(0,0,255)
aColors[3,1] = Rgb(0,255,0)
aColors[1,2] = Rgb(0,0,255)
aColors[2,2] = Rgb(255,0,0)
aColors[3,2] = Rgb(255,255,0)
columncount = 2
height = 200
left = 24
top = 18
width = 320
column1.dynamicbackcolor = this.aColors[RECNO('testing'),1]
column2.dynamicbackcolor = this.aColors[RECNO('testing'),2]
*- Note the column# here!
EndDefine
Define Class colorform as Form
datasession = 2
Add Object grid1 as colorgrid
Procedure load
Create Cursor testing (col1 c(15), col2 c(15))
Insert into testing values (red, blue)
Insert into testing values (blue, red)
Insert into testing values (green, yellow)
LOCATE
EndProc
EndDefine
/code
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Namens Whil Hentzen (Pro*)
Verzonden: vrijdag 27 juli 2007 0:15
Aan: [EMAIL PROTECTED]
Onderwerp: VFP-9 Grid column colors, revisited
In a message long, long ago (Feb 07), Sytze asked about changing
different grid columns as well as rows with DynamicBackColor:
I have a grid with an INIT like:
thisform.Grid1.SetAll(DynamicBackColor,IIF(calltype=IN,
RGB(192,192,192),RGB(255,255,255)), Column)
This give me an easy way to differentiate an IN call from an OUT call,
on different ROWS.
It looks like this prevents me from having a specific COLUMN in a
different color from the rest. Is this true ?
Sietse Wijnker then responded:
The 3rd param in the SetAll method is to specify the class where the
property is set. In this case specifying the column-class isn't needed
because the DynamicBackColor property only applies to the columns.
The SetAll sets all columns DynamicBackColor property to the specified
value. If you want a specific column display in another color, you'll have
to reset the DynamicBackcolor property or at least alter it.
B.T.W. The expression in all the dynamic properties are evaluated in the
scope of the grid, not the column, so using 'this.' in the expression
refers
to the grid!
I'm trying to take this one step further. I would like to change the
backcolor of any cell in a grid. I've got a cursor supporting the grid,
with columns named c1, c2, etc., and an array of colors that map to the
cursor, like so:
col1 col2
row1 green red
row2 red yellow
row3 blue yellow
and want to use that as the dynamic back color for each cell in the grid.
And I'm close, oh so close
Option 1:
thisform.grid.setall(DynamicBackColor, ;
eval(thisform.aCellColor[recn('csrGrid'), ;
some expression],) ;
)
but no matter how much fidgeting I do, I can't get anything to work for
'some expression' that will return the column number in the same manner
as recn() works for the row number.
Option 2:
I've also tried spinning through each column, setting dynamicbackcolor
for just that column, but that has no effect:
thisform.grid.column1.dynamicbackcolor ;
= thisform.aCellColor[recn('csrGrid'),1]
but this puts the same color in every row - so column 1 is green for
rows 1-3.
Ideas?
Whil
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL
PROTECTED]@sw-software.nl
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Blank page 1 when printing from Acrobat Reader ActiveX
Hi all, In an CRM application I'm working on we're storing pdf docs linked to a customer. In the application we're letting the user view those PDF's using a form with a Acrobat Reader ActiveX (version 7.something) hosted inside a form. When viewing it in the form all is ok. Printing the document however, the first page is 'printed' blank. All other pages come out just fine. Loading the same doc in the Acrobat reader application and printing it from there results in a perfectly printed first page. I've tested using different settings in the print-dialog without any results. Anyone that has seen this before? BTW, the pdf's are merged from multiple single page PDF documents that are created by a scanner. The merging is done by programmatically using the Amyuni PDF Creator ActiveX. Regards, Sietse Wijnker --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Multiple Databases Same Name
Hi Jeff, I'm just trying to reproduce your problem. When setting the database active with SET DATABASE or OPEN DATABASE the right databae is activated. When opening the table using the dbname!tablename syntax the last opened database is queried first for the table, no matter what database is currently active. A workaround is selecting the DB, close it and reopen it before opening a table. Problem here is that already opened tables are automagically closed. However if you are using a procedure to open up all tables/views in a db with an unique alias this can help you out. Btw, Opening the tables using USE .\db1\databasename.dbc!table also refers to the correct table. Maybe you can rewrite the USE calls to semething like this: SelUse(table1, .t.) Function SelUse() LPARAMETER tcTableName, tcAlias, tlDatabase IF VARTYPE(tcAlias) C tcAlias = JUSTSTEM(tcTableName) ENDIF IF tlDatabase AND NOT EMPTY(DBC()) lcDB = DBC() SELECT 0 USE (lcDB + ! + tcTableName) ALIAS (tcAlias) ELSE SELECT 0 USE (tcTableName) ALIAS (tcAlias) ENDIF EndFunc Regards, Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Jeff Johnson Verzonden: vrijdag 18 mei 2007 20:17 Aan: [EMAIL PROTECTED] Onderwerp: Multiple Databases Same Name I have multi-site applications where the database name and table structures are the same and different sites are stored in different folders. Application\Site1\files.dbc Application\Site2\files.dbc Etc. I have been doing this for a long time, only now I have a new app that is consolidating data from all sites. VFP only recognizes one dbc name regardless of how many are open with that name. I can open .\site1\files.dbc and .\site2\files.dbc. I can SET DATABASE TO .\site2\files.dbc and it will not change from site1. This is related to a thread I started a couple of weeks ago about backing up a dbc. Does anyone know of a work around? I guess the only solution at this point is to modify everything to open up tables by full path rather than dbc!table. Jeff Jeff Johnson [EMAIL PROTECTED] 623-582-0323 Fax 623-869-0675 --- StripMime Report -- processed MIME parts --- multipart/signed multipart/alternative text/plain (text body -- kept) text/html application/x-pkcs7-signature --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Keyboards and Mice
I've been using the Ms Trackball Optical for 'bout 6 years now. http://www.microsoft.com/products/info/product.aspx?view=22pcid=10426173-9a ba-45eb-b7ce-af9ef9724d3dtype=ovr or http://tinyurl.com/6spde My previous employer left room for selection for keyboard and mouse/trackball when shopping for new office hardware. I've kept it with me ever since. My favorite keyboard is the MS Comfort Curve Keyboard http://www.microsoft.com/hardware/mouseandkeyboard/productdetails.aspx?pid=0 40 or http://tinyurl.com/a7sey It's got a slight curve and the feel of a laptop-keyboard which I like. Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Derek Kalweit Verzonden: vrijdag 4 mei 2007 16:31 Aan: [EMAIL PROTECTED] Onderwerp: Keyboards and Mice As developers, we spend a huge amount of time using our keyboards and mice. A keyboard/mouse combination can either help us get our work done quicker, or annoy us to no end... I'm kinda curious-- does anyone have any special keyboard/mouse hardware that they use to help them beyond the basic flat keyboard and standard scroll mouse that come with most computers these days? Personally, for the past 5-6 years, I've been using the Microsoft Natural Keyboard Pro: http://www.dansdata.com/nkpro.htm I don't think they still make this model. I switched to the ergonomic keyboards, as I started developing carpal tunnel from typing at the young age of 19!! These keyboards made the symptoms go away. I like this specific model, as the keys are in the correct position-- the insert/delete/pgup/pgdn block and arrow keys, particularly. I don't use the programmable keys much, except for one for the Windows calculator, one to bring up Windows Explorer, one for mute occasionally, and I re-program the top middle one as a quick button to lock my workstation(sure beats ctrl+alt+delete, enter). For a mouse, I've used trackballs since about 1998. Until recently, I was using the Logitech Trackman Marble FX: http://www.amazon.com/Logitech-TrackMan-Marble-FX-Trackball/dp/B0JBUI This is no longer made, and is considered by many to be one of the best pointing devices ever made-- the resale value of these on Ebay is very, very good. Thinking of which, I need to sell the two I have still... ;-) Recently, I really started wanting a scroll wheel which the device above lacks. I ended up with the Cordless Trackman Optical: http://www.logitech.com/index.cfm/products/details/SE/EN,CRID=2150,CONTENTID =5006 This gave me the finger-operated wheel that I prefer(I get symptoms of trigger finger in my thumb with the thumb operated trackballs). It includes the scroll wheel, and includes a few extra buttons. I had to get used to a slightly different layout for some of the buttons, but now that I've adapted, I wouldn't want to go back. I've re-programmed a few of the buttons-- the button originally programmed as a browser 'forward' button(why would anyone need that?), changed to double-click. There's also a button near the scroll wheel that I use as a 'minimize current window' button, which saves a considerable amount of time when juggling windows around(or rather getting specific ones out of my way)... Anyone else want to share? -- Derek [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Windows 2000 password
I've delt with that problem in the previous century. I used a small Linux bootdisk that could read a NTFS partition and reset the admin password. Don't know where I found that but I do remember I googled for it Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Kent Belan Verzonden: vrijdag 4 mei 2007 22:26 Aan: [EMAIL PROTECTED] Onderwerp: [NF] Windows 2000 password Hello, I have my sisters computer and need to find a way to get the password. Windows 2000 professional. Thanks, Kent [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Vista+context menu
Hi all, I've got a client who reports problem with the contextmenu in a VFP application on a Vista box. The context-menu has a second popup that's shown when a specific item in the context-menu is selected. The 2nd popup however is shown on the wrong side of the parent-popup so only the border of the 2nd popup is visible. The rest is rendered off-screen. Anyone heard of this and maybe has a solution/workaround? Sietse Wijnker --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/%(messageid)s ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Vista+context menu
Great, Thanks. Will monitor the feedback. Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Tracy Pearson Verzonden: donderdag 3 mei 2007 17:31 Aan: [EMAIL PROTECTED] Onderwerp: RE: Vista+context menu And now it's entered as a bug: https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?Feedba ckID=275450 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/%(messageid)s ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Collections and DLLs needing some help please
Hi Anthony, When you instantiate a COM-object, the interface is read from a Isomething interface definition. This definition is generated at compile time of the COM object. Now VFP is not a strong typed language where your stuff property is not typed as a collection. This means that the property is defined for your interface as a variant type. This will make VFP query the instance of the COM object-property for the actual type of the property. The Collection interface however is not defined, so it just knows it's an object. The properties or methods of that object are unknown. To solve your problem: try to type your properties using the COMATTRIB flags in the class definitions. Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Anthony L. Testi Verzonden: donderdag 19 april 2007 17:35 Aan: [EMAIL PROTECTED] Onderwerp: Collections and DLLs needing some help please I am using VFP 9.0 and am trying to return a collection from a DLL with no luck. Is there some trick that I am missing? For example I have created a DLL ( Named Junk2 ) that has one class (Junk) in one prg (test.prg) Code follows: DEFINE CLASS Junk as Custom OLEPUBLIC Stuff = null Foobar = null FUNCTION Init() this.Stuff = NEWOBJECT( [Collection]) This.Stuff.Add( [This is a test this is only a test] ) This.FooBar = [This is foobar] ENDFUNC Init ENDDEFINE As can be seen it has two class properties: -Stuff ( which in the init is made into a collection ) -FooBar ( Which in the init is made into a string ) I then wrote the following testing code: SET STEP ON X = CREATEOBJECT( [Junk2.JUNK] ) -- OPtion one does not work *X = NEWOBJECT( [Junk], [Test.prg] ) -- Option 2 works Z = X.FooBar Z = X.Stuff z = 1 When I do the X = NEWOBJECT( [Junk], [Test.prg] ) option I can see in the debugger that X.Stuff is a collection When I run the code X = CREATEOBJECT( [Junk2.JUNK] ) option X.Stuff is an object but not a collection. In both options x.foobar is a string as I expect. What am I missing? Anthony L. Testi [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Menu Prompt
I'm assuming you know the bar number and the menu-name: Just a new DEFINE BAR call with the new prompt will do the trick Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Andrew Stirling Verzonden: woensdag 11 april 2007 20:50 Aan: [EMAIL PROTECTED] Onderwerp: Menu Prompt Hi Is there a simple way of changing the 'prompt' message on a menu. Thus instead of having a prompt such as CalcPay Help it becomes oApp.prodname +' ' + help where oApp.prodname could be 'CalcPay' or even 'Pegasus' using VFP9. Thanks. -- Andrew Stirling 01250 874580 http://www.calcpay.co.uk HMRC Accredited UK payroll program [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@sw-software.nl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Date calculations.
Hmm, the start date isn't relevant. It's all about the difference so the ldDate1 = Date(2000,1,1) should not matter for the outcome. The ldDate2 = ldDate1 + tnTotDays + 1 seems fault to me. If you pass a value of 0 to the function, the difference should be 0 years, 0 months and 0 days. Adding the 1 to the equation would result in a difference of 1 day? Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens aihsan Verzonden: donderdag 29 maart 2007 12:01 Aan: [EMAIL PROTECTED] Onderwerp: RE: Date calculations. I think to get correct answer, two line should change like these: ldDate1 = DATE() ldDate2 = DATE() + tnTotDays ldDate1 = Date(2000,1,1) ldDate2 = ldDate1 + tnTotDays + 1 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Thursday, March 29, 2007 6:49 AM To: [EMAIL PROTECTED] Subject: Re: Date calculations. Sietse Wijnker wrote: And my stab at it: IMHO, less calculations, less problems FUNCTION verbosedate LPARAMETERS tnTotDays LOCAL lnYears, lnMonths, lnDays LOCAL ldDate1, ldDate2 ldDate1 = DATE() ldDate2 = DATE() + tnTotDays lnYears = YEAR(ldDate2) - YEAR(ldDate1) lnMonths = MONTH(ldDate2) - MONTH(ldDate1) lnDays = DAY(ldDate2) - DAY(ldDate1) ? lnYears, lnMonths, lnDays RETURN ENDFUNC [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Date calculations.
And my stab at it: IMHO, less calculations, less problems FUNCTION verbosedate LPARAMETERS tnTotDays LOCAL lnYears, lnMonths, lnDays LOCAL ldDate1, ldDate2 ldDate1 = DATE() ldDate2 = DATE() + tnTotDays lnYears = YEAR(ldDate2) - YEAR(ldDate1) lnMonths = MONTH(ldDate2) - MONTH(ldDate1) lnDays = DAY(ldDate2) - DAY(ldDate1) ? lnYears, lnMonths, lnDays RETURN ENDFUNC -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Vince Teachout Verzonden: woensdag 28 maart 2007 5:56 Aan: [EMAIL PROTECTED] Onderwerp: Re: Date calculations. Bryant Minard wrote: If I have variable (d = 397, the difference between two dates), how can I show that in years, months and days? (example 1 year, 1 month and 1 day) Has anyone written a function to do something like this? Here's how I'd do it: VerboseDate(397) FUNCTION verbosedate LPARAMETERS nTotDays LOCAL nyears, nmonths, ndays, nRemain nyears = nTotdays/365.25 nRemain = nYears - INT(nYears) nmonths = nRemain*12 nRemain = nMonths - INT(nMonths) nDays = (nRemain*365.25)/12 nYears = INT(nYears) nMonths = INT(nMonths) nDays = INT(nDays) ? nYears, nMonths, nDays RETURN ENDFUNC [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: File Copying Problems
Is there a virus scanner in place? Try to turn that off for a test-run. Maybe that is interfering in your process. Sietse Wijnker -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens John Weller Verzonden: zondag 18 maart 2007 16:57 Aan: [EMAIL PROTECTED] Onderwerp: File Copying Problems I've written a small app to copy a directory from one location to another as a backup and it's giving me the weirdest errors. Any enlightenment would be gratefully received. The directory being copied is D:\CELEBRATION FILE which is being copied to F:\Backup\ If I run as an app from the directory D:\COPYUTIL I get the following errors: One error is with the line COPY (tcSourceFile) TO (tcTargetName). The source file shows as D:\CELEBRATION FILE\SOURCECODE\PRGS\MAIN.FXP in Debug. The target name is F:\BACKUP\Mirror20070318a\SOURCECODE\PRGS\MAIN.FXP The error message is File C:\docume~1\john\locals#1\temp\main.fxp does not exist! Another is where two of the files being copied CONTROL.SCX, and CONTROL.SCT in the folder D:\CELEBRATION FILE\SOURCECODE\FORMS are shown as being in use - but they shouldn't be. This app uses a form CONTROL but a totally different folder. If I run as an exe from C:\Program Fils\CopyUtil I get the following errors: File 'c:\program files\copyutil\dbfs\about.dbf' does not exist. File 'c:\program files\copyutil\dbfs\logos.dbf' does not exist. File 'c:\program files\copyutil\forms\control.sct' does not exist. File 'c:\program files\copyutil\forms\control.scx' does not exist. File 'c:\vfp9 common code\graphics\h_point.cur' does not exist. Which is quite correct - they don't as they are components of the exe and exist in D:\CopyUtil\Sourcecode\. There are over 1500 files in the folder I'm copying and the rest copy without any problems. I'm baffled! But for the fact I hate being beaten I'd have replaced the lot by RUN XCOPY... John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Code references
Hi, Here's a time saver I just stumbled upon: I recently saw a post here about the Code References taking a long time to run. The answer was that de code references tool creates a cache table to all files searched that's also updated on each search that follows. You can speed up the search if you switch the creation of the reference-table. For that in the search dialog press the 'options' button, then uncheck the 'create symbol definition table during search' Regards, Sietse Wijnker --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Windows Desktop Search and VFP
Hi all, I've grown used to the Windows Desktop Search functionality to quickly find content on my system, but it lacks indexing for VFP code. After some research I found that it's possible to create an indexer that handles specific kind of files. Like there's a PDF iFilter that indexes the content for PDF files into the WDS search index. Nowhere however I could find even a reference for an iFilter implementation for SCX or VCX files. Has anyone here heard of some initiative like this? I've also looked for some samples of creating a VFP iFilter implementation myself, but the documentation on how to create one is also hard to find/understand. Anyone knows of some examples, preferably in VB/C#? Regards, Sietse Wijnker --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: rebuilding quickly for IIS-loaded COM objects/web services
Hi Derek, A better way for VFP/COM/Web development: Place the COM component in a COM+ Application environment. This way you can control what credentials are used to run the COMponent without setting that credentials on the website. Then in your build program: *- Shutdown COM+ app lcAppName = MyCom+ApplicationName objCatalog = CREATEOBJECT(COMAdmin.COMAdminCatalog) objCatalog.ShutDownApplication(lcAppName) That way the DLL is released without shutting down the entire website. Another cool feature: Install the COM component in COM+ on the server (let's say data-server) where the VFP data files are stored. Then export that application from COM+ into an Application Proxy and then install that proxy on the web-server The web server will the call the COM component as if it's local. COM+ will then take care of the communication of the requests and responses to the actual implementation on the data-server. It's like a DCOM call, but with better configuration options. Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derek Kalweit Sent: dinsdag 27 februari 2007 18:12 To: [EMAIL PROTECTED] Subject: rebuilding quickly for IIS-loaded COM objects/web services Hi. Usually when I develop COM objects/web services in VFP, I have to do an 'iisreset' before each build, as IIS holds on to the VFP COM object. I found a quicker solution to this that can easily put in a quick prg along with the build commands-- or use a project hook: * replace 'virtualdir' with the name of your virtual directory o = GetObject(IIS://localhost/w3svc/1/Root/virtualdir) o.appunload() This will greatly speed up my iterative development process, and thought I'd share this tid-bit in case anyone else is wasting time the same way I was... -- Derek [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Tracing (somebody else's) program flow tricks
When I log the current running program/function/method to the debug output, I always prefix it with the Call-stack depth : DEBUGOUT PROGRAM(-1), PROGRAM() Regards Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Whil Hentzen (Pro*) Sent: Wednesday, February 21, 2007 13:58 To: [EMAIL PROTECTED] Subject: Re: Tracing (somebody else's) program flow tricks Andy Davies wrote: Whil said: I want to see customer.init() customer.SetCreditLimit() customer.ProcessNewOrder() customer.DisplayOrders(). Separate methods. in debugo don't you get this in the call stack? Andrew Davies MBCS CITP - AndyD8-)# ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ** [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Clearing the Word Clipboard
Hi Robert, I ran and tested the code on word 2000. In office 2007 there's a toolbar named 'Clipboard' with indeed 0 controls, but there's also a toolbar named Office Clipboard. Maybe that does what you're aiming for in office 2003+? Regards, Sietse Wijnker. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tristan Leask Sent: dinsdag 20 februari 2007 10:34 To: [EMAIL PROTECTED] Subject: FW: Clearing the Word Clipboard Siestse, There are no controls in your first option and the second option doesn't work either. This is Word 2003. By some accounts Micro$oft took out the support for your second option in the release of 2003. Regards Robert ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Clearing the Word Clipboard
Hi, Depending to the amount of customization in the toolbars the following should work: ox.CommandBars(Clipboard).Controls(4).Execute Where ox is a reference to any Office COM-reference like Word.Application or Excel.Application I would recommend not using such a hard reference but would search for the correct button like this: #DEFINE msoControlButton = 1 oy = ox.CommandBars.FindControl(msoControlButton, 3634) IF VARTYPE(oy) = O oy.Execute() ENDIF Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies Sent: maandag 19 februari 2007 16:07 To: [EMAIL PROTECTED] Subject: Re: Clearing the Word Clipboard Hi, I haven't worked with Word automation but I have done some with Excel - in Excel if you rely on the macro editor you end up using the clipboard for stuff, but this is deprecated - the recommendation is to use the api directly. Word is probably similar. otoh you could try disabling the multiple clipboard in Word and then use _cliptext in fox to manipulate the normal clipboard. Andrew Davies MBCS CITP - AndyD 8-)# ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ** [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VPF-9 Grid column colors
Hi Sytse, The 3rd param in the SetAll method is to specify the class where the property is set. In this case specifying the column-class isn't needed because the DynamicBackColor property only applies to the columns. The SetAll sets all columns DynamicBackColor property to the specified value. If you want a specific column display in another color, you'll have to reset the DynamicBackcolor property or at least alter it. B.T.W. The expression in all the dynamic properties are evaluated in the scope of the grid, not the column, so using 'this.' in the expression refers to the grid! Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sytze de Boer Sent: vrijdag 16 februari 2007 4:48 To: [EMAIL PROTECTED] Subject: VPF-9 Grid column colors Hi Foxers Can someone help me ? I have a grid with an INIT like: thisform.Grid1.SetAll(DynamicBackColor,IIF(calltype=IN,RGB(192,192,192) , RGB(255,255,255)), Column) This give me an easy way to differentiate an IN call from an OUT call, on different ROWS. It looks like this prevents me from having a specific COLUMN in a different color from the rest. Is this true ? i.e. it does not show the color I specify. If I remove the dynamicBackColor factor, all is fine. Why is the SetAll clause referenced with Column when the effect is that the ROWS give me the colors I want. Sytze [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: C00000005 exception
And giving your comment on 'over the network', possibly the networkadapter, network cables or caching on the 'file server'? Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton Sent: woensdag 17 januari 2007 1:09 To: [EMAIL PROTECTED] Subject: Re: C0005 exception Chet Gardiner wrote: Can't a corrupted Foxuser file do this or is my memory faulty? Don't know about the Foxuser suggestion but I would have thought that faulty memory could well be a problem ... [EMAIL PROTECTED] wrote: Over and over using VFP 9 It usually happens after I run a query on a free table and attempt to close the SQL code - results a crash with this error. Just checked my VFP error log - 59 recorded events all with the same exception. I also have VFP8 loaded on this machine and haven't seen this happen once. Any suggestions? [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Strange error message
By the way, To see where the build errors out, there's another option to see what's goin on next to the 'Display Errors' checkbox: Open up the Debugger Output window during the build. This will echo some detailed messages during the process. Another option is to use SET DEBUGOUT, f.i. SET DEBUGOUT TO Build.txt BUILD EXE myApp.exe FROM (_VFP.ActiveProject.Name) SET DEBUGOUT TO MODIFY FILE Build.txt Has helped me numerous times sofar Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christof Wollenhaupt Sent: woensdag 10 januari 2007 13:50 To: [EMAIL PROTECTED] Subject: RE: Strange error message Hi John, You get the locking error, because your project contains a DBC (database) that is opened elsewhere, either on your machine or by an user of your application. VFP tries to recompile all stored procedures. To locate the faulty lines, enter OPEN DATABASE c:\pontotoc\pontotoc.dbc SET DATABASE TO pontotoc MODIFY PROCEDURE Probably the line with ENDIF contains some additional characters that have been inserted accidentally. -- Christof [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] New LAN solution
Hi, I'm on the point of replacing all LAN networking equipment at my home due to numerous problems where multiple devices (router, AP) have to be reset in order to get it working again. Also I've bought some new computers over the last years that have a Gigabit LAN, but my LAN equipment doesn't support it (100Mbit and 10Mbit). For that I need a new router with VPN, a WLAN AP (or both in one device) and a separate 8port or 16 port Gb switch. Does anyone have any tips/experience on make/models to buy or NOT to buy? Regards, Sietse WIjnker ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] New LAN solution
Hi Peter, Forgot to mention it, but i need a T1 router, not ADSL VPN passthrough means I need to install a separate VPN server, what I don't want I want to support VPN connections from and to the router. Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Cushing Sent: woensdag 10 januari 2007 17:13 To: [EMAIL PROTECTED] Subject: Re: [NF] New LAN solution Sietse Wijnker wrote: Hi, I'm on the point of replacing all LAN networking equipment at my home due to numerous problems where multiple devices (router, AP) have to be reset in order to get it working again. Also I've bought some new computers over the last years that have a Gigabit LAN, but my LAN equipment doesn't support it (100Mbit and 10Mbit). For that I need a new router with VPN, a WLAN AP (or both in one device) and a separate 8port or 16 port Gb switch. Does anyone have any tips/experience on make/models to buy or NOT to buy? I got one of these a while ago: http://www.pcwb.com/catalogue/item/LKSWL083 ADSL modem, wireless AP and 4 port switch with a free PCMCIA wireless card. Great value. Not tried out any VPN capability but it mentions VPN pass through. Peter [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: storing table info in tables
Hi Jeff, You can use SAVE TO MEMO to store any variables into a memo field So if you have a tblDefinitions table that has a cName and a mStruct field You can do the following to fill the table: LOCAL laFields[1] SELECT 0 USE tblSource1 AFIELDS(laFields, tblSource1) SELECT tblDefinitions INSERT INTO tblDefinitions (cName) VALUES (tblSource1) SAVE TO MEMO tblDefinitions.mStruct ALL LIKE laFields To recreate the tables defined in the tblDefinitions: CLOSE TABLES ALL LOCAL lcName USE tblDefinitions SCAN lcName = ALLTRIM(tblDefinitions.cName) RESTORE FROM MEMO tblDefinitions.mStruct ADDITIVE IF VARTYPE(laFields) U AND TYPE(laFields,1) = A CREATE TABLE (lcName) FROM ARRAY laFields ENDIF ENDSCAN Of course there are some path-issues in the provided code, along with some error handling, but it shows a possible way to do it. Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Sent: zondag 7 januari 2007 16:50 To: [EMAIL PROTECTED] Subject: storing table info in tables I need to be able to recreate free tables using information stored in tables. I know how to create tables using SQL statements but how would I pull the field [column - hate that about VFP!] information [column name, type, character/column length,... - all stored for reporting] to create a new table? jeff fisher, MCP www.turbofish.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: FW: Error Handling
Hi John, As far as i read your question and the conversation that followed, This is what I understand from your observations: 1. In a server VFP program an error is encountered 2. The error handling kicks in, as it should issuing a CLEAR EVENTS 3. you're expecting it to go straight through to the line after the READ EVENTS in your main program. but: it still executes some lines of code you didn't expect it to. Right? Then my question to you: What command is used to exit the error-handling? If it's handling from an ON ERROR routine, there are some possible scenario's If you're using a RETURN or even no command at all (as I'm expecting you're using), the line that triggered the error is ignored and the program continues to run UNTIL it finaly hits the wait-state. Then it notices that the wait state was cleared and continues onto the following lines. RETRY reissues the last line, so you're again in the errorhandling giving you an endless loop. CANCEL cancels the complete program, so that's probably not what you want for to quit gracefully. IMO you want a RETURN TO MASTER. This doesn't return to the executing procedure/program/method but goes straight back to the READ EVENTS. So the last lines in your error handling should be: CLEAR EVENTS Clear the wait state RETURN TO MASTER Return to the main program READ EVENTS. Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Weller Sent: vrijdag 5 januari 2007 23:29 To: [EMAIL PROTECTED] Subject: RE: FW: Error Handling I know exactly where and why it is bombing - there is a syntax error in an SQL command. The problem is that the SQL error has shown me that my error handling routine is not behaving as I expected. My query is - where am I going wrong with the error handler? As I explained in my reply to Ted, in this case it is a fault on my part but it could be an error caused by the backup app using the tables when my app needs to open them or move a file. So that the error won't lock up the system I need it to exit gracefully ready to try again 5 minutes later when, hopefully, the backup routine will have moved on. John Weller 01380 723235 07976 393631 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of john harvey Sent: 05 January 2007 22:20 To: [EMAIL PROTECTED] Subject: RE: FW: Error Handling Is it bombing at a the same place each time? If so, try-catch is a good solution. John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Weller Sent: Friday, January 05, 2007 4:15 PM To: profox@leafe.com Subject: RE: FW: Error Handling The process hasn't finished but has hit an error - typically unable to open a table as another app, probably a backup routine, has grabbed it. Basically I need ON ERROR QUIT but I really want something slightly less dramatic that will log an error and close gracefully. I expected that the CLEAR EVENTS command would return me to the READ EVENTS which has all the good stuff like on shutdown immediately after it. John Weller 01380 723235 07976 393631 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of john harvey Sent: 05 January 2007 21:58 To: [EMAIL PROTECTED] Subject: RE: FW: Error Handling If the process has finished, why not just do an - on shutdown, clea all, close all, quit? [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Input and html
Hi Virgil, How 'bout setting up some hidden input boxes, filling them with the values and reading those out in your saving routine? That way there's no labeling needed. For parsing the querystring variables: simple ASP test page: %@ Language=VBScript % % cVar1 = Request.QueryString.Item(var1) cVar2 = Request.QueryString.Item(var2) % html body var1: %=cVar1%br/ var2: %=cVar2% /body /html calling url: http://localhost/dnn/test/ASPTest.asp?var1=1234var2= Result: var1: 1234 var2: greetings, Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Virgil Bierschwale Sent: dinsdag 26 december 2006 5:12 To: [EMAIL PROTECTED] Subject: [NF] Input and html I've got a page that I want to grab the variables passed in the url link which are branch and unit. TO see it in acxtion, go to http://www.virgilslist.com Click on Navy Click on FF-1059 You will see a list of people in this group. Below that there are two fields in an input tag that say Do Not Change I want to grab the branch and unit and place them in those fields.. Then I want the user to fill in the rest of the fields and click the submit button which passes the variables to another page which adds them to the sql server tables.. Everythings basically working except for grabbing those two fields and then sending them on down the line. I also would like to change those two fields from a get to a say (for want of a better description), but I havent found that this is possible yet. I can grab the variables no problem, but I'm not sure how to pass them to the input tag. Anybody got any ideas ? Thanks, Virgil Bierschwale http://www.virgilslist.com http://www.tccutlery.com http://www.bierschwale.com http://www.bierschwalesolutions.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.15.26/601 - Release Date: 12/24/2006 11:31 AM [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: ON KEY with barcoding
By the way, it also provides for a perfect way to test it; just type in the prefix and key in the barcode. Handy if you don't have the barcode scanner at the dev-location Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Jarvis Sent: dinsdag 26 december 2006 20:40 To: [EMAIL PROTECTED] Subject: Re: ON KEY with barcoding Sietse Wijnker wrote: Hi, I've worked with some barcode scanners sofar and ech of them allowed for a prefix character in the settings. Set this prefix to the on key label and the on key label should work. Regards a merry christmas, Sietse I prefer Sietse's idea of programming the scanner to use a prefix... just document what that prefix is and keep the barcode to scan it in handy for when some nimrod resets the scanner... (This happened to me a couple weeks ago so I'm still a bit testy about it... ) As an alternative maybe playing around with a form's KEYPRESS (or whatever) method... some fun logic to work out for other legit keystrokes, but I have every confidence in you to figure it out... g Matthew S. Jarvis IT Manager Bike Friday - Performance that Packs. www.bikefriday.com 541/687-0487 x140 [EMAIL PROTECTED] [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Input and html
Hi Virgil input type=hidden name=vjb1 value=%=vjbBranch % //td input type=hidden name=vjb2 value=%=vjbUnit % //td should do the trick Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Virgil Bierschwale Sent: dinsdag 26 december 2006 17:38 To: [EMAIL PROTECTED] Subject: RE: [NF] Input and html That's what I was trying to do, but because of the way this example program was developed, I have to put it in the code below OR figure out a better way to do it. Here is my retrieval code: --- Dim vjbBranch vjbBranch = Request.QueryString(branch) Dim vjbUnit vjbUnit = Request.QueryString(unit) --- And here is where I'm sending it to the next page to add to sql server -- form name=input action=addroster.asp method=get table border=0 width=100% tr td align=right width=50%Do Not Change:/td td width=50% input type=hidden name=vjb1 value=vjbbranch //td /tr tr td align=right width=50%Do Not Change:/td td width=50% input type=hidden name=vjb1 value=vjbbranch //td input type=hidden name=vjb2 value=vjbUnit //td /tr tr td align=right width=50%First Name:/td td width=50% input type=text name=firstname //td /tr tr td align=right width=50%Last Name:/td td width=50% input type=text name=lastname //td /tr tr td align=right width=50%City:/td td width=50% input type=text name=city //td /tr tr td align=right width=50%State:/td td width=50% input type=text name=state //td /tr tr td align=right width=50%Zip Code:/td td width=50% input type=text name=zipcode //td /tr /table input type=submit value=submit id=Submit1 language=javascript onclick=addroster.asp / br / /form Virgil Bierschwale http://www.virgilslist.com http://www.tccutlery.com http://www.bierschwale.com http://www.bierschwalesolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sietse Wijnker Sent: Tuesday, December 26, 2006 2:07 AM To: profox@leafe.com Subject: RE: [NF] Input and html Hi Virgil, How 'bout setting up some hidden input boxes, filling them with the values and reading those out in your saving routine? That way there's no labeling needed. For parsing the querystring variables: simple ASP test page: %@ Language=VBScript % % cVar1 = Request.QueryString.Item(var1) cVar2 = Request.QueryString.Item(var2) % html body var1: %=cVar1%br/ var2: %=cVar2% /body /html calling url: http://localhost/dnn/test/ASPTest.asp?var1=1234var2= Result: var1: 1234 var2: greetings, Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Virgil Bierschwale Sent: dinsdag 26 december 2006 5:12 To: [EMAIL PROTECTED] Subject: [NF] Input and html I've got a page that I want to grab the variables passed in the url link which are branch and unit. TO see it in acxtion, go to http://www.virgilslist.com Click on Navy Click on FF-1059 You will see a list of people in this group. Below that there are two fields in an input tag that say Do Not Change I want to grab the branch and unit and place them in those fields.. Then I want the user to fill in the rest of the fields and click the submit button which passes the variables to another page which adds them to the sql server tables.. Everythings basically working except for grabbing those two fields and then sending them on down the line. I also would like to change those two fields from a get to a say (for want of a better description), but I havent found that this is possible yet. I can grab the variables no problem, but I'm not sure how to pass them to the input tag. Anybody got any ideas ? Thanks, Virgil Bierschwale http://www.virgilslist.com http://www.tccutlery.com http://www.bierschwale.com http://www.bierschwalesolutions.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.15.26/601 - Release Date: 12/24/2006 11:31 AM [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: ON KEY with barcoding
Hi, I've worked with some barcode scanners sofar and ech of them allowed for a prefix character in the settings. Set this prefix to the on key label and the on key label should work. Regards a merry christmas, Sietse ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Polling App
I have been playing around to get it to work in a full VFP solution, but didn't look foor the code there, nor did I find Christoff's example, probably because it was before he published it, but I don't know for sure - It's ben a while. Anyway, thanks for the pointer. I've looked at the solution-sample and it's workable though it needs some work to implement it in a real-world app. Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jaime Vasquez Sent: woensdag 20 december 2006 5:19 To: [EMAIL PROTECTED] Subject: Re: Polling App Sietse Wijnker wrote: I'm using filesystem events to react to a file create/change in similar cases. The only problem is binding to them, but I've written a .NET ActiveX thet does that for me. Use that inside a VFP form and I'm able to write VFP code to react to the events. The vfp9's solutions samples have a demo on how to do that with VFP code, look for it in New in VFP9 - Binding To Windows Message Events - File/Folder Shell Events. HTH Jaime Vasquez. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Any JavaScript Pro's out there
ehrm how about:
if (svcBranch == 'VA') map.setCenter(new GLatLng( 37.7,-97.3), 5);
if (svcBranch == 'VA') map.setCenter(new GLatLng( 37.7,-97.3), 5);
if (svcBranch == 'FL') map.setCenter(new GLatLng( 37.7,-97.3), 3);
if (svcBranch == 'TX') map.setCenter(new GLatLng( 37.7,-97.3), 7);
when there's only one instrucvtion following the if, there no need to
encapsulate it inside the curly brackets.
And why are the if statements inside it's own bracketing?
Sietse Wijnker
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Virgil Bierschwale
Sent: woensdag 20 december 2006 20:42
To: [EMAIL PROTECTED]
Subject: [NF] Any JavaScript Pro's out there
This should be working, but its not..and to top it off,
response.write('svcBranch') and response.end doesn't show me
that its getting there.
It also is the only changes I've made to code that was
working before so I'm sure this has to be the problem, but at
this point, who knows ? grin
var svcBranch = new String( Request.Form(state) )
{
if (svcBranch == 'VA')
{
map.setCenter(new GLatLng( 37.7,-97.3), 5);
}
{
if (svcBranch == 'FL')
{
map.setCenter(new GLatLng( 37.7,-97.3), 3);
}
{
if (svcBranch == 'TX')
{
map.setCenter(new GLatLng( 37.7,-97.3), 7);
}
The code in operation is at http://www.virgilslist.com/branch.asp
Click on navy, click on ff-1059 then select any state size
and I want it to change the zoom levels and center of state
which is what the above mentioned code does.
Thanks,
Virgil Bierschwale
http://www.virgilslist.com
http://www.tccutlery.com
http://www.bierschwale.com
http://www.bierschwalesolutions.com
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.25/593 - Release
Date: 12/19/2006
1:17 PM
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
RE: Polling App
I'm using filesystem events to react to a file create/change in similar cases. The only problem is binding to them, but I've written a .NET ActiveX thet does that for me. Use that inside a VFP form and I'm able to write VFP code to react to the events. Another solution I'm also using is a small .NET app that reacts to evnts and writes a message to a message-queue which in its turn is monitored by a VFP application. Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Weller Sent: maandag 18 december 2006 23:43 To: [EMAIL PROTECTED] Subject: Polling App Hi Guys, I have to write a small utility that will check for the presence of a file or files in a particular folder every 5 minutes or so. If any are there it does some processing on them. It will probably run on the server. As I see it there are two ways I can go: 1.Have a program that runs every 5 minutes triggered by scheduler. Snag arises if the processing takes more than 5 minutes (which could possibly happen in the future). 2.Run the program continuously in a loop which will process the files then go to sleep for 5 minutes (using the API Sleep function). Question - will this absorb much in the way of resources? I've found the Fox to be very fast but a resource hog. Any comments or suggestions of a better way will be gratefully received - I see no benefit in re-inventing the wheel if someone has already tried something similar. TIA John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Browser/Internet problem
Hi Paul, In the possibility to totally miss the point, but maybe hit the jackpot. (lots of maybe's here...) Can you ping to the servers' IP address in a command prompt? You said IE and FF work, while Opera amoungst others don't.. Maybe it's a DNS problem. What if the 1st listed DNS-server in your TCP/IP settings (or the ones set for your DHCP server) isn't available? Don't know for sure but maybe IE and FF know to loom further for the 2nd and third DNS but the other programs that have problems don't? Maybe switch the DNS server order? Regards, Sietse Wijnker ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Changing Colours
You interpreted my suggestion correct, but it only works for colors where none of the components isn't maxed out. When working on a dark grey tone, it works. That's where i tested it This does not work, for example if I set screen back colour to a nice orange. _screen.BackColor= RGB(255,128,0) Matter of taste. ;-) How 'bout this: _screen.BackColor = RGB(255,128,0) _screen.BackColor = IncreaseColor(RGB(255,128,0),25) FUNCTION IncreaseColor(tnColor, lnIncrease) *- Determine the RGB values lnRed = BITAND(tnColor, 255) lnGreen = BITAND(BITRSHIFT(tnColor,8), 255) lnBlue = BITAND(BITRSHIFT(tnColor,16), 255) *- Increase the RGB values with a maximum of 255 lnRed = MIN(lnRed + lnIncrease, 255) lnGreen = MIN(lnGreen + lnIncrease, 255) lnBlue = MIN(lnBlue + lnIncrease, 255) *- Return the new color RETURN RGB(lnRed, lnGreen, lnBlue) ENDFUNC Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Davis Sent: woensdag 22 november 2006 17:51 To: [EMAIL PROTECTED] Subject: RE: Changing Colours This does not work, for example if I set screen back colour to a nice orange. _screen.BackColor= RGB(255,128,0) And then do as you suggest and add a value to it, it does not change it to a more vivid,brighter orange as I wish it turns green! _screen.backcolor=_screen.BackColor+RGB(25,25,25) Any more ideas, or have I interpreted your suggestion wrong ? Cheers Chris. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Changing Colours
Just add a RGB() value to the color you have where the Red,green and blue values are equel f.i. RGB(25,25,25) Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Davis Sent: woensdag 22 november 2006 16:53 To: [EMAIL PROTECTED] Subject: Changing Colours Hi All, Could anyone suggest a way of working out a brigter version of a colour. I use RGB(x,x,x) to set a colour to say Blue,Pink,Red or whatever and would like to be able to work out from whatever colour it is a brighter version. So I'm after bright blue,bright pink,bright red in order to highlight the blue,pink or red line I'm on. Sorry for the rubbish explanation. Cheers Chris. P.s. I don't want a pre defined list of colours and their brighter versions. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Error 2091 table corrupted, needs repaired!
Also the SET TABLEVALIDATE option is worth checking out (VFP8+) Regards, Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James E. Harvey Sent: woensdag 22 november 2006 17:09 To: [EMAIL PROTECTED] Subject: RE: Error 2091 table corrupted, needs repaired! That's interesting. So if it happens again I'll try the copy command first. It is bothersome that it occurred in the first place though. If it happens again I'll really be concerned... Thanks. James E. Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com [EMAIL PROTECTED] 717-637-8931 fax: 717-637-6766 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent: Wednesday, November 22, 2006 10:30 AM To: profox@leafe.com Subject: RE: Error 2091 table corrupted, needs repaired! Looking up the error, it might be a reccount problem. Check this UDF: http://fox.wikis.com/wc.dll?Wiki~UDFFixRecCount Tracy [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VS 2005 Professional with VFP9
Hi James, The 'Visual Database Tools' do NOT refer to VFP9. The VFP should be purchased separately next to VS-install Or you'll downoad it separately in a MSDN subscription. Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James E. Harvey Sent: dinsdag 14 november 2006 16:47 To: [EMAIL PROTECTED] Subject: VS 2005 Professional with VFP9 The MS web site isn't clear that VFP 9 is included with this product? See #4. ??? MicrosoftR Visual StudioR 2005 Professional Edition Includes: 1.Microsoft Visual BasicR, Microsoft Visual C#R, Microsoft Visual C++R, and Microsoft Visual J#R programming languages 2.Tools for building WindowsR and Web solutions 3.SmartPhone and Pocket PC development tools for building Windows CE-based applications 4.Visual Database Tools 5.XSD and XSLT editing and debugging 6.Advanced debugging tools, including cross-machine debugging 7.Visual Basic and Visual C# development of stored procedures, functions, and triggers when combined with SQL ServerTM 2005 8.Tools for building server-based solutions Does that mean you'd either have to purchase VFP 9 separately, or buy into the MSDN subscription to get VFP9 with VS 2005? James E. Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com [EMAIL PROTECTED] 717-637-8931 fax: 717-637-6766 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP9 - Problem moving columns in grid with custom headers
Hi Paul, Your headers get 'out of sync'. What exactly do you mean with that? Do the captions get all elmar fud modeskweawy/elmar fud mode, or does the handling of the click/rightclick. If it's the latter, It's probably due to a coding-problem in the HeaderClick method. Do you do anything with the this-reference that's get passed except for the toHeader.Parent.ColumnOrder? The columnorder is indeed out-of-sync with the coulumn index number in the grid's columns collection. Perhaps that's where you have a mismatch? Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton Sent: vrijdag 27 oktober 2006 1:17 To: [EMAIL PROTECTED] Subject: VFP9 - Problem moving columns in grid with custom headers Hi all I have a simple custom header class: DEFINE CLASS gridheader AS Header PROCEDURE Click THISFORM.HeaderClick(THIS,L) ENDPROC PROCEDURE RightClick THISFORM.HeaderClick(THIS,R) ENDPROC ENDDEFINE I have a grid which starts off with column count = -1 and then I have the following code: .Grid1.RecordSource = IndexTable FOR EACH loColumn IN .Grid1.Columns lcCaption = loColumn.Header1.Caption loColumn.RemoveObject(Header1) loColumn.AddObject( 'Header1', 'gridheader' ) loColumn.Header1.Caption = lcCaption ENDFOR Now all this works fine and when I click or right click on any of the headers the code in THISFORM.HeaderClick executes. A problem arises however when I move columns in the grid by holding down the left mouse button and dragging - sure the column moves but the columns and headers get all out of synch ! Any suggestions ? [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Problem with class init
Hi AJ,
The private datasession has the default setting opf SET EXCLUSIVE ON
Make sure you set all appropriate session specific settings prior to loading
any data
Regards,
Sietse Wijnker
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of aj
Sent: donderdag 19 oktober 2006 15:39
To: [EMAIL PROTECTED]
Subject: Problem with class init
I placed a custom class onto a form with a private
datasession. Inside the Init method of my class I have code
like this.
if used('tablename') = .F.
use data\tablename in 0
endif
The Default data session has this table open.
What happens is the used() test returns false but when the
code inside of the if statement executes, foxpro gives me an
error telling me that the file is already open.
Has anyone seen this before?
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
RE: System not deleting files
Small parts left out here Ken:
1. Create the cursor with SQL. Don't forget the NOFILTER clause! This forces
the VFP-SQL engine to actually create the cursor in a temp-file. When the
query is fully optimizable fox will otherwise pass you a reference to the
actual source table with a SET FILTER clause in effect. This will cause some
problems when modifying or deleting records and you're not expecting you're
modifying the source table.
2. USE DBF('YourCursorName') again alias MyData IN 0
Regards,
Sietse
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
Kixmoeller/fh
Sent: maandag 16 oktober 2006 21:45
To: [EMAIL PROTECTED]
Subject: Re: System not deleting files
On Oct 16, 2006, at 2:20 PM, John J. Mihaljevic wrote:
I'm on 6.0 right now. I need to get into 9.0, but wanna get this
system stabilized first.
In that case:
1. create the cursor with SQL
2. USE DBF('YourCursorName') again alias MyData
3. Select MyData
4. Manipulate at will
Ken
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
RE: Which Excel pem to make an active worksheet?
When you install office, there is an option with the additional tools section in the custom-install mode where you can select VBA helpfiles. If installed the filename for Office2003 is C:\Program Files\Microsoft Office\OFFICE11\1033\VBAXL10.CHM Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Kaye Sent: woensdag 4 oktober 2006 2:55 To: [EMAIL PROTECTED] Subject: Re: Which Excel pem to make an active worksheet? The Hentzenwerke Automation book is an excellent source of information. Lew wrote: Thanks, Chet. Would you happen to know if there's a help file/chm around somewhere that document the excel object model? -Lew -- Richard Kaye Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Australian Support - [EMAIL PROTECTED] Internet Support - [EMAIL PROTECTED] All Other Requests - [EMAIL PROTECTED] - This message has been checked for viruses before sending. - [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP Keyword Jeopardy (51)
How about SQL-create-commands? from the top of my head it's used for the field-level validation in at-least CREATE CURSOR? Probably also for CREATE TABLE and even ALTER TABLE. Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joel N. Fischoff Sent: dinsdag 5 september 2006 6:54 To: [EMAIL PROTECTED] Subject: Re: VFP Keyword Jeopardy (51) ERROR is a KEYWORD to another command. Of course, it's a command itself, but what command is ERROR a keyword? @ ... GET is probably what you're looking for. It's part of the validation part, indicating the error message that gets displayed when the code in the VALID clause evaluates to .F.. Alternatively, you're talking about ON ERROR. Joel, who mostly works in FPD, but believes these are still true of VFP [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP9 Environment Manager problem
How aboput creating a program that loops through all the _Screen.Forms and sets the top and left property to 0 and bind that program to a ON KEY F4 Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James E. Harvey Sent: dinsdag 5 september 2006 14:36 To: [EMAIL PROTECTED] Subject: VFP9 Environment Manager problem I somehow messed up the settings on my laptop so that when I try to load the Manage Environments in my Task Manager the main vfp desktop stops running and all I get is the bell when I click anywhere in the vfp window. I have to hit the Escape key to get my vfp desktop back to normal. It's as though there is an invisible modal form active. I'm using dual monitors and its acting as though the window (where you can create New Environments or edit old ones) is there, but not visible. All other apps are fine so I'm pretty sure it's a FoxPro issue. I tried deleting the foxuser.dbf in the working folder but that hasn't helped. I notice that a new foxuser.dbf is not being re-created in the working folder when I reload VFP...? I thought the Manage Environments window may have been off the screen but issuing _screen.left = 1 doesn't work either. Any ideas on how to get it back? TIA James E. Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com [EMAIL PROTECTED] 717-637-8931 fax: 717-637-6766 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Move directories
Here's something I cooked up while waiting for a convert-program running: It uses the SHFileOperation API which is also used when dragging files from one folder to another in winexplorer. Regards, Sietse Wijnker *** *- Defines for the SHFILEOPSTRUCT.wFunc #Define FO_MOVE 0x0001 #Define FO_COPY 0x0002 #Define FO_DELETE 0x0003 #Define FO_RENAME 0x0004 *- Defines for the SHFILEOPSTRUCT.fFlags #DEFINE FOF_ALLOWUNDO 0x0040 #DEFINE FOF_CONFIRMMOUSE 0x0002 #DEFINE FOF_FILESONLY 0x0080 #DEFINE FOF_MULTIDESTFILES 0x0001 #DEFINE FOF_NOCONFIRMATION 0x0010 #DEFINE FOF_NOCONFIRMMKDIR 0x0200 #DEFINE FOF_NOCOPYSECURITYATTRIBS 0x0800 #DEFINE FOF_NOERRORUI 0x0400 #DEFINE FOF_RENAMEONCOLLISION 0x0008 #DEFINE FOF_SIMPLEPROGRESS 0x0100 *- Declare the needed DLL's Declare Integer SHFileOperation In Shell32 ; String @lpFileOp DECLARE Long GlobalAlloc IN WIN32API Long, Long DECLARE Long GlobalFree IN WIN32API Long lcFrom = D:\SourceFolder\* + CHR(0) + CHR(0) hGlobalFrom = GlobalAlloc(0x0040, LEN(lcFrom)) SYS(2600, hGlobalFrom, LEN(lcFrom), lcFrom) lcTo = \\xpsrv1\targetfolder\ + CHR(0) + CHR(0) hGlobalTo = GlobalAlloc(0x0040, LEN(lcTo)) SYS(2600, hGlobalTo, LEN(lcTo), lcTo) lcTitle = Copy FILE(s)... + CHR(0) + CHR(0) hGlobalTitle = GlobalAlloc(0x0040, LEN(lcTitle)) SYS(2600, hGlobalTitle, LEN(lcTitle), lcTitle) Local shFileOp As String SHFILEOPSTRUCT lnFlag = FOF_CONFIRMMOUSE ; + FOF_NOERRORUI ; + FOF_RENAMEONCOLLISION ; + FOF_MULTIDESTFILES ; + FOF_SIMPLEPROGRESS ; + FOF_NOCOPYSECURITYATTRIBS ; + FOF_NOCONFIRMMKDIR ; + FOF_NOCONFIRMATION shFileOp = BinToC(_vfp.HWnd, 4RS) + ; BINTOC(FO_MOVE, 4RS) + ; BINTOC(hGlobalFrom, 4RS) + ; BINTOC(hGlobalTo, 4RS) + ; BINTOC(lnFlag, 2RS) + ; CHR(0) + CHR(0) + CHR(0) + CHR(0) + ; CHR(0) + CHR(0) + CHR(0) + CHR(0) + ; BINTOC(hGlobalTitle, 4RS) IF SHFileOperation(@shFileOp) = 0 ?files copied! ELSE ?Error while copying... ENDIF GlobalFree(hGlobalFrom) GlobalFree(hGlobalTo) GlobalFree(hGlobalTitle) ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Sent: donderdag 31 augustus 2006 22:10 To: [EMAIL PROTECTED] Subject: RE: Move directories Chet wrote: I think he's trying to do it in a VFP program...? Exactly, there are a few thousand directories, moving each one manually might take some time ;) stephen.russell wrote: why not xcopy /E to include all the empty folders as well as all folders with files? Because we don't want the whole lot moved only a selection of them; those that have a certain string (year) in their name. Lew Schwartz wrote: Fox's rename will move files across drives, but you'll have to handle the directory structures with adir(AA,path+*.*,D) md. (Currently working on a fox version of xcopy). Fox version of XCopy would be _extremely_ interesting. Rgds, Nick [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: I Didn't Know That!
In my DevTools menu i've added a bar: 'Goto Line' with a shortcut Ctrl+G that calls SYS(1500,_MED_GOTO,_MEDIT) This way I still can use the 'default' shortcut Ctrl+G even in VFP Another option I used prior to setting up the shortcut was 1. press Ctrl+G 2. Find out it didn't work 3. Press the Context Menu key on my keyboard (or Shift+F10 if not present) 4. press 'g' for the Goto Line dialog Also the Context menu gives options for commenting (m) and Uncommenting (n), Breakpoint (k), Look up reference (e), Object List (j) (When editing a method, very usefull!), Execute selection (x), View Definition (v) and Beautify (y). The rest is available through other shortcuts (Ctrl+something) Some of these I use often, some I use seldom, but knowing how to find them and start the options quickly without grabbing my mouse saves me a lot of time throughout the day. Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Malcolm Greene Sent: woensdag 23 augustus 2006 19:53 To: [EMAIL PROTECTED] Subject: Re: I Didn't Know That! Jeff, To make sure VFP shows line numbers in status bar type the following command in the command window: SET MESSAGE TO I also add this line to my application shutdown code (bracketed by version() check for dev vs. runtime). Enjoyed your story :) Malcolm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP Keyword Jeopardy (44)
What is a keyword for COPY TO? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Anderson Sent: dinsdag 8 augustus 2006 1:09 To: [EMAIL PROTECTED] Subject: VFP Keyword Jeopardy (44) FOXPLUS [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP Keyword Jeopardy (43)
PLAY MACRO cleanup TIME 0.5? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Garrett Fitzgerald Sent: dinsdag 1 augustus 2006 17:07 To: [EMAIL PROTECTED] Subject: Re: VFP Keyword Jeopardy (43) On 7/31/06, Bill Anderson [EMAIL PROTECTED] wrote: TIME All true, but those aren't VFP keywords g. WAIT WIND Wait TIME 1? :-) [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Wierd SQL Error - Any Ideas?
Hmm. strange indeed. What I'm seeing: The 1st call to the date function, the curTemp.cDate contains an empty value! I'm not sure but I'm bettiong it has to do with optimization of the query. I've seen this result by using an UDF that accepts 1 param and prints it out to the screen. Then include that UDF as a column, passing the curTemp.cDate as the param The solution: use EVL() in the expression: Date(2000+Val(Substr(EVL(curTemp.cDate, 01/01/00),7,2)), ; Val(Substr(EVL(curTemp.cDate, 01/01/00),4,2)), ; Val(Substr(EVL(curTemp.cDate, 01/01/00),1,2))) ; Another solution: You're only using the join to filter out the records from the lookup: Don't use the join but use Where curTemp.F1=A01 AND curTemp.FK1 IN (SELECT pk FROM curTemp2) Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Crozier Sent: maandag 31 juli 2006 12:04 To: [EMAIL PROTECTED] Subject: Wierd SQL Error - Any Ideas? To All, I had a WEIRD error come up over the weekend in a set of programs that have been working for ages. I managed to tie the problem down to what I think is an error in VFP and wonder what you all think. Run the program below and you should find that the first and second select statement works OK and the third one doesn't! My question is WHY? I can't come up with a reasonable answer here other than the fact that in (3) VFP seems to be trying to pre process or parse the Date() expression with a dataset containing null records (maybe?) caused by the Join. As the only difference is the Join in statement (3), this is obviously the culprit but WHY? Important Note: If you replace the date() statement with Ctod(Substr(curTemp.cDate,1,8)) ; as Date ; Then ALL the statements work. Surely this is a deep error with the Date() - or am I missing something obvious here. All I know is that it ate up 4 hours to find the problem! *** * Start of Program * Close Tables all Set Date British DD/MM/YY Create Cursor curTemp (FK1 I, F1 C(10), cDate C(8)) Insert Into curTemp Values (1, A01,01/01/06) Insert Into curTemp Values (1, A02,02/01/06) Insert Into curTemp Values (2, A03,03/01/06) Insert Into curTemp Values (2, A04,04/01/06) Insert Into curTemp Values (1, A05,05/01/06) Create Cursor curTemp2 (PK I, F1 C(10)) Insert Into curTemp2 Values (1, Lookup) * (1) This statement works OK it has one record Select All ; Date(2000+Val(Substr(curTemp.cDate,7,2)), ; Val(Substr(curTemp.cDate,4,2)), ; Val(Substr(curTemp.cDate,1,2))) ; as Date ; From curTemp ; Where curTemp.F1=A01 ; Into Cursor curResult * Browse * (2) This is OK, no records Select All ; Date(2000+Val(Substr(curTemp.cDate,7,2)), ; Val(Substr(curTemp.cDate,4,2)),; Val(Substr(curTemp.cDate,1,2))) ; as Date ; From curTemp ; Where curTemp.F1=A99 ; Into Cursor curResult * Browse * (3) This errors. Also No records Select All ; Date(2000+Val(Substr(curTemp.cDate,7,2)), ; Val(Substr(curTemp.cDate,4,2)), ; Val(Substr(curTemp.cDate,1,2))) ; as Date ; From curTemp ; Join curTemp2 on curTemp2.PK=curTemp.FK1 ; Where curTemp.F1=A01 ; Into Cursor curResult * Browse * * End of Program Dave Crozier The best way to make a Million pounds in computing. ...Start with 5 million! -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date: 28/07/2006 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Wierd SQL Error - Any Ideas?
Part of my explanation was missing: The DATE() function does not accept year, month and day parameters that are equal to 0 (zero) and responds with the 'Function argument value, type, or count is invalid.' error. Because the VAL(substr()) starts with an empty string, the call to the DATE() function is DATE(2000,0,0). So there's your error! Regards, Sietse Hmm. strange indeed. What I'm seeing: The 1st call to the date function, the curTemp.cDate contains an empty value! I'm not sure but I'm bettiong it has to do with optimization of the query. I've seen this result by using an UDF that accepts 1 param and prints it out to the screen. Then include that UDF as a column, passing the curTemp.cDate as the param The solution: use EVL() in the expression: Date(2000+Val(Substr(EVL(curTemp.cDate, 01/01/00),7,2)), ; Val(Substr(EVL(curTemp.cDate, 01/01/00),4,2)), ; Val(Substr(EVL(curTemp.cDate, 01/01/00),1,2))) ; Another solution: You're only using the join to filter out the records from the lookup: Don't use the join but use Where curTemp.F1=A01 AND curTemp.FK1 IN (SELECT pk FROM curTemp2) Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Crozier Sent: maandag 31 juli 2006 12:04 To: [EMAIL PROTECTED] Subject: Wierd SQL Error - Any Ideas? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: a collection issue
Hi Vassilis To directly access an item inside a collection for filling a property, you can use collection[index] or collection(index) (like it's an array) This is also handy when trying to access a value in the watch window As you've probably seen, debugging values inside a collection in the debugger using the item() is impossible. Accessing the collection as if it's an array makes it possible. BTW, Changing the value of the collection-item is impossible, even when using the array-like approach. So oCol(2) = test doesn't work. Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vassilis Aggelakos Sent: maandag 31 juli 2006 14:46 To: [EMAIL PROTECTED] Subject: Re: a collection issue Thanks Mal, I use collections in my apps very frequently. Usually I have a simple ColItem class that looks like this: DEFINE CLASS myColItem AS Custom Key = .null. Value = .null. TagInfo = .null. oChild = .null. ENDDEFINE I add this object to my collection and everything is fine when I want to modify a value but playing now with collections I thought that I have missed something obvious. Thank you very much -V ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Windows events
Hi Brian, I've looked into it in the past to do it from native foxpro, but it prooved to be extremely difficult. There are some API calls and structures needed as well as a callback function that's called which is almost impossible to create. Having said that. In .NET ist's extremely easy to do, so I've created a class in .NET which can be used in VFP as an ActiveX control where you can set some properties, and implement code in the event that's triggered. Available for download @ http://www.sw-software.nl/Downloads/tabid/61/Default.aspx (FileMonitor). A demo on a VFP form is included. Regards, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Erickson Sent: donderdag 27 juli 2006 19:08 To: [EMAIL PROTECTED] Subject: Windows events I am sure this is very simple. How do I hook into a windows directory event to tell when something in that directory has changed??? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Checking variables and #Defines
Hi Michael
How about a intellisense script?
I've wrapped up an example for the typecheck. It defaults the type of a var
to the 2nd char in the varname. You can take it from here when seeing an 'i'
as 2nd char (making the typecheck 'N' and adding an extra assert line with
the INT(var) = var check
Regards,
Sietse Wijnker
intellisense script
Type: 'U'
Abbrev: 'vas' (variable assert)
cmd: '{}'
data:
LPARAMETERS oFoxcode
LOCAL lcIndent, lcVarName, lcReturn
lcIndent = STRTRAN(RTRIM(oFoxCode.FullLine), oFoxCode.usertyped)
lcVarName = _CLIPTEXT
lcReturn =
IF EMPTY(lcVarName) OR GETWORDCOUNT(_CLIPTEXT) 1
lcVarName = INPUTBOX(What variable?, ASSERT GENERATOR)
ENDIF
IF NOT EMPTY(lcVarName)
lcType = UPPER(SUBSTR(lcVarName,2,1))
oFoxcode.valuetype = V
TEXT TO lcReturn TEXTMERGE NOSHOW
lcIndent ASSERT VARTYPE(lcVarName,.t.) = 'lcType'
MESSAGE 'General Error - Stop and investigate!' + Chr(13) + 'Variable
(lcVarName) not valid type.'
ENDTEXT
ENDIF
RETURN lcReturn
/intellisense script
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Hawksworth
Sent: donderdag 27 juli 2006 12:36
To: [EMAIL PROTECTED]
Subject: Checking variables and #Defines
I use assert checks throughout my code, in fact I try to
check variables and parameters religiously (unfortunately my
grasp of religion must be patchy).
One common check is of the type...
Assert Vartype(liValue,.t.) = 'N' Message 'General Error -
Stop and investigate!' + Chr(13) + 'Variable (liValue) not
valid type.'
Assert int(liValue) = liValue Message 'General Error - Stop
and investigate!' + Chr(13) + 'Variable (liValue) not INT (Probably)'
(Yes I know the message is daft but it helps to stop me just
continuing through them thinking they are assert .f. lines
that I use all over.)
To save the typing I was looking at using #defines to
automate the lines but you can't enter variable in the
#defines to expand out. This leaves coding them in or using
a global object to test the values (I use this for critical
code sections in the live systems just to make sure anyway)
but this adds to the overheads especially even if you check
on call if you are in dev mode (.lDevMode = Version(2) = 2)
Can you think of a better way?
--
Michael Hawksworth
Visual Fox Solutions
[EMAIL PROTECTED]
www.foxpro.co.uk
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
RE: Checking variables and #Defines
Having had more time to think it through, the filling of the varname should be something like this: lcVarName = lcReturn = IF GETWORDCOUNT(_CLIPTEXT) = 1 THEN lcVarName = _CLIPTEXT ENDIF lcVarName = INPUTBOX(What variable?, ASSERT GENERATOR, lcVarName) This way you always have control on what varname is used. The 1st attempt got the varname in the _cliptext if it had just one word without any posibility to set another name. Regards, Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Malcolm Greene Sent: donderdag 27 juli 2006 15:54 To: [EMAIL PROTECTED] Subject: RE: Checking variables and #Defines Sietse, How about a intellisense script? SWEET! Thanks, Malcolm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP9 Errors don't show in development mode
Hi, Still, it is strange that the error does not appear while running the program in development mode. I mentioned in my previous post: Maybe you have the code that's filling the cSignatp property in a conditional block which is run when VERSION() (or even VERSION()) or _VFP.StartMode has a specific value? As I said, when running the prog in the IDE apperantly the cSignatp is filled differently. Thinking about the problem further: Maybe it's due to a SET DATE setting, as the exe defaults to some unexpected settings where those are all taken care of in the options dialog in the IDE? Debug the filling of the cSignatp property, cause this is causing the problem you observed. The lnentrynum is only set if the cSignatp property is NOT EMPTY. Regards, Sietse ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Day of Week from Command Prompt
My bet is that your locale-settings for the date format are throwing it off. What's the result of just the date ? echo %date% test.txt Regards, Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gérard Lochon Sent: zondag 23 juli 2006 22:03 To: [EMAIL PROTECTED] Subject: Re: [NF] Day of Week from Command Prompt 23/ as before ... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
