In an application I am developing, I need to be able to make a windows form smaller than the minimum height limit imposed by the operating system (36 px in Vista). I have tried intercepting WM_GETMINMAXINFO and providing my own information to override the OS limits, but this only works for the user. From code I can set the height to a ...
Given a function zipdistance(zipfrom,zipto) which calculates the distance (in miles) between two zip codes and the following tables: create table zips_required( zip varchar2(5) ); create table zips_available( zip varchar2(5), locations number(100) ); How can I construct a query that will return to me each zip code from the z...
Suppose I have some 1000 odd points on a plane. Then, what I think could be done is to discard the points that do not affect the radius of the circle in any way - the points through which the convex hull does not pass [using one of the several algorithms]. This leaves us with points that do matter. Now from here on, what can be done to...
I have been tasked with setting up a flat-file SKU database for use on embedded devices with limited storage and processor speed. Basically the data I need to store consists of the following: SKU Description Location Price Qty The file will consist of several million records. The most important considerations are storage space and re...