Hello,
Working with OpenInsight Client/Server Connection I have some problems. I created Connection and DataSets, auto-defined scripts (as recommended in manual). But when I work in Query Window all Microsoft ODBC 16- bit drivers for dBase didn?t ?understand?
?standard? SQL commands (such as SQL-92 and any variants ). These drivers performed only ?Select? , without any filters. But I found another (non Microsoft) drivers and decided all problems. ?New? driver ?understand? ?standard? SQL and I might ?complex? Select, Delete, Update, Insert.
But when I worked in Form Designer with Form, associated with Database, I might only Read rows (using F5). But I did all and only what recommended in OI manual. May be ?SQL for scripts? are not compartable for connection between ODBC driver and OpenInsight Form Designer ( as in Query Window for MS ODBC, when scripts were generated by OI, but dBase driver did?t ?understand? SQL command, created same type as scripts ? )
My question to Revelation Technology and other specialists:
What ODBC 16-bit drivers you recommend for correct work in C/S and what standart of SQL for these drivers ? And why I can manipulate with data in Query Window and read only in Form associated with Database?
Thanks
Peter Kassinski
Hi Peter,
And why I can manipulate with data in Query Window and read only in Form associated with Database?
First, you need to verify that the scripts in the DataSet are correct. You can do this by trying them in the Query Window and replacing the arguments/column place-holders.
Second, there is a bug in the Form I/O logic of a recent version of OpenInsight that prevents the updates from being committed. We have a patch available; I know that David Carrano ([email protected]) in our technical services group was working with a customer related to this.
Third, make sure you set the key columns in the DataSet before producing the scripts. This is the key for the DataSet, which is usually the same as the key of the table; it must uniquely identify the row in the DataSet.
Cameron Purdy
Revelation Software
Hi Cameron,
1 . I have verified that the scripts in the DataSet are correct. I successfully performed in the Query Window SQL-commands created same type as scripts.
2. I have received and copied into OI patch from Martyn Philips.
3. I have set the key columns in the DataSet before producing the scripts, but when I try to read (F5) rows in Form, I get "Unique Key Validation Error" ! By the way, S/ENL Volume 2 Issue 1 in article "Connections" by Andrew P McAuley contains information that this message appear only first couple of times. But my OI generates this error all times, and I can't read data !
May be OpenInsight is not support C\S connection using ODBC in Form Associated with Database, and OI user can manipulate external data using ODBC only in Query Window ? And all information ( in Revelation manuals, Sprezzatura Letters etc. ) about access to data using ODBC in Form Associated with Database - Grand Mistake !?
Otherwise, may be Revelation Specialists print special Letter (White Paper )where step by step with examples of drivers, scripts, patches etc. explain how set connection and access to data in Form Associated with Database ? (Becouse information in "Getting Started" is not full and correct).
Thanks,
Peter
Peter,
Let me know how it worked out for you.thanx
Peter,
when I try to read (F5) rows in Form, I get "Unique Key Validation Error"
That is caused by one of two things:
1. An MS 32-bit ODBC driver that is returning blank rows
2. Improperly configured DataSet key column definitions
If it is the second, make sure that the columns marked as keys will not have duplicate values in them … test the script in the Query Window.
Cameron Purdy
Revelation Software