Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with primary key
Message
 
To
25/07/2005 07:22:05
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01035448
Message ID:
01035668
Views:
12
Hi Mike,

I did not make myself clear so let me clarify.
I do not put my library routines in a common physical file, unless I am creating classes and put them in a class library.]

In cases like this, I will have an individual prg for each pdf, then put of all my utilitiy prg's in a 'library' as in
c:\dev\libs
This folder (library) is then added to my path, so I actually meant what you are saying, I just did not say it well.

Burt

>Hiya Burt!
>
>That's something I want to disagree on. Worry about what happens at runtime. Copying the files around is not even a design time issue. It's more of a setting up the development environment. You only need to set the path so VFP can find the prgs. As you said, the project manager will pull in everything.
>
>Take a look at this...
>
>http://fox.wikis.com/wc.dll?Wiki~VFPSetProcedure~VFP
>
>>You certainly have a point on the 'I forgot to copy the file' issue.
>>What I due is have a central library for my utility code that I include in the path for all of my projects. When I build the project, if the UDF is referenced, it will automatically be pulled into the exe or app file.
>>The only place I would really see this biting me would be if I was running from a command window without the utility library available.
>>
>>
>>>Hi Burt, Hi all,
>>>
>>>>DTOS() is easier to read than DTOC(,1)
>>>
>>>>To Preserve consistency, what I would do is create the following function
>>>>Function TTOS(tdDate)
>>>>Return TTOC(tcDate,1)
>>>
>>>I'd prefer #DEFINE, if you could do some define like
>>>
>>>#DEFINE TTOS(a) TTOC(a,1)
>>>
>>>but that doesn't even work with a=DateTime().
>>>
>>>Consistency advantage and readability or not, with a function or a define you are dependant of that and if you forget to copy that function or define into your next database stored procs, you'll also run into errors. So I'd say use DTOC(dField,1) in the key expression and TTOC(tField,1) with DateTime fields. It's not all that hard to look up or just try out the meaning of ,1 in the command window.
>>>
>>>Bye, Olaf.
Burt Rosen
Software News & Views, Editor in Chief and Writer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform