Clarion - How to display the result of the prop:sql?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to display the result of the prop:sql?

dorst622@gmail.com

2007-10-11, 3:55 am

I would like to display the result of a prop:sql.
example:
sqlfile{prop:sql}='select count(stockcode) from stockitems'

How do i display the result on a windows form?
C55 ABC
dorst622

Brad Kunkel

2007-10-11, 6:55 pm

sqlfile{prop:sql}='select count(stockcode) from stockitems'
NEXT(sqlfile)

This will retrieve the count into the first field in sqlfile.

HTH,
Brad Kunkel
Integrated Business, Inc.

<dorst622@gmail.com> wrote in message
news:1192092605.366958.193770@o3g2000hsb.googlegroups.com...
>I would like to display the result of a prop:sql.
> example:
> sqlfile{prop:sql}='select count(stockcode) from stockitems'
>
> How do i display the result on a windows form?
> C55 ABC
> dorst622
>

Sponsored Links