My preference for ObjectPAL is to follow the camel casing promoted in the examples and help files originally developed by Borland. The following code works: MsgBox ("hello") For example, if you type msgbox it is converted to Msgbox. Like VB Classic, if you type any other case for command or variable names, Access VBA will change it to the "accepted" or "defined" case.
For example, are "printf" and "PrintF" equivalent? Are fullname and FullName equivalent? When you create commands, operations, methods, or variables should you worry about case?Īccess VBA is not case sensitive. More Info / CommentĬase sensitiviy in this case is referring to commands and variable names. Paradox offers a built-in reporting tool that will suffice for most desktop database applications. Microsoft Access offers a built-in reporting tool that will suffice for most desktop database applications. For example, popular reporting tools include Crystal Reports, ReportBuilder, and MS SQL Reporting Services (tied to MS SQL). A built-in reporting tool makes development of reports across many clients and applications consistent and therefore easy.Īdd-On: Development tools that do not have a built-in reporting tool need to use either a currently bundled report writer, or one of the popular reporting tools that integrates well with the development tool. For example, typically desktop databases such as Paradox and Access have a built-in reporting tool and typically that reporting tool is used with nearly every application built with it. More Info / Commentīuilt-In: Some development tools have a reporting tool built-in and some do not. Target Platforms: Corel Paradox is most suitable for creating business desktop applications that run within Corel Paradox for Windows. You can store reusable code such as custom methods and procedures in a library. You may have a short startup script but you design forms and reports and tie them together with a common form. Most Paradox applications are form based. You code in a traditional approach attaching code to objects or within a script. Although you cannot create classes, ObjectPAL has built-in objects you can use in your code. Language Overview: Object based language. Although ObjectPAL uses object oriented techniques "under the hood", it is not object oriented. Target Platforms: Microsoft Access is most suitable for creating business desktop applications that run within Microsoft Access for Windows. You code in a traditional approach using functions, procedures, and global data, and you can make use of simple classes to help organize your reusable code. It is a traditional language with a few OOP extensions. Language Overview: Class-based language. Although you can create classes, Access VBA is not fully OOP.