Re: Inconsistency with SQL in ACS vs RPG
David Gibbs via RPG400-L <[email protected]>
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <CAEStNX=+oFq5wzL0yN9D1=pexY1cjHxzivHOjVbVwCoM8jxiCQ@mail.gmail.com> |
On Wed, Oct 8, 2025 at 7:43 AM Vern Hamberg via RPG400-L < [email protected]> wrote: > And I believe we can type in parameter markers, and RSS will prompt you > for a value for each. As I recall, you can specify data types for each, > too. > Yes, you can. Just prefix the variable name with a colon. For example. select * from abc where field1 = :value1 It's a nice feature, although it doesn't remember previously entered values. Also, if you use the same variable name more than once, it the prompt will include it multiple times instead of prompting once and using the same value for each instance. david -- IBM i on Power Systems: For when you can't afford to be out of business! I'm riding in the American Diabetes Association's Tour de Cure to raise money for diabetes research, education, advocacy, and awareness. You can make a tax-deductible donation to my ride by visiting https://mideml.diabetessucks.net. I may have diabetes, but diabetes doesn't have me! -- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/rpg400-l or email: [email protected] Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact [email protected] for any subscription related questions.