Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I've got a form which uses a remote view I created from one Oracle table. I've got controls (in this case an edit box) on my form which are using fields from this remove view as datasources. I'm using the TableUpdate() function to commit the changes from the remove view to my Oracle table.
>
>Just recently I was required to allow the user to delete the contents of an edit box which is bound to memo field in my remove view. On the Oracle end of things that column is actually a varchar(2000), but since VFP doesn't support character data types with a length greater than 254 I had to use a memo field in my remote view.
>
>Here's the problem: The user clears the contents of the edit box (and it's controlsource). I then attempt to commit the changes to that record using the TableUpdate() command. I receive a few different errors:
>'SQLExecDirect with return code 99 (SQL_NEED_DATA)'
>'[ODBC]No data at execution values pending. (0)'
>
>I've tried setting the field to .NULL. before issuing the TableUpdate(), but I get these errors:
>'SQLExecDirect with return code -1 (SQL_ERROR)'
>'ORA-01084: invalid argument in OCI call'
>
>I may be overlooking something really obvious, but I'm stumped as to what to do. I haven't been able to find any information regarding this problem anywhere I've looked. Any help would be greatly appreciated. Thanks.
>
>Corey
Corey;
Just a thought - could it be your ODBC driver? Which one are you using?
Tom
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