Search found 1281 matches

by anserkk
Mon Oct 29, 2018 5:12 am
Forum: FiveWin for Harbour/xHarbour
Topic: Mysql with ADO
Replies: 10
Views: 1606

Re: Mysql with ADO

I check whether the connection object is NIL or not if not NIL, then I check whether the DefaultDatabase property (available in the connection object) is empty or NOT, if empty, then I understand that for some reason, the connection with the database was lost in-between and need to reconnect. Then I...
by anserkk
Mon Oct 29, 2018 4:34 am
Forum: FiveWin for Harbour/xHarbour
Topic: Mysql with ADO
Replies: 10
Views: 1606

Re: Mysql with ADO

Yes, we will definitely will face this issue at one point of time, especially when we access the database via Internet. At times, the internet connectivity in the client PC may break. It may be for few seconds or for few minutes, or hours and the internet connectivity is resrored automatically. Ther...
by anserkk
Sat Sep 22, 2018 5:00 am
Forum: FiveWin for Harbour/xHarbour
Topic: hash
Replies: 4
Views: 716

Re: hash

Did you try
hb_jsonDecode( <jsonString>, @var, [<codePage>] ) -> length of decoded <jsonString>, var will contain the resulting Harbour value
by anserkk
Thu Jul 12, 2018 4:25 am
Forum: FiveWin for Harbour/xHarbour
Topic: Latest FWH upgrade, performance issues, larger EXE
Replies: 27
Views: 4103

Re: Latest FWH upgrade, performance issues, larger EXE

What about the count of deleted records in the DBF files. ? This may slow down the read/write.
by anserkk
Wed Jun 20, 2018 4:06 am
Forum: FiveWin for Harbour/xHarbour
Topic: MySQL vs MariaDB
Replies: 4
Views: 815

Re: MySQL vs MariaDB

I too use MariaDB for more than 3 years. I have deployed 5 different applications using MariaDB as the database. All these databases are being used by more than 600 users with concurrent users counting to 100+ at any point of time. The size of some of the databases are more than 15 GB. Till now I ha...
by anserkk
Mon Jun 18, 2018 4:41 am
Forum: FiveWin for Harbour/xHarbour
Topic: HYPERLINK
Replies: 9
Views: 1539

Re: HYPERLINK

Code: Select all

cText := ""
TEXT INTO cText
=HYPERLINK("[D:\\MyExcelFile.xlsx]'Sheet1 A'!C5","CLICK HERE")
ENDTEXT
Now use the cText on the cell
by anserkk
Sun Jun 17, 2018 2:16 pm
Forum: FiveWin for Harbour/xHarbour
Topic: HYPERLINK
Replies: 9
Views: 1539

Re: HYPERLINK

Hi =HYPERLINK("[C:\MyFolderName\MyExcelFile.xlsx]Sheet1-A!C5","CLICK HERE") If the page (Sheet1-A) has a hyphen, the link is not valid. How to overcome this. Please try replacing the sheet name within single quotes ' '. For eg =HYPERLINK("[C:\MyFolderName\MyExcelFile.xlsx]'...
by anserkk
Tue Jun 12, 2018 9:57 am
Forum: FiveWin for Harbour/xHarbour
Topic: HYPERLINK
Replies: 9
Views: 1539

Re: HYPERLINK

Hi oSheet:Cells( 12,6 ):Value := '=HYPERLINK("c:\abc\TEST1.xlsx", "oExcel:Sheets(1):Select()" )' How to hyperlink to sheet 1 of Test1 Thanks Regards ACWoo Using bcc582 + FHW Did you try =HYPERLINK("[C:\MyFolderName\MyExcelFile.xlsx]Sheet1!C5","CLICK HERE") Th...
by anserkk
Mon May 28, 2018 7:17 am
Forum: FiveWin for Harbour/xHarbour
Topic: Word OLE
Replies: 2
Views: 868

Re: Word OLE

Did you try

Code: Select all

cText = oWord:ActiveDocument:Tables(1):Cell(1, 1):Range:Text
by anserkk
Fri May 18, 2018 10:59 am
Forum: FiveWin for Harbour/xHarbour
Topic: Include Variable within "TEXT INTO" (SOLVED)
Replies: 6
Views: 686

Re: Include Variable within "TEXT INTO"

Did you try this ?

Code: Select all

TEXT INTO cSql
  SELECT Column1 
  FROM myTable
  WHERE Column2 = ? 
ENDTEXT
nMyVar:=1
cSql := FW_AdoApplyParams( cSql, { nMyVar } )
Regards
Anser
by anserkk
Thu Jan 18, 2018 3:57 am
Forum: FiveWin for Harbour/xHarbour
Topic: Text (SMS), and emails.
Replies: 4
Views: 1335

Re: Text (SMS), and emails.

byron.hopp wrote:Additional we would like to send texts (sms).
There are many Bulk SMS and Email service providers. You can use http GET to send SMS via web. They will provide you their API URL which you can use in your Fivewin application.
by anserkk
Tue Nov 28, 2017 4:29 am
Forum: FiveWin for Harbour/xHarbour
Topic: What FWH version are you using for production work ?
Replies: 5
Views: 992

Re: What FWH version are you using for production work ?

I am curious what FWH version people are using for actual production work ( released product ). The latest released version is 17.09, however, I know several of us had to re-vert to 17.06 or .07 database.prg to resolve problems with the new database revisions. I'm wondering if anyone is able to use...
by anserkk
Wed Oct 25, 2017 4:04 am
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse as record adding tool for data tables
Replies: 16
Views: 3040

Re: xBrowse as record adding tool for data tables

Its just an idea. All the recordset data will be read into an array initially, then use this Array on xBrowse. So you will be adding a blank array row and the data is validated and if all the data typed in by the user is as per your rules, then append the data to your DBF/Recordset. Of course you wi...
by anserkk
Sat Aug 19, 2017 4:47 am
Forum: FiveWin for Harbour/xHarbour
Topic: Dos application help
Replies: 5
Views: 1323

Re: Dos application help

Someone can help me to create a small harbour dos test ? I need a bat file to compile thanks Long time back, I tried compiling one of my 16 bit clipper applications using Harbour. It worked fine, except some minor issues in the Tbrowse classs. Here is the rmk file that I used #Borland make sample, ...