Field not changing type

Jeanne Reyes bornfree11 at gmail.com
Thu Nov 15 15:59:24 EST 2018 

Yes, sorry about that.   I'm using Studio 6.0 running on citrix equivalent
to windows 10
I'm using the native studio database.

------------

> Date: Thu, 15 Nov 2018 09:28:41 +1030
> From: Mike Rowan <michael.rowan3 at gmail.com>
> To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
> Subject: Re: Field not changing type
> Message-ID: <71D5F5E0-EE74-4FBF-BC4D-AF055C5002DC at gmail.com>
> Content-Type: text/plain;       charset=utf-8
>
> Hi Jeanne
>
> We?ll need to know the operating system version and the Omnis version and
> how the data is being recorded (Omnis native database or a SQL database).
>
> Mike
>
> > On 15 Nov 2018, at 8:34 am, Jeanne Reyes <bornfree11 at gmail.com> wrote:
> >
> > Is there a reason why an indexed 32 bit integer will not change to
> text?  I
> > recently had the need to include letters as part of a code that was
> > previously just numbers, however, while the file now states character 20,
> > the field does not actually convert.  The field in the windows keep
> saying
> > 32 bits, and if I try to include a letter it evaluates as Zero.
> >
> > I have reorganized the data, drop indexes, etc.  the file say CH 20, the
> > field on windows keeps the 32 bits.
> >
> > I'm puzzled.  Any insights?
> >
> > Jeanne
> >
> > --
> > <a href="http://www.upromise.com/guest/2653678835">Shop online through
> this
> > link to help me pay for college!</a>
> > _____________________________________________________________
> > Manage your list subscriptions at http://lists.omnis-dev.com
> > Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
>
>
> ------------------------------
>
> Message: 12
> Date: Thu, 15 Nov 2018 10:26:57 +1100
> From: Bastiaan Olij <Bastiaan.Olij at instinctsystems.com.au>
> To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
> Subject: Re: Saving Documents in PG vs File system
> Message-ID: <343606704-10394 at mail.instinctsystems.com.au>
> Content-Type: text/plain; charset="utf-8"
>
> Hey Mike,
>
>
> The approach we took is going down the WebDAV route. We wrote our own
> WebDAV server that queries our database for the meta data but then saves
> the actual files on disk. This ensures that users can't suddenly start
> moving files around and when things change in our database the WebDAV
> server magically gets updated.?
>
>
> Now WebDAV is a bit of a conundrum, you can mount WebDAV servers as drives
> to give users direct access through the OS but support for this is
> dwindling. Apple Finder gets completely overloaded when you have large
> repositories (not really a WebDAV issue, also happens on normal file
> servers) and Microsoft was once a WebDAV stronghold but now has some weird
> 250 character maximum path length issue and limits the file size of WebDAV
> stored files to 500Mb due to security issues they had with publicly
> available WebDAV servers.
> The WebDAV framework we've build our solution on (http://sabre.io) has a
> web interface that does a good job for access outside of our application so
> we rarely use the mount option. Yes it's PHP based but it's incredibly easy
> to build your own backend solution into this. It's really a joy to work
> with.
>
>
> I'm simplifying but in broad strokes we expose a directory structure to
> the user that is totally virtual. So the user will see a list of folders,
> one for each client, go into a clients folder and we see a list of folders
> for the clients jobs, and inside of that folder sees the files they have
> uploaded for that job. That folder structure does not exist, we are
> creating it from the actual clients and jobs in our database. There is a
> table joined to our jobs table that contains the meta data for the files
> such as the name, location on disk, etc.
>
>
> Say you do mount the WebDAV as a drive in your OS you will see this as a
> network drive with all the folders and stuff. When you copy a file in what
> happens on the background is that this becomes and HTTP upload of the file,
> our web server than moves that file into a nice location we manage and
> creates a new entry in our database so we know where the file is stored.
> The folder structure on the actual server can be anything.
>
> >From within Omnis we use HTTP directly to communicate with the WebDAV
> server. We had to write our own XComp because in Studio 4 days Omnis didn't
> have the support but I think in Studio 8 the new HTTP workers have all the
> needed enhancements as they are similar to the improvements needed for
> REST.?
>
> Kindest Regards,
>
>
> Bastiaan Olij
> Head of development - Instinct Systems: The JobBag People
> Ground Floor, 48 Chandos Street
> St Leonards NSW 2065
> Australia
>
>
> Phone +61 2 8115 8000
> Mobile +61 4 321 44833
> bastiaan.olij at instinctsystems.com.au
> http://www.jobbag.com
>
>
>
>  From:   Michael Matthews via omnisdev-en <omnisdev-en at lists.omnis-dev.com>
>
>  To:   OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
>  Cc:   Michael Matthews <omnis at lineal.co.uk>
>  Sent:   11/15/2018 2:25 AM
>  Subject:   Saving Documents in PG vs File system
>
> Hello All,
>
> A question for those of you who store documents in your Omnis system. ?We
> currently do, and we have a separate DB for the storage, and keep the
> metadata in the main database.
>
> However, in certain cases, the PG database size is now over 100gb when
> exported. ?And 99% of that data is static, so a waste of time in backing it
> up etc every day.
>
> 1 ? ? I could split the database into 2 parts as well, 1 for new items,
> which will periodically move items to the 2nd archive database.
>
> 2 ? ? But I want to explore storing the files in the file system, and
> passing them to the user when asked for. ?Can PostGres save files locally,
> and then read team and send them back to a user within a SQL call?
>
> 3 ? ? I also remember Marten Verhoven showing how he uses Symbolic links
> to files that would normally be hidden AND inaccessible unless given.
>
> So what do others do at this point with numbers of docs exceeding 100Gb
> now?
>
> Thank you
>
> Mike
>
> ????????? <http://www.lineal.co.uk/> ? ? ? ?
>
>  <https://twitter.com/linealsoftware> ?<
> https://www.facebook.com/linealsoftware?fref=ts&ref=br_tf> ?<
> https://plus.google.com/112982815000763473226/about> ?<
> https://www.linkedin.com/company/1859834?trk=tyah&trkInfo=clickedVertical%3Acompany%2Cidx%3A1-1-1%2CtarId%3A1437729256906%2Ctas%3Alineal%20s>
> ? ? ? ? ?
> Mike Matthews
> omnis at lineal.co.uk <mailto:omnis at lineal.co.uk>
> Lineal Software Solutions
> 01271 375999
> Commercial House, The Strand
> Barnstaple, Devon, EX31 1EU
> www.lineal.co.uk <http://www.lineal.co.uk/>
>
>  <http://www.lineal.co.uk/windows-support/> ?<
> http://www.lineal.co.uk/microsoft-office-365/> ?<
> http://www.lineal.co.uk/wifi-networks/> ?<
> http://www.lineal.co.uk/wifi-networks/> ?<
> http://www.lineal.co.uk/it-systems/> ?<
> http://www.lineal.co.uk/gamma-horizon-voip/> ?<
> http://www.lineal.co.uk/kerio/> ?<
> http://www.lineal.co.uk/apple-upgrades-repairs/> ?<
> http://www.lineal.co.uk/eset-security-software/> ?<
> http://www.lineal.co.uk/shoretel/>
>
>
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
>
> ------------------------------
>
> Message: 13
> Date: Wed, 14 Nov 2018 17:11:36 -0800
> From: Michael Houlberg <michael at houlbergdevelopment.com>
> To: Omnis List <omnisdev-en at lists.omnis-dev.com>
> Subject: Re: O$ interface with Credit Card machine
> Message-ID:
>         <197B9DAD-BFE4-48D4-9771-812AC2CDD172 at houlbergdevelopment.com>
> Content-Type: text/plain;       charset=utf-8
>
> Thanks to all who responded.
>
> It turns out that the problem I was having was not something related to
> the credit card terminal, it was a mismatch with an assumption built into
> the Omnis HTTPGet function.
>
> I need to pass a parameter to the device which is actually an encoded
> command string to the program running inside the device.  It?s packaged as
> a single logical packet which is to be passed as a parameter to the GET
> command.  The Omnis HTTPGet command is configured to pass parameters as
> attribute/values pairs.  The Omnis HTTPGet uses a list to pass these, and
> even if I just put my command string in the first column of the list and
> leave the other column blank, it sticks the ?=? on the end of it, messing
> it up.  So I found this worked where ivIP is the IP number of the device
> and ivPort has the specific port for it, and lEncoded is my encoded command
> string to pass to the device.
>
> HTTPOpen (ivIP,ivPort) Returns lSocket
> If lSocket>0
>         Begin text block
>         Text: {GET /?[lEncoded] HTTP/1.1} (Carriage return,Linefeed)
>         Text: {HOST: [ivIP]:[ivPort]} (Carriage return,Linefeed)
>         End text block
>         Get text block ivCommandText
>         HTTPSend (lSocket,ivCommandText) Returns lByteCount
> End If
>
> Hope that helps someone else too.
>
> Michael Houlberg
> Houlberg Development, LLC
>
> > On Nov 12, 2018, at 1:30 AM, Phil (OmnisList) via omnisdev-en <
> omnisdev-en at lists.omnis-dev.com> wrote:
> >
> > Something like this maybe:
> >
> > Do llCGIlist.$define()
> > Do llCGIlist.$cols.$add('attribute',kCharacter,kSimplechar,30)
> > Do llCGIlist.$cols.$add('value',kCharacter,kSimplechar,30)
> >
> > ...Add values to list..
> >
> > HTTPGet (ccWebserver,con(ccWebPath,ccLatestVersion),llCGIlist) Returns
> lnSocket
> > If lnSocket<0
> >     Do code method ccError/ErrorHandler (lnSocket)
> >     Quit method
> > End If
> > HTTPRead (lnSocket,lcResult) Returns lnCounter
> > HTTPClose (lnSocket)
> >
> > regards
> > Phil Potter
> > Based in Chester in the UK.
> >
> > On 10/11/2018 00:54, Michael Houlberg wrote:
> >> I?m trying to communicate with a credit card machine.  This one is made
> by PAX, but my problem isn?t necessarily bound to any particular
> manufacturer.  My problem is how to correctly use the HTTPGet command in
> Omnis.
> >>
> >> The way you talk to this machine is via HTTP using GET on the local
> area network.  The manual makes it look easy enough.  For instance to
> initialize the device they show this example:
> >>
> >> Assume the destination of Terminal ?IP: Port? is ?192.168.2.100:10009?.
> [02] as STX, [03] as ETX, [1c] as field separator.
> >> 3.3.2.1. Initialize (A00) (A01)
> >> http://192.168.2.100:10009?AkEwMBwxLjI4A0s=
> >> Message before base64 encoded:
> http://192.168.2.100:10009?[02]A00[1c]1.28[03]K
> >>
> >> What?s going on here, is the actual content you are sending are the
> strings ?A00? and ?1.28?.  It uses control characters shown in HEX to mark
> the start (02), a field separators (1c), and the end (03).  The ?K? on the
> end is a check character, and I?ve figured out how to generate that.  I
> have the part working where I use the Omnis functions bintobase64() and
> utf8tochar() to translate the message to base 64 including the check
> character then turn it into the string ?AkEwMBwxLjI4A0s=? as shown in the
> example, so I think that part is right.
> >>
> >> If I type the above http string into a browser, it returns a good
> response.  But how do I format that for the Omnis HTTPGet?
> >>
> >> HTTPGet (host,uri[,cgilist,hdrlist,service|port,secure {Default
> kFalse},verify {Default kTrue},map+ {Default kFalse}]) Returns socket
> >>
> >> HTTPGet wants a uri, but there really isn?t one here.  And then it
> wants to send any parameters as part of a cgilist.  How do I translate "
> http://192.168.2.100:10009?AkEwMBwxLjI4A0s=? into Omnis HTTPGet?
> >>
> >> Thanks,
> >> Michael Houlberg
> >> Houlberg Development, LLC
> >> _____________________________________________________________
> >> Manage your list subscriptions at http://lists.omnis-dev.com
> >> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> > _____________________________________________________________
> > Manage your list subscriptions at http://lists.omnis-dev.com
> > Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
>
>
> ------------------------------
>
> Message: 14
> Date: Thu, 15 Nov 2018 07:47:18 +0100
> From: "Marc De Roover" <omnis1 at arcict.com>
> To: "OmnisDev List - English" <omnisdev-en at lists.omnis-dev.com>
> Subject: Re: Saving Documents in PG vs File system
> Message-ID: <698601E1-7304-46E6-BF0D-1F8D6A54A39D at arcict.com>
> Content-Type: text/plain; charset=utf-8
>
> Dear Mike,
>
> I?m loosing you in threads ;-)
>
> Allow me to draw your attention to the last 2 lines of every post.
>
> Especially **> Start a new message -> mailto:
> omnisdev-en at lists.omnis-dev.com**
>
> Simple effective and I won?t loose you again . . .
>
> Cheers,
>
> Marc
>
> On 14 Nov 2018, at 16:25, Michael Matthews via omnisdev-en wrote:
>
> > _____________________________________________________________
> > Manage your list subscriptions at http://lists.omnis-dev.com
> > Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>
>
> ------------------------------
>
> End of omnisdev-en Digest, Vol 16, Issue 13
> *******************************************
>


-- 
<a href="http://www.upromise.com/guest/2653678835">Shop online through this
link to help me pay for college!</a>

More information about the omnisdev-en mailing list