SQL(oDBO,cQStr) –> aTable - This is used to execute only the “SELECT” type queries. This function returns a two dimensional array of the query result (even though the resultant number of rows and columns be 1). An empty array will be returned in case there are no rows returned.

MiscSQL(oDBO,cQStr) -> lOk – This is used to execute all the other miscellaneous commands like “Insert, Delete, Update, Create, Alter, Grant” etc., except “Select”. This function returns a logical value. If the query execution was successful, .t. is returned. Otherwise .f. is returned.

Copy the DLL to the directory of my application but I followed
giving errors, search the Internet and I found
with this. [url] http://es.dll-files.com/libmysql.dll.html [/ url]
I have no previous errors, syntax now.
I keep trying. . .

Google Translation
I send an application that will see how to connect to mysql server, and use of inserts and update very basic but enough to start, so I'll upload the restaurant later, thanks to some moves that did we realized a few details and are working on them to deliver on time the application

Note, when you compile the project, I will see that when they come to the choice of articles, this takes too long and has an annoying flicker, this half fix it with a trick that is not the best, but it took far less time, and
shows no flicker.

on line 547 of h_grid.prg

* _HMG_DOGRIDREFRESH (I)
the commit to not compile, rebuilt the library and ready, of course after that, we have to manually refresh the grid in our programs.