Collection of Macros

Before adjustment:

	nPointer = 0 && Init variable nPointer
	nPos = 0 && Init variable nPos
	i = 1 && Init variable i

After adjustment:

	nPointer = 0 && Init variable nPointer
	nPos     = 0 && Init variable nPos
	i        = 1 && Init variable i

Before adjustment:

	nPointer = 0 && Init variable nPointer
	nPos = 0 && Init variable nPos
	i = 1      && Init variable i

After adjustment:

	nPointer = 0 && Init variable nPointer
	nPos = 0     && Init variable nPos
	i = 1        && Init variable i

Before:

	Dimension aArray[ 1 ] 
	Select Customer 
	Select * From Customer Into Array aArray

After:

	Dime aArray[ 1 ] 
	Sele Customer 
	Sele * From Customer Into Arra aArray

Before:

	If This.Pointer = 0
	  This.Pointer = This.Pointer + 1
	Else
	  This.Pointer = This.Pointer -1
	EndIf

After:

	*!* Comments: Administrator [19.02.2003 08:33:16]
	*!*If This.Pointer = 0
	*!*  This.Pointer = This.Pointer + 1
	*!*Else
	*!*  This.Pointer = This.Pointer -1
	*!*EndIf

Before:

	Dime aArray[ 1 ] 
	Sele Customer 
	Sele * From Customer Into Arra aArray

After:

	Dimension aArray[ 1 ] 
	Select Customer 
	Select * From Customer Into Array aArray

Before:

	If This.Pointer = 0
	  This.Pointer = This.Pointer + 1
	Else
	  This.Pointer = This.Pointer -1
	EndIf

After:

 
	 If This.Pointer = 0
	   This.Pointer = This.Pointer + 1
	 Else
	   This.Pointer = This.Pointer -1
	 EndIf

The dialog with parameters for the new class will appear after calling the Insert Class macro:

Before:

	cString = "This string contains the substring 'this substring'"

After:

	cString = 'This string contains the substring "this substring"'

Before:

	If This.Pointer = 0
	  This.Pointer = This.Pointer + 1
	Else
	  This.Pointer = This.Pointer - 1
	EndIf

After:

	if this.pointer = 0
	  this.pointer = this.pointer + 1
	else
	  this.pointer = this.pointer - 1
	endif
			

Before:

	if This.pointer = 0
	  This.pointer = This.pointer + 1
	else
	  This.pointer = This.pointer - 1
	endif

After:

	If This.Pointer = 0
	  This.Pointer = This.Pointer + 1
	Else
	  This.Pointer = This.Pointer - 1
	Endif

• Auto complete
• Expand keywords
• Collapse keywords
• Lower case
• Upper case
• Proper case
• Adjust assignments
• Adjust comments
• Invert quotes
• Code Navigator
• Form & class members show

Before:

	*!* Comments: Administrator [19.02.2003 08:33:16]
	*!*If This.Pointer = 0
	*!*  This.Pointer = This.Pointer + 1
	*!*Else
	*!*  This.Pointer = This.Pointer -1
	*!*EndIf

After:

	If This.Pointer = 0
	  This.Pointer = This.Pointer + 1
	Else
	  This.Pointer = This.Pointer -1
	EndIf

Before:

	 If This.Pointer = 0
	   This.Pointer = This.Pointer + 1
	 Else
	   This.Pointer = This.Pointer - 1
	 EndIf

After:

	If This.Pointer = 0
	  This.Pointer = This.Pointer + 1
	Else
	  This.Pointer = This.Pointer - 1
	EndIf

Before:

	If This.Pointer = 0
	  This.Pointer = This.Pointer + 1
	Else
	  This.Pointer = This.Pointer - 1
	EndIf

After:

	IF THIS.POINTER = 0
	  THIS.POINTER = THIS.POINTER + 1
	ELSE
	  THIS.POINTER = THIS.POINTER - 1
	ENDIF

Check and execute any SQL requests to any ODBC data source.

+Macros SQL Assistant Additional Macro is a part of +Macros toolkit for Visual FoxPro (VFP) developers. This macro extends capabilities of VFP Integrated Development Environment (IDE) allowing you to use Visual FoxPro mechanisms for checking SQL requests to any ODBC data source.

It's very useful in case you apply Visual FoxPro to create a client for a large corporate database (MS SQL Server, Oracle etc.) and in other cases when your data source is not Visual FoxPro native and you must use ODBC technology.

SQL Assistant Macro has three basic abilities:

• it can connect to any ODBC data source described in your system (to view list of your data sources, open Windows Control Panel and double-click the "ODBC 32" icon),
• it can perform any SQL request to this source,
• and it can disconnect from the source.

So at the beginning of your work you can create a connection to the data source you want to use. If connection established successfully, SQL Assistant macro will add a new window (called "SQL command") to your IDE windows list.

Thus you get fast and handy instrument to optimize your requests by trying quickly some variants of request, check their times and select the best one.

And there's another way to use SQL Assistant Macro. When you edit your program code you can select any SQL command in it and press Ctrl-F5 - and SQL Assistant Macro will automatically insert this command in "SQL command" window and try to execute it, so you can check correctness and running time of your SQL requests on the fly, without compiling and starting project in whole!

Also SQL Assistant Macro saves information about connection (that you made at the start) into special +Macros database and it keeps connection alive until you use its "Disconnect" command. Because of that if you close Visual FoxPro and open it later, you can use SQL Assistant Macro with the same data source as before, without repeating connection operations. And if you want to change data source you can use SQL Assistant's "Connect" command again and choose a new data source, then SQL Assistant macro will automatically close previous connection and open the new one.

If your project contains hundreds and thousands of SQL commands, it's too long to debug and tune them by compiling and running project in whole just to get another "SQL syntax error" message. Use the +Macros SQL Assistant Macro to check those commands one by one on the fly and save your time!

Quick and easy navigation through the Visual FoxPro project source code.

+Macros Bookmarks Additional Macro is a part of +Macros toolkit for Visual FoxPro (VFP) developers. This macro extends capabilities of VFP Integrated Development Environment (IDE) providing a convenient way for quick and easy navigation through the project source code.

When you open source file this macro analyses its contents and makes a list of Visual FoxPro definitions (FUNCTION, PROCEDURE, DEFINE CLASS etc.). Then you can jump back to the beginning of any of them just in two clicks: the first one to get a list and the second one to choose a definition from it - and you're on the spot! No more boring and tiresome scrolling of kilobytes of text!

In addition to this automatically created list of bookmarks you can make your own bookmarks at any place of the source code. Do you have a hardly debugging cycle in a very long procedure definition? Make a bookmark on it and you can get there again and again in above-mentioned two clicks!

At last, you can create an individual list of bookmarks for every source file in your project. All these lists are stored in special +Macros database and don't disappear when you exit Visual FoxPro, so they can be used in many working sessions, until your project is done. Plenty of source code - and you can get on any spot just in two seconds!

+Macros Bookmarks Macro really accelerates your development process in several times saving your valuable time for more important work then long-pressing the PgUp/PgDn buttons again and again.

+Macros Bookmarks Additional Macro offers several useful commands for quick and easy navigation through the Visual FoxPro source code.

• Add\Delete Bookmark - adds new bookmark into current line of source code or remove bookmark from current line if it was here.
• Next Bookmark - moves cursor to next bookmark in source code.
• Prev Bookmark - moves cursor to previous bookmark in source code.
• Remove All Bookmarks - removes all bookmarks in current file.
• Show Procedures & Bookmarks - shows the list of procedures, functions, class definitions and bookmarks for current source file. You can easily find any procedure, function in your source file with the help of this dialog.