<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=content-type content=text/html;charset=iso-8859-1>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY bottomMargin=0 leftMargin=3 topMargin=0 rightMargin=3>Posting this to the
use-rev list as well. So others can become more familiar<BR>with this new
feature.<BR><BR>> But now the set up is different. Can you just walk us
through?<BR>> 1. Select a field?<BR>> 2. Open dbquerymanager and enter log
in details, click connect (I was<BR>> successful with that.... i.e. i was
obviously now connected to the<BR>> dBase on the honolulu server..)<BR><BR>1)
Open the db query manager.<BR>2) Enter the log in details<BR>3) click
connect<BR>4) click to the recordset tab<BR>5) If you plan to display images
> 64k check 'display large binary data'<BR>6) If your using a database like
Oracle with forward only moving cursors, or<BR>want to avoid requerying the data
check 'cache resultset'. I would suggest<BR>that you check this if the result
set is not huge. This will tell Rev to<BR>load the data into an array.<BR>5)
select a table, and enter the SQL.<BR>6) select the primary key (this is used
for updating changes back to the<BR>server). To enter multiple primary keys (a
combined key) enter the names of<BR>the primary key columns seperated by a comma
eg: empno, deptno<BR>7) select a field. click to the database linked tab. Select
the query.<BR>8) Select the column in the query resulset to link to. To display
all the<BR>data..perhaps in a table..select show all. Otherwise select a column
to<BR>display the data in the current record of the query. This enables you
to<BR>create forms without any scripting. You can even link images! Be sure
to<BR>check 'update after editing' if you want Rev to save any changes to
the<BR>field back to the database.<BR>9) If your creating a form and wish to
avoid any additional scripting, you<BR>can also link buttons to a query.<BR>10)
Create a button..select the database linked tab, select a query, and<BR>select
an action. For 2.0 only simple navigation related actions are<BR>supported. 2.1
will feature additional actions (insert, delete).<BR><BR>But you can always use
revExecuteWithQuery (queryname) and pass it some SQL<BR>to execute.<BR>get
revCursorOfQuery(queryname) -- returns the cursor for a query.
Returns<BR>'cached' if the data is cached, and in an array.<BR>get
revConnectionOfQuery(queryname) -- returns the connection for a
query<BR><BR>Tip: To update images back to the server<BR>on
mouseup<BR> set the text of the image 1 to url
("binfile:newimage.png")<BR> revUpdateQueryObject the long
name of image 1<BR>end mouseup<BR><BR>>PS: minor suggestions for post-version
2.0 addition<BR>>- ability to hook up checkboxes as boolean fields<BR>Is
planned.<BR><BR>>- ability to hook up radio-button groups as integer<BR>Right
also option boxes. All planned for 2.1, we just want to get rev 2.0<BR>solid
now.<BR><BR>>ability to link from substack to queries in
the<BR>>mainstack<BR>Supported. Queries are implemented as unplaced
backgrounds in stacks. You<BR>just have to type the full name of the background.
Also note that<BR>connections are reference counted, so if you have multiple
queries which<BR>connect to the same database it doesn't open up additional
connections and<BR>overwhelm the server.<BR><BR>Oracle testing: We are
especially looking for people to test the new<BR>database features with Oracle
databases on both OSX and Windows, and give<BR>use feedback.<BR><BR>Tuviah
Snyder <<A href="mailto:tuviah@runrev.com">tuviah@runrev.com</A>> <<A
href="http://www.runrev.com/">http://www.runrev.com/</A>><BR>Runtime
Revolution Limited - Software at the Speed of Thought<BR><BR></BODY></HTML>