Your method has one very useful feature, for multi-user environment, you can always get the latest datarathinagiri wrote: Yes. I invoke the SQL query as and when we require the data.
Yesrathinagiri wrote: This method would have some drawbacks too. In the case of remote server concept, the bandwidth may the problem. May be we should download the master data once and store locally in an array. Otherwise, for SQLite and LAN operated MySQL databases, SQL queries can be made as and when the data is required.
Yes, I use following code in my VFP apps.rathinagiri wrote: For changing table structure there is a command "alter table". I think we can write a safe user defined function for this.
I am also thinking about same type of function with Sqlite
Code: Select all
Function AddField(cTablenm, cFieldnm, cTypeLen, cDefaultVal) if !used(cTablenm) **** used() function works differently in Fox use &cTablenm in 0 endif select &cTablenm if type(cFieldNm) = "U" alter table &cTablenm add &cFieldnm &cTypeLen default &cDefaultVal endif use in &cTableNm return * usage is like addfield("Emp", "Basic", "n(10, 2)", "0.00")
Size of our Sqlite-app code is generally bigger than Dbf-apps. I am thinking about some functions, which will reduce the size (Yes, I am lazy programmer )
With best regards.