Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The syntax for: UPDATENAMELIST
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00552627
Message ID:
00553659
Views:
18
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
Map
View

Click here to load this message in the networking platform