Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The syntax for: UPDATENAMELIST
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00552627
Message ID:
00553659
Vues:
19
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
Fil
Voir

Click here to load this message in the networking platform