devxlogo

Tip Bank

Sensing Browser Type

You can easily find out the browser type, version, and sometimes the operating system that your visitors are using by checking the userAgent and appVersion properties of the navigator object.

Alwyas on Top

Question: How can you make your application “always on top,” just like the Windows clock application can? I use PB 4.0 and Windows 3.1. Answer: Use the SetPosition command to

Converting txt Files

Question: How can I import a delimited text file into a SQL Sever table? Answer: Welcome to the world of BCP. Included with SQL Server, the Bulk Copy Program will

SQL and arrays of data

Question: I need to enter up to 1,600 measured data points into a SQL database. Each point makes one record. Is there a way to enter all of these records

sql user name

Question: How can I find out the user name at SQL prompt. Answer: In SQL Server, you can write select user_name()

Two lines of text in command buttons

Question: Is there a way to display the text on two lines with a command button in PowerBuilder 5? We have already tried the ~n. Answer: There is no way

Unmatched Query

Question: When one is working with large amounts of data, what is the quickest way of displaying rows not found when comparing two tables, without doing the following: SELECT table1.field1

Using ActiveX controls in PowerBuilder 6.0

Question: I would like to know how to find information(books, online documentation) on using ActiveXcontrols in PowerBuilder. Answer: I find the best way to learn how to use a new