You are here: Advisor.com » Advisor Guides » DataBased Advisor » DataBased Advisor gives you everything: All Advisor's IT, collaboration, development, admin, database and tech know-how in one place, including Microsoft Access, .NET, Office, SharePoint, SQL Server, Visual Basic, Visual FoxPro, and Visual Studio, and IBM Lotus, WebSphere and Workplace, and Novell GroupWise, and Law Technology, Compliance and E-Discovery, plus E-Business, Mobile Business, Security, and more. DataBased Advisor -- the authority since 1983.
My.ADVISOR.com Sign-In
EXPERT ADVICE ON BUSINESS DATABASE, DEVELOPMENT & COLLABORATION TECHNOLOGY SINCE 1983
You are not signed-in. If you are a subscriber to this publication, sign-in above to access locked articles. To subscribe or renew go to www.AdvisorStore.com.
Here's a formula that tests to see if a record belongs to the currently logged-on account, but also allows the full-access password to see all records.
When your program stops working, you need to know what you've changed. Here's a utility that will let you quickly compare the old and new versions of your code—or any text file—to find out what's different.
Often, data you want to import into FileMaker Pro comes to you in a format that is not conducive to the proper design of a database. Here's a parsing technique to speed things up.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
Companies that take charge by proactively managing enterprise information reduce litigation risk, maintain compliance more efficiently, and save a bundle in the process
Complex hierarchies can be tricky. Here's how to treat top-level items, work with hierarchical found sets, let users expand and collapse records independently, and more.
If you work with controls for long, sooner or later, you'll want to create a new property for a control. Unfortunately, in VBA, you're limited to exactly the control behavior that the original programmers provided.
Blogs let anyone publish their latest thoughts to the world. Make sure your employees are crystal clear on what is OK to discuss in a personal blog -- and what isn't.
By Christopher Byrne, The Cayuga Group vice president and practice manager, and Richard Schwartz, RHS Consulting managing consultant
Here's how to create a custom exception class that inherits from System.ApplicationException (or System.Exception), and add custom properties as necessary.
If you aren't ready for for Microsoft Windows Communication Foundation (WCF) or aren’t upgrading to Visual Studio 2008, you can still write applications which are transport neutral -- where the same code will work across local, Web service, and remoting calls -- using Visual Studio 2005 and ASP.NET 2.0.
Make sure that your users know which row is the current row in a continuous form by highlighting it—and use practically no code.
By Christopher Weber
-- SUBSCRIBER NOTICE --
In 2007 several Advisor business/technology publications were merged into DataBased.Advisor.com and subscriptions were upgraded to this much larger publication. Subscribers can sign-in now to get EVERYTHING in all Advisor publications -- more than 10,000 articles, tips and downloads, including all new articles when published, and everything in the ever-growing reference library. - Merger/Upgrade details - Subscriber online access instructions - Subscribe or renew
You're using ESS to link a FileMaker Pro database to an external database, and you've changed some values. Some of these values sync and some don't. Here's the answer to this mystery.
By Chris Moyer, technical editor; and Bob Bowers, techncial editor
Indexing your data improves solution performance and can help you in many ways, but it can be a little tricky to figure out how it all works. Get to know the ins and outs of FileMaker Pro indexing here.
It's hard to underestimate the power of XPages. It could be the most important Domino feature since the HTTP task debuted with version 4.5. Find out why.
By Terrance A. Crow, Corporate One assistant vice president of technology and DataBased Advisor technical editor
Most users don't even know how to cancel a script, but many users know how to accidentally type the right keys at the wrong time. So find out how to protect your solutions with the Allow user Abort script step.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
Indexing your data improves solution performance and can help you in many ways, but it can be a little tricky to figure out how it all works. Get to know the ins and outs of FileMaker Pro indexing here.
Find out what to do if you want to normalize contact data, but you don't have complete contact information.
By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor
Effective deployment and administration of either version of FileMaker Server 9 requires you to open a number of TCP ports on the various machines that comprise the FileMaker Server 9 environment.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
Learn how to build a LotusScript Extension (LSX) in MS C++ 6.0 to capture key presses such as the ENTER key in such a way that you can identify the UI field in which the key press occurred.
By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor
Often, data you want to import into FileMaker Pro comes to you in a format that is not conducive to the proper design of a database. Here's a parsing technique to speed things up.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
Get it all -- every current and past ADVISOR tech/business publication, now all-in-one subscription, with new articles and a huge reference library packed with expert advice, how-to and downloads. Subscribe now to get it all.
Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.
Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!
RSS Feed
= free access
= subscriber-only
= not online (on CD or in print)
= has download
RSS FEEDS
