Search found 986 matches

by reinaldocrespo
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

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

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 ...
by reinaldocrespo
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 ...
by reinaldocrespo
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 ...
by reinaldocrespo
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.
by reinaldocrespo
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 ...
by reinaldocrespo
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 ...
by reinaldocrespo
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 ...
by reinaldocrespo
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 ...
by reinaldocrespo
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 ...
by reinaldocrespo
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 ...
by reinaldocrespo
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 ...
by reinaldocrespo
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 ...
by reinaldocrespo
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 ...
by reinaldocrespo
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 ...
by reinaldocrespo
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 ...