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. -- John Fabiani _______________________________________________ Post Messages to: [email protected] 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]
