FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )

[nageswaragunupudi]

Both Query() and RowSet() are two names for the same method.
We just prefer to use RowSet name. You may use the name you like to use.

[goosfancito]

Is there a wiki that explains how to use fwconnect so I can see what is needed for an embedded mariadb connection?

thanks

[reinaldocrespo]

Hello group;

Is there a pdf or wiki that documents this MariaDB class? I would like something that describes the whole class without having to read each post on the forum.

And one other thing; is this an update to the TDolphin class or a whole different class altogether?

Thank you.

[vilian]

Hi Reinaldo,
Some time ago I started to collect all Mr Rao tips about FWH MySql in a chm file. You can download it through the link bellow:

https://drive.google.com/file/d/1DnNBBt ... sp=sharing

[Compuin]

Hi Reinaldo,
Some time ago I started to collect all Mr Rao tips about FWH MySql in a chm file. You can download it through the link bellow:

https://drive.google.com/file/d/1DnNBBt ... sp=sharing

Hello,

It doesn't work.

Regards

[vilian]

Another link https://www.mediafire.com/file/r92mgkwd ... s.chm/file

[reinaldocrespo]

I need some help executing certain SQLs using this class. Below is the code to one such instance where the class returns an error.

Code: Select all | Expand

DELIMITER //    
CREATE FUNCTION CurrentLease( 
   pPropID CHAR( 25 ), pDate DATE 
   )  
   RETURNS CHAR( 13 ) DETERMINISTIC   
BEGIN   
   DECLARE cLease CHAR( 13 ) DEFAULT '' ;  
                              
   SELECT leaseID INTO cLease  
   FROM leases   
   WHERE propertyID = pPropID   
      AND StartDate <= pDate   
      AND ( IsMtoM OR EndDate IS NULL OR EndDate >= pDate )  
ORDER BY startdate DESC   
   LIMIT 1 ;  
  
   RETURN( cLease ) ; 
  
END //  
 DELIMITER ; 	

The sql executes fine using HeidiSQL connected to the same db and creates the function.

I have tried to execute the sql using Execute() and QueryResult() at no avail.

Can someone help?

Thank you.

[cnavarro]

Mira a ver si esto te ayuda
viewtopic.php?t=33280

[reinaldocrespo]

Querido amigo mio;

Muchas muchas gracias.

That thread helped me see the problem.

So far, everywhere I have read and even when testing scripts with HeidiSQL, I must use the clase "DELIMITER" to change the standard delimiter from ; to something else, like //. That way a ; does not ends the script. This is stupid to me, but it is a MySQL rule non the less; as per all documentation I have read.

However, with the fw client being used for MariaDB (and I suspect MySQL), the clause "DELIMITER" causes a syntax error. That was all the problem.

I realized this when reading your reference thread where Mr. Rao shows a script that creates a function and he is not using the clause "DELIMITER'.

This brings me to the question... why? I would expect there is a standard.

Well, what really matters to me is that is a problem solved and thank you very much Cristobal.

[cnavarro]

Dear Reinaldo, thanks
This is one of the most valuable posts on this forum.
The explanation is wonderful, but above all, Mr. Rao's implementation of STORE PROCEDURES (and use of CALL) in his fabulous class developed for MySQL/MariaDB is magnificent.
The differences between the standard and Fivewin's implementation lie in the development Mr. Rao did in his class, as always, to try to make it easier for users.
Best regards and a hug.