 05-20-2008, 3:25 PM
|
samir
Joined on 05-21-2008
Posts 28
|
Adaptive Server Enterprise insert record
|
|
|
|
|
Hello,
1- Create a DSN to ASE (ODBC).
2- Create any simple table using Interactive SQL. Two fields ID smallint, serialno smallint.
3- Create a new Clarion Dictionary and import the sample table. You need to assign external names to fields, use same field names.
4- Use the Application wizard to create a simple application using the above-mentioned dictionary.
5- insert the following code in the embed close window of the generated form.
6- Create a button on the browse and add the following code :
tableName{prop:sql} = 'insert into tablename values ( 10,10)' ; Brw1.resetSort(1)
7- You will notice the insert record displays can not insert nulls into table fields. Then on cancel , the code displays the bug "the sql code generated by the driver". While if you press on the button on the browse, insert will occur sucessfully.
8- If you do the above experiment with other ODBCs like Oracle or SQL Anywhere, the form on exit displays proper sql insertion code.
Any body has a similar experience. If this bug is fixed, it will allow us to use ASE as back end server. N.B the update and delete code have no problem and display proper sql code on closing the form.
Samir
|
|
|
|
|
Report
|
|
|
|