From Newsgroup: comp.lang.clarion

Hi All,

I want to fill a browse with an sql statement like this:

self.Open()

Self.View{prop:sql} = 'select xmlid, xmlTag , xmltagwaarde from xml002 where xmlid=1'

Return
It keeps giving me the followin error:

Error file not open 37 dbo.xml002
Does anyone have an good example of filling an browse

Regards Joep
--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.lang.clarion

Op maandag 8 juni 2020 17:20:32 UTC+2 schreef Joep Borghans:

Hi All,

I want to fill a browse with an sql statement like this:

self.Open()

Self.View{prop:sql} = 'select xmlid, xmlTag , xmltagwaarde from xml002 where xmlid=1'

Return
It keeps giving me the followin error:

Error file not open 37 dbo.xml002
Does anyone have an good example of filling an browse

Regards Joep

I have got the prop:sql working.
The code is in the reset embed. But it ad's the records up on all the existing records. How can I clear the browse so only my prop:sql records remain?

Regards Joep
--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.lang.clarion

On 9/6/20 1:20 am, Joep Borghans wrote:

Hi All,

I want to fill a browse with an sql statement like this:

self.Open()

Self.View{prop:sql} = 'select xmlid, xmlTag , xmltagwaarde from xml002 where xmlid=1'

Return
It keeps giving me the followin error:

Error file not open 37 dbo.xml002
Does anyone have an good example of filling an browse

Regards Joep

I'd just have a normal table defined with those fields and let the
normal browse templates deal with it.

If this is a one off I'd use the dummy table technique (using turboSQL)

You might also try asking on the groups at new.softvelocity.com and also
try www.clarionhub.com


Sean H

--- Synchronet 3.21d-Linux NewsLink 1.2