Access VBA is a non-OOP language with some OOP features. It offers both Subs and Functions. A Sub does not return a value while a Function does. When Subs and Functions are used in a class module, they become the methods of the class.

• .MDB - Access Database
• .MDE - Protected Access Database

Store the image outside of your MDB Access database. There are many benefits to storing it outside of Access including the following:

• More easily work with all the images at once.
• avoid the overhead of an OLE server
• decrease the size of your MDB file
• easily reuse images with other development tools such as a website, VB, VS.Net, etc.
• Metadata is preserved

If the analyst is qualified sure, but if they're not, don't push it. Many times a resource was made the analyst not because they are a great analyst but because they have great people skills, know the domain well, and can document process well. Under that scenario, I prefer a programmer analyst work with the business analyst to identify entities and attributes. If the analyst is not good at documenting process, find a new analyst.

In PSDP, we overcome this problem by creating the database and GUI prototype during the requirements phase. By forcing the creation of the database while discovering what the client wants, you force the identifying of entitities and attributes.

In UML, sometimes analysts create class diagrams to create the database. The Data Model is a much better choice.

How to use ASPMail to send email from your web site.

The member visibility modifiers are Private and Public. If not specified, the default is Public. Private and Public have the usual meaning. Private members are visible only within the class block. Public members are visible within the class and outside of the class.

ASP classic uses the keywords sub and function. A sub does not return a value and a function does. Many programmers like to use the optional call keyword when calling a sub to indicate the call is to a procedure.

'Declare class.

Class Cyborg

  Public Function IntroduceYourself() 

    Response.Write("Hi, I do not have a name yet.") 

  End Function 

End Class

'Create object from class.

Set T1 = new Cyborg

T1.IntroduceYourself() 

Although this question really depends on the provider, in general, the answer is no to MS Access views and yes to MS SQL Server views so long as you open the RecordSet editable.

A quick example to demonstrate the yield keyword in the .NET Framework

In C#, parens indicate a method and the lack of parens indicate a property. You use special get and set methods to both get and set the values of properties. For a read-only property, leave out the set method. The value keyword is used to refer to the member field. Properties can make use of any of the access modifiers (private, protected, etc). It is common to use a lowercase member names for member fields ("name" in our example) and uppercase properties to manage member fields ("Name" in our example).

C++, Java, and C# all use C-like variable declaration.

C# has C-like variable declaration and although variables are case sensitive, VS.Net will auto-fix your variable names to the defined case.

C# offers many variable types. Some common types used include short, int, long, float, double, decimal, Int16, UInt16, Int32, Int64, string, and bool.

You can also specify the value when you declare a variable as in:

String FirstName = "Mike";

String LastName = "Prestwood";

Int16 Age = 42;

string FullName;

int16 Age;

double Weight;

FullName = "Mike Prestwood";

Age = 32;

Weight = 154.4;

Same as standard C++. Both standard C++ and C++/CLI are case sensitive. In C and C++ commands and variable names are case sensitive.

The following first C++/CLI snippet works:

MessageBox::Show("Hello");

messagebox::SHOW("Hello"); //>>>Does not work!

Also known as a Class Field.

A class variable defined with a specific class visibility, usually private visibility. A member property is different than a member field. A member property uses a member field to store values through accessor methods (getters and setters). For example, it is common to use a private member field to store the current value of a property. The current values of all the class member fields is the current state of the object.

You turn on ASPX in your control panel. Depending on what O/S and version of IIS there are slightly different steps required but essentially you go to the Add/Remove Programs, Alter Windows Components, and make sure ASPX is checked in the Application Server or Application Development Services.

More Info / Details - http://support.microsoft.com/default.aspx?scid=kb;en-us;332124&Product=winsvr2003

Maintained by Bill Todd. The Database Group specialized in Delphi & Interbase. In the past, Bill Todd was a Paradox guru and has authored many articles on Paradox, Delphi, and Interbase and co-authored several books. He was a consistent presenter at the various BorCons and a frequent contributer to the Paradox Informant and Delphi Informant.

Although Bill speciales in several areas, I posted this link to the Interbase topic because my belief is that Bill specializes in Interbase a bit more than the other areas.

BLOBs (Binary Large Objects) are collections of data that can be stored as a single entity in a database. In Microsoft SQL Server, BLOBs are stored using the text, ntext, and image data types.

• The text data type stores a variable length of non-unicode data up to 2³¹ - 1 characters.
• The ntext data type stores a variable length of unicode data up to 2³⁰ - 1 characters. The storage size, in bytes, is twice the amount of characters.
• The image data type is used to store image files smaller than 2³¹ - 1 bytes.

Notice in the more complete example that the semicolon for the begin..end block after end is not included. That tells the compiler something else is coming (the statement is not finished). Also note the semicolon is missing right before the final "else" statement.

Note: The following example uses floating point literals. In Delphi, to specify a fractional floating point literal between 1 and -1, you preceed the decimal with a 0; otherwise, you will get a compiler error (i.e. .1 + .1 does not work).

if (0.1 + 0.1 + 0.1) = 0.3 then
  ShowMessage('Correct')
else
  ShowMessage('Not correct');

//Complete example:
if x = true then
begin 

  ShowMessage('x is true');

end

Else If y = 'Mike' Then 

  ShowMessage('hello mike')

Else 

  ShowMessage('last option');

I recommend GExperts for one simple reason: I'm addicted; I can't live without it.

GExperts is a collection of incredibly useful plug-ins for the Delphi IDE. There are too many to list, so I'll mention just a couple of my favorites:

Replace Components: Select one or more controls on a form, choose GExperts "Replace Components," and you're presented a dialog that allows you to select a replacement component from a very smart drop-down. As GExperts replaces the selected component(s), it also preseves as many properties as possible.

Component to Code: Select a component on one of your forms or data modules, select GExperts "Component to code," and all the code necessary to create that component in explicit code is magically placed on the clipboard.

MessageDlg builder: While in the Delphi code editor, simply hit Crl-D. GExperts pops up a dialog in which you can type in text to be displayed, choose which buttons to include, choose an icon for your MessageDlg, and even test it. Clicking OK inserts the appropriate MessageDlg call right into your code.

Oh. Did I mention that GExperts is free? Don't start Delphi again without first downloading and installing GExperts. You'll be hooked, too.

Protected visibility means members are invisible outside of the unit. In other words, protected members are visible to the class they are declared in as well as descendant classes and any class declared within the unit.

Strict Protected visibility means that protected members within a class are visible ONLY within the class declared and to descendant classes. In OO terms, this is true protected visibility.

Java logical operators:

&&	and, as in this and that
||	or, as in this or that
!	Not, as in Not This
&	boolean logical OR (not short circuited)
|	boolean logical OR (not short circuited)
?:	Ternary (short for if-then-else)
~	Unary bitwise complement
<<	Signed left shift
>>	Signed right shift
>>>	Unsigned right shift
^	Bitwise exclusiv OR

//Given expressions a, b, c, and d:

if !((a && b) && (c || d)) {

  //Do something.

}

No built-in report writer but because JavaScript most frequently targets website development (a document interfaced GUI), a common solution is to simply output an HTML formatted page with black text and a white background (not much control but it does work for some situations).

Export to OpenOffice

method openWorkBook(var Excel OleAuto, fileName string) logical
var
 StarDesktop,StarOffice  OLEAuto
 oooDoc,scr,lists,list,zak OleAuto
 massiv AnyType
 fs filesystem
 put,s string
 dlin,k,i smallInt
endVar

ShName.BLANK()
ShiNDEX.BLANK()

try
  scr.open("MSScriptControl.ScriptControl")
 scr.language = "javascript";
 scr.eval("aaa=new Array()")
 massiv = scr.eval("aaa")
 scr.AddCode("function SetItem(ind,val){massiv[ind]=val}")

 StarOffice.Open("com.sun.star.ServiceManager")
 StarDesktop=StarOffice.createInstance("com.sun.star.frame.Desktop")

 dlin=fileName.size()
 
 put=""
 k=1
 i=1

 while i<>dlin
  s=fileName.subStr(i,1)

  if ansiCode(s)=92 then 

   put=put+"/"+fileName.subStr(k,i-k)
   k=i+1
  endIf 

  i=i+1
 endWhile

 put=put+"/"+fileName.subStr(k,i-k+1)

 if put.subStr(put.size()-3,4)=".xls" then
 else
  put=put+".xls"
 endif

 Excel=StarDesktop.LoadComponentFromURL("file://"+put,"_blank", 0,massiv)

 return True
onFail errorClear() return False
endTry
endMethod

How do you get Paradox 9 Runtime?

To use the Paradox 9 Runtime, you must have a valid Paradox 9 Developer license. You can keep an eye on eBay and other resources for this software package. 

If Prestwood Software is working on your Paradox 9 application, we can distribute the Paradox 9 Runtime to you. If you are a Prestwood client, you can download the Paradox 9 Runtime from the Prestwood Clients private area - Download Paradox 9 Runtime.

You will also want to  to apply the Paradox 9 Runtime Service Pack 3.

No, Paradox X4 (version 14) is Paradox 11 with SP2 applied (build 11.0.0.411). There is no version 12, 13, or 14. In fact, no new features since version 10. Version 11 does have some significant bug fixes though and SP2 has even more fixes. Also, there are lots of rumors that Corel will release a patch for Paradox 11 soon that will address the Vista problems many users are struggling with.

List of Perl operators.

Perl

• Operator - Yes
• Method -

PHP is a hybrid language with both traditional PHP and OOP features. PHP is widely-used general-purpose scripting language that is especially suited for web development and can be embedded into HTML. PHP has been used to create some amazing web content, particularly outstanding message boards.

Target Platforms: PHP is most suitable for creating websites targeting any browser (any web server with PHP installed).

Hear David I discuss software development on a nationally syndicated radio show. I posted this to the PHP group because he focused a bit on Delphi for PHP and PHP in general.

Our Prestwood Community rank titles are based on Star Trek's Starfleet Officer Ranks. I know, I know, it's a bit geeky, but what the heck. You rise up in the ranks by earning Prestwood points with our Member Points Program. You earn points by participating in our online community: visit, post, etc. You can spend your points in our online store.

Cadet 1st Year=,  Lieutenant=, Commodore=, more...

The easiest way to earn points is to visit daily and post to our Prestwood Message Boards.

Can I share code between a Delphi and a Dephi Prism project? I want to have a single source Win32 and .Net application.

Unlike Delphi, Delphi Prism uses the .Net garbage collector to free managed object instances. Prism does not have nor need a true destructor.

In .Net, a finalizer is used to free non-managed objects such as a file or network resource. Because you don't know when the garbage collector will call your finalizer, Microsoft recommends you implement the IDisposable interface for non-managed resources and call it's Dispose() method at the appropriate time.

Notice in the more complete example that the semicolon for the begin..end block after end is not included. That tells the compiler something else is coming (the statement is not finished). Also note the semicolon is missing right before the final "else" statement.

//Complete example:
if x = true then begin 

  ShowMessage('x is true');

end

Else If y = 'Mike' Then 

  ShowMessage('hello mike')

Else 

  ShowMessage('last option');

Oxidizer is a free tool that (in combination with ShineOn) is provided to help to port Delphi (Win32 and .NET) projects to the Delphi Prism language. Oxidizer is a command line tool that will adjust your .pas source files for common differences between the two languages.

This wiki is provided as a central live source of information about Delphi Prism and will be updated in an ongoing process.

This change management procedure is specific to Prestwood Software Development Process (PSDP).  PSDP is our free process we maintain and distribute as well as use with our own clients. Althought this is specific to PSDP, you can read it with an eye toward your own change management procedure. Do you use version control software? Do you use promotion groups?

The problem with collecting individual items is that the user inputting the item tends to put to much information in tasks and use requirement items and design items only as a secondary thought. When collecting project information, you generally collect a combination of what the customer wants (the requirement), how you want to code it (the design), how to test it (the test script), and even a bit of end-user documentation. Your tendency will be to put all of it in whatever bucket your looking at. A PSDP Artifact puts you on a single page where you can put information into their correct place, their correct bucket.

By using primarily Artifacts, you put yourself in the correct frame of mind while developing that feature from the first time you talk about it through testing it, and artifacts make managing linked items easier (one location to deal with name, category, linked actors, etc.)

Software that allows you to burn a .ISO image to CD on Windows XP or Vista and to DVD on Vista. Free and very easy to use (right click on image and select Copy Image to CD.

Check the IP address of the SMTP Virtual Server. If you want to serve ALL IP's on that box, then set it to All Unassigned IPs.

The key aspects of learning evolve by sharing or exchanging information with your peers. For a technical writer, it is very much important to focus/target towards a technical topic. This article presents a short information about the key aspects of learning and the methods/techniques used to enable the learning curve.

We're all familiar with program help systems. At Prestwood, of course, we need to author them for many of the applications we create.

There are many help authoring tools available, and HelpScribble is one of my two favorites.

Now, even though you may not need to create program help systems, help files, on their own, can be a great way to organize and convey all manner of information. Because they can contain a table of contents, an index, search capabilities, hyperlinks from one topic to another, and embedded graphics, they can be a wonderful way to document many kinds of complex information - say a training manual for new workers - in just about any industry.

The people at Just Great Software like to say that, "If you can scribble, you can create help systems." They're right: HelpScribble makes it about as easy as it could get. Naturally, HelpScribble includes an extensive help system of its own, which will teach you everything you need to know.

HelpScribble can produce

• WinHelp (.hlp files),
• Compiled HTML Help (.chm files),
• Rich Text Format (.rtf files) for printed manuals, and
• Multi-page HTML output - suitable for web help.

At only $99, this is one of the best software bargains I've encountered.

You can read all about HelpScribble, and download a free trial here:
http://www.helpscribble.com/

VB Classic is a non-OOP language with some OOP features. It offers both Subs and Functions. A Sub does not return a value while a Function does. When Subs and Functions are used in a class module, they become the methods of the class.

Sub DoSomething(ByVal pMessage As String)

  MsgBox (pMessage)

End Sub

Function GetAge(ByRef pFullname As String) As Integer

  GetAge = 7

End Function

VB.Net uses a special property keyword along with special get and set methods to both get and set the values of properties. For a read-only property, leave out the set method. The value keyword is used to refer to the member field. Properties can make use of any of the access modifiers (private, protected, etc).

My preference for VB.Net code is to start member fields with "F" ("FName" in our example) and drop the "F" with properties that manage member fields ("Name" in our example).

VB.Net supports both partial classes and partial methods.

Languages Focus: End of Statement

In coding languages, common End of statement specifiers include a semicolon and return (others exist too). Also of concern when studying a language is can you put two statements on a single code line and can you break a single statement into two or more code lines.

Console.WriteLine("Hello1")
Console.WriteLine("Hello2")
Console.WriteLine("Hello3")
 
'The following commented code 
'on a single line does not work...
'Console.WriteLine("Hello4")  Console.WriteLine("Hello5")
 
'Two or more lines works too with a space+underscore:
Console.WriteLine _
 "Hello6";

As of early 2008, we test each website we build with the latest release of Internet Explorer, FireFox, and Safari. Sometimes we also include Opera but not usually. Also, if desired, we sometimes test with older versions of browsers but not usually. The minimum resolution we test "regular" websites is 1024x768 (and higher). We no longer support 800x600.

Protect your computer before it slows down, you lose data, or someone steals information. The basics are an antivirus program, Windows Updates, and a firewall. Beyond that, I like to use several programs that add layers of protection to your computer.

Do you want free software? You know you do!

Did you know that Microsoft offers tons of free software? Most of us know of a few free titles, like the Express editions of Visual Studio and SQL Server.

But there's more, much, much more.

At this link you'll find a great compilation of free software offerings from Microsoft.

For similar Vista offerings, see the link below.

If you intend to use it ONLY for ReadyBoost, the current limit ReadyBoost will use as of early 2008 is 4 GB. Another guideline you could use is that Microsoft is currently recommending a ReadyBoost cache size of 1 to 3 times your RAM. So, if you have 1 GB or RAM, they recommend a 1 to 3 GB ReadyBoost cache.