Tip Bank

DevX

Related Database

Question: I’m trying to make outer join by the query builder in Delphi 2.0 but the only active option is inner join. I want to use left outer join and

DevX

Increase Query Performance

Question: I have a form that uses one data source and one query component. The data set of the data source is the query. Depending on the process, I assign

DevX

Find Trouble Spots

Implement a low-tech trace of your application by writing a message whenever your code enters and exits a subroutine. This can help you locate elusive bugs, because you can turn

DevX

Determine Next/Previous Weekday

This function returns week identifier information, such as Week Beginning/Ending date, and makes it more generic to return a date of any previous or following weekday. You can use this

DevX

Let the Editor Check Your Spelling

To make certain that you declared your variables, place Option Explicit in your Declarations section. Using a mixture of upper and lower case in variable names, you can easily verify

DevX

DCOM and Win NT Workstation

Question: How many DCOM connections can I have on a Windows NT Workstation? (Does it have a limit of 10, like in shares?) How is performance affected when 20 users

DevX

Create DLL from PB

Question: I have an application with a lot of business logic in nonvisual objects that I’d like to deploy as DLLs callable as standard windows DLLs from applications written in