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.
31
Language / Re: *X Mnemonic / Print Channel Timing Question
« on: March 07, 2023, 11:19:05 AM »
Hi Allen,
thank you.
so closing the file (again) is not forbidden or bad.
jeff
thank you.
so closing the file (again) is not forbidden or bad.
jeff
32
Language / *X Mnemonic / Print Channel Timing Question
« on: March 07, 2023, 10:16:30 AM »
Hi All,
i'm trying to use *X mnemonic to print to a text file and email to customer.
But i noticed that when I enter the call entry point the file is still open and locked for that matter.
I added another close inside of the call routine and that worked (i could access file).
But is this correct / good practice?
Jeff
i'm trying to use *X mnemonic to print to a text file and email to customer.
But i noticed that when I enter the call entry point the file is still open and locked for that matter.
I added another close inside of the call routine and that worked (i could access file).
But is this correct / good practice?
Jeff
33
ODBC / Re: ODBC Date Issue
« on: March 03, 2023, 03:47:08 PM »
So I just spoke to our Product Manager. Our dates in this file use the format:
DATE-MM/DD/AA
the AA was a Legacy Y2K Data Class. Could that be the issue?
jeff
DATE-MM/DD/AA
the AA was a Legacy Y2K Data Class. Could that be the issue?
jeff
34
ODBC / Re: ODBC Date Issue
« on: March 03, 2023, 02:52:22 PM »
Hi Mike
1.) it returns all the data
2.) i did have a key so i tried the order by and it did not work....
but to be sure i tried on another date field (no key) ...stilll did not work
3.) Order by primary key (no date in key) - did not work
4.) I think the data class might be the problem...
i'm going to take this off line...thanks for the info..
1.) it returns all the data
2.) i did have a key so i tried the order by and it did not work....
but to be sure i tried on another date field (no key) ...stilll did not work
3.) Order by primary key (no date in key) - did not work
4.) I think the data class might be the problem...
i'm going to take this off line...thanks for the info..
35
ODBC / Re: ODBC Date Issue
« on: March 03, 2023, 02:25:02 PM »
Devon can i bug you with one last question...
when you say ODBC expects YYYY/MM/DD are you saying that my date needs to be stored in the pxplus Data Dictionary as YYYY/MM/DD -> because our dates are stored as MM/DD/YY in the pxplus data dictionary.
or are you just saying the WHERE clause needs to be in 'YYYY/MM/DD' format.
jeff
when you say ODBC expects YYYY/MM/DD are you saying that my date needs to be stored in the pxplus Data Dictionary as YYYY/MM/DD -> because our dates are stored as MM/DD/YY in the pxplus data dictionary.
or are you just saying the WHERE clause needs to be in 'YYYY/MM/DD' format.
jeff
36
ODBC / Re: ODBC Date Issue
« on: March 03, 2023, 11:50:43 AM »
I just tried it with Excel Power Query and that failed too. I tested it against another database we have (mysql) and that worked. Is it possible there is something wrong with the 7.00 ODBC Driver. This worked when we were using 4.21.
jeff
jeff
37
ODBC / Re: ODBC Date Issue
« on: March 03, 2023, 09:20:19 AM »
Devon,
i'm sorry i was just pseudo coding it quick to give you all an idea what i was trying to do
i'm not creating the SQL Select (Excel is).
jeff
i'm sorry i was just pseudo coding it quick to give you all an idea what i was trying to do
i'm not creating the SQL Select (Excel is).
jeff
38
ODBC / ODBC Date Issue
« on: March 03, 2023, 08:14:56 AM »
Hi All,
We are using ODBC Driver 7.00.
If we do the following in Excel
Select Order_Number, Order_Date from "Open Orders" WHERE Order Date > "09/01/2022"
it returns every order up until 12/31/2022 and does not return anything from 2023
if we do
Select Order_Number, Order_Date from "Open Orders" WHERE Order Date > "01/01/2023"
then it returns the 2023 orders
has anyone ever seen this or know what i could be doing wrong?
thanks
jeff
We are using ODBC Driver 7.00.
If we do the following in Excel
Select Order_Number, Order_Date from "Open Orders" WHERE Order Date > "09/01/2022"
it returns every order up until 12/31/2022 and does not return anything from 2023
if we do
Select Order_Number, Order_Date from "Open Orders" WHERE Order Date > "01/01/2023"
then it returns the 2023 orders
has anyone ever seen this or know what i could be doing wrong?
thanks
jeff
39
Programming / Outlook Appt or Meeting
« on: January 30, 2023, 01:15:51 PM »
Has anyone ever been able to send an email via *web\email to create an Outlook Meeting or Appointment?
Not sure if it is even possible.
jeff
Not sure if it is even possible.
jeff
40
Programming / Re: Passing a COM Object to a CMD
« on: November 18, 2022, 10:33:25 AM »
Thank you - I will try it out.
41
Programming / Re: Passing a COM Object to a CMD
« on: November 18, 2022, 07:48:55 AM »
Hi Stéphane ,
I was hoping there was something that already existed. I should have looked harder. However when i run it it says pvxtlb.exe does not exist? I'm running version 1710-001 on windows...should it be there?
thanks
jeff
I was hoping there was something that already existed. I should have looked harder. However when i run it it says pvxtlb.exe does not exist? I'm running version 1710-001 on windows...should it be there?
thanks
jeff
42
Programming / Passing a COM Object to a CMD
« on: November 17, 2022, 05:06:39 PM »
Hi List
I was trying to do the following
def object excel_obj,"Excel.Application"
I then created a *cmd\PO to parse object and return values for troubleshooting...
if i do
call "*cmd\PO",excel_obj it works
but if i do
PO EXCEL_OBJ
i get an error 36 ..i don think it sees it as a numeric...i seem to remember something like *VARIANT
can anyone shed any light on this?
thanks
jeff
I was trying to do the following
def object excel_obj,"Excel.Application"
I then created a *cmd\PO to parse object and return values for troubleshooting...
if i do
call "*cmd\PO",excel_obj it works
but if i do
PO EXCEL_OBJ
i get an error 36 ..i don think it sees it as a numeric...i seem to remember something like *VARIANT
can anyone shed any light on this?
thanks
jeff
43
Programming / Re: Associative Arrays
« on: October 17, 2022, 11:32:11 AM »
Thanks Mike
that is exactly what i am looking for.
jeff
that is exactly what i am looking for.
jeff
44
Programming / Associative Arrays
« on: October 17, 2022, 11:06:23 AM »
Hello All,
If I have a small associative array of items like this
INSTALL_ITEM_ARRAY["INS1"]=1
INSTALL_ITEM_ARRAY["INS2"]=1
INSTALL_ITEM_ARRAY["INS3"]=1
If I check to see if item is in the array it adds that item to array with a value of 0.
Question -> Is there a way i can check the array without it adding it to array. Is this taking up room in memory ...
if i'm checking a few million invoices lines - i dont want to run into an error 31
I know i can use a memory file but the associative array is quite convenient.
thanks
jeff
If I have a small associative array of items like this
INSTALL_ITEM_ARRAY["INS1"]=1
INSTALL_ITEM_ARRAY["INS2"]=1
INSTALL_ITEM_ARRAY["INS3"]=1
If I check to see if item is in the array it adds that item to array with a value of 0.
Question -> Is there a way i can check the array without it adding it to array. Is this taking up room in memory ...
if i'm checking a few million invoices lines - i dont want to run into an error 31
I know i can use a memory file but the associative array is quite convenient.
thanks
jeff
45
Web Services / Re: EZWeb Server
« on: September 26, 2022, 02:59:28 PM »
Hi Mike
the program name is parts.pxp
i'm using http://localhost:8080/parts.pxp
i'm not using a query string at this time
it is an older version of pxplus 10.2
here is my program parts.pxp
0010 print (%PRINT_FN)"<html>"
0020 print (%PRINT_FN)"<head>"
0030 print (%PRINT_FN)"</head>"
0040 print (%PRINT_FN)"<body>"
0041 print (%PRINT_FN)"<h1>Hello Jeff</h1>"
0042 print (%PRINT_FN)"</body>"
0043 print (%PRINT_FN)"</html>"
0050 end
i'm pretty sure it is finding my program because in firefox here is what it shows on screen
[Pvxprg]�Ù���Õ�½�cai ����������������������������������������c1’þ���������������X9�������Ù���Õ���½�������Ù��������������������������������������������������������������������������������������������������������������������������������������������€�'� text/htmlÿ��
Ç$€&�<html>ÿ��Ç$€&�<head>ÿ�� Ç$€&�</head>ÿ��(Ç$€&�<body>ÿ� �)Ç$€&�<h1>Hello Jeff</h1>ÿ��*Ç$€&�</body>ÿ��+Ç$€&�</html>ÿ��2¦ÿ�ýè¦ÿ
%CONTENT_TYPE %PRINT_FN���
the program name is parts.pxp
i'm using http://localhost:8080/parts.pxp
i'm not using a query string at this time
it is an older version of pxplus 10.2
here is my program parts.pxp
0010 print (%PRINT_FN)"<html>"
0020 print (%PRINT_FN)"<head>"
0030 print (%PRINT_FN)"</head>"
0040 print (%PRINT_FN)"<body>"
0041 print (%PRINT_FN)"<h1>Hello Jeff</h1>"
0042 print (%PRINT_FN)"</body>"
0043 print (%PRINT_FN)"</html>"
0050 end
i'm pretty sure it is finding my program because in firefox here is what it shows on screen
[Pvxprg]�Ù���Õ�½�cai ����������������������������������������c1’þ���������������X9�������Ù���Õ���½�������Ù��������������������������������������������������������������������������������������������������������������������������������������������€�'� text/htmlÿ��
Ç$€&�<html>ÿ��Ç$€&�<head>ÿ�� Ç$€&�</head>ÿ��(Ç$€&�<body>ÿ� �)Ç$€&�<h1>Hello Jeff</h1>ÿ��*Ç$€&�</body>ÿ��+Ç$€&�</html>ÿ��2¦ÿ�ýè¦ÿ
%CONTENT_TYPE %PRINT_FN���