RE: [U2] unidata bci commands not compiling
The compiler has informed you (via the ^ ) where it stopped compiling. This suggests that it's having a problem with the constant SQL.NUMERIC, which is in the header file BCI.H. My guess is that you have not included this file. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unidata bci commands not compiling
Hi It might be stating the obvious, but it has caught me once or twice, did you include $INCLUDE UNIVERSE.INCLUDE ODBC.H at the beginning of the program. I have used this in UniVerse for years, the problem maybe using a wrong parameter code. The following is from some of my code ST=SQLBindParameter(STMTENV,1,SQL.B.BASIC,SQL.CHAR,0,0,CLIENT.NO,SQL.PARAM.I NPUT) Hope it gives you some ideas to try. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Clark Sent: Saturday, 15 January 2005 8:58 AM To: u2-users@listserver.u2ug.org Subject: [U2] unidata bci commands not compiling I'm attempting to use BCI on unidata 6.0 under hpux on a pa-risc box. The simple commands work--I can open and close connections and statement handles and execute statements that affect remote databases. However, when I attempt to do something more complicated and efficient--use SQLBindParameters--the statement will simply not compile. I can make a call to SQLPrepare, but the SQLBindParameters function apparently doesn't exist in my version of unidata. I have also tried the documented synonym SQLSetParam with the same result. The compiler thinks I'm referencing an array with too many dimensions, as the following compiler output shows: main program: syntax error at or before ST=SQLBindParameter(STMT.HANDLE,1,0,SQL.NUMERIC,0,0,0) ---^ Expecting: array,string,number,function,variable,OR,AND,!,>,>=,<,<=,=,<>,MATCH,CAT,:,+, - Has anyone else experienced this? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] unidata bci commands not compiling
I'm attempting to use BCI on unidata 6.0 under hpux on a pa-risc box. The simple commands work--I can open and close connections and statement handles and execute statements that affect remote databases. However, when I attempt to do something more complicated and efficient--use SQLBindParameters--the statement will simply not compile. I can make a call to SQLPrepare, but the SQLBindParameters function apparently doesn't exist in my version of unidata. I have also tried the documented synonym SQLSetParam with the same result. The compiler thinks I'm referencing an array with too many dimensions, as the following compiler output shows: main program: syntax error at or before ST=SQLBindParameter(STMT.HANDLE,1,0,SQL.NUMERIC,0,0,0) ---^ Expecting: array,string,number,function,variable,OR,AND,!,>,>=,<,<=,=,<>,MATCH,CAT,:,+, - Has anyone else experienced this? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Sorting after MERGE.LIST
I thought the results of a MERGE.LIST were already sorted. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Sorting after MERGE.LIST
I believe in Unidata, using ED you could edit the list and then do $sort to sort it, or a similar command. I don't recall exactly the command. Thanks, Marilyn A. Hilb Value Part, Inc Direct: 847-918-6099 Fax: 847-367-1892 [EMAIL PROTECTED] www.valuepart.com -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 11:19 AM To: u2-users@listserver.u2ug.org Subject:RE: [U2] [UV] Sorting after MERGE.LIST It's a bit more involved, but typically when I'm facing a similar issue I'll write code to copy the sort fields to records in a work file so that I have all of the sort information from all n files in one place, then SSELECT that work file to get everything in order. It's a bit more involved this way, but it's portable and avoids issues like this. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, January 14, 2005 8:35 AM To: u2-Users Subject: [U2] [UV] Sorting after MERGE.LIST Greetings all, Does anyone know of a way to sort the results of a MERGE.LIST? My problem is that the results of the MERGE.LIST are from 3 separate files so I have nothing to select against. My first thought was to look at SELECTE but there are no options for that and no SSELECTE. Thanks in advance, Scott --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Sorting after MERGE.LIST
If on *nix, SAVE.LIST then quit to *nix and use the OS sort on the SAVEDLIST "record" ? Could be difficult if it's a very big list which spans multiple records (or is that Unidata ?) but you can get round it hth Piers --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Sorting after MERGE.LIST
It's a bit more involved, but typically when I'm facing a similar issue I'll write code to copy the sort fields to records in a work file so that I have all of the sort information from all n files in one place, then SSELECT that work file to get everything in order. It's a bit more involved this way, but it's portable and avoids issues like this. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, January 14, 2005 8:35 AM To: u2-Users Subject: [U2] [UV] Sorting after MERGE.LIST Greetings all, Does anyone know of a way to sort the results of a MERGE.LIST? My problem is that the results of the MERGE.LIST are from 3 separate files so I have nothing to select against. My first thought was to look at SELECTE but there are no options for that and no SSELECTE. Thanks in advance, Scott --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Sorting after MERGE.LIST
How about SAVE.LIST, SORT.LIST, GET.LIST ? Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, January 14, 2005 8:35 AM To: u2-Users Subject: [U2] [UV] Sorting after MERGE.LIST Greetings all, Does anyone know of a way to sort the results of a MERGE.LIST? My problem is that the results of the MERGE.LIST are from 3 separate files so I have nothing to select against. My first thought was to look at SELECTE but there are no options for that and no SSELECTE. Thanks in advance, Scott --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Sorting after MERGE.LIST
Greetings all, Does anyone know of a way to sort the results of a MERGE.LIST? My problem is that the results of the MERGE.LIST are from 3 separate files so I have nothing to select against. My first thought was to look at SELECTE but there are no options for that and no SSELECTE. Thanks in advance, Scott --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: WinteGrate
Steve,
I don't know if you have a solution. But $0.02 is the following
001: X.PROG = "iexplore"
002: XFILE =
"http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&;
loc=en_US&Requester=UPSHome&tracknum=1Z9366900308642377&AgreeToTermsAndC
onditions=yes&track.x=22&track.y=9"
003: CALL WIN.PCRUN(X.PROG,XFILE)
Compilied and ran the code and it worked fine.
HTH
Frank
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Steve Kunzman
Sent: Wednesday, January 12, 2005 3:19 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Re: WinteGrate
I had saved this post for future reference. The future is here. I am
trying to use WIN.PCRUN to launch internet explorer to retrieve UPS
package tracking information. Their web site has changed, so I tried to
paste in the new URL, but it gives me a wIntegrate message, "Unable to
run specified program". This URL works if I type it in the browser. If I
try to just launch the browser and view a jpeg, a simple URL
(WWW.UPS.COM), or a text file, it works. Any ideas?
http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&l
oc=en_US&Requester=UPSHome&tracknum=1Z9366900308642377&AgreeToTermsAndCo
nditions=yes&track.x=22&track.y=9
Thanks. Steve
Unidata/HP-UX
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Mark Johnson
Sent: Saturday, February 21, 2004 12:23 PM
To: U2 Users Discussion List
Subject: Re: WinteGrate
A simpler way would be:
PCFILE="C:\FOLDER\PICTURE.JPEG"
CALL WIN.PCRUN("IEXPLORE", PCFILE)
It opens up a new window with the aforementioned picture.
You can also pass URL's that you fabricate to open up very useful
windows.
Two that i use are:
www.maps.yahoo.com\&address=123&main&street&zip=12345
and
www.ups.com/tracking/1Z12345678901234567
These are fictious urls, but you can visit both UPS/Fedex and/or
Mapquest/Yahoo or any other map-like site and cut & paste the real URL
and modify the variable portion. Brings green screen users a little
closer to the nice feel of the windows world.
All of my UPS clients use the UPS concept and 3 of mine with 'truck' use
the map concept.
my 3 cents.
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Saturday, February 21, 2004 11:39 AM
Subject: Re: WinteGrate
> In a message dated 2/19/2004 5:51:51 AM Pacific Standard Time,
> [EMAIL PROTECTED] writes:
>
> > Question: Using WinteGrate, running UniVerse 10, Unix - Is
there
> > a way to display a 'jpeg' file in UniVerse ?
> > We have trucking companies that send up 'proof of
> > deliveries' in jpeg format. Our user base would love
> > to be able to view them straight from UniVerse.
> >
> > As always, very appreciative for ideas/assistance
> >
> > Barry Rogen
>
> Barry store all the jpegs in a shared windows directory on your
network
> In Universe have your program tell Wintegrate to "write the following
path
> into the clipboard" blah blah blah (the path of the image in the
shared
Windows
> directory)
> Then in your Universe program tell Wintegrate to execute its script
> "showjpg.scr" or something like that (you create this script in a
shared
location as
> well)
> The Wintegrate script merely launches whatever it finds in the
clipboard
>
> Will Johnson
> Fast Forward Technologies
> --
> u2-users mailing list
> u2-users@oliver.com
> http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
u2-users@oliver.com
http://www.oliver.com/mailman/listinfo/u2-users
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: WinteGrate
Here's a summary of how this works in wIntegrate:
To run a specific PC program from a Basic program and pass it an argument, use:
CALL WIN.PCRUN("iexplore", "www.ups.com")
CALL WIN.PCRUN("excel", "myfile.xls")
To run a program from the file association in the registry, use:
CALL WIN.PCRUN("www.ups.com", "")
CALL WIN.PCRUN("myfile.xls", "")
To run a url displayed on the 80x24 character screen, for example www.ups.com,
single-click on the url. This can be customised, see:
* Setup Mouse, Key Definition for MouseLeft
* Program Files\wIntegrate\WintSys\Script\Click.wis
wIntegrate can also display images in various formats including jpegs, either
on the 80x24 screen (using WIN.IMAGE) or in a pop-up dialog (which would need
some scripting).
David
Vistus Technologies
-Original Message-
From: Steve Kunzman [mailto:[EMAIL PROTECTED]
Sent: 12 January 2005 20:19
To: u2-users@listserver.u2ug.org
Subject: [U2] Re: WinteGrate
I had saved this post for future reference. The future is here. I am trying to
use WIN.PCRUN to launch internet explorer to retrieve UPS package tracking
information. Their web site has changed, so I tried to paste in the new URL,
but it gives me a wIntegrate message, "Unable to run specified program". This
URL works if I type it in the browser. If I try to just launch the browser and
view a jpeg, a simple URL (WWW.UPS.COM), or a text file, it works. Any ideas?
http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&l
oc=en_US&Requester=UPSHome&tracknum=1Z9366900308642377&AgreeToTermsAndCo
nditions=yes&track.x=22&track.y=9
Thanks. Steve
Unidata/HP-UX
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Mark Johnson
Sent: Saturday, February 21, 2004 12:23 PM
To: U2 Users Discussion List
Subject: Re: WinteGrate
A simpler way would be:
PCFILE="C:\FOLDER\PICTURE.JPEG"
CALL WIN.PCRUN("IEXPLORE", PCFILE)
It opens up a new window with the aforementioned picture.
You can also pass URL's that you fabricate to open up very useful windows.
Two that i use are:
www.maps.yahoo.com\&address=123&main&street&zip=12345
and
www.ups.com/tracking/1Z12345678901234567
These are fictious urls, but you can visit both UPS/Fedex and/or Mapquest/Yahoo
or any other map-like site and cut & paste the real URL and modify the variable
portion. Brings green screen users a little closer to the nice feel of the
windows world.
All of my UPS clients use the UPS concept and 3 of mine with 'truck' use the
map concept.
my 3 cents.
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Saturday, February 21, 2004 11:39 AM
Subject: Re: WinteGrate
> In a message dated 2/19/2004 5:51:51 AM Pacific Standard Time,
> [EMAIL PROTECTED] writes:
>
> > Question: Using WinteGrate, running UniVerse 10, Unix - Is
there
> > a way to display a 'jpeg' file in UniVerse ?
> > We have trucking companies that send up 'proof of
> > deliveries' in jpeg format. Our user base would love
> > to be able to view them straight from UniVerse.
> >
> > As always, very appreciative for ideas/assistance
> >
> > Barry Rogen
>
> Barry store all the jpegs in a shared windows directory on your
network
> In Universe have your program tell Wintegrate to "write the following
path
> into the clipboard" blah blah blah (the path of the image in the
shared
Windows
> directory)
> Then in your Universe program tell Wintegrate to execute its script
> "showjpg.scr" or something like that (you create this script in a
shared
location as
> well)
> The Wintegrate script merely launches whatever it finds in the
clipboard
>
> Will Johnson
> Fast Forward Technologies
> --
> u2-users mailing list
> u2-users@oliver.com
> http://www.oliver.com/mailman/listinfo/u2-users
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.11 - Release Date: 12/01/2005
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] Person Locator
I would like to get in contact with a person named Natasha Grinberg, formerly of Microdata, Pantone and Unidata. I found a most interesting Microdata circumstance that has her name written on it. If anyone would have an email address for her or her husband, Henry Grinberg, then it would be appreciated. You could forward my email to them if you feel confidentiality is an issue. They were a pick-programming husband/wife team. You don't see that too often. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
