Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view problem
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00436726
Message ID:
00436975
Views:
27
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?
Previous
Reply
Map
View

Click here to load this message in the networking platform