Tip Bank

Question: Why can’t I run an application like ws-ftp from SQL with xp_xmdshell? ws-ftp will start, but it’s not visible on the screen. Answer: xp_cmdshell runs in the space of

Question: What is the advantage of creating temporary tables? Answer: SQL query optimizers, while usually very efficient and accurate, sometimes refuse to evaluate a query in the most efficient manner.

Question: How do I set up a field in a table to accept the current date and time? And how do I insert the current time/date into this field? Answer:

Question: I have code in Visual Basic that allows a user to search the Registry and return a value from the passed key and path. Can you show me a

Question: Do I necessarily need a WAP gateway in order to view WML documents that reside on my Web server, or what is the WAP gateway for? Answer: You don’t

Question: I’m getting the first “page” of data from a table and I’m wondering about getting the next page… I’m using the query: SELECT TOP 50 ID, Name, Address, Phone,

Question: I am running Informix 7.3 on SCO Openserver 5. I run Ontape every morning and it has been going fine. Starting yesterday I’ve been getting the following error: Archive

Question: I am new to VFP. I want to create a unique number for a customer ID field in a table. The VFP sample program “tastrade” simply uses NEWID() as

Question: I’m trying to install the of Informix for WinNT and during the process I get error number 126? Answer: Have you rebooted your system after installing the ODBC? It