April 10, 2000

Using PL/SQL in VFP or SQL Server

Question: Can I use Oracle’s PL/SQL in Visual FoxPro or SQL Server 6.0? Answer: No. PL/SQL is a language native to Oracle, not Microsoft’s products. Each Microsoft database product has

Date Subtraction

Question: I have a date field store in one of my database tables. How do I pull a record from that table within seven days of today’s date? today’s date

Reading From an Excel File

Question: Is there a way to store data in an Excel file from an ADO recordset by doing some sort of block read/write instead of reading/writing every data field in