CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Update a Joined Query

Print topic Send  topic

Author Message
J Bond
Posted: 10/08/2002, 3:29 PM

Problem is I get this error
Command text was not set for the command object. (Microsoft JET Database Engine)

This is likely due to my update form usinga joined tables.

How can I force the update, of a known record. As the form is using a joined query to display details from mutiple tables.

ie All I need to do is change the value of 2 fields on the displayed record.

Any suggestions appreciated.
J Bond
Posted: 10/08/2002, 3:37 PM

Using CSS 1.0.7
Timothy
Posted: 10/09/2002, 7:32 AM

Hello,
Select SQL from Custom Update Type property of the record form and enter custom update query.
Hope it helps.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.