Question: Is it possible to design a pull down menu that will show over an object? Every way that I’ve tried still hides the part of the menu behind the

Question: Can we call a nested procedure in ASP? Answer: Nope. This isn’t supported in any Visual Basic-variant language. Having done nested procedures before (Pascal, I think), I never saw

Question: After retrieving data into a recordset object, I want to filter this data. I tried using the objRs.filter method of ADO, but it doesn’t seem to work. This is

Often when you’re developing script, you may want to determinejust how long the code takes to run. To do so, take advantage ofASP’s built-in Timer function. As you may know,

Question: How do I use Active Server Pages to create WAP pages? Answer: By setting the MIME type, you can use ASP to write WML. This command accomplishes this: Response.ContentType

Question: When I create a spinner control and limit the upper and lower limits to specific integers, how do I wrap around the spinner to a specific integer range? For

Question: After I install this driver, I see the error message when starting Lotus Notes Application: “The application uses CTL3D32.DLL, which is not the correct version. This version of CTL3D32.DLL

Question: Can WAP pages be built to interface directly with a phone and its functionality? Answer: Yes, you can write WAP pages that will display and call phone numbers directly,

Question: We have an application; within it is a file with the extension .DCT. What are .DCT files? Answer: DCT files are one of the files that Visual FoxPro uses

Question: How can I make the Visual FoxPro main window minimize and maximize through code? Answer: VFP forms and the _SCREEN object have a property called “WindowState” that can be

Question: I am trying to populate the stores (demo) database with a SQL script through dbaccess. The script keeps on returning syntax errors. The script is as follows: DECLARE status

Question: Can WAP pages be secure? Answer: Absolutely. WAP pages can be used for sending and receiving confidential information, such as credit cards and/or bank account statements. WAP was designed

When an error message is logged into the errorlog table, there is often a need to know the entire call stack, to debug the exact location of the error. This

Often the existing data in the database needs to get updated, even if they are part of any primary or foreign keys. In Oracle8.0, it is possible to defer integrity

There are times when duplicate records somehow creep into a table despite your best efforts. This happens more in cases where data is loaded into table from other sources because

The LIKE statement is often used in SQL queries with wildcards to find data that issimilar to a matching pattern. PL/SQL has two forms of wildcard: _ and %. The

You often encounter requirements for reports to retrieve the top-n/first-n rows of a table Related Posts Perform Connectionless Communication Between Producer and ConsumerMicrosoft’s Azure Search Becomes Generally AvailableComponent-based JavaScript Development

In a nested procedure environment, I have often felt the need to isolatethe transactions of the child/called procedure from the parent/calling procedure’s transactions. Until Oracle8i, it used to be a

Use Cascading Style Sheets to create a floating text paragraph. First, add the attribute in the document’s section: Now, add the content you want to display in the window: Visit

Checking whether a table exists in a Microsoft SQL Server database is easy. You can use this query: SELECT ‘x’FROM sysobjectsWHERE type = ‘U’ and NAME = ‘mytable’ But this

In Microsoft SQL Server, you frequently need to navigate through data row by row. This is usually done using T-SQL server-side cursors. Considering that processing overhead on cursors is higher

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

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

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

Private Declare Function RegOpenKeyEx Lib “advapi32.dll” Alias “RegOpenKeyExA” _ (ByVal hKey As Long, ByVal lpSubKey As String, ByVal ulOptions As Long, _ ByVal samDesired As Long, phkResult As Long) As

Private Declare Function RegOpenKeyEx Lib “advapi32.dll” Alias “RegOpenKeyExA” _ (ByVal hKey As Long, ByVal lpSubKey As String, ByVal ulOptions As Long, _ ByVal samDesired As Long, phkResult As Long) As

Private Declare Function RegDeleteValue Lib “advapi32.dll” Alias _ “RegDeleteValueA” (ByVal hKey As Long, ByVal lpValueName As String) As LongPrivate Declare Function RegOpenKeyEx Lib “advapi32.dll” Alias “RegOpenKeyExA” _ (ByVal hKey As

Private Declare Function RegOpenKeyEx Lib “advapi32.dll” Alias “RegOpenKeyExA” _ (ByVal hKey As Long, ByVal lpSubKey As String, ByVal ulOptions As Long, _ ByVal samDesired As Long, phkResult As Long) As

Private Declare Function RegCreateKeyEx Lib “advapi32.dll” Alias _ “RegCreateKeyExA” (ByVal hKey As Long, ByVal lpSubKey As String, _ ByVal Reserved As Long, ByVal lpClass As Long, ByVal dwOptions As Long,

Private Declare Function RegOpenKeyEx Lib “advapi32.dll” Alias “RegOpenKeyExA” _ (ByVal hKey As Long, ByVal lpSubKey As String, ByVal ulOptions As Long, _ ByVal samDesired As Long, phkResult As Long) As