zipcode

Christophe Vigny <[email protected]> Fri, 26 Mar 2004 17:49:42 +0100

Newsgroups	gmane.comp.gnu.enterprise.general
Message-ID	<[email protected]>

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."

_______________________________________________
Gnue mailing list
[email protected]
http://mail.gnu.org/mailman/listinfo/gnue

Mysql_zip_code.sql (text/plain, 3.7 KB)

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');