[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Dataset bound Windows (OpenInsight Specific) ====
=== At 01 MAY 1998 10:41:48AM John Henry wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I am trying to create a window to maintain records in an Access97 database.



Everything appears normal except that entering a key into the 'key' field on the form and pressing enter always causes the window to think that a  is being created.  I checked with the CS_SPY and the  'key' parameter is being passed and the correct SQL command is being created. "select .... from TRANS where TRANS_NUM=ID:'



The CS_SPY args parameter contains the value for the ID that I keyed in the window.



The MASTER view contains a single row of data with ONLY the TRANS_NUM field populated.  The INSERT view contains the same row as the MASTER.

The SELECT view is empty. 



I can execute the Query in the Query Window and it retrieves the row correctly.  What am I missing??



Running OIWG 3.6, Access97.  
</QUOTE>
----

=== At 01 MAY 1998 06:43PM Cameron Revelation wrote:  ===

<QUOTE>John,



That means that it is not bringing back a row so it is inserting a blank one and setting the key.



Make sure the argument in the script appears as ":name", not "name:".  Then copy the script into the query window and replace the ":name" with your value.



Cameron Purdy

Revelation Software

</QUOTE>

----

=== At 02 MAY 1998 10:29AM John Henry wrote:  ===

<QUOTE>Cameron,



The misplaced colon was the problem.



Thanks,



John

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=0B57063118B94BD7852565F70050BB4E|View this thread on the  forum...]]