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 ...
Search found 986 matches
- Sat Mar 29, 2025 12:37 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
- Replies: 84
- Views: 45440
- Sat Mar 29, 2025 12:21 am
- Forum: FiveWin for Harbour/xHarbour
- Topic: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
- Replies: 84
- Views: 45440
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
I need some help executing certain SQLs using this class. Below is the code to one such instance where the class returns an error.
DELIMITER //
CREATE FUNCTION CurrentLease(
pPropID CHAR( 25 ), pDate DATE
)
RETURNS CHAR( 13 ) DETERMINISTIC
BEGIN
DECLARE cLease CHAR( 13 ) DEFAULT ...
DELIMITER //
CREATE FUNCTION CurrentLease(
pPropID CHAR( 25 ), pDate DATE
)
RETURNS CHAR( 13 ) DETERMINISTIC
BEGIN
DECLARE cLease CHAR( 13 ) DEFAULT ...
- Sat Mar 22, 2025 6:26 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Parameterized queries with MariaDB
- Replies: 1
- Views: 1138
Parameterized queries with MariaDB
Hello Everyone;
Parameterized queries are key to preventing SQL injection in any SQL including MariaDB. However, in MariaDB (and MySQL), the parameterization itself is handled at the level of the client application, not in SQL syntax directly.
Parameterized queries are also a lot faster when ...
Parameterized queries are key to preventing SQL injection in any SQL including MariaDB. However, in MariaDB (and MySQL), the parameterization itself is handled at the level of the client application, not in SQL syntax directly.
Parameterized queries are also a lot faster when ...
- Fri Mar 21, 2025 6:39 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
- Replies: 84
- Views: 45440
Re: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
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.
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.
- Thu Mar 20, 2025 7:54 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: ADSODBC and OpenSSL
- Replies: 2
- Views: 1111
ADSODBC and OpenSSL
Hello everyone;
Is anyone connecting to an Advantage Database data dictionary using ODBC?
I'm having problems trying to connect using an ODBC DNS entry. I'm using ADSODBC and ADSODBC64 from ADS ver 10.10. Here is the error:
Connection failed: [iAnywhere Solutions][Advantage SQL][ASA] Error 7160 ...
Is anyone connecting to an Advantage Database data dictionary using ODBC?
I'm having problems trying to connect using an ODBC DNS entry. I'm using ADSODBC and ADSODBC64 from ADS ver 10.10. Here is the error:
Connection failed: [iAnywhere Solutions][Advantage SQL][ASA] Error 7160 ...
- Mon Mar 03, 2025 2:32 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: multi-column popup menu
- Replies: 15
- Views: 39865
Re: multi-column popup menu
Hello Everyone;
I made a small change to Mr Rao's and Mr. Cristobal's function so that I can use it on a get to show a multi-column dropdown list:
//----------------------------------------------------------------------------//
Function MyPopMnu( oWnd, nR, nC, aChoices, aHeaders )
local oPop ...
I made a small change to Mr Rao's and Mr. Cristobal's function so that I can use it on a get to show a multi-column dropdown list:
//----------------------------------------------------------------------------//
Function MyPopMnu( oWnd, nR, nC, aChoices, aHeaders )
local oPop ...
- Sun Mar 02, 2025 10:52 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: multi-column popup menu
- Replies: 15
- Views: 39865
Re: multi-column popup menu
Hello Cristobal. Very ingenious way to use a Tmenu object. I like it and I wish to use it on a get:
REDEFINE GET o VAR ::oDbf:VarCNKey ID 104 OF oDlg BITMAP "Search16"
o:bAction := { || x := MyPopMnu( oDlg, o:nTop, o:nLeft, ::aContractors ) }
The problem is your MyPopMenu function returns ...
REDEFINE GET o VAR ::oDbf:VarCNKey ID 104 OF oDlg BITMAP "Search16"
o:bAction := { || x := MyPopMnu( oDlg, o:nTop, o:nLeft, ::aContractors ) }
The problem is your MyPopMenu function returns ...
- Tue Jul 30, 2024 3:02 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: DBF File Format - Considerations A Secure Option
- Replies: 15
- Views: 4693
Re: DBF File Format - Considerations A Secure Option
Hello. It is easy to defend and swear by DBF when you have not experimented with SQL. It is hard to miss or even imagine what you have never experienced.
If you are a DBF user, you don’t care much for referential integrity. Sync and replication are just fancy words. Relational joints and result ...
If you are a DBF user, you don’t care much for referential integrity. Sync and replication are just fancy words. Relational joints and result ...
- Tue Jul 16, 2024 9:33 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: How to Curl for text messaging
- Replies: 5
- Views: 5931
Re: How to Curl for text messaging
curl_global_init() and curl_global_cleanup() should be called only once in the program. Throw them away from the function.
Have a main function as an entry point. For example: Main(). And from that Main() entry point call curl_global_init.... then call your function as many times as needed. Then ...
Have a main function as an entry point. For example: Main(). And from that Main() entry point call curl_global_init.... then call your function as many times as needed. Then ...
- Tue Jul 16, 2024 7:30 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: How to Curl for text messaging
- Replies: 5
- Views: 5931
Re: How to Curl for text messaging
If the program successfully sends texts via Twilio and then you get a runtime error when closing, the problem is most likely in your code and it has nothing to do with your make file. Try finding the exact line that causes de GPF or write and share a reduced sample code that replicates the runtime ...
- Tue Jul 16, 2024 12:27 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: EZTexting Send Message
- Replies: 8
- Views: 2197
Re: EZTexting Send Message
Hello Byron and Tim;
This link will show you my initial post when I shared the TTwilio class on this forum back in 2022: https://forums.fivetechsupport.com/viewtopic.php?f=3&t=40019&sid=9aaac815084955aeea18479527c26320
And you can see I'm not using aHeaders here. Instead I allow curl_easy_setopt ...
This link will show you my initial post when I shared the TTwilio class on this forum back in 2022: https://forums.fivetechsupport.com/viewtopic.php?f=3&t=40019&sid=9aaac815084955aeea18479527c26320
And you can see I'm not using aHeaders here. Instead I allow curl_easy_setopt ...
- Tue Jul 16, 2024 12:11 pm
- Forum: mod_harbour
- Topic: Replace jQuery with JavaScript
- Replies: 2
- Views: 9787
Re: Replace jQuery with JavaScript
Hello Otto;
If you were to organize another FWH-ModHarbour-WEB-SQL summit, I would attend. The summit from 2017 was a great experience for me.
As you mature on your web development, it seems to me like you have been gravitating more and more towards PHP and Javascript (and I'm guessing HTML + CSS ...
If you were to organize another FWH-ModHarbour-WEB-SQL summit, I would attend. The summit from 2017 was a great experience for me.
As you mature on your web development, it seems to me like you have been gravitating more and more towards PHP and Javascript (and I'm guessing HTML + CSS ...
- Tue Jul 02, 2024 1:07 pm
- Forum: mod_harbour
- Topic: Building modharbour with ADS on Linux
- Replies: 18
- Views: 30860
Re: Building modharbour with ADS on Linux
Thank you Otto and thank you Antonio;
I decided I will setup a Windows server as well as the Linux server both running Apache.
I'm always busy with many things but expect to spend some time testing Mod_harbour and PHP accessing ADS tables.
I'm fully aware we are on our own when it comes to ADS ...
I decided I will setup a Windows server as well as the Linux server both running Apache.
I'm always busy with many things but expect to spend some time testing Mod_harbour and PHP accessing ADS tables.
I'm fully aware we are on our own when it comes to ADS ...
- Sun Jun 30, 2024 12:45 pm
- Forum: mod_harbour
- Topic: Building modharbour with ADS on Linux
- Replies: 18
- Views: 30860
Building modharbour with ADS on Linux
Hello ModHarbourers;
Wishing to experiment more with ModHarabour, I have setup an old computer with Fedora server + Apache + PHP 8.2. Apache and PHP are working fine.
I have <git> cloned mod_harbour from GitHub.com/fivetechsoft/mod_harbour.git and Harbour from GitHub.com/vszakats/harbour-core.git ...
Wishing to experiment more with ModHarabour, I have setup an old computer with Fedora server + Apache + PHP 8.2. Apache and PHP are working fine.
I have <git> cloned mod_harbour from GitHub.com/fivetechsoft/mod_harbour.git and Harbour from GitHub.com/vszakats/harbour-core.git ...
- Sun Apr 14, 2024 5:39 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: ADS with 64bit FWH Apps
- Replies: 24
- Views: 5623
Re: ADS with 64bit FWH Apps
Hello everyone;
I bet the problem here is that you are trying to connect to an older server version using a newer client version. The opposite is fine. But newer clients need same or newer server.
Try using 64 bit version of ADS 12 if you want to connect to ADS 12 server.
All my customers are ...
I bet the problem here is that you are trying to connect to an older server version using a newer client version. The opposite is fine. But newer clients need same or newer server.
Try using 64 bit version of ADS 12 if you want to connect to ADS 12 server.
All my customers are ...