VwpFAQQueryDB

How do I query a database from VWP?

Once you have associated a table with a web page by drag-and-dropping a table node, a CachedRowSet DataProvider on the page and a JDBC CachedRowSet in the SessionBean are added to the application and are seen in Outline window, if the page is in Design View mode. Double-clicking the RowSet object (or using its Edit SQL Statement contextual menu item) will take you to the Query editor. Here you can use the graphical query editor to formulate and/or edit SQL queries, which will be saved as a property on the rowset.

Not logged in. Log in, Register

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo