Keyboard Shortcuts
Likes
- MadFox
- Messages
Search
|
Re: MadFox Meeting
Stein Goering
开云体育Thanks Eric.? Not only is that cool, but it hits at exactly the command I had in mind when I brought up modifying IS.? This deals with one of my complaints – getting that huge tip box when all I wanted was to select a work area.? My other complaint is getting that huge tip box when I want to type a SQL select statement.? It doesn’t automate anything, just shows me syntax that I mostly already know, and I end up just wanting to get the damn thing out of the way because it’s hiding the code I already wrote.? ? At the meeting, I’ll volunteer to implement and demo Eric’s code.? Then maybe we can look at options for dealing with the default dialog.? (If nothing else, just disable IS for the SELE command) ? From: Eric Selje [mailto:eselje@...]
Sent: Monday, January 19, 2004 5:50 PM To: madfox_vfp@... Subject: RE: [madfox_vfp] MadFox Meeting ? Oooh, I have a good one for this.? I did it some time ago and may have even shown you before, but it's been so useful to me that I think it's worth revisiting. ? If you've ever typed SELE (space) at the command line, you know that you get the syntax for SQL - Select statements.? This is fine sometimes, but what if you really wanted the SELECT [workarea] syntax?? Well, who would really want that, because it's so simple?? Wouldn't it actually be very cool if it presented you with a list of open tables to choose from?? (Believe me, it is).?? And, as an added bonus, if there were no tables open it automatically changes itself to USE so you can open the table you're looking for. ? Here's what you do to get this: ? 1. Open Intellisense Manager, and change to the "Custom" tab. 2. In the box that says "Replace", type opentables, change the Type to "Script," then click "Add."? This adds a new script record to the FoxCode table.? Click "Script" to edit this script, and paste this code: ? LPARAMETER oFoxCode ? LOCAL X, cReturn, nUsed ? * Create array of open tables ? IF nUsed? = 0 ? 3 . Save that script (Ctrl+W), then add a new record to FoxCode by typing SEL in the Replace box, changing the type to "Command", and click "Add." ? 4. To make it so that SEL invokes our opentables script, click "Edit", and type {opentables}?? in the Cmd field.? ? 5. Click Ok and you should be all set.? Good luck! ? Even though it ends up being very simple, it actually took me about an hour to figure out how to do this all over again tonight. ? Enjoy, ? Eric ?
Yahoo! Groups Links
|
|
Re: MadFox Meeting
Eric Selje
开云体育Oooh, I have a good one for this.? I did it some time ago and may have even shown you before, but it's been so useful to me that I think it's worth revisiting.
?
If you've ever typed SELE (space) at the command line, you know that you get the syntax for SQL - Select statements.? This is fine sometimes, but what if you really wanted the SELECT [workarea] syntax?? Well, who would really want that, because it's so simple?? Wouldn't it actually be very cool if it presented you with a list of open tables to choose from?? (Believe me, it is).?? And, as an added bonus, if there were no tables open it automatically changes itself to USE so you can open the table you're looking for.
?
Here's what you do to get this:
?
1. Open Intellisense Manager, and change to the "Custom" tab.
2. In the box that says "Replace", type opentables, change the Type to "Script," then click "Add."? This adds a new script record to the FoxCode table.? Click "Script" to edit this script, and paste this code:
?
LPARAMETER oFoxCode
?
LOCAL X, cReturn, nUsed
?
* Create array of open tables
nUsed =AUSED(aTables) ?
IF nUsed? = 0
??* Return a value ?oFoxCode.valueType = 'V' ?cReturn =? 'USE ~' ELSE ?* Tell IntelliSense that you want a dropdown list to appear ? oFoxCode.valueType = 'L' ?* Build the list using oFoxCode's built in properties ?DIMENSION oFoxcode.Items[m.nUsed,2] ?FOR i = 1 TO m.nUsed ??oFoxcode.Items[m.i,1] = aTables[i, 1] ??oFoxcode.Items[m.i,2] = "" ?ENDFOR ?* Return the prefix for the results of the list ?cReturn = "SELECT" ENDIF * Return either USE or SELECT RETURN cReturn ?
3 . Save that script (Ctrl+W), then add a new record to FoxCode by typing SEL in the Replace box, changing the type to "Command", and click "Add."
?
4. To make it so that SEL invokes our opentables script, click "Edit", and type {opentables}?? in the Cmd field.?
?
5. Click Ok and you should be all set.? Good luck!
?
Even though it ends up being very simple, it actually took me about an hour to figure out how to do this all over again tonight.
?
Enjoy,
?
Eric
?
|
|
Meeting
P.J. Fernandez
Ok, we have settled on some things.
MadFox Meeting @ PJ's 5:30 PM 222 West Washington Avenue, Suite 200, Madison Call 608-239-1507 to gain entrance to the garage and/or the building. Agenda: 1. How to use set preferences for the browse window. 2. Customizing intellisense. Also, your questions and a review of Suse intalled on my computer. Pizza for everyone. See you here. P.J. |
|
Re: MadFox Meeting
P.J. Fernandez
We may need to do research on the browse window first.
toggle quoted message
Show quoted text
I used "preferences" in the past to save browse window display characteristics. P.J.
|
|
Re: MadFox Meeting
Lorentzen David F.
开云体育No
more "huddled masses, yearning to VFP8".
?
And I
can hold off on that shower I've been thinking about taking.
-= Dave David F. Lorentzen
|
|
Re: MadFox Meeting
P.J. Fernandez
You -the man!
toggle quoted message
Show quoted text
P.J.
|
|
Re: MadFox Meeting
P.J. Fernandez
Thanks,
toggle quoted message
Show quoted text
P.J.
|
|
Re: Tomorrow
P.J. Fernandez
Did you get my email?
toggle quoted message
Show quoted text
P.J.
|
|
Re: MadFox Meeting
Jim Tooley
开云体育And I'd like to see how to?manipulate?the
browse window defaults in foxuser.dbf
?
... Jim in Lodi??? ..... and I'll be
bringing a projector!
?
|
|
Re: MadFox Meeting
Stein Goering
开云体育One of many items on my “sometime when I have time” list is customizing Intellisense.? If anyone has added their own commands (or modified the default behaviors), maybe you could demonstrate what you’ve done.? If nobody’s done that, perhaps trying something as a group project would be beneficial.? ? ? From: PJ Fernandez
[mailto:pjfern@...]
Sent: Thursday, August 14, 2003 8:57 AM To: Madfox_Vfp@Yahoogroups. Com Subject: [madfox_vfp] MadFox Meeting ? Hello sleepy heads.... ? It seems the cold weather has kept you busy and industrious.? Hope you enjoyed your holidays. ? It is time to collect suggestions for the meeting tomorrow.? What should we discuss?? Any suggestions?for the agenda? ? Thanks, ? P.J. Fernandez, MCSD ? ? Yahoo! Groups Links
|
|
Re: MadFox Meeting
Lorentzen David F.
开云体育P.J.:
?
Enero 5 del 2004, Después del inicio
en Octubre 20, 2003 con la traducción de Visual FoxPro 8 al espa?ol PortalFox
Libera la Ayuda de Visual FoxPro 8.
Este proyecto se ha logrado gracias a la colaboración de voluntarios de la comunidad hispana de Visual FoxPro y al empe?o que cada uno dedico a la traducción, revisión y coordinación en todas las tareas asignadas. Quiero agradecer a todos los que colaboraron con la traducción por el enorme trabajo realizado. Gracias Pablo Roca Sysop PortalFox Para descargala y ver mas información, visite ?
-= Dave David F. Lorentzen
|
|
Re: Beer with Eric?
开云体育Sorry sir - I can't/didn't make it either.? we are off to oshkosh for New Year's eve to see the Vic Ferrari band and a stay over at the same hotel.
?
peter d.
|
|
Re: Beer with Eric?
PJ Fernandez
开云体育Sorry
I missed it.? There is always an emergency at work at 5:00 PM.? Happy
new year to all.
?
P.J.
|
|
Re: Beer with Eric?
Eric Selje
开云体育Ok, perfect, 3's a crowd so we'll make it 5:30.? Is a different location more convenient?? Will you be coming down Hwy 12 Jim, or through town.? If through town, I can probably get further east. -----Original Message-----
From: Jim Tooley Sent: Dec 30, 2003 11:57 AM To: madfox_vfp@... Subject: Re: [madfox_vfp] Beer with Eric? Hi Eric,
?
I'll be there too? ... about 5:30
?
Jim in Lodi
Yahoo! Groups Links
|
|
Re: Beer with Eric?
Jim Tooley
toggle quoted message
Show quoted text
|
|
Re: Beer with Eric?
Eric Selje
Where even are you? Happy Christmas! I hope you're getting what you want.
toggle quoted message
Show quoted text
-----Original Message-----
From: Peter Hecht <phecht@...> Sent: Dec 30, 2003 10:15 AM To: madfox_vfp@... Subject: Re: [madfox_vfp] Beer with Eric? Eric, I can't make it sorry. Peter On 30 Dec 2003 at 9:38, Eric Selje wrote: Can anyone come over to the Nitty Gritty on Gammon Road tonight, say, 5ish, for a beer with me? Yahoo! Groups Links To visit your group on the web, go to: To unsubscribe from this group, send an email to: madfox_vfp-unsubscribe@... Your use of Yahoo! Groups is subject to: |
|
Re: Beer with Eric?
Lorentzen David F.
开云体育I can
likely make it by 5:30, depending on traffic from an errand to the east
side.
-= Dave David F. Lorentzen
|
|
Re: Beer with Eric?
Eric,
toggle quoted message
Show quoted text
I can't make it sorry. Peter On 30 Dec 2003 at 9:38, Eric Selje wrote:
Can anyone come over to the Nitty Gritty on Gammon Road tonight, say, 5ish, for a beer with me? |