RDD SQL!

HMG Samples and Enhancements

Moderator: Rathinagiri

User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: RDD SQL!

Post by Roberto Lopez »

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.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: RDD SQL!

Post by Roberto Lopez »

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.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: RDD SQL!

Post by Roberto Lopez »

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.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: RDD SQL!

Post by sudip »

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
Last edited by sudip on Fri Apr 03, 2009 5:14 pm, edited 1 time in total.
With best regards,
Sudip
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: RDD SQL!

Post by Rathinagiri »

Yes Sudip. Our application would be web enabled by using HBTIP. :)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: RDD SQL!

Post by sudip »

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
With best regards,
Sudip
User avatar
bruno
Posts: 5
Joined: Wed Jul 30, 2008 11:40 pm

Re: RDD SQL!

Post by bruno »

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


//////////////////////////////////////////////////////////////////////////////////
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: RDD SQL!

Post by sudip »

Thanks a lot Bruno :-)

With best regards.

Sudip
With best regards,
Sudip
mbelgrano
Posts: 59
Joined: Sun Aug 03, 2008 8:47 pm

Re: RDD SQL!

Post by mbelgrano »

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
Post Reply