Hi Doug, We have been using Money fields in omnis for years. The dam for Sybase readily converts the money fields into numeric 2p schema defined list fields without any problems. (It too doews not have money field types) In the sybase dam, a money field is a 4 dp field that presents/masks as as a 2dp field; it...
These are the contents of the Omnis-Dev List, a worldwide independent developer community.
Omnis Software is kindly allowed to mirror the contents of the list server on this website.
Hi David and Dan, Both works fine. Thank you for your help. regards, xavier > El 24/4/2019, a las 17:58, David Barnett escribió: > > Try adding a ‘having’ clause after the group by clause. Possibly: > > Having sum(sign(fcomp.ar_weight))=count(*) > > That should restrict the select to only products that have the same number of components with a...
Hi, I am having problems if the field in the table is defined as type money; Omnis will not fetch it into one of it’s numeric types. Schema’s do not allow for type money; they only allow short dp, long dp’s and floats. If the table on the backend is numeric or double precision, Omnis has no problems fetching...
Hi, I am experiencing a problem when trying to fetch money fields from postgres into a list defined with this money fields as numeric 2dp. Omnis won’t convert the money values into numerics without explicitly converting them. the values come back as 0. I tried 4dp, float, short 2dp, nothing works. I think this is a bug. The sybase...
I don’t recall working on a case where the table has a column of type money in the db. Sorry I missed this info “Money Fields” in your initial email. Mayada —–Original Message—– From: omnisdev-en On Behalf Of Terence Young Sent: Wednesday, April 24, 2019 6:43 PM To: ‘OmnisDev List – English’ Subject: Re: Money Fields in postgres...
Hi Terence, We are using O$ 8.1.3. with postgresql and we don’t have any issue with fetching data from fields defined for example as numeric(18,2) in the database into Omnis var type Omnis Number Short 2pd. Check the field definition in your table and the variable definition in Omnis and make sure that both of them are defined correctly....
Hi all I have this select SELECT fart.ar_codin,sum(flin.la_cantid*fcomp.ar_weight) ar_weight FROM farticulos fart INNER JOIN flinar flin ON ( fart.ar_codin = flin.la_codinar ) INNER JOIN farticulos fcomp ON ( flin.la_codinco = fcomp.ar_codin ) where fart.ar_tipo=’C’ group by fart.ar_seq order by fart.ar_codigo This is a products file (fart ) with their weight and a link file (flin) to components file (fcomp)....
hi Terrence. I’m going on a small limb here. here’s the numeric types (money isn’t there): www.postgresql.org/docs/current/datatype-numeric.html and the monetary type is The money type stores a currency amount with a fixed fractional precision; see Table 8.3 . The fractional precision is determined by the database’s lc_monetary setting. The range shown in the table assumes there are two fractional digits....
You could do something like this SELECT fart.ar_codin,sum(flin.la_cantid*fcomp.ar_weight) ar_weight ,sum(case when fcomp.ar_weitght>0 then 0 else 1 end) weight_zero FROM farticulos fart INNER JOIN flinar flin ON ( fart.ar_codin = flin.la_codinar ) INNER JOIN farticulos fcomp ON ( flin.la_codinco = fcomp.ar_codin ) where fart.ar_tipo=’C’ group by fart.ar_seq having sum(case when fcomp.ar_weitght>0 then 0 else 1 end) = 0. — if...
I don’t think you can do that from a list Michael. You may have to use a context or popup menu. Rob > On 24 Apr 2019, at 15:14, Michael Mantkowski wrote: > > I need to disable (Grey Out) a line of the list on a PopList control. > > Can’t figure out how to do that. >...
active 1 month ago
active 1 month ago
- Registered Users
- Topic Tags
Latest Dev-List Posts
- Money Fields in postgres and Aomnis Terence Young, 04-25-2019 12:54
- SQL question IT, 04-25-2019 09:16
- Money Fields in postgres and Aomnis Terence Young, 04-24-2019 22:42
- Money Fields in postgres and Aomnis Terence Young, 04-24-2019 21:58
- Money Fields in postgres and Aomnis Mayada Al-Kishtini, 04-24-2019 19:53