Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
Hi James
Unfortunatly I am totally new to adaptor cursors. I have also tried it and although the tableupdate returns .T. for both the view and the cursoradaptor, the data is not updated.
Any idea what I can be doing wrong or not doing right?
Thanks
>Yes, You have to tableupdate(1) to update all the rows.
>
>btw, if you are going to be doing a lot of this I would recommend that you use cursor adapter and make it alltrim() the character fields. ASA treats all type of char columns as varchar. Remote views pads, spaces to the full width of the field so ASA can't trim the length of the column.
>
>>Hi James
>>Thanks for the reply.
>>>What version of ASA?
>>As far as I know its the latest version. 9.0.2.2451
>>
>>I have set the buffer to 5 but it still does not write the data back to ASA. Do I need to execute a tableupdate or somthing simmilar to update the table?
>>
>>Thanks
>>
>>>
>>>I have used remote views very good success as remote views go. Sounds like you have buffering set to 3 meaning that you have to either save or revert the change before going to the next row. Set buffering to 5 will fix this problem.
>>>
>>>>Hi
>>>>My app needs to talk to a IAnywhere database (ASA/Sybase). I have tied updateable remote views. I can read the dta but as soon as I change the data and move to the next record I need to revert as it cannot update.
>>>>
>>>>Anybody used updateable views with IAnywhere before?
>>>>
>>>>Thanks in advance
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement