Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Update
Message
 
 
To
25/05/2008 01:11:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01319401
Message ID:
01319402
Views:
13
replace qty with 1 for code = '1401'
>
>create cursor table1 ;
>	(code char(7), qty n(4))
>
>insert into table1 values ('1401',0)
>insert into table1 values ('1401007',0)
>insert into table1 values ('1401010',0)
>insert into table1 values ('1401025',0)
>insert into table1 values ('1402',0)
>insert into table1 values ('1402088',0)
>insert into table1 values ('1402101',0)
>insert into table1 values ('1402225',0)
>
>select table1
>locate for code=alltrim('1401')
>replace qty with 1
>
>Now first value in table is as
>1401-1
>
>On this point all qty field must replace with 1 until code like 1401
>I want to use update, loop or scan throuhout table.
>
>please help
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform