Edit records in mutitable query

Forum for DBF Commander discussing.

Edit records in mutitable query

Postby tdolan » Fri Apr 01, 2016 4:17 am

I'm working with Foxpro files that have bits and pieces of info stored in about 26 different files. I have figured out how to create the select query with joining 4 of the tables and can then see the records that I need to change 1 field in. Do I have to do the changing with an update query or can I edit the records as they are shown on the screen and the program save the changes back to the correct files?
tdolan
 
Posts: 2
Joined: Thu Mar 31, 2016 4:09 am

Re: Edit records in mutitable query

Postby Admin » Fri Apr 01, 2016 10:14 am

Hello,
when you run a SELECT query, new table is being created. So, changing its field values doesn't affect to the source tables. That's why, you should run an UPDATE query on the source tables.
Best regards,
Oleg Zhechkov
User avatar
Admin
Site Admin
 
Posts: 124
Joined: Wed Apr 21, 2010 7:27 pm

Re: Edit records in mutitable query

Postby tdolan » Fri Apr 01, 2016 8:40 pm

Can you tell me is the SQL used in this program MS SQL, MySQL, SqlLite or what version of SQL?
tdolan
 
Posts: 2
Joined: Thu Mar 31, 2016 4:09 am

Re: Edit records in mutitable query

Postby Admin » Sat Apr 02, 2016 11:28 am

The app uses Visual FoxPro SQL syntax. The core clauses syntax described here: http://dbf-software.com/sql-select.html
Best regards,
Oleg Zhechkov
User avatar
Admin
Site Admin
 
Posts: 124
Joined: Wed Apr 21, 2010 7:27 pm


Return to DBF Commander Professional

Who is online

Users browsing this forum: No registered users and 6 guests

cron