Hello,
I'm a new member in this forum. The title of this and my last answer is wrong. It is the titel of the second last answer.
My Problem is the VARCHAR in Oracle and fixed length in CHAR-Type in VFP. I must trim the CHAR-Value before I tableupdate to Oracle. I would like use SQLEXEC(lnConn,"Update...."). But how do I check if an other user has changed the the updatedable field?
I use the Mere Mortals Framework 7. I don't know if the framework works with CursorAdapter.
Best regards!
C.Przioda
>I am not quite sure what you are asking. You title says CursorAdapter so >you can use the ConversionFunc property to RTRIM any character field data >being sent back to the Oracle table --
>Adapter.ConversionFunc = [LastName RTRIM, LastName RTRIM, etc]
>If you are using SPT, your SQL could look like:
>...SET LastName = ?RTRIM(crsCustomer.LastName), FirstName = ?RTRIM>(crsCustomer.FirstName)
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