Tip Bank

DevX - Software Development Resource

User-Defined Data Type in a Temporary Table

Question: Can I use a user-defined data type when defining a temporary table in a stored procedure? Answer: You can use user-defined data types in temporary tables, but remember one

DevX - Software Development Resource

CopyURLToFile – Download a file from the Internet via FTP or HTTP

Const INTERNET_OPEN_TYPE_PRECONFIG = 0Const INTERNET_FLAG_EXISTING_CONNECT = &H20000000Private Declare Function InternetOpen Lib “wininet.dll” Alias “InternetOpenA” _ (ByVal lpszAgent As String, ByVal dwAccessType As Long, _ ByVal lpszProxyName As String, ByVal lpszProxyBypass

DevX - Software Development Resource

Determining Field Data Type

Question: Is there a non-platform-specific SQL way of determining what data type a given field is? Answer: That information is specific to each database. Every product stores its meta data

DevX - Software Development Resource

Renaming a File

To rename a file, use the standard function rename() (declared in ). This function takes two arguments of type const char *, the first of which is the old name

DevX - Software Development Resource

Deleting a File

The standard function remove() deletes a file. It takes one argument of type const char * which is the name of the file to be deleted. You can provide a

DevX - Software Development Resource

New & Malloc

Question: I understand that most of the time, new and malloc may use the same allocation routines, but does that necessarily mean new calls malloc? I am asking because I

DevX - Software Development Resource

Superclass Variables Referencing Subclasses

Question: What is the advantage of declaring a variable as a superclass referenceand then pointing that variable to an instance of a subclass? Theway I see it, I can achieve

DevX - Software Development Resource

Debugging in Visual C++

Question: Is there a way to access the call stack debugging information from the code? I would like to print the call stack inside a function, each time it is

DevX - Software Development Resource

Obtaining the Max Value from an Array

Question: How can I make a function to return and display the maximum number in the following array: int my_array[]={10,3,35,101,65,100}; Answer: First, sort the array. Then display the last element