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
Programming / Re: Create/Update Excel Workbook
« on: June 06, 2023, 02:42:57 PM »
Oops - I thought that was Tom posting that.
32
Programming / Re: Create/Update Excel Workbook
« on: June 06, 2023, 02:30:11 PM »
Hi Tom,
I'm not sure at what point you are getting the error, but are you at least able to do this:
def object excel_obj,"Excel.Application"
filename$="c:\temp\customers.xls" ! Replace filename$ with your file name
workbook=excel_obj'workbooks'open(filename$)
can you get that far without an error?
jeff
I'm not sure at what point you are getting the error, but are you at least able to do this:
def object excel_obj,"Excel.Application"
filename$="c:\temp\customers.xls" ! Replace filename$ with your file name
workbook=excel_obj'workbooks'open(filename$)
can you get that far without an error?
jeff
33
Nomads / Re: HTML Tip
« on: May 22, 2023, 08:22:17 AM »
Hi Mike
i was trying to mimic what the editor was doing so i did something like this
<p>Hinge Locations are measured from Top of Door</p>
<p>Hinge Location 1: 7-12</p>
<p>Hinge Location 2: 7-12</p>
<p>Hinge Location 3: 7-12</p>
and it put a scroll bar (this is a general summary of html...any how i changed it to just
put <br/> after each line and the scrolling stopped...but i would like to know if i did anything wrong.
i dont think i was exceeding a limit.
i was trying to mimic what the editor was doing so i did something like this
<p>Hinge Locations are measured from Top of Door</p>
<p>Hinge Location 1: 7-12</p>
<p>Hinge Location 2: 7-12</p>
<p>Hinge Location 3: 7-12</p>
and it put a scroll bar (this is a general summary of html...any how i changed it to just
put <br/> after each line and the scrolling stopped...but i would like to know if i did anything wrong.
i dont think i was exceeding a limit.
34
Hi All,
if i make a long html tip inside of nomads it displays nice.
if i do it in code via the tip$ then i'm getting a vertical scroll bar (and the tip is not even that long).
i'm using version 16.20 .
does anyone know a way i can rid myself of this vertical scroll bar
thanks
jeff
if i make a long html tip inside of nomads it displays nice.
if i do it in code via the tip$ then i'm getting a vertical scroll bar (and the tip is not even that long).
i'm using version 16.20 .
does anyone know a way i can rid myself of this vertical scroll bar
thanks
jeff
35
Programming / Auto Clicking Buttons and entering data
« on: May 11, 2023, 03:13:11 PM »
Hi List,
i have handled this different ways in the past and i'm wondering if someone has some input on a better way to handle it.
I have a gui screen that has been around a while. The client is giving me a file which is the input for the screen. But unlike something like Excel.Application there is no api for the screen. Is there a better way to simulate the user clicking on buttons and filling out the fields than what i have done in the past which is to:
a.) fire off screen with some argument saying Auto Mode
b.) then go to a routine that will do something like this
1.) Item_Number = passed in item Number
2.) gosub item_number_changed
3.) Quantity = passed in quantity
4.) gosub quantity changed
thanks jeff
i have handled this different ways in the past and i'm wondering if someone has some input on a better way to handle it.
I have a gui screen that has been around a while. The client is giving me a file which is the input for the screen. But unlike something like Excel.Application there is no api for the screen. Is there a better way to simulate the user clicking on buttons and filling out the fields than what i have done in the past which is to:
a.) fire off screen with some argument saying Auto Mode
b.) then go to a routine that will do something like this
1.) Item_Number = passed in item Number
2.) gosub item_number_changed
3.) Quantity = passed in quantity
4.) gosub quantity changed
thanks jeff
36
Programming / Re: Preview / Viewer Object
« on: April 10, 2023, 08:39:13 AM »
Hi Stéphane,
Yes that is it.
Thank you !
jeff
Yes that is it.
Thank you !
jeff
37
Programming / Re: Preview / Viewer Object
« on: April 07, 2023, 07:19:12 AM »
Hi Mike,
I'm sorry I should have given an example.
He gave me the code to do something like this:
def object viewer_obj,"Viewer"
and then i could automate some of the functions like saving it.
is this still possible?
I'm sorry I should have given an example.
He gave me the code to do something like this:
def object viewer_obj,"Viewer"
and then i could automate some of the functions like saving it.
is this still possible?
38
Programming / Preview / Viewer Object
« on: April 06, 2023, 02:15:54 PM »
Hi List,
A long time ago Gord Davey helped me invoke a viewer object where i could interact with the viewer. I have lost the code and I cant remember how to do it. Can anyone help me with that?
thanks
jeff
A long time ago Gord Davey helped me invoke a viewer object where i could interact with the viewer. I have lost the code and I cant remember how to do it. Can anyone help me with that?
thanks
jeff
39
Language / Re: *X Mnemonic / Print Channel Timing Question
« on: March 07, 2023, 04:32:30 PM »
Thank you Allen and Mike. I appreciate it.
40
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
41
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
42
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
43
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..
44
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
45
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