Motor BD

[MIGUELON]

Hi Roger, where do I tell Express + + the type of motor that I use for dcbrowse

"SQLStatement"
"SQLDataSet" / / Sql-express

"dsACEServer"


Regards
Miguel

[rdonnay]

Miguel -

By "motor", I assume that you are talking about the data source.

This can be a workarea (Alias), an array, or a data object.

If you are browsing a work area, then use the clause ALIAS <alias>.
If you are browsing an array, then use the clause DATA <aArray>.
If you are browsing a SQLExpress SQL cursor, then use the clause DATA <oCursor>.
If you are browsing an ADS cursor, then use the clause DATA <nCursor>.

[MIGUELON]

Thanks for the reply but I think I explained well.

As I indicated to Express + + I'm working with "dsACEServer" and not "SQLDataSet"?

In _dcxbrow.prg code shows:

IF Valtype (xdata) = 'A'
aGetListItem [nGETLIST_SUBTYPE]: = BROWSE_ARRAY
Valtype ELSEIF (xdata) = 'C'
aGetListItem [nGETLIST_SUBTYPE]: = BROWSE_DATABASE
Valtype ELSEIF (xdata) = 'O' / / J. Duijf 27/11/2002
IF xdata: isDerivedFrom ("SQLStatement"). OR. xdata: isDerivedFrom ("SQLDataSet") / / Sql-express
aGetListItem [nGETLIST_SUBTYPE]: = BROWSE_SQLEXPRESS
ELSEIF xdata: isDerivedFrom ("dsACEServer") / / ACE Server
aGetListItem [nGETLIST_SUBTYPE]: = BROWSE_ACESERVER
ElseIf xdata: isDerivedFrom ("SpSql") / / SpSql flint
aGetListItem [nGETLIST_SUBTYPE]: = BROWSE_SPSQL
ELSE / / Database object
aGetListItem [nGETLIST_SUBTYPE]: = BROWSE_DATAOBJECT
ENDIF
Valtype ELSEIF (xdata) = 'N'
aGetListItem [nGETLIST_SUBTYPE]: = BROWSE_ADSHANDLE
ENDIF

I try to enter a new SpSql

regards
Miguel


Regards
Miguel

[rdonnay]

I don't have dsAceServer, however I can add support for it if you will just tell me the name of the data class and the navigation methods.

[MIGUELON]

Roger, I have not conveyed this is not my question.

I want to implement changing sources Express + + a new "DATA SOURCE" specifically "SPSQL" Igor Golobrodskiy of Softpro.

I have adapted all _dcxbrow.prg file to work with "SPSQL"

But not like you to "xdata: isDerivedFrom (" SpSql ") =. T."

Where do I tell the Express + + "DATA SOPURCE" is SPSQL?

Thanks for your help
Miguel

Roger, no lo he explicado bien esta no es mi pregunta.

Deseo implementar cambiando las fuentes de Express++ un nuevo "DATA SOURCE" en concreto "SPSQL" de Igor Golobrodskiy de SoftPro.

He adaptado todo el el fichero _dcxbrow.prg para que funcione con "SPSQL"

Pero no se como indicarle que "xdata: isDerivedFrom ("SpSql")=.t."

Donde le digo a Express++ que el "DATA SOPURCE" es SPSQL ?

Gracias por su ayuda
Miguel

[rdonnay]

I have adapted all _dcxbrow.prg file to work with "SPSQL"

Send me your modified _DCXBROW.PRG and I will update it and send it back.

[MIGUELON]

Roger sent the file you ask me.

thank you very much
Miguel

[rdonnay]

Miguel -

I received your files.
I am confused about what is your question.

It appears that you have made the changes necessary to _DCXBROW.PRG and _DCGETBX.PRG.
I have updated my source code for build 257.

The only change you have not made is the necessary change to DCDIALOG.CH:

Code: Select all

#define   BROWSE_ARRAY               1
#define   BROWSE_DATABASE            2
#define   BROWSE_SQLEXPRESS          3
#define   BROWSE_DATAOBJECT          4
#define   BROWSE_ACESERVER           5
#define   BROWSE_ADSHANDLE           6
#define   BROWSE_SPSQL               7       // <<<<<<<<<<<< new