mobile database, paperless forms, and wireless synchronization … where you need to work
Providing Pocket Access, Mobile Database, Windows CE Database, and Windows CE Development Solutions



Winter, 2011 Edition
 

Thank you for reading the SYWARE, Inc. monthly newsletter, which provides updates on our mobility products, offers tips, and highlights industry-related articles and resources.

  • Technical Tip: Having mEnable Use Windows Authentication to Login to SQL Server
  • Technical Tip: Associating a Name with a Variable
  • Technical Tip: Making an Edit control required


Technical Tip from "Dr. DeeBee": Having mEnable Use Windows Authentication to Login to SQL Server

One way to establish a SQL Server connection is to provide a user name and password. Alternatively, SQL Server has a way to verify your credentials based on your network login (in the setup of a SQL Server ODBC datasource, this is refered to as "Windows NT authentication using the network login ID"). Here how to setup mEnable Use Windows Authentication.

Technical Tip from "Dr. DeeBee": Associating a Name with a Variable

Within your form, you may use variables. By just looking at the variable reference (@var(0), @var(1), etc.), there is no way to really know what kind of data it holds. Is it an employee id? An age? A record counter? Starting in Visual CE version 12.1, you can associate an alias (a.k.a. a name) with a variable.

Technical Tip from "Dr. DeeBee": Making an Edit control required

To makea an edit control required, all you have to do is set the miniumum number of characters to be non-zero. Here are step-by-step instructions on how to do that.


Have a success story? Tell us here.