headers
George Gallen | 16 May 2013 15:41

[U2] Selecting a special character in a SELECT (UV)

Ok.

I'm trying to find all the ID's in a file that contain the character ^160

I tried : SELECT filename WITH  <at> ID LIKE "...^160..."
But that didn't work.

Aside from writing a program to scan the file, is there a way from TCL?

George
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 13 comments |
headers
Kathleené M Hunter | 15 May 2013 18:25

[U2] Convert data from UniData to Microsoft SQl server

Does anyone have a way to calculate the disk space required to move data
from a UniData Server to a Microsoft SQL server.  

_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 6 comments |
headers
Sathya | 15 May 2013 11:44
Picon

[U2] select query..

Hi Experts..

I have one issue here with fetching data from the file. 

EXECLINE = "SELECT FILE.NAME WITH  <at> ID = \":KEYVALUE:"\"
DISPLAY EXECLINE
EXECUTE EXECLINE RTNLIST LIST1
EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1

LIST.NAME = "GET-LIST SOME.LIST"
sellist = ''
EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk

Here Im running a loop for a set of "KEYVALUE"s and for each run the 
SSELECT statement is taking around 30 seconds. When I want to run 1000 
loops, ideally the run time will be much. 

Is there any easier way to do this with less time consumption.

Thanks & Regards,
Sathya V. 

_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 15 comments |
headers
Anthonys Lists | 8 May 2013 20:42
Picon

Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.

On 08/05/2013 18:11, George Gallen wrote:
> That's assuming you are the one who created / imported the data into Excel.
> However, I receive Excel files very frequently where the user who created it
> Has little knowledge of formatting cells.
>
> So very often I am forced to import data with dropped trailing zeros.
>
> That and phone numbers being converted to E notation....Hate those.
>
With our phone numbers ... we are forced to use a database that exports 
to excel ...

And if you don't put spaces and whatnot in phonenumbers to force excel 
to realise it's text, all your phone numbers have their leading zeroes 
stripped ...

(I believe it's written by outside consultants, but the lady internal to 
the organisation who looks after it thinks it's wonderful. As a database 
programmer forced to use it, my opinion of it is unprintable ... I can't 
be too rude though because this lady is a good friend of and 
sort-of-boss-to my wife)

Cheers,
Wol
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
(Continue reading)

Permalink | Reply | 4 comments |
headers
Susan Joslyn | 7 May 2013 17:18

Re: [U2] SB and Printers

Hi everyone,

I have not used the printer admin parts of SB very much.  I have a customer
trying to set up printers in SB but when he runs a report (/ARD type) and
uses 'P' to go to the printer he gets this message about the printer not
being 'started'.  Anyone know what step we missed?  Screen shot below if you
can see it.  Basically it's the SB Print Manager window, then centered on
the bottom row 'THIS PRINTER IS NOT STARTED'.

Susan

_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 2 comments |
headers
Sathya | 7 May 2013 08:37
Picon

[U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.

Hi all,..

Im getting the below error while running my code,..Can someone please help 
me with this issue?

Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, 
SOAP or database variable.

Code snippet : 

OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP "CAN Not find file"

READ DATA FROM temp_file1 ELSE STOP "Can not find temp filename"

Where TEMP.FILE1 is something like "Filepath/filename.txt". Its a text file 
in the server and I want to read the contents and do some comparison. 

TIA, 
Sathya V.  

_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 39 comments |
headers
Wjhonson | 6 May 2013 18:50
Picon
Favicon

[U2] Fwd: [1] job on LinkedIn


 Bracknell, looks like its about 20 miles from London (as the crow flies)
The job doesn't *state* that you need a work visa, but I assume you would ?
Is it difficult to get a permit to work in Britain?

-----Original Message-----
From: Rocket Software Group Members <group-digests <at> linkedin.com>
To: Will Johnson <wjhonson <at> aol.com>
Sent: Mon, May 6, 2013 9:42 am
Subject: [1] job on LinkedIn

    

            Rocket Software          

        
          May 6, 2013        

  
Job Discussions (1)

      

          
                          Epicor Software  is looking for Application Support Analyst.                          

              
Posted by Sharon Small, Recruiter at Epicor Software Corp
(Continue reading)

Permalink | Reply | 2 comments |
headers
Tony Gravagno | 3 May 2013 22:11
Picon
Favicon

Re: [U2] FOSS

From: Wjhonson 
> Tony, the link I posted has tons of free code.

Just no MV BASIC implementation. So the tons of free code there has nothing to do with your suggestion that
"someone" write something new.

> So "giving it away for free" is not anything new, although I know that
> attacking that idea is your own personal hobby horse :)

I manage and/or contribute to freeware on Google Code, Codeplex, Sourceforge, GitHub, PickWiki, my own
freeware page, and elsewhere. I also provide occasional forum support for various freeware projects and
Android apps. It's easily evident that I don't have any axe to grind against freeware.

> I was just suggesting maybe there could also be a BASIC algorithm
> listed on that link, along with all the other ones listed.

And I just have a visceral reaction when people _assume_ that something of value is going to be written on
uncompensated time, given away for free, and then maintained at no cost by people who obviously derive
commercial benefit.

You mistake my pro-FOSS comments as attacks. The problem with the FOSS model is that it's horrendously
abused by people who take but don't give back, by people who assume that there is no cost in terms of time or
contributions, let alone money) for what they consume, but people who casually suggest that someone else
will provide slave labor for the benefit of all. The FOSS world is a mass graveyard of dead projects
abandoned by altruistic developers who've been abused by hoards of people who love their software
creations - and when one developer is beaten down the locusts fly off to the next project. Our own community
has hundreds of offerings that have suffered this fate. I support the model enough to point out its faults
in the hope that good software doesn't go away because of the propa
 gation of this inane idea that somehow it's all "free" - as in beer.
(Continue reading)

Permalink | Reply | 1 comment |
headers
Wjhonson | 3 May 2013 18:17
Picon
Favicon

[U2] Fwd: Your message to U2-Users awaits moderator approval


 40 K ?  That seems so tiny....

-----Original Message-----
From: u2-users-bounces <u2-users-bounces <at> listserver.u2ug.org>
To: wjhonson <wjhonson <at> aol.com>
Sent: Fri, May 3, 2013 9:14 am
Subject: Your message to U2-Users awaits moderator approval

Your mail to 'U2-Users' with the subject

    Re: [U2] AES Encryption Of CC Numbers

Is being held until the list moderator can review it for approval.

The reason it is being held:

    Message body is too big: 46521 bytes with a limit of 40 KB

Either the message will get posted to the list, or you will receive
notification of the moderator's decision.  If you would like to cancel
this posting, please visit the following URL:

    http://listserver.u2ug.org/mailman/confirm/u2-users/46c1bb56e98c4aa9b1285183674a36c9dad4127f

 
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
(Continue reading)

Permalink | Reply | 0 comments |
headers
George Gallen | 3 May 2013 17:24

[U2] [way ot] - Electronic Button Purshers?

OK.

I'm trying to use a Raspberry pi to push a button, but only want to use one GPIO port.
Basically, I'm trying to get the pi to turn a device on or off - and can't easily get to
Where the button on the device's board is at to have the pi trigger with a relay,
So I plan to mount the device, and have something just push the button directly.

Do they make a device that when energized,  will push a rod out then back?
Right now, my only option (maybe not only), would be to create a Scotch Yoke
http://en.wikipedia.org/wiki/Scotch_yoke

But for space contraints, and ease, I'd rather put in something that would do
That as it's primary function.

George

_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 49 comments |
headers
Gary Heiman | 3 May 2013 07:36
Picon
Favicon

[U2] AES Encryption Of CC Numbers

Hi folks - I'm new to this community, but aged in Multivalue Experience.
Forgive me if this was aswered previously, but does anybody know of an
algorithm in MV Basic to Encrypt/DeCrypt Credit Card Numbers based on one of
the industry standards AES ? Thanks in advance ! Gary

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of
u2-users-request <at> listserver.u2ug.org
Sent: Thursday, May 02, 2013 12:00 PM
To: u2-users <at> listserver.u2ug.org
Subject: U2-Users Digest, Vol 49, Issue 2

Send U2-Users mailing list submissions to
	u2-users <at> listserver.u2ug.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://listserver.u2ug.org/mailman/listinfo/u2-users
or, via email, send a message with subject or body 'help' to
	u2-users-request <at> listserver.u2ug.org

You can reach the person managing the list at
	u2-users-owner <at> listserver.u2ug.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of U2-Users digest..."

Today's Topics:

   1. Re: Would anyone else like a change to *HS.UPDFINFO? (Allen Bell)
(Continue reading)

Permalink | Reply | 7 comments |

Gmane