Tip Bank

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

Will VBScript Ever Be Platform Independent?

Question: Will the VBScript in the coming version Visual Basic 7 be platform independent? Answer: Unless Microsoft decides to radically change things, Visual Basic 7.0 will not use Visual Basic

DevX - Software Development Resource

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

DevX - Software Development Resource

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