How to write table data in uppercase only

Home | Site map

HowTo: Write table data in uppercase only

This document describes the steps you need to follow to add records to your database in uppercase only.

The simplest method is to make changes in Events tab on eleventh step of your ASPRunner/PHPRunner project. For that you need to go through a couple of steps.

	Double click on Before Record Updated Event
	Choose from one of the predefined actions Custom Code and click OK

Modify sample event code putting to appropriate place following code snippets

ASPRunner Example

dict("Make") = UCase(dict("Make"))
dict("Model") = UCase(dict("Model"))

PHPRunner Example

$values["Make"]=strtoupper($values["Make"]);
$values["Model"]=strtoupper($values["Model"]);

Make the same for Before Record Added Event

These changes will apply to Make and Model fields. Now, these fields will be written to database in upper case.

Applies to:
ASPRunner Pro
PHPRunner

Home | Products | Downloads | Support | Contacts

All comments send to webmaster@xlinesoft.com