Search found 811 matches

by fraxzi
Thu Sep 06, 2018 12:54 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS to Temporary Table
Replies: 3
Views: 1344

MariaDB RS to Temporary Table

Hi All,

i've been looking our threads related to this but none I found..

I am looking for a way to save oRS to Table (not as .dbf) in MariaDB.. How to do this :?:

any :idea:
by fraxzi
Thu Sep 06, 2018 12:38 am
Forum: FiveWin for Harbour/xHarbour
Topic: FWH and SAP ???
Replies: 1
Views: 1028

Re: FWH and SAP ???

Anyone :?:

BTW, SAP ECC using SybaseDB ...

:!:
by fraxzi
Wed Sep 05, 2018 9:05 am
Forum: FiveWin for Harbour/xHarbour
Topic: SetCheck() on MariaDB => SOLVED
Replies: 15
Views: 5453

Re: SetCheck() on MariaDB => SOLVED

Hi Rao,

Yes you are correct! :D

The example you provided truly demonstrate xBrowse flexibility ... I so much appreciate your help.

Thanks!

:idea: :idea: :idea: :idea: :idea:
by fraxzi
Wed Sep 05, 2018 3:25 am
Forum: FiveWin for Harbour/xHarbour
Topic: SetCheck() on MariaDB => SOLVED
Replies: 15
Views: 5453

Re: SetCheck() on MariaDB => SOLVED

Hi Rao,

You Nailed it :!:

:wink: :wink: :wink:
by fraxzi
Wed Sep 05, 2018 12:11 am
Forum: FiveWin for Harbour/xHarbour
Topic: FWH and SAP ???
Replies: 1
Views: 1028

FWH and SAP ???

Dear All,

Anyone here using FWH connects to SAP or full records from TCode??

:?: :?: :?:
by fraxzi
Tue Sep 04, 2018 11:53 pm
Forum: FiveWin for Harbour/xHarbour
Topic: SetCheck() on MariaDB => SOLVED
Replies: 15
Views: 5453

Re: SetCheck() on MariaDB

Hi Rao, The samples you provided works.. But the other query condition (expression) still not recognized as boolean (after MYSQL_TinyIntAsLogical ( .T. ) global declaration) as shown: with TinyInt column: http://i208.photobucket.com/albums/bb82/fraxzi/FWxHarbour/setcheck_02_zpsy9dqbfp2.png with expr...
by fraxzi
Tue Sep 04, 2018 9:14 am
Forum: FiveWin for Harbour/xHarbour
Topic: SetCheck() on MariaDB => SOLVED
Replies: 15
Views: 5453

Re: SetCheck() on MariaDB

Hi Rao,

Here's the result with table containing TINYINT field is it the same structure when I query a table with TINYINT field?:

Image
by fraxzi
Tue Sep 04, 2018 5:13 am
Forum: FiveWin for Harbour/xHarbour
Topic: SetCheck() on MariaDB => SOLVED
Replies: 15
Views: 5453

Re: SetCheck() on MariaDB

Hi Rao,

I declared it as global on my init procedure and modify conditions ...

Image

Still the :SetCheck() and the oRS column showing numeric zero instead of boolean..

:?:
by fraxzi
Mon Sep 03, 2018 1:20 am
Forum: FiveWin for Harbour/xHarbour
Topic: SetCheck() on MariaDB => SOLVED
Replies: 15
Views: 5453

SetCheck() on MariaDB => SOLVED

Hi Folks, I am having trouble displaying xBrowse :SetCheck() on MariaDB RS as shown: RS: ... SELECT False AS lcheck, rdt_reqnum, rdt_reqdat, rdt_mrnumb, rdt_mrdesc FROM rdt_forms ... oRS::lTinyIntAsLogical := .T. ... oBrw:aCols[ 1 ]:SetCheck({'checkon16', 'checkoff16'}, .T.) ...   I tried other comb...
by fraxzi
Sat Sep 01, 2018 12:25 am
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse error on ADS (SOLVED!)
Replies: 12
Views: 2977

Re: xBrowse error on ADS

Hi Roderick,

Call me at the office. :wink: :wink: :wink:

Thanks,
Frances
by fraxzi
Wed Aug 22, 2018 3:50 am
Forum: FiveWin for Harbour/xHarbour
Topic: How do you handle User Access on your FW App
Replies: 5
Views: 1629

Re: How do you handle User Access on your FW App

Dear Gentlemen Mr. Marc and Mr. Rick, Thanks for the great Idea :idea: I got it sorted now.. defining :nID for each object I wish to control (enable/disable) defined in user table.. iterate these objects based also on defined :nID of Dialog/Window.. Before I used to define menu to access dialogs.. n...
by fraxzi
Sat Aug 18, 2018 9:02 am
Forum: FiveWin for Harbour/xHarbour
Topic: How do you handle User Access on your FW App
Replies: 5
Views: 1629

Re: How do you handle User Access on your FW App

bpd2000 wrote:Simple logig is enable/disable Menu Item according to user's rights
Hi,

User menu/item is fine.. but what about get objects you define each object per user?

:?:
by fraxzi
Sat Aug 18, 2018 6:49 am
Forum: FiveWin for Harbour/xHarbour
Topic: How do you handle User Access on your FW App
Replies: 5
Views: 1629

How do you handle User Access on your FW App

Dear All,

How do you manage user privilege to access certain menu item / edit fields, etc. on your FW?

What is best suited structure? I dunno if I am asking the right question, help me out here.

Any Idea?
:idea: :idea: :idea:
by fraxzi
Mon Aug 13, 2018 12:04 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS Tree
Replies: 5
Views: 1546

Re: MariaDB RS Tree

Mr. Rao,

This is great approach.. I did it with JOINS too.. I thought of On-The-Fly oChild when parent root expanded.. But maybe not a good idea?

I always referenced your sample relative to xBrowse.. Absolutely very helpful. :wink:


:idea:
by fraxzi
Sat Aug 11, 2018 2:15 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS Tree
Replies: 5
Views: 1546

MariaDB RS Tree

Hi All, It's been helpful Mr. Rao providing great help on oRS Tree issues (not only that of-course) :D can anyone help creating this Tree using oRS-Parent-Child? where in the child sync when tree item expanded... :?: :?: :?: http://i208.photobucket.com/albums/bb82/fraxzi/FWxHarbour/oRS_Tree_zpsavjsn...