Our DBMS limits the number of Items in an “IN Clause” to 255. If you attempt to retrieve with an array of a larger size, the retrieve fails. One method of dealing with this constraint is to create a temp table, populate this with your retrieval arguments, and then have your datastore join to the temp table during the retrieve. Another way is to use a function similar to this: Continue reading
The PFC’s contains handy services to work with files saved on your PC or network. I recently had a need to collect all the files contained in particular folder and any of its subfolders. The result is this recursive function wf_GetFileNames(). Continue reading
If you have not read about how PowerBuilder treats nulls, you may want to read nulls first.
If you have worked with PowerBuilder for a while, you have learned that setting the status of a row is not always a straight forward procedure. I have created a handy utility which will simplify this process.
We all eventually need to build a datawindow where the contents of a drop down list is dependent on the value of another column.
Filtering the available selections in the dddw for the current row is straight forward, just add the necessary filtering script in the RowFocusChanged and ItemChanged events. (See DDDW Contents Based on the Value of Another Column for more information regarding this. ) But if you have a tabular view, problems may soon become apparent with dependent columns in some rows displaying code values instead of descriptions.
- 1. PowerBuilder General
- 2. Datawindows
- 3. PFC