On Wednesday 11 June 2008 07:17:33 am johnf wrote: > On Wednesday 11 June 2008 12:05:41 am Darthcoder wrote: > > John, > > Dabase is MySQL, URL > > Assume AGENTID=CRE9999, Address= Hilltop Rd 54 WAMBERAL 2260 NSW > > URL = WWW.XessWealth.net\CRE9999HILLTOPRD54WAMBERAL2260NSW.html > > if that Tail of the URL is not Unique within one appends letter A, -Z > > until successful > > OK I think I understand. I don't have MySQL loaded on my systems. I > really don't have a need. So I setup your tables on Postgres as follows: > > CREATE TABLE agents > ( > pkid serial NOT NULL, > agentid character varying(30), > "name" character(64), > address1 character(64), > address2 character(64), > city character(32), > postalcode character(6), > email character(64), > referrer character(8), > CONSTRAINT agent_pkid PRIMARY KEY (pkid) > ) > WITHOUT OIDS; > ALTER TABLE agents OWNER TO johnf; > GRANT ALL ON TABLE agents TO johnf; > GRANT ALL ON TABLE agents TO public; > > CREATE TABLE property > ( > pkid serial NOT NULL, > fk_agentpkid integer, > agentid character(8), > propertyid character varying(70), > address1 character(64), > address2 character(64), > city character(32), > state character(3), > postalcode character(6), > editrequired boolean, > voiceover boolean, > bluescreen boolean, > script boolean, > soundtrack character(64), > entrydate date, > editdate date, > hostingdate date, > lastrevision date, > status boolean, > CONSTRAINT property_pkid PRIMARY KEY (pkid) > ) > WITHOUT OIDS; > ALTER TABLE property OWNER TO johnf; > GRANT ALL ON TABLE property TO johnf; > GRANT ALL ON TABLE property TO public; > > I realize that ClassDesigner is having a problem on windows at the moment > so I'll send you a simple version of a two tab form. You will have to > create a connection (named "myagent") to get it to work but it's a simple > start. The first tab is 'Agent' with agent info (the parent) > The second tab is "properties" with the children info (in a grid). It's > not complete and I expect you will need to lots more. It took about 15 > mins to complete. I almost never use ClassDesigner - so I'm not bragging. > I'm just trying to show you how easy it is to create simple forms from the > ClassDesigner. > > I didn't try to code your URL info - I leave that up to you to complete.
Forgot to tell you that the 'pkid' fields are serial (auto-increment) and the child uses the fields along with a fk_agentpk field. See the code. -- John Fabiani _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
