Tip Bank

DevX - Software Development Resource

Common Stored Procedures

Question: I have three databases in SQL Server 6.5. All have the same structure of tables and stored procedures, but whenever I change stored procedures in one I must do

DevX - Software Development Resource

Determining Visual Fox Pro Field Length

Question: Is there a way, using Visual FoxPro, to determine the maximum number of characters (not spaces) in a field? I am working with a table that has over 3

DevX - Software Development Resource

Changing NT 4.0 File Ownership

Question: Is there any way to change the ownership of files and directories with scripts or programs? Answer: You can use the SubInAcl.exe file (included in the NT 4.0 Resource

DevX - Software Development Resource

Binary File Support in SQL

Question: I have been asked to develop a database of imagery from a company’s slide collection that needs to be incorporated into a Web site. Does SQL support binary files?

DevX - Software Development Resource

Choosing a Career in FoxPro

Question: I’m equally comfortable using both VB and FoxPro. Each product has its pros and cons. I think VB has a better developed IDE and debugging facilities. FoxPro, on the

DevX - Software Development Resource

Passing Text Fields

Question: I need to pass large fields of text. Problem is, some of the text has single quotes in it ( ‘ ). How do I pass these text fields

DevX - Software Development Resource

Remotely Shutting Down NT Using VB

Question: I am writing an application that needs to be able to shut down any NT workstation or server remotely. Do you have any ideas on how to do this

DevX - Software Development Resource

Migrating Data from R:BASE to SQL

Question: My company has been using R:BASE in the past and we recently upgraded our network and installed SQL. How can I migrate my old R:BASE data into SQL? I

DevX - Software Development Resource

Associating an Icon with an EXE File

Question: I am using VFP 5.0. When I create an EXE file, how can I get my own icon associated with it? (instead of a Fox head) Answer: First, when