Page 6 of 6
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Posted: Wed Oct 06, 2021 5:53 pm
by 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.
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Posted: Wed Jul 19, 2023 5:28 pm
by goosfancito
Is there a wiki that explains how to use fwconnect so I can see what is needed for an embedded mariadb connection?
thanks
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Posted: Fri Mar 21, 2025 6:39 pm
by 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.
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Posted: Fri Mar 21, 2025 7:03 pm
by 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
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Posted: Sun Mar 23, 2025 1:41 pm
by Compuin
Hello,
It doesn't work.
Regards
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Posted: Sun Mar 23, 2025 2:26 pm
by vilian
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Posted: Sat Mar 29, 2025 12:21 am
by 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.
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Posted: Sat Mar 29, 2025 12:29 am
by cnavarro
Mira a ver si esto te ayuda
viewtopic.php?t=33280
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Posted: Sat Mar 29, 2025 12:37 pm
by 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.
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Posted: Sun Mar 30, 2025 12:47 am
by 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.