Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote view problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00436726
Message ID:
00436975
Vues:
28
Well... If anyone cares... here was the problem. If I use the parameter setup from the vfp menu and declare the vparampn as a character it
won't work. If I don't type the parameter and enter the part number in quotes it works fine. Sounds like a bug to me but oh well.

>I have a remote view set up with vfp5 and progress 9.
>If I set up the select like this...
>
>SELECT Partopr.PartNum, Partopr.RevisionNum, Partopr.OprSeq;
> FROM PUB.PartOpr Partopr;
> WHERE Partopr.Company = 'GMI';
> AND Partopr.PartNum LIKE ?vparampn; && subsitute lines as shown below
> AND Partopr.RevisionNum = ?vparamrev;
> AND Partopr.OprSeq = ?vparamopseq
>
>vparamopseq=10
>vparamrev='e'
>
>I get the following results with the following lines substituted...
>
>partopr.partnum = '45-0601' works.
>partopr.partnum like '45-0601' works.
>partopr.partnum like vparampn works if vparampn = '45-0601%'
>partopr.partnum like vparampn will not work if vparampn = '45-0601'
>
>
>partopr.partnum exists in the progress database as '45-0601'
>
>Any tips?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform