Tip Bank

DevX

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

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

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

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

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

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

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

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

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