General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only