Database Synchronization

2001-11-08 Thread Tim Cowan
Hi Is it possible to synchronize databases. Let me tell you the scenario. The client lives out of town and wants to do point-of-sale at their place of business. Internet connection is not very reliable. They already have a comprehensive database that runs at an ISP in town. I would like to s

Query by design...

2001-09-08 Thread Tim Cowan
Hi Does anyone know of a QBD (query by design) interface for MySQL? What I mean is the same thing that MS Access has where you can drag fields, create joins and have it generate SQL syntax. Right now I am using MS Access via MyODBC. but Access has its own peculiarities. Has anyone created or d

Table joinning problem...

2001-08-30 Thread Tim Cowan
thing to tell whether they are in the trial. Thanks Tim Cowan ** # # Table structure for table `judges` # CREATE TABLE judges ( judgeid tinyint(3) unsigned NOT NULL auto_increment, judge char(70) NOT NULL default '&#x

4 fields to form key

2001-08-23 Thread Tim Cowan
Hi Is it possible to use 2 or more fields to become the primary key. I have a table CREATE TABLE tmptraining ( rowid int(10) unsigned NOT NULL auto_increment, sid char(32) NOT NULL default '', expiry date NOT NULL default '-00-00', arenaid tinyint(1) unsigned NOT NULL default '0',