
Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.
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
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
Private Declare Function RegDeleteKey Lib “advapi32.dll” Alias “RegDeleteKeyA” _ (ByVal hKey As Long, ByVal lpSubKey As String) As Long’ Delete a registry key” Under Windows NT it doesn’t work if
Private Declare Function GetVersion Lib “kernel32″ () As LongConst HKEY_LOCAL_MACHINE = &H80000002′ Return the name of the registered user” Requires the GetRegistryValue functionFunction GetRegisteredUser() As String Dim regKey As String
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 GetVersion Lib “kernel32″ () As LongConst HKEY_LOCAL_MACHINE = &H80000002′ Return the name of the registered organization” Requires the GetRegistryValue functionFunction GetRegisteredOrganization() As String Dim regKey As String
Question: I have developed a custom AWT component that can be placed at any level in a component hierarchy. How can it determine the top level Frame in the hierarchy?
Question: How can I enumerate the methods of an object? I know there must be away since JBuilder and other IDEs know how to populate a list ofmethods from a
Question: I have several checkboxes and I want one checkbox tocause all of the checkboxes to be selected when it is selected. Howcan I do this? Answer: Even though the











