Thank you Daniel.
Yes, I checked the dwSyntax:
0 (Default) Form, group, query, or tabular
1 Grid
2 Label
3 Graph
4 Crosstab
5 Composite
But the question is how can I change from Tabular to Form and viceversa
at run time (when both have a 0 value)?
I tried this procedure:
1. sql_syntax = dw_control.GetSQLSelect()
( also tried sql_syntax =
dw_control.Describe("DataWindow.Table.Select")
2. dwsyntax_str = SQLCA.SyntaxFromSQL(sql_syntax,
"style(type=Tabular)", ERRORS)
( or "style(type=Form)" )
3. dw_control.Create( dwsyntax_str, ERRORS)
But the SQLCA.SyntaxFromSQL keeps telling me that
"SyntaxFromSQL caused these errors: Arguments for select are
invalid or incomplete"
Is it than the SQLCA.SyntaxFromSQL and the Create() functions can not be
used when the SQL uses Retrieval Arguments?
Any help with this will be very much appreciated!
Thanx again,
William.
-----Original Message-----
From: Daniel Coppersmith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 29, 1999 1:55 PM
To: William Ulate
Cc: PFCSIG
Subject: Re: PFCSIG LibraryImport (Non-PFC: Changing Presentation
Style)!
You can change the DW presentation style by exporting the datawindow
syntax
and changing the PROCESSING=xxx tag. Off the top of my head, I do not
remember the numbers (0 is tabular, 1 is grid, etc?? -- check dwSyntax
for
the actual numbers).
At run time, you can do a similar thing... get Datawindow.Syntax into a
string, search on PROCESSING= and change the value and do a CREATE on
the
modified syntax.
----- Original Message -----
From: William Ulate <[EMAIL PROTECTED]>
To: 'Daniel Coppersmith' <[EMAIL PROTECTED]>; Dario Schmidt
<[EMAIL PROTECTED]>
Cc: PFCSIG <[EMAIL PROTECTED]>
Sent: Wednesday, September 29, 1999 1:49 PM
Subject: RE: PFCSIG LibraryImport (Non-PFC: Changing Presentation
Style)!
> Hello:
>
> I have a similar case, maybe you can help me.
> Do you know if there is a way to copy a DW (or DWO) and change only
the
> presentation Style
> (say from Tabular to FreeForm and Viceversa) ?
>
> TIA,
>
> William.
>
> -----Original Message-----
> From: Daniel Coppersmith [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 17, 1999 8:29 AM
> To: Dario Schmidt
> Cc: PFCSIG
> Subject: Re: PFCSIG LibraryImport
>
>
> I'm not sure I understand your question, but if you are trying to
> dynamically create a datawindow at run time, you will want to look at
> the
> dw.CREATE function (and also dw.SYNTAXFROMSQL).
>
> If you want to create a datawindow that is an exact copy of another,
> what
> you can do is this:
>
> ls_syntax = dw_1.describe("Datawindow.Syntax")
> dw_1.create(ls_syntax)
>
> (I did that from memory, so I might have take some liberty in the
> syntax,
> but it's close).
>
> If all you want to do is change the SQL, you can do this:
>
> // Error checking omitted
> ls_newSQL = 'select a from b where c = d'
> dw_2.dataobject = dw_1.dataobject
> dw_2.modify("Datawindow.Table.Select='" + ls_newSQL + "'")
> dw_2.setTransObject(SQLCA)
>
> Note you will need to do some work creating the SQL since you will
need
> to
> delimite ticks and whatnot, but the string service will help with
that.
>
> In my experience, the LibraryImport feature really isn't used too much
> for
> final applications -- I use it mostly for writing development
tools....
>
> D
>
>
>
> ----- Original Message -----
> From: Dario Schmidt <[EMAIL PROTECTED]>
> To: Lista PB <[EMAIL PROTECTED]>
> Cc: Lista PFC <[EMAIL PROTECTED]>
> Sent: Monday, May 17, 1999 8:24 AM
> Subject: PFCSIG LibraryImport
>
>
> > Hi,
> >
> > I am using PB 6.5 and PFC.
> >
> > I have problems with LibraryImport.
> >
> > I have a window with a button. In the button4s script I create a dw
> using
> > the syntax of another dw and modify your sql select. The first time
i
> press
> > the button all run ok, but the second time the function
libraryimport
> > return -1 without message error.
> >
> > Any ideas ?
> >
> > TIA
> >
> > Ing. Dario Schmidt
> > Ceride - Argentina
> >
> > > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE
> COMMANDS,
> ADDRESS
> > > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
> pfcsig
> > > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> >
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE
> COMMANDS, ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
> pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
>
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
