June 15, 1999

N.T. 4 Conversion

Question: Is there a painless way of converting a Novell 4.1 server to N.T. 4 without just performing a total rebuild? There are no applications running from the server but there is a large amount of data stored on it. Answer: Painless? No, not really. The easiest way is to

OLE Commands for Powerbuilder to Word/Excel

Question: I was wondering if there is a list available somewhere of all the commands with their syntax for OLE? I want to manipulate Word and Excel from inside Powerbuilder without using the standard plug-ins. Answer: There are two places to look for the commands and their syntax. The first

Accessing 2 or More Databases

Question: How do I access more than one database (e.g., Oracle and Access) via a Powerbuilder application? I currently have ODBC drivers for both databases, but cannot access the required tables simultaneously. Answer: You will need to create two transaction objects and connect to each database with a different transaction

NT Scheduling

Question: How do I schedule to run my Exe automatically?When I schedule it, the exe does not run. Answer: First, for Command Scheduler to work consistently, the Schedule service must be configured for Automatic startup in the Services option of Control Panel. And second, dump the raw AT command and

Counting Time

Question: How can I count how long an application is used? Answer: You can use two time variables for this. Use the first variable to record the start time, then the second variable to record the later time. Then use the SecondsAfter() function to return the number of seconds between

PowerBuilder 6.5 and MS Word 97 Example

Question: Do you have any examples of calling MS Word Visual Basic to open, modify, print and close a document (i.e., calling macros, inserting tables)? Answer: Here is an example of connecting to Word, and creating a table, then populating the table with headings, it should give you a few

Running NT Server 4.0 with Service Pack 4

Question: I have a question about running NT Server 4.0 with Service Pack 4. On start-up, I’m getting an error in my event log: Source: Server Control Manager, EventID 7023, “The Server service terminated with the following error: Not enough server storage is available to process this command.” I tried

Use the Intern Method to Achieve String Equality

String comparison doesn’t work for variables. In fact, only variables referencing the same string will work. The String class has an intern method, which lets you compare two variables. This intern method returns a canonical representation for the string object. You can compare interned Strings using == operator. In this

SQL Server 7.0 Allows Table and Field Names With Spaces

SQL Server 7.0 allows field and table names to contain spaces or other characters that violate valid identifier rules. These table or field names should be enclosed in “[” “]” when used in SQL expression or queries. If the quoted identifier is set to “ON”, double quotation marks can also

No more posts to show