HMGforum.com

sudip wrote: So, shall I continue my MySql journey with TMySqlServer library? What is your advice?

It appears to be a good option

Moreover, my last development involving MySql uses a very different approach. I've used HBTIP (it was widely discussed in another thread).

IMHO It is an EXTREMELY RELIABLE approach but is A LOT HARDER than TMySql.

Again... maybe that the best solution for me be not the best for you. IMHO You should make your own tests and decide which solution is the best for you.

Regards,

Roberto.

Roberto Lopez wrote: Moreover, my last development involving MySql uses a very different approach. I've used HBTIP (it was widely discussed in another thread).

viewtopic.php?f=12&t=153&hilit=hbtip

Regards,

Roberto.

Roberto Lopez wrote: Moreover, my last development involving MySql uses a very different approach. I've used HBTIP (it was widely discussed in another thread).

And (more important) this:

viewtopic.php?f=9&t=198&hilit=mysql+hbtip

Regards,

Roberto.

Roberto Lopez wrote: It appears to be a good option

Moreover, my last development involving MySql uses a very different approach. I've used HBTIP (it was widely discussed in another thread).

IMHO It is an EXTREMELY RELIABLE approach but is A LOT HARDER than TMySql.

Again... maybe that the best solution for me be not the best for you. IMHO You should make your own tests and decide which solution is the best for you.

Excellent!

I went to the threads you specified. Hats off to you! And Rathi, you are great!

I also went to EasyPhp.org!!! I shall download EasyPhp within 2/3 days.

My old dreams are coming to be true by coming to this Forum! I tried PHP + MySql before trying Harbour/xHarbour!!!

Yes, HBTIP will be harder than TMySqlServer but more secure. I think they will be more useful for WAN application (if I am not wrong). One of my big clients definitely need it.

Thank you very much.

With best regards.

Sudip

Yes Sudip. Our application would be web enabled by using HBTIP.

rathinagiri wrote:Yes Sudip. Our application would be web enabled by using HBTIP.

Hello Rathi,

I had never imagined it, when I stared learning HMG!!!

I am very lucky to be with this forum!

So, I am re-initializing my journey with MySql

Regards.

Sudip

This is a transcript of mail interchange with Mindaugas Kavaliauskas Creator of HARBOUR RDDSQL
Ithink may be usefull for you roberto

Bruno
/////////////////////////////////////////////////////////////////////////////////////


Bruno Luciani wrote:

could you send to me
a sample more complete of using RDDSQL ?

The sample in the contrib is very little and I' dont understand
the full use of this library



I have a few applications using rddsql, but none of it is a sample for rddsql. That features do you want to see inside sample? The main idea of rddsql is that it represents query result as database workarea. After SQL query result is opened, any Harbour/Clipper database code is a sample:
? FIELDGET(1)
AMOUNT := AMOUNT + 1
etc.


Regards,
Mindaugas


/////////////////////////////////////////////////////////////////////////////

Hi,



I understand that update data o modify it must be done using sql code
but I can use a Browse for example to display data in my aplicattion

It's that correct ?


Yes. But we can do edit ("asynchronous") using BROWSE() too in the future (it is not implemented yet). Something like:
DBUSEAREA(...)
BROWSE()

// Commit browse modifications
nRec := 0
DO WHILE DBINFO(DBI_NEXTCHANGED, @nRec) != 0
IF DBINFO(DBI_ISAPPENDED)
// generate and execute INSERT query
ELSEIF DBINFO(DBI_ISMODIFIED)
// generate and execute UPDATE query
ENDIF
ENDDO

Also modifications can be committed on browse row change, etc.


Regards,
Mindaugas

///////////////////////////////////////////////////////////////////////////////

Bruno Luciani wrote:

Ha ok , but this may work in a graphic browse like HarbourMinigui ?

I only use Browse() in console linux aplications

And I use HMG and Xhgtk in my aplicattions and would be amazing that this
feature work here too.


Hi,

I do not know HMG and HXGTK, but the main differences between "normal" DBF RDD and RDDSQL:
1) SQL usualy trims leading space characters from string data types, thus making length of field not constant.
2) RDDSQL return NIL for NULL SQL values.

These are the main stoppers of compatibility. Because browse could expect constant field lengths and no NIL values. Both 1) and 2) are still question of discussion. It can be implemented in another way.


Regards,
Mindaugas


//////////////////////////////////////////////////////////////////////////////////

Thanks a lot Bruno

With best regards.

Sudip

I have downloaded and installed mysql from http://dev.mysql.com/downloads/mysql/5.1.html#downloads
How can generate myself the libmysqldll.a from mysql\lib\opt ?

Thanks in advance