devxlogo

Tip Bank

“Out of Memory” Error

Question: About halfway through compiling a 32-bit EXE with PB 6.5 on Windows NT, I keep getting an “out of memory” message box and then another that says “DDE Server

Accessing Multiple Databases from a Datawindow

Question: Using a single datawindow, can I access data from multiple databases (Oracle and Sybase)? If not, can I use PowerBuilder to access it without having any intermediate table? Answer:

IIS Applications

Question: When I try to create a new IIS app,I receive an error message: “IIS or peer web services 3.0 or latermust be installed,” but IIS is installedand running on

How to Pass a Variable into Report

Question: When I use a datawindow to generate a custom report, how can I pass a variable into the report from an input field? Answer: You can do this through

Insert Column into Table

Question: What is the proper syntax to insert a column into an existing SQL table? Answer: Here’s the syntax to add a column to a table: ALTER TABLE Employees ADD

ADO Events

Question: How do I use the ADO events FetchProgress or FetchComplete? Answer: If you want to use these, they work just like other events generated by other objects. When you

Determining Variable Length

Question: How do I test the number of ‘characters’ contained within a given variable? Answer: Try this: Debug.Print “Length: ” & Len(CStr(X)) Once you convert a variable to a string,