[GNUe] zipcode

[Christophe Vigny]

Hi, small contrib to zipcode here for mysql user.

I run the exemple zipcode.gfd with the wx and win32 UI, and i have a 
problem selecting a state in the combo box,  first the selection of the
state isn't incremental when u type w u have washington, and then u type 
y for wyoming and it don't work, second when u drop down the list (with F4)
u cant use the arrow to select the state !

Is it possible to have extension off that exemple, using trigger, and 
navigator (i want to see if we do only one login for all the form in the 
navigator).

Is it possible to use common in order to open a recordset, iter from it 
and update each record etc ..., in a better way than with only db api ?





"Ce message et toutes les pièces jointes sont des informations
strictement confidentielles et réservées au(x) destinataire(s). Ce
courriel n'a pas de valeur contractuelle et son contenu ne constitue ni
une acceptation, ni un engagement de la part de l'auteur et des sociétés
du groupe Serveur et Artprice, sauf dans le cas où cela aurait été prévu
avec le destinataire par un accord écrit. Le contenu de ce message et
les pièces jointes ne peuvent constituer une preuve au sens de l'article
1316-1 du Code Civil. L.auteur et les sociétés du groupe Serveur et
Artprice déclinent toute responsabilité au titre de ce courriel s'il a
été altéré, déformé, falsifié ou indûment utilisé par des tiers ou
encore s'il a causé tout dommage ou perte de toute nature. Si vous
n'êtes pas le bon destinataire, merci de nous contacter et de ne pas le
divulguer."

"This message including any attachments are confidential and privileged
material intended solely for the addressees. Its contents do not
constitute a commitment by groupe Serveur sas and Artprice SA, except
when provided for in a written agreement with the addressees. The
contents of this message cannot constitute neither the proof nor the
acceptance of any agreement as per article 1316-1 of the French civil code.
Groupe Serveur sas and Artprice SA shall not be rendered liable in any
manner whatsoever for the delay and/or loss in transit of this message,
for corruption, alteration, falsification, misuse or fraudulent use
(which may be made) of this message. If you receive this message in
error, please delete it and immediately notify the sender. If the reader
of this message is not the intended recipient, you are hereby notified
that any unauthorized use, copying or dissemination is prohibited."

drop table if exist state;
create table state
(
  state char(2)                 PRIMARY KEY,
  description varchar(30)       NOT NULL
);

drop table if exist zipcode ;
create table zipcode 
(
  zip char(5)      PRIMARY KEY, 
  city varchar(30) NOT NULL,
  state char(2)    NOT NULL REFERENCES state
);

INSERT INTO state (state, description) VALUES('AL','Alabama');
INSERT INTO state (state, description) VALUES('AK','Alaska');
INSERT INTO state (state, description) VALUES('AZ','Arizona'); 
INSERT INTO state (state, description) VALUES('AR','Arkansas'); 
INSERT INTO state (state, description) VALUES('CA','California'); 
INSERT INTO state (state, description) VALUES('CO','Colorado'); 
INSERT INTO state (state, description) VALUES('CT','Connecticut'); 
INSERT INTO state (state, description) VALUES('DE','Delaware'); 
INSERT INTO state (state, description) VALUES('DC','District of Columbia');
INSERT INTO state (state, description) VALUES('FL','Florida');
INSERT INTO state (state, description) VALUES('GA','Georgia'); 
INSERT INTO state (state, description) VALUES('GU','Guam');
INSERT INTO state (state, description) VALUES('HI','Hawaii');
INSERT INTO state (state, description) VALUES('ID','Idaho'); 
INSERT INTO state (state, description) VALUES('IL','Illinois'); 
INSERT INTO state (state, description) VALUES('IN','Indiana'); 
INSERT INTO state (state, description) VALUES('IA','Iowa'); 
INSERT INTO state (state, description) VALUES('KS','Kansas'); 
INSERT INTO state (state, description) VALUES('KY','Kentucky'); 
INSERT INTO state (state, description) VALUES('LA','Louisiana'); 
INSERT INTO state (state, description) VALUES('ME','Maine'); 
INSERT INTO state (state, description) VALUES('MD','Maryland'); 
INSERT INTO state (state, description) VALUES('MA','Massachusetts'); 
INSERT INTO state (state, description) VALUES('MI','Michigan'); 
INSERT INTO state (state, description) VALUES('MN','Minnesota'); 
INSERT INTO state (state, description) VALUES('MS','Mississippi'); 
INSERT INTO state (state, description) VALUES('MO','Missouri'); 
INSERT INTO state (state, description) VALUES('MT','Montana');
INSERT INTO state (state, description) VALUES('NE','Nebraska'); 
INSERT INTO state (state, description) VALUES('NV','Nevada'); 
INSERT INTO state (state, description) VALUES('NH','New Hampshire'); 
INSERT INTO state (state, description) VALUES('NJ','New Jersey'); 
INSERT INTO state (state, description) VALUES('NM','New Mexico'); 
INSERT INTO state (state, description) VALUES('NY','New York'); 
INSERT INTO state (state, description) VALUES('NC','North Carolina'); 
INSERT INTO state (state, description) VALUES('ND','North Dakota'); 
INSERT INTO state (state, description) VALUES('OH','Ohio'); 
INSERT INTO state (state, description) VALUES('OK','Oklahoma'); 
INSERT INTO state (state, description) VALUES('OR','Oregon'); 
INSERT INTO state (state, description) VALUES('PA','Pennsylvania'); 
INSERT INTO state (state, description) VALUES('PR','Puerto Rico');
INSERT INTO state (state, description) VALUES('RI','Rhode Island'); 
INSERT INTO state (state, description) VALUES('SC','South Carolina'); 
INSERT INTO state (state, description) VALUES('SD','South Dakota'); 
INSERT INTO state (state, description) VALUES('TN','Tennessee'); 
INSERT INTO state (state, description) VALUES('TX','Texas');
INSERT INTO state (state, description) VALUES('UT','Utah'); 
INSERT INTO state (state, description) VALUES('VT','Vermont'); 
INSERT INTO state (state, description) VALUES('VA','Virginia'); 
INSERT INTO state (state, description) VALUES('VI','Virgin Islands');
INSERT INTO state (state, description) VALUES('WA','Washington'); 
INSERT INTO state (state, description) VALUES('WV','West Virginia'); 
INSERT INTO state (state, description) VALUES('WI','Wisconsin');
INSERT INTO state (state, description) VALUES('WY','Wyoming');