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.
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India
FiveTech Support Forums
FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Is there a wiki that explains how to use fwconnect so I can see what is needed for an embedded mariadb connection?
thanks
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.
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/1DnNBBtwj4nDIER63_tCdWIUOW5XjwpVU/view?usp=sharing
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/1DnNBBtwj4nDIER63_tCdWIUOW5XjwpVU/view?usp=sharing
vilian wrote: Hi Reinaldo,Hello,
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/1DnNBBtwj4nDIER63_tCdWIUOW5XjwpVU/view?usp=sharing
It doesn't work.
Regards
FWH 25.12
Harbour/Hbmk2
Microsoft Visual C++
MySql 8.0
Antigravity
I need some help executing certain SQLs using this class. Below is the code to one such instance where the class returns an error.
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.
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 ;I have tried to execute the sql using Execute() and QueryResult() at no avail.
Can someone help?
Thank you.
Cristobal Navarro
Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo
El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces
Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo
El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces
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.
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.
Cristobal Navarro
Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo
El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces
Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo
El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces
vilian wrote: Another link https://www.mediafire.com/file/r92mgkwd1p55p2j/MariaDB+native+support+docs.chm/fileDo you have another copy of the CHM, That one doesn't work either
Greetings from Chile
;-) Ji,ji,ji... buena la cosa... "all you need is code"
http://www.xdata.cl - Desarrollo Inteligente
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650
http://www.xdata.cl - Desarrollo Inteligente
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650
Hi Adolfo,
Here is it: https://www.mediafire.com/file/r92mgkwd1p55p2j/MariaDB_native_support_docs.chm/file
Here is it: https://www.mediafire.com/file/r92mgkwd1p55p2j/MariaDB_native_support_docs.chm/file