Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pratik Singh
  Where is Pratik Singh?
 Kota
 India
 Pratik Singh
 To: Tore Bleken
  Where is Tore Bleken?
 Stokke
 Norway
 Tore Bleken
 Tags
Subject: RE: mysql structure update
Thread ID: 395421 Message ID: 395427 # Views: 44 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, January 14, 2014 8:27:49 PM         
   


Thanks Tore

I just clear my problem. When i develop or amend my project so sometimes as per requirement add some fields my existing table in my development machine. that is easy i add fields like alter table command in mysql table.
now what i want
i dont know how many fields add in table and which tables after exectuing exe file in client machine and in other word when customer runs new exe file he does not knows how to impliment new fields in database. so i need a program to check tables

if table not exist in database then create table and if table exits in databse then add missing fields they havent in table


Regards
Pratik

ENTIRE THREAD

mysql structure update Posted by Pratik Singh @ 1/14/2014 8:01:32 PM
RE: mysql structure update Posted by Tore Bleken @ 1/14/2014 8:12:07 PM
RE: mysql structure update Posted by Pratik Singh @ 1/14/2014 8:27:49 PM
RE: mysql structure update Posted by Pete Sass @ 1/14/2014 8:21:38 PM
RE: mysql structure update Posted by Vivek Deodhar @ 1/15/2014 6:31:12 AM