Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi,
I hoped you were on ;-). That usually gives a fast answer.
ad. 1) Interesting. I may try it.
ad 2) the collate sequence error is as I guess a wrong error. I havent changed the collation (not what I'm aware of - I have searched the code, but perhaps there is something I don't know...)
If I add a reccord to the cursor in a virginal upstarted mashine, it works.
When I fire the following code - I get the collate error (after =tableupdate(.T.):
tctable = "Topr"
SELE (tcTable)
STORE '' TO lcFList, lcNList, lcNmlm
FOR lnCnt = 1 TO FCOUNT()
lcNmlm = DBGETPROP("Topr."+FIELD(lnCnt), "field", "updatename")
** svaret returneres med hip!*** alt før ! skal fjernes
lcNmlm = SUBSTR(lcNmlm,AT("!",lcNmlm)+1)
lcFList = lcFList + ',' + FIELD (lnCnt)
lcNList = lcNList + ',' + FIELD (lnCnt) + ' ' + lcNmlm
*** + tcTable + '.' + FIELD(lnCnt)
ENDFOR
CURSORSETPROP ('UPDATABLEFIELDLIST', SUBST (lcFList, 2))
CURSORSETPROP ('UPDATENAMELIST', SUBST (lcNList, 2))
CURSORSETPROP ('BUFFERING', 5) && assuming opt. table buffering
CURSORSETPROP ('KEYFIELDLIST', "oprfelt5" )
CURSORSETPROP ('SENDUPDATES', .T.)
CURSORSETPROP ('TABLES', 'topr')
Does that give you an idea??
Thanks
Lasse
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