On 08/05/13 21:43, Tony Gravagno wrote:
[ad]
And of course all of these situations are avoidable by using
NebulaXLite.
http://Nebula-RnD.com/products/xlite.htm
[/ad]
And of course, all of these situations are UNavoidable when you are just
a mere user of the database :-(
I'd love to have
On 08/05/13 20:10, Tony Gravagno wrote:
I have news for you - they ALL do. Other systems don't store data
with trailing zeros because they have no need to store them. It's up
to each individual user/application to decide whether to use 1 digit,
2, 4, or none. Data is stored with as few
...@youngman.org.uk
To: u2-users u2-users@listserver.u2ug.org
Sent: Fri, May 10, 2013 2:04 am
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
On 08/05/13 21:43, Tony Gravagno wrote:
[ad]
And of course all of these situations
, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
if var is XXX.XX
ICONV(var,MD2) then OCONV(var,MD0)
Dale
On 05/07/2013 12:04 PM, Sathya wrote:
Wjhonsonwjhonsonat aol.com writes:
Satya the OSOPEN command.. what version of the system are you running?
Hi,.
Thanks everyone
] On Behalf Of dale kelley
Sent: Tuesday, May 07, 2013 6:06 PM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
if var is XXX.XX
ICONV(var,MD2) then OCONV(var,MD0)
Dale
On 05/07/2013 12:04 PM, Sathya wrote
Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
George,
After sending it I thought, Well,... that OCONV acomplishes nothing!
Dale
On 05/08/2013 08:32 AM, George Gallen wrote:
What purpose will the OCONV(var,MD0
: Wednesday, May 08, 2013 9:37 AM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
George,
After sending it I thought, Well,... that OCONV acomplishes nothing!
Dale
On 05/08/2013 08:32 AM, George Gallen wrote
Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
It doesn't do nothing - it rounds - if the input value is 55.5 you get 56 as
output. It only does nothing if your input is a whole number.;
-Original Message
...@listserver.u2ug.org] On Behalf Of dale kelley
Sent: Wednesday, May 08, 2013 9:37 AM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
George,
After sending it I thought, Well,... that OCONV acomplishes nothing!
Dale
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley
Sent: Tuesday, May 07, 2013 6:06 PM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable
...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Wednesday, May 08, 2013 10:34 AM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
NUM() will validate '' (null string) as numeric, and I believe some
...@listserver.u2ug.org] On Behalf Of dale kelley
Sent: Wednesday, May 08, 2013 9:37 AM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
George,
After sending it I thought, Well,... that OCONV acomplishes nothing
: Wednesday, May 08, 2013 10:34 AM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
NUM() will validate '' (null string) as numeric, and I believe some
implementations would validate '.' (decimal point
Of dale kelley
Sent: Wednesday, May 08, 2013 9:37 AM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
George,
After sending it I thought, Well,... that OCONV acomplishes nothing!
Dale
On 05/08/2013 08
-users@listserver.u2ug.org
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
Not to be too obtuse, but if the only point is to convert MM.MM to
you could just use CONVERT
Of Wjhonson
Sent: Wednesday, May 08, 2013 12:08 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
Not to be too obtuse, but if the only point is to convert MM.MM to
you could just use CONVERT
Of Wjhonson
Sent: Wednesday, May 08, 2013 12:14 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
Yes but the original request was just to take MM.MM and write
-Original
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
On Behalf Of Wjhonson
Sent: Wednesday, May 08, 2013 12:14 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
Yes
, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
Haha yes, but again, the original request...
If a client sent me dollar figures where 12.2 was supposed to mean 12.20 I
would go like ... what kind of system do you run where 12.2 means 12.20 ?
I'm assuming that a file you want to read
:36 am
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
They call it Excel!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
On Behalf Of Wjhonson
Sent
-08-13 9:38 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
No when I tell Excel that a column is dollars, or time, it always leaves
the trailing zero.
What are you doing that makes
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, May 8, 2013 9:36 am
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
They call it Excel!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
1:04 PM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
If my code isn't at least as smart as a 5th grader, it's too stupid to go to
production.
___
U2-Users
] On Behalf Of Robert Houben
Sent: Wednesday, May 08, 2013 1:04 PM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
If my code isn't at least as smart as a 5th grader, it's too stupid to go to
production
-users-boun...@listserver.u2ug.org]
On Behalf Of Robert Houben
Sent: Wednesday, May 08, 2013 1:04 PM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
If my code isn't at least as smart as a 5th grader, it's too
: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
But the problem is that those 5th graders are already programming! They get
number theory (better than some of us) and they get that 12.2 is the same as
12.20. When you tell them
PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
Are you implying that I program like a fifth grader?
-Original Message-
From: Robert Houben robert.hou...@fwic.net
To: U2 Users
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
From: Wjhonson
I'm assuming that a file you want to read into a Pick system, with
embedded MM.MM dollars is coming from an outside source. I can't
recall ever seeing 12.2 used for 12.20 outside of a Pick system.
This is weird, I've seen a few discussions within the last week where
people
var = int(var * 100)
Nick Tilstra
-Original Message-
From: dale kelley [mailto:dalekel...@dalewkelleyinc.com]
Sent: Tuesday, May 07, 2013 6:06 PM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable
You can create a custom format in Excel containing a zero mask of how
ever many characters you like and that will preserve (well, actually
replace the already stripped) leading zeros.
Anthonys Lists wrote:
With our phone numbers ... we are forced to use a database that
exports to excel ...
There are a couple ways to prevent automatic numeric reformatting in
Excel:
1) Any value preceded by a single quote is not treated as a number and
is thus not reformatted. So a telephone number becomes '123-456-7890.
2) If the document is real Excel and not just CSV rendered in the
Excel
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
OPENSEQ TEMP.FILE1 to temp_file1 else
READSEQ...
WRITESEQ
CLOSESEQ...
On 7 May 2013 16:37, Sathya sathya8...@gmail.com wrote:
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,
Dennis Bartlett dqbartlett at gmail.com writes:
OPENSEQ TEMP.FILE1 to temp_file1 else
READSEQ...
WRITESEQ
CLOSESEQ...
Hi Dennis,..
Thanks a lot for your help. However let me explain my requirement.
I need to open and read a file from the server. That means a text file from
a path and
Hi back,
Here's what I usually do. I create a file record in the voc pointing to
that directory and give it D_BP as a dictionary. If that VOC record is
named TEMP.FILE; I can then open it in a program and read TEMP.FILE1 as
a record from that file. Then every flat file record is a field in
, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
Hi back,
Here's what I usually do. I create a file record in the voc pointing to
that directory and give it D_BP as a dictionary. If that VOC record is
named TEMP.FILE; I can then open it in a program and read TEMP.FILE1
Wjhonson wjhonson at aol.com writes:
Satya the OSOPEN command.. what version of the system are you running?
Hi,.
Thanks everyone for the suggestions and I have sorted out the issue. Now I
want to write some dollar values to a file. But the format in which it is
in the file is XXX.XX, but I
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya
Sent: Tuesday, May 07, 2013 1:04 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
Wjhonson wjhonson at aol.com writes:
Satya
-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya
Sent: Tuesday, May 07, 2013 10:04 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket,
HTTP,XML, SCTX , MQS, SOAP or database variable.
Wjhonson
if var is XXX.XX
ICONV(var,MD2) then OCONV(var,MD0)
Dale
On 05/07/2013 12:04 PM, Sathya wrote:
Wjhonsonwjhonsonat aol.com writes:
Satya the OSOPEN command.. what version of the system are you running?
Hi,.
Thanks everyone for the suggestions and I have sorted out the issue. Now I
want to
41 matches
Mail list logo