Updating tables using forms
I have a quick newbee question: Is is possible to update in multiple tables at the same time.
I am working with PHP scripts and will use the following example toexplain what I want to do: I have a generic_user tables, which forms a INNER JOIN with thelogon_user table (with a join using id).generic_user:- id- name- passowrdlogon_user:- id- last_logon- nickname As I load all the fields at once in an array, and want to update thesame, so just something like"UPDATE generic_user INNER JOIN logon_user USING (id) SET name='test',nickname='test2' WHERE id = 1"; Is there anybody who can explain how to do this?
The procedure below describes how to update tables using Architect.
Once a table is added to a project, you can modify and view table definitions using the Properties pane in Architect.
To view the various properties and contents of a table in Architect, from the Tables tab of the Properties pane, select the table from the drop-down list.
The table of the Micro Strategy Tutorial project shown below is used as an example of how you can modify and view tables definitions using Architect.
I can create a form for one of these but not for all three.The column names in an expanded column list are enclosed in quote marks to account for the possibility that the columns of the base object were originally entered with quotes and require them for the query to be syntactically correct.As an example, assume that the statement, the database can create the view even if the defining query of the view cannot be executed.Are their any benefits to transitioning our code to another approach with the OPENROWSET command?Yes - You are correct the OPENROWSET command can directly support INSERT, UPDATE or DELETE operations as shown in these tips: Export data from SQL Server to Excel and Different Options for Importing Data into SQL Server.