Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table View
Message
 
 
To
20/01/2010 13:16:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01445042
Message ID:
01445046
Views:
46
>Hello all! hi again:D
>
>i have a little code that populates a view of mine.
>so example I have in the view
>
>kem
>net
>Lod
>
>im trying to like take the name out of that view and add a number to it so ill have kem001
>but so far that only works for the first name
>i cant call the second and thrid is their anyway too step thru the table?
local lnI
lnI = 0
select myView
scan

  lnI = m.lnI + 1
  replace myField with alltrim(myField) + padl(m.lnI,3,'0')
endscan

*------------------------------
alternative solution (assuming no deleted records)

replace all myField with alltrim(myField) + padl(recno(),3,'0') in myView
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform