Dataset bound Windows (OpenInsight Specific)
At 01 MAY 1998 10:41:48AM John Henry wrote:
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.
At 01 MAY 1998 06:43PM Cameron Revelation wrote:
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
At 02 MAY 1998 10:29AM John Henry wrote:
Cameron,
The misplaced colon was the problem.
Thanks,
John