Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting a string to number in update query
Message
From
21/05/2003 10:35:32
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Converting a string to number in update query
Miscellaneous
Thread ID:
00791060
Message ID:
00791060
Views:
50
How can i convert a string which is col2 in the update statement to a number size 10,2

i am trying to do cint but it is not accepting.

Could you please tell me.

**************************Start************************
for n = 1 to thisform.pageframe1.page3.list1.listcount

col1 = thisform.pageframe1.page3.list1.listitem(n, 1)
col2 = thisform.pageframe1.page3.list1.listitem(n, 2)

update actions set sub_id = col2 where sub_key = col1

endfor

*************************END******************************

Thank you.
Next
Reply
Map
View

Click here to load this message in the networking platform