Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple Grid Question
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00043566
Message ID:
00043980
Views:
64
>>Ok then here's the text in activate section:
>>set excl off
>>clos all
>>use plist
>>appe blank
>> REPL UDATE WITH DATE()
>> REPL UTIME WITH TIME()
>> REPL VERSION WITH 'LMCAVFP!'
>> REPL OS1 WITH OS()
>> REPL OS2 WITH OS(0)
>
>It's better practice to replace the append and replace commands with:
>
>INSERT INTO pList ;
> (uDate, uTime, version, os1, os2) ;
> VALUES ;
> (DATE(), TIME(), 'LMCAVFP1', OS(), OS(0))
>
>That way, if you have or add indexes, they're only updated once, instead of once for each line.
>
>Also, you should spell out your commands: for example, is REPL REPLACE or REPLICATE()? :-) You'll be much happier when you have to maintain your code in a year....

OK Thanks for the tips!!
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Previous
Reply
Map
View

Click here to load this message in the networking platform