Active7 years, 3 months ago
I just started working with FoxPro at school and I have a few problems when I try to create a form that needs to add data to muliple tables (no designer).
I am using the APPEND command but this seems to add data only to the main table.
Membuat database menggunakan visual foxpro: Memuat Form Menu Utama Di Visual Foxpro Selasa, 02 Desember 2014. Memuat Form Menu Utama Di Visual Foxpro Memuat Form Menu Utama Di Visual Foxpro. Memuat Form Menu Utama Di Visual Foxpro Sepert Gambar Dibawah Ini: Kan form di atas memiliki 5 tombol/command yaitu. Membuat Aplikasi Akademik Menggunakan Visual Foxpro & Database MySQL Part3 Video.
Any suggestions for a solution are greatly appreciated.
Thanks
Maria-daciana RodeanMaria-daciana Rodean
1 Answer
You need to explicitly select the work area (alias or table) before doing an append. For example, in your 'CLICK' event you would do something like...
If the tables are NOT already opened from the form's DataEnvironment, you might want to ensure they are open first by doing the following BEFORE the above Append/Replace
etc...
Additionally, VFP DOES support SQL too, so you could do
And to query data out via SQL-Select
DRappDRapp39.2k1010 gold badges6161 silver badges119119 bronze badges