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:
00043760
Views:
59
>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....
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform