Page 1 of 1
Motor BD
Posted: Mon May 28, 2012 12:14 pm
by MIGUELON
Hi Roger, where do I tell Express + + the type of motor that I use for dcbrowse
"SQLStatement"
"SQLDataSet" / / Sql-express
"dsACEServer"
Regards
Miguel
Re: Motor BD
Posted: Tue May 29, 2012 3:28 pm
by 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>.
Re: Motor BD
Posted: Wed May 30, 2012 2:08 am
by 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
Re: Motor BD
Posted: Wed May 30, 2012 7:30 am
by 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.
Re: Motor BD
Posted: Thu May 31, 2012 1:19 am
by 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
Re: Motor BD
Posted: Thu May 31, 2012 6:43 am
by 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.
Re: Motor BD
Posted: Thu May 31, 2012 1:37 pm
by MIGUELON
Roger sent the file you ask me.
thank you very much
Miguel
Re: Motor BD
Posted: Sat Jun 02, 2012 10:44 am
by 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