devxlogo

Tip Bank

Refreshing a Menu

Question: How can I refresh or redraw a menu? Answer: If you make one of the menu items nonvisible and then make it visible again, it should refresh the menu

Sharing Calendars Without Exchange

Question: How do I set up a shared calendar, or at least public access to other people’s private calendar, in a network that uses Outlook 2000 and Windows NT server

ActiveX Code Not Working in IE5

Question: Our company is developing a Web site with some ActiveX code. On Windows 98 with Internet Explorer 5 loaded, some can see that portion of code perfectly, and then

Using ANSI SQL Versus Transact SQL

Question: Is it advantageous to use ANSI SQL syntax or SQL Server syntax? For example, Inner Joins: Select * from T1 inner Join T2 on t1.id=t2.idSelect * from T1,T2 where

PowerBuilder Compatibility with Oracle

Question: I used PowerBuilder with another database tool at my previous employer. Unfortunately, I have transferred to another company that uses Oracle and Oracle Developer. Can I use PowerBuilder with

Embedded Apostrophe in a Query

Question: When I pass a string containing an embedded apostrophe in a query to SQL Server, it sees the apostrophe as an end-of-string marker. Example: “Select * from Members Where

Best Approach to Designing Three-Tier Systems

Question: I am aware of the recommended approach to developing three-tier systems?for example, presentation layer to business objects to data objects. Say I have a system that has a data

Column-Level Permissions or Access

Question: I have a table that contains about six million records. Each record contains some sensitive data or data that be accessible by the public. What would be the best