Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2008 Server
Hi,
I have a special database stored procedure which make a mirroring between databases using OnInsert event.
The way what I use
1) Generate local view for Database1
2) Scatter
3) Generate local view for Database2
4) Gather
5) Tableupdate()
It seems to work long time, (its 2006 software) and now I have an error - "Line is too long" during TABLEUPDATE,
I thinking it depends from "SQL Where clause includes" - but default it was "Key and modified fields" - in this case I'v got an error - Line is too long, if I change it to "key fields only" - then error is "Too much fields in update"
For Information .The source table has 207 columns.
The error happens in exe.. when I try to reporoduce it in VFP using debugger - it seems to work. No error during tableupdate.
Any help
Thanks
Denis
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