Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

GET & SET

Status
Not open for further replies.
edc000

edc000

Programmer
Joined
Mar 4, 2011
Messages
28
Location
AR
When I do a verification of the existence of a value and then modified, do this:

TABLE:COD=X
GET(TABLE,TABLE:KEY)
IF ERRORCODE()
..
END
TABLE:COD=X
SET(TABLE:KEY,TABLE:KEY)
NEXT(TABLE)
TABLE:NOM='XXXX'
ACCESS:TABLE.UPDATE()

because I'cant GET to modify the data, but yes with the SET. At the same time, if I use the SET / NEXT then I can not corroborate the FIELD = VAR because always return yes!.

There is a more flexible working? Thanks.
 
Sort by date Sort by votes
Hi!

1. You need to use a CLEAR(TABLE:RECORD) before a GET or SET to make sure that the record buffer is empty.

2. GET() will work ONLY is the Key is UNIQUE.

3. When you use SET(), you should ALWAYS check if the record key is the one you want before you update it i.e.

Code: 
TABLE:COD=X
SET(TABLE:KEY,TABLE:KEY)
NEXT(TABLE)
IF NOT ERRORCODE() AND TABLE:COD = X
   TABLE:NOM='XXXX'
   ACCESS:TABLE.UPDATE()
END

Regards
 
Upvote 0 Downvote
Thanks Shan!! very much.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Jose Pires
  • Locked
  • Question Question
What function to get hashe code clarion 6.0
Replies
0
Views
635
Jose Pires
Jose Pires
sk2107c
  • Locked
  • Question Question
Getting result Header From SQL statement using clarion
Replies
0
Views
760
sk2107c
sk2107c
edc000
  • Locked
  • Question Question
Get OCR Data with Clarion
Replies
0
Views
182
edc000
edc000
SalehKiswani
  • Locked
  • Question Question
Get BarCode value from image
Replies
1
Views
172
SalehKiswani
SalehKiswani
JustinPEM
  • Locked
  • Question Question
Convert from Clarion 6 to Clarion 8 and getting File () could not be opened error.
Replies
0
Views
276
JustinPEM
JustinPEM

Part and Inventory Search

Sponsor

Back
Top