2006/3/23, Vivien Malerba <[EMAIL PROTECTED]>:
OK. Done.
Could you give me any simple (just this part) of create and reder the query, please?
I know this process from the oldest GDA then I could do it with out problems.
I think we need to simplify the API, and allow the developers with a few steps access the data he/she needs with out great complexity.
On 3/23/06, Daniel Espinosa <[EMAIL PROTECTED]> wrote:
> I'm trying to create a simple example to a Tutorial in the Wiki, and now I'm
> following the next steps:
>
> 1. Open a GnomeDbLoginDialog, then the user select the Data Source (in the
> Tutorial, the SalesTest default source), the username and the password (in
> SalesTest is leaving with out blanck by the user).
>
> 2. Uses the data from the point 1, to open the connection:
> a) Create a Client
> b) Creae a Connection with that client, using the DSN, username and
> password from the GnomeDbLoginDialog
> c) Check if the connection is opened
>
> 3. Load the XML dict file and update it:
You can create a dictionary using gda_dict_new() and tell it which
connection to use with gda_dict_set_connection(). Then you can load
the dictionary file using a simple gda_dict_load(); no need to try to
figure out the dictionary name.
OK. Done.
> a) Try to open the default XML file: $HOME/.gda/DICT_<data source
> name>_default.xml
> For SalesTest will be:
> $HOME/.gda/DICT_SalesTest_default.xml
> b) If the load fails, set the file name using:
> gda_dict_set_xml_filename
> c) Update the XML dict (in the example, to ensure the integrity of the
> data, before show any data the program updates the Dict)
> Use the gda_dict_update_dmbs_data
>
> 4. Create a Query:
> a) Create a Query with a SQL command using: gda_query_new_from_sql
At the moment you need to:
-> if necessary get and fill the parameters to execute the query
-> get the SQL for your query using gda_renderer_render_as_sql(query)
Could you give me any simple (just this part) of create and reder the query, please?
-> create a GdaCommand with that SQL
-> use gda_connection_execute_command() to get a list of GdaDataModel
(or gda_connection_execute_single_command() to get only one model).
-> use the returned data model in a GnomeDbGrid.
I know this process from the oldest GDA then I could do it with out problems.
It's a bit complex though and I plan to simplify this a bit using a
gda_connection_execute_query() function.
I think we need to simplify the API, and allow the developers with a few steps access the data he/she needs with out great complexity.
--
Trabajar, la mejor arma para tu superación
"de grano en grano, se hace la arena" (R) (entrámite, pero para los cuates: LIBRE)
_______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
