Datawindow Retreive With Large In Clause
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
Other Event
Mouse Scroll Wheel (other event)
The user can hold down control and then use the mouse scroll wheel to zoom in or out. This can be disabled with the code below. If you want to disable the scroll wheel all together, you would just remove “AND KeyDown(KeyControl!) ” from the code.
// dw's "other" event CONSTANT integer LCI_MOUSEWHEEL = 522 IF message.number = LCI_MOUSEWHEEL AND & KeyDown (KeyControl!) THEN message.processed = TRUE RETURN 1 END IF
Expression Syntax
Like
“Like” can be used to create an expression to look to see if a string to exists anywhere in a column. For example, if you want to filter to include only names which have the string “ing”:
name like “%ing%”
Continue reading
How do I Enable Just-In-Time Debugging
In the PowerBuilder System Options dialog window, check the Just-in-Time Debugging option. This feature was new in PB 6.0.
In PowerBuilder 7.0, Systems Options is under the Window menu column (Window>System Options…)
-
Archives
- August 2009 (2)
- May 2009 (1)
- March 2009 (1)
- January 2009 (2)
- December 2008 (1)
- November 2008 (2)
- September 2008 (1)
- August 2008 (1)
- July 2008 (24)
- June 2008 (22)
- May 2008 (69)
- April 2008 (25)
-
Categories
-
RSS
Entries RSS
Comments RSS