Schultz’s PowerBuilder Notes

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

August 10, 2009 Posted by | 2. Datawindows, Uncategorized | , , , , , , | 1 Comment