PxPlus User Forum

Twitter Twitter Twitter

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Jeffrey Ferreira

Pages: 1 ... 6 7 [8] 9
106
ODBC / Providex File Service Keeps Dying
« on: July 02, 2019, 09:21:02 AM »
Hello List,
We have this account where we are running Providex File Service and PxPlus IO Service.
the PxPlus IO Service runs fine.
but everytime we go to query from the Providex File Service  the Service Stops.
The event viewer is not helpful.
I added a log to my dsn....
and here is what i get (see below)
does anyone have any thoughts

=======================================================
Driver version: 5.20.0000
ISAMOpen: UserID='cai', length=3
ISAMOpen: Trying to access the server using UserID='cai', Company=''
GetAccessibleTables:<table=ALL> Open catalog(s) [rmt:ponderosa1;20222]p:\cai\cai_lib , available 1266 table(s)
<Customer Master File> Open file p:\customer_data\mpd\MF1010, maxksz=22
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
     CACHE STATS - 0 reads, size 21642240 estimated, 0 used
------------------------------
SELECT * FROM "Customer Master File" WHERE 0 = 1

<Customer Master File> Open file p:\customer_data\mpd\MF1010, maxksz=22
Accessing table Customer Master File using keyno 0 * All records *
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
<Customer Master File> Open file p:\horner\mpd\MF1010, maxksz=22
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
     CACHE STATS - 0 reads, size 21642240 estimated, 0 used
GetAccessibleTables:<table=ALL> Open catalog(s) [rmt:ponderosa1;20222]p:\cai\cai_lib , available 1266 table(s)
------------------------------
SELECT * FROM "Customer Master File" WHERE ( 0 = 1 )

<Customer Master File> Open file p:\customer_data\mpd\MF1010, maxksz=22
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
     CACHE STATS - 0 reads, size 21642240 estimated, 0 used
------------------------------
SELECT * FROM "Customer Master File" WHERE ( 0 = 1 )

<Customer Master File> Open file p:\horner\mpd\MF1010, maxksz=22
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
     CACHE STATS - 0 reads, size 21642240 estimated, 0 used
------------------------------
SELECT * FROM "Customer Master File" WHERE ( 0 = 1 )

<Customer Master File> Open file p:\customer_data\mpd\MF1010, maxksz=22
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
     CACHE STATS - 0 reads, size 21642240 estimated, 0 used
------------------------------
SELECT * FROM "Customer Master File"

<Customer Master File> Open file p:\customer_data\mpd\MF1010, maxksz=22
Accessing table Customer Master File using keyno 0 * All records *
<Customer Master File> First Read Seek sts=0 key='', len=-1, keyno=1
<fh=Customer Master File> PVK_read returns buffer= iRsz='-1'

107
Programming / Re: Object Oriented Question
« on: June 25, 2019, 02:30:17 PM »
Stephane,

i think i finally understand what you are saying and how it could work....
if i had program1 create instantiate an object...
and inside method of the object i use the concurrent window that would allow me to create a closeable window  and because it is inside the method it would not be visible to the program that isntantiated the object...
is that what you were saying?

jeff

108
Programming / Re: Object Oriented Question
« on: June 24, 2019, 07:27:04 PM »
Hi Mike,

Thank you I will look at it. However, I was trying to get my feet with OOP and I thought why not do it with something useful.
I guess what I was looking for was an answer to the question:

is OOP good to use for GUI user interfaces?
or just for doing calculations and storing data.

For instance i can see the usefulness of something like this
==============================================
Customer.pvc object

cust=new("Customer")
cust'load("ABC100")
print cust'ar_balance
cust'deactivate()

but i cant see a good way to get it to work with a panel....

and the answer might be, "No Jeff you dont use OOP with panels."

thanks for you patience with me.

jeff

109
Programming / Re: Object Oriented Question
« on: June 24, 2019, 11:56:36 AM »
Hi Stephane,

Thanks for getting back to me. My only concern with that is that I think then all the controls / variables will be visible in new window.  I dont think that is a good idea or at least it violates the concept of encapsulation. I feel like a dummy because i read all these tutorials on OOP and it seems to work fine if you never want a user interface. But again it is probably the way I am implementing and I'm missing something very basic.

Jeff

110
Programming / Re: Object Oriented Question
« on: June 23, 2019, 08:03:36 PM »
i re-read my post...i should clarify...all the oop examples are like:

x=new("Automobile")
x.blow_horn()
x.top_speed=120

i'm wondering if associating a panel is a good idea or possible with oop

thanks

jeff

111
Programming / Object Oriented Question
« on: June 23, 2019, 07:19:06 PM »
Hello List,
i'm really new to oop.
I was trying to create an object using pxplus charts that would do something like the following:
chart1=new("chart")
and then i change properties to make a bar, line chart etc..then i can invoke the object from any panel presenting data....
the problem i am having is I want it to display in  a window...
i would like to equate to:

def object excel_obj="Excel.Application" and you have a visible excel that you can close....

the problem is when i draw a 'dialogue' and put my chart on it
if i close it i close my whole session....

i feel like once i get past this hurdle i can run with it....

112
ODBC / Re: Error Log ODBC
« on: March 18, 2019, 01:23:27 PM »
Devon, i think i'm pretty sure i'm using the same one
i have 64 bit version
if i go back in there it is still checked....
i will double check everything.

113
ODBC / Error Log ODBC
« on: March 18, 2019, 11:36:41 AM »
Hello List,
On the Debug Tab of a 64 bit odbc pxplus data source i checked.
Enable Debug
and then specified log file
if i use test connection it outputs to the file but no other tests will write to the file....Excel  or Other applications that we use to access it...
Has anyone had this issue before....
i have used this feature before at another client with some degree of success.

jeff

114
Programming / Re: Generic Query
« on: March 07, 2019, 05:02:49 PM »
i was told i need to do a set_focus and not next_id

115
Programming / Generic Query
« on: March 07, 2019, 04:35:30 PM »
Hello List,

I tend to always run into these one off situations where I need user input from a list
but the data is not in a file and too many selections for a message box.
and i dislike making a panel for each instance....
so i had this idea for a generic query routine that i could
pass in an associative array
and get a return value
============================================
here is my code ...it is almost working but i dont think i have the OBTAIN right
and the arrows are not working on the list box.....
has anyone ever done this?
can someone help me out

29000 !
29010 GENERIC_QUERY:
29020 enter (PANEL_TITLE$),ARRAY${all},RETURN_VALUE$
29030 if dim(read num(ARRAY$))=0 then exit ! If No Values then Exit
29040 call "CAIREPOS;PRINT_CENTERED_DIALOGUE",50,35,(PANEL_TITLE$) ! This is just my routine to Print a Centered Window (this part works)
29050 let LOAD_THIS$=""
29060 for ARRAY_INDEX$ index ARRAY${all}
29070 let LOAD_THIS$+=ARRAY_INDEX$+sep
29080 next
29090 list_box 100,@(1,1,48,33),fnt="*"
29100 list_box load 100,LOAD_THIS$
29120 list_box write 100,1,err=*next
29121 let NEXT_ID=100
29130 wait .5
29140 repeat
29150 obtain (tim=2)NIU$
29160 let MODE$=""
29170 list_box read 100,RETURN_VALUE$,MODE$,err=*next
29180 until MODE$=$0D$ or MODE$=$02$
29190 print (0,err=*next)'pop',
29990 exit

116
Programming / Re: JSON to Array
« on: February 28, 2019, 11:36:49 AM »
A Coworker of mine just pointed out that I missed this in the documentation:

DIM LOAD array_name${ALL} = JSON_value$

sorry about that.

117
Programming / JSON to Array
« on: February 28, 2019, 10:58:38 AM »
Hi All,

I know we can take a PxPlus Associative Array and convert it to JSON.
I'm struggling with the inverse.
How do I parse JSON passed back via PxPlus.
Is it possible using PxPlus?

jeff

118
Programming / Re: Defining Function
« on: February 25, 2019, 12:54:59 PM »
This looks promising James. I will give it a try. Thank you.

119
Programming / Defining Function
« on: February 25, 2019, 11:51:13 AM »
Hello List,

I'm trying to avoid using a global function but I would like function available in multiple programs.  I tried doing the following: 

PROG01

10 perform "PR0G02;DEFINE_FUNCTIONS"
20 PRINT fnPAIR$("Key","Value")

but I can't access the function defined in PR0G02

is my only recourse  a Global Function?

jeff

120
Programming / Re: Multi Line Dash
« on: February 21, 2019, 02:01:16 PM »
thanks Mike.
I figured was standard behavior but I just thought I would ask.
jeff

Pages: 1 ... 6 7 [8] 9