Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have tried it, but it doesn't work either. There is only one memo field.
Do you know the limit of the internal update command?
Thanks,
Javier.
>If you have memo fields, change CompareMemo to .f. This reduces the length of the internal update command which has a limit.
>
>>Hi all,
>>
>>I have a view in a form that updates a table with 100 fields. The SQL statement is short, as all the fields belong to one table but 2 of them.
>>
>>When I issue tableUpdate(.t., .f., 'myView'), I get the error "SQL string is too long", and return .F.
>>If I force all rows to be updated with tableUpdate(.t., .t., 'myView'), then I don't get the error.
>>
>>I don't even know how to debug it to know what's happening inside, and why the error goes away when I force the update.
>>
>>Any ideas?
>>
>>TIA,
>>Javier.
Précédent
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