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: 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: 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-5A0F62BF7796&displaylang=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: 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
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, [],
[],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.
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, "",
"", 1, 1)
lnPos = 1
DO WHILE .T.
lcID= STREXTRACT(lcSectionXML, [], [], 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('',lcXML)
all needet sections and extract them.
lcXML= your_xmlString
Lnstart=atc('',lcXML)
lni=1
Do While Lnstart#0
.. find end of this section and extract the value
lni=lni+1
Lnstart=atc('',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:
Package in Non-Mimeo Packaging; Use
appropriate FedEx Packaging
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.
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 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. 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
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
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
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)
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: 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: 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(, 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: 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: 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: 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 of > 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: 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 of 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: 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 Sh
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: 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:
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
-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'), ;
],) ;
")
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: [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.
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=22&pcid=10426173-9a ba-45eb-b7ce-af9ef9724d3d&type=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: 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.
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: 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.
Good point! Thanks for your input. Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Ted Roche Verzonden: vrijdag 30 maart 2007 15:11 Aan: [EMAIL PROTECTED] Onderwerp: Re: Date calculations. On 3/30/07, Sietse Wijnker <[EMAIL PROTECTED]> wrote: > Hmm, the start date isn't relevant. I think start date is relevant. 1. How many months and days are there in 59 days if you start on January 1st? 2. How about 62 days? 3. What if you start on January 15th? 4. June 1st? June 15th? June 30th? "It depends." A1: Two months, or one month and 29 days, depending on leap year. A2. Two months three days or two months, two days, ditto. 3. Same problem, leap day. 4. A different problem: depending on where you start in the month and how long the months are you traverse, you could end up with a different number of months and a different remainder of days. The question of "How many years, months and days in 500 days" has no answer without a base date. You can't even answer "years and days" unless you can tell me how many days there are in "a" year. The quick answer: use 365.25 for years and 30.4375 for days and return the answer as "approximate" #DEFINE DaysInYear 365.25 #DEFINE DaysInMonth 30.4275 * Given d=397, the number of days: nYears = INT(d/DaysInYear) nMonths = INT((d-nYears*DaysInYear)/DaysInMonth) nDays = INT(d-(nYears*DaysInYear)-(nMonths*DaysInMonth)) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.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: 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.
RE: Windows Desktop Search and VFP
Hi Dave, Thanks for the pointer but I really want to extend the Mickeysoft's desktop search, for eventually I'll probably switch to Vista and the desktop search engine is default included in the OS. Sietse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Crozier Sent: woensdag 28 februari 2007 9:35 To: [EMAIL PROTECTED] Subject: RE: Windows Desktop Search and VFP Sietse, Not a complete answer to your problem but take a look at Copernic desktop search http://www.copernic.com/en/products/desktop-search/index.html This is a FREE download and you can add different file types to be searched. I have .prg, .vcx/vct and .scx/sct ...etc. The search is EXTREMELY rapid and displays the .prg (being a text file straight away and the vcx/vct files are displayed by location allowing you to load up VFP automatically with the file in question. Certainly worth a look and it doesn't strangle your machine like M$'s offering does. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sietse Wijnker Sent: 27 February 2007 23:54 To: profox@leafe.com Subject: 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 --- [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: 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.
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: 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: [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.
[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: 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.
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
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
> --
>
>
>
>
> Do Not Change:
>
>
>
>
> Do Not Change:
>
>
>
>
>
> First Name:
>
>
>
>
> Last Name:
>
>
>
>
> City:
>
>
>
>
> State:
>
>
>
>
> Zip Code:
>
>
>
>
>
>
>
> onclick="addroster.asp" />
>
>
>
>
>
> 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") %>
> var1: <%=cVar1%>
> var2: <%=cVar2%>
>
>
>
>
> calling url:
> http://localhost/dnn/test/ASPTest.asp?var1=1234&var2=
>
> 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... > > > 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,
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")
%>
var1: <%=cVar1%>
var2: <%=cVar2%>
calling url:
http://localhost/dnn/test/ASPTest.asp?var1=1234&var2=
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: [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 ?
>
>
> 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 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: 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: 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: 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: 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: Grids and columns
Hi Paul, The memberclass properties where added in VFP8 The usage: Set a class for the memberclass when the objectcount is increased: So for the grid Set the grid column class that's added when you increase the columncount. This way you can specify the added class/classlibrary to be added instead of the VFP-base classes For the Column subclass you can set the headerclass to add a specific header class. All classes which add sub-objects when you increase a property (f.i. Grid (columncount), Commandgroup(Buttoncount), OptionGroup(buttoncount), Pageframe (pagecount), any more?) for an example: http://www.code-magazine.com/focus/Article.aspx?quickid=0301082 Regards, Sietse Wijnker > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton > Sent: vrijdag 27 oktober 2006 1:22 > To: [EMAIL PROTECTED] > Subject: Grids and columns > > Hi all > > This may be related to my other post but I really wanted to > keep them separate. > > I've just noticed two new (to me) grid properties, > MemberClass and MemberClassLibrary and two new column > properties, HeaderClass and HeaderClassLibrary. > > When did they arrive on the scene (7, 8 or 9) - and can > anybody give me or point me to examples of their usage and > utility/usefulness ? > > Tx > > > > > > [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 skweawy, 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: Adding controls to a grid column
You mean:
1. Copy the following code into a program
IF ASELOBJ(laTemp) > 0 AND VARTYPE(laTemp[1]) = "O" AND laTemp[1].BaseClass
= "Column"
lcName = INPUTBOX("Adding object to column:" +
laTemp[1].Name,"Specify the name","Checkbox1")
IF NOT EMPTY(lcName)
IF NOT PEMSTATUS(laTemp[1], lcName, 5)
lnChoice = MESSAGEBOX("Do you want to add a custom
class?", 3, "Adding control")
DO CASE
CASE lnChoice = 6
IF AGETCLASS(laClass)
laTemp[1].NewObject(lcName,
laClass[2], laClass[1])
ENDIF
CASE lnChoice = 7
lcClass = INPUTBOX("Adding object to
column:" + laTemp[1].Name,"Specify the class","Checkbox")
IF NOT EMPTY(lcClass)
laTemp[1].AddObject(lcName,
lcClass)
ENDIF
ENDCASE
ELSE
MESSAGEBOX("Object wioth the specified name already
exists",16,"Error adding control")
ENDIF
ENDIF
ENDIF
2. Select the column in the designer
3. Run the program
Hmm. This might be a nice little gem to put into an intellisense script?
Sietse Wijnker
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies
> Sent: donderdag 26 oktober 2006 20:07
> To: [EMAIL PROTECTED]
> Subject: RE: Adding controls to a grid column
>
> c'mon folks - what's with all the dragging and clicking?
> - tell the guy how to do it *programmatically*
>
> 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: 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 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
> 3. Select
> 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: 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: Indexing
INDEX ON PADL(field1, 7, "0") + PADL(100 - Field2,3,"0") TAG _Sort for the values: Field1: 100 Field2: 99 -> 11 Field1: 100 Field2: 2 -> 0000100098 Regards, Sietse Wijnker > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Sytze de Boer > Sent: dinsdag 5 september 2006 6:42 > To: [EMAIL PROTECTED] > Subject: Indexing > > Can anyone help me please, my brain is on go-slow > > I have a table with umpteen fields > I need to index on column 1, then column 2 in descending order e.g. > column is a numeric field ranging from 1 to 99 column 2 is a > numeric field ranging from 0 to 1,000,000 I need the report > to start and sub total on field 1, and I want the highest of > column 2 at the top > > > Can this be done ? > > Sytze > > > --- 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: 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: 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(,,"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: Case Statement
Hi Michael, I've tried to upset your code, but am unsuccessfull in recreating the situation you describe However, I can take an educated guess on why the case-statement did only execute the otherwise while you'd expect it would: VARTYPE(varname, .T.) will return the type that a variable or property contains. The .T. as a 2nd parameter will cause VARTYPE not to return "X" in case of a .NULL. value but the type it was previous to setting it to .null. So if the property boLoadSupplier contained an object but was reset to .null. the VARTYPE(Thisform.boTradingSheet,.t.) will return "O" and thus won't execute the branch. Solution: Just use VARTYPE() without the 2nd parameter. This will only return "O" when the object is actually there. Regards, Sietse Wijnker > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Michael Hawksworth > Sent: vrijdag 18 augustus 2006 12:39 > To: [EMAIL PROTECTED] > Subject: Case Statement > > Could you try running this code and see if the otherwise > clause executes? I forgot to have the form load the > boLoadSupplier business object and the routine should have > trapped it but it appear to set lcErrorMsg and then run the > otherwise code. If it does work could you try making the > first line " Case vartype(llOK,.t.) = 'L' " so that it fails > on the second line and see if otherwise executes. > > Thanks > > local lcErrorMsg as string > lcErrorMsg = '' > > local llOK as Logical > llOK = .f. > > Do case > Case Vartype(thisform.boTradingSheet,.t.) <> 'O' > lcErrorMsg="boTradingSheet" > Case Vartype(thisform.boLoadSupplier,.t.) <> 'O' > lcErrorMsg="boLoadSupplier" > Case Vartype(thisform.boTradingLoad,.t.) <> 'O' > lcErrorMsg="boTradingLoad" > Case Vartype(thisform.boOrganisation,.t.) <> 'O' > lcErrorMsg="boOrganisation" > Case Vartype(thisform.boProductCodes,.t.) <> 'O' > lcErrorMsg="boProductCodes" > Case Vartype(thisform.boUsers,.t.) <> 'O' > lcErrorMsg="boUsers" > Otherwise > If ! Empty(lcErrorMsg) > Assert .f. Message 'There IS a bug in foxpro' > else > llOK = .t. > EndIf > EndCase > > If ! llOK > Assert .f. Message 'Unable to load business object '+ > Chr(13) + lcErrorMsg > Return .f. > EndIf > > -- > 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: 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 . > > 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: 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: 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: 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: 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
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: 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
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
<> ASSERT VARTYPE(<>,.t.) = '<>'
MESSAGE 'General Error - Stop and investigate!' + Chr(13) + 'Variable
(<>) not valid type.'
ENDTEXT
ENDIF
RETURN lcReturn
> -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: [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.
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: VFP9 Errors don't show in development mode
Hi KAM, All variables declared in a LOCAL statement are defaulted to .F., which has always been so. The problem you're seeing occur has to do with the lOptInFieldObject.cSignatp property which suddenly gave unexpected results, probably due to a code change in that area. I agree with Bill, The code you've shown can be much more defensive. Expect the worst! f.i. are you always sure this proc/method will always be called with a toObject parameter that's indeed an object with the properties you expect? Writing this, I realise that you probably ment that you tested this functionality in the IDE and didn't get the error, wile when running the compiled exe you did that didn't occur in VFP8-? 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? Regards, Sietse Wijnker > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of KAM > Sent: zondag 23 juli 2006 3:08 > To: [EMAIL PROTECTED] > Subject: Re: VFP9 Errors don't show in development mode > > operator/operand type mismatch. > > There are many others, but I have this documented here (with > pictures): > http://www.medicaresoftware.net/ftp_www/exe_errors.rtf > > > > - Original Message - > From: "Kevin Cully" <[EMAIL PROTECTED]> > To: > Sent: Saturday, July 22, 2006 12:47 PM > Subject: Re: VFP9 Errors don't show in development mode > > > Can you give an example of an error message? > > Kevin Cully > CULLY Technologies, LLC > > Sponsor of Fox Forward 2006! > http://foxforward.net > > > KAM wrote: > > Has anyone noticed that a lot of coding errors do not show > when you are using the development IDE, but they do show with you run > > the EXE? > > > > Is this a setting that I have incorrect? I am sure that > VFP8 did show the errors. > > > > > > [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: Docking Toolbar in Top-Level Form
Hi Dave,
I have the following code running with a visually designed form and toolbar.
The code was generated from the SCX and VCX using the class-browser and
trimmed down to it's bare essentials.
Regards,
Sietse Wijnker
PUBLIC oform1
oform1=NEWOBJECT("form1")
oform1.Show
RETURN
DEFINE CLASS form1 AS form
ShowWindow = 2
PROCEDURE Activate
IF TYPE([This.TB.Name]) <> [C] THEN
This.AddProperty("tb", CREATEOBJECT("tb"))
This.tb.Visible = .F.
ENDIF
IF NOT This.tb.Visible THEN
This.tb.Dock(0)
This.tb.Show()
ENDIF
ENDPROC
ENDDEFINE
DEFINE CLASS tb AS toolbar
ShowWindow = 1
ADD OBJECT command1 AS commandbutton WITH ;
Caption = "..."
ENDDEFINE
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Crozier
> Sent: dinsdag 27 juni 2006 17:33
> To: [EMAIL PROTECTED]
> Subject: RE: Docking Toolbar in Top-Level Form
>
> To All,
> Having investigated the problem further and unless anyone can
> prove me wrong, there is no way of having a visually designed
> Form with a visually designed toolbar which is docked in the
> aforesaid form and to run it in development mode to see the
> final result i.e the toolbar DOCKED IN the form.
>
>
> The main VFP screen seems to take control as the top level
> form and the toolbar will ALWAYS dock with the main VFP
> window regardless of which property settings you use.
>
> One lesson learnt.
>
> Dave Crozier
> "A computer is a stupid machine with the ability to do
> incredibly smart things, while computer programmers are smart
> people with the ability to do incredibly stupid things. They
> are, in short, a perfect match" - Bill Bryson
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Crozier
> Sent: 27 June 2006 15:47
> To: 'ProFox Email List'
> Subject: RE: Docking Toolbar in Top-Level Form
>
> Rafael,
> Solved the Problem. I needed to define the Toolbar as a class
> in its own right and set the ShowWindow property accordingly.
> Also, I just noticed the post from Rick which says the same
> thing. Funny that as in my application I use a visually
> designed class that is subclassed from a standard toolbar.
> Only in the subclass is the ShowWindow set to 1 and this is
> why it didn't work.
>
> Creating the class as the original toolbar where Showwindow
> is 0 screws everything else up even though I had the
> subclassed item set correctly.
>
> * Test Program for toolbars
> oForm=CreateObject("clsForm")
> With oForm
> .Width=200
> .Height=200
> .AutoCenter=.T.
> *
> .Visible=.T.
> *
> Endwith
> *
> Read events
>
>
> Define Class clsForm as Form
> ShowWindow=2 && Top Level
> Desktop=.T.
>
> Function Activate()
> * See if the toolbar exists
> * ...So I can rename init() as Activare for testing
> *
> If type("This.barToolbar")<>"O"
> This.AddProperty("barToolbar2")
> This.barToolbar2=CreateObject("clsMyToolbar")
> With This.barToolbar2 as toolbar
> .Dock(0)
> .Show()
> Endwith
> Endif
> *
> Endfunc
>
> Function Unload()
> Clear Events
> Endfunc
> *
> *
> Enddefine
>
> Define Class clsMyToolbar as Toolbar
> ShowWindow=1
>
> Function Init()
> With This
> .AddObject("btnButton1","CommandButton")
> .btnButton1.Visible=.T.
> .btnButton1.Height=30
> *
> .AddObject("btnButton2","CommandButton")
> .btnButton2.Visible=.T.
> .btnButton2.Height=30
> *
> Endwith
> *
> Endfunc
> *
> Enddefine
>
>
> Dave Crozier
> "A computer is a stupid machine with the ability to do
> incredibly smart things, while computer programmers are smart
> people with the ability to do incredibly stupid things. They
> are, in short, a perfect match" - Bill Bryson
>
>
> --
&g
RE: VFP8/9 XMLAdapter falling over on LoadXML method.
Hi Alan, >However on looking > at the file with a hex editor I see that the first byte is > 3C, which as far as I can ascertain means UTF-8. Ehrm... 3C is hex for decimal 60... (try ?0x3C in the commend window). CHR(60) returns '<' So it's just the opening of the xml-declaration... Have you tried the XMLAdapter.NoCpTrans property? 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.
