Search found 811 matches

by fraxzi
Wed Sep 19, 2018 2:57 am
Forum: FiveWin for Harbour/xHarbour
Topic: Encrypt and Decrypt errors
Replies: 9
Views: 2465

Re: Encrypt and Decrypt errors

I got it...

Str2Hex() and Hex2Str() ...

:)
by fraxzi
Wed Sep 19, 2018 2:39 am
Forum: FiveWin for Harbour/xHarbour
Topic: Encrypt and Decrypt errors
Replies: 9
Views: 2465

Re: Encrypt and Decrypt errors

Hi All,

how to use HB_StrToHex()/HB_HexToStr() in xHarbour ... Any equivalent?

:?:
by fraxzi
Wed Sep 12, 2018 9:00 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS AppendBlank (SOLVED)
Replies: 12
Views: 3758

Re: MariaDB RS AppendBlank (SOLVED)

Hi Rao,

Copy ... I will find a way to modify those entry/dialogs ... I will keep you posted.
Rest assured this is only temporary.

:wink: :wink: :wink:
by fraxzi
Wed Sep 12, 2018 7:56 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS AppendBlank (SOLVED)
Replies: 12
Views: 3758

Re: MariaDB RS AppendBlank

Hi Rao, I did this: ... oRs:Append() ... oRec := oRs:Record(.T.) ... oRec:field := "if wrong data entered, trigger fires up, else normal)" ... oRec:Save()   When there's error, trigger shows up AND IT DOES NOT clear the input fields so user can still continue. i verified and validated the ...
by fraxzi
Wed Sep 12, 2018 5:41 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS AppendBlank (SOLVED)
Replies: 12
Views: 3758

Re: MariaDB RS AppendBlank

Hi Rao, I have one observation.. while testing. ... oRs:Append() oRec := oRs:Record() ... oRec:field := "wrong value" oRec:Save()  //returns .T., no trigger error!? (there should be...) oRS:Save()   //returns .F. ...   but with this (presumably correct) ... oRs:Append() oRs:field := "...
by fraxzi
Wed Sep 12, 2018 3:35 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS AppendBlank (SOLVED)
Replies: 12
Views: 3758

Re: MariaDB RS AppendBlank

Hi Rao, Well explained. I will keep this open for some time.. for a while, I will test based on your directions how to avoid the issue (fields getting cleared) when trigger/procedure fires up. I will also check oRS:field => oRec:field while editing on screen. Thanks much as always you are very helpf...
by fraxzi
Wed Sep 12, 2018 1:37 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS AppendBlank (SOLVED)
Replies: 12
Views: 3758

Re: MariaDB RS AppendBlank

Hi Rao, I did a good dialog editing modeled after your good samples specially from 'MariaInv.Prg' ... Let me share my working dialog designed and required by end-user: http://i208.photobucket.com/albums/bb82/fraxzi/FWxHarbour/datan3a_zpskjedbjzc.png http://i208.photobucket.com/albums/bb82/fraxzi/FWx...
by fraxzi
Wed Sep 12, 2018 12:16 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS AppendBlank (SOLVED)
Replies: 12
Views: 3758

Re: MariaDB RS AppendBlank

Hi Rao,

I used the oRs:AppendBlank() so user can edit blank oRs:field.. then oRs:Save() when done.
xbrowse is not use here.

:?:
by fraxzi
Tue Sep 11, 2018 12:02 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS AppendBlank (SOLVED)
Replies: 12
Views: 3758

Re: MariaDB RS AppendBlank

anybody experienced this ?

:?:
by fraxzi
Mon Sep 10, 2018 1:44 am
Forum: FiveWin for Harbour/xHarbour
Topic: Encrypt MariaDB Data
Replies: 5
Views: 1452

Re: Encrypt MariaDB Data

Hello Otto,

What are the steps you made? could you share ...

:wink:
by fraxzi
Fri Sep 07, 2018 5:59 am
Forum: FiveWin for Harbour/xHarbour
Topic: FWMARIADB 127.0.0.1 connection fail *Solved*
Replies: 4
Views: 1175

Re: FWMARIADB 127.0.0.1 connection fail

Hi Dutch,

No Issue here... I only changed the query and connection parameters to match with my test..

Image

:)
by fraxzi
Fri Sep 07, 2018 4:47 am
Forum: FiveWin for Harbour/xHarbour
Topic: FWMARIADB 127.0.0.1 connection fail *Solved*
Replies: 4
Views: 1175

Re: FWMARIADB 127.0.0.1 connection fail

Hi Dutch,

I use FWH1805/06 with localhost (127.0.0.1) without a glitch in my test environment ...
Just letting you know.

:wink:
by fraxzi
Fri Sep 07, 2018 3:01 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS AppendBlank (SOLVED)
Replies: 12
Views: 3758

MariaDB RS AppendBlank (SOLVED)

Hi All, 1. I have a trigger and procedure to check data lenght/data validity of user input, this is working fine. 2. When user encodes data to oRs:field (under appendblank) and fires oRs:Save()... then trigger captures and send message about the insufficient field length.. 3. then the oRs:fields are...
by fraxzi
Fri Sep 07, 2018 2:55 am
Forum: FiveWin for Harbour/xHarbour
Topic: Encrypt MariaDB Data
Replies: 5
Views: 1452

Re: Encrypt MariaDB Data

Thank you Otto,

I am planning to do encryption on my current project too.. This is a good start to initially understand it .

:wink:
by fraxzi
Thu Sep 06, 2018 5:55 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS to Temporary Table
Replies: 3
Views: 1289

Re: MariaDB RS to Temporary Table

Hi Vilian,

Thanks! I will try this. Let you know.

:wink: