Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Macro substitution of SQL statement
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00168161
Message ID:
00168241
Vues:
20
>No, I don't think you are being "thick" on this one. Your point and approach is well taken. There are many times that "we" as developers tackle things almost with a "one track mind" and later on we find a "six million dollar man" solution. If I had to redo it again, I would certainly try something along the lines of your approach, but for now, the client will not be pleased with an additional re-engineering bill.
>
>Regardless of approach, what is really wrong here? Is it a macro substitution deficiency or an OS problem. According to Ken Weber on this thread, the sample code that I provided works well under Win95. I however, am using NT 4.0 and it fails miserably.
>
>I happen to feel that it is a macro substitution deficiency or anomally because the same file name can be used in a USE statement with no problem.
>
>ie.
>m.lcPath = "c:\December 1998\test.dbf" && Note, no quotes
>USE ( m.lcPath )
>
>As you can see my finding supports your approach.

Hi Juan,

I do try to take as many externals (like the OS) out of the equation as possible. I don't know if this will work on NT or not, but it does on Win 95/98. Further, it may not meet your needs, depending on how specific your example was. However, might try:
SELECT *;
  FROM (m.lcpath)
  INTO ARRAY aFees
where m.lcpath is the name of your table.

hth,
George

Ubi caritas et amor, deus ibi est
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform