Re: v12 - Query problem

2017-03-01 Thread Keisuke Miyako via 4D_Tech
but did you use the "query by formula" dialog and use [table]Sent_Date = Date("02/27/17") as the criteria? it might we worth creating a new DB with just one date field and see if the results are reproducible. then upgrade to a higher version and compare results. 2017/03/02 7:44、Chip Scheide via

Re: v12 - Query problem

2017-03-01 Thread Kirk Brooks via 4D_Tech
Chip, I'm generally a big fan of writing really lean code but in a case like this I'd put the date value into a variable first. If it still gives inconsistent results I'd do go to the user mode and call up the IP user set, the one that gives you all 46 records. Do apply to selection and set the

Re: Can I programatically turn off multi-style on a text object in v13?

2017-03-01 Thread Kirk Brooks via 4D_Tech
Tim, Thanks for the code - that's a really good option. I'll propose it. On Wed, Mar 1, 2017 at 9:39 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com > wrote: > On Mar 1, 2017, at 11:15 AM,Kirk Brooks wrote: > > > In this case an record entry field sometimes has data pasted in from > things > >

v12 - Query problem

2017-03-01 Thread Chip Scheide via 4D_Tech
I have a query being run Query([table];$Query_Field-> = Date(s_Search_Start)) $Query Field is [table]Sent_Date (a date field) s_Search_Start = "02/27/17" If I run the query (in code) the result is 46 records. In debugger Creating an interprocess set, and using the set in the 'user

Re: Going Paperless with 4D...

2017-03-01 Thread Balinder Walia via 4D_Tech
It should be possible but depends on the bill suppliers and if there online systems allow bills downloaded via APIs or not? You could use oAuth and or HTTP Get command to download bills and do whatever you wish to with them in 4D. Other way is emails - as Many suppliers email bills as PDFs so you

Re: Can I programatically turn off multi-style on a text object in v13?

2017-03-01 Thread Jeremy Roussak via 4D_Tech
Kirk, Yes, that’s an issue. I’ve also found that the stuff received from Word is highly variable. I’ve never been sufficiently motivated to write code to extract the useful stuff, I’m afraid, or I’d let you have it. As far as the toggling goes, “display multistyle” is, I think, just that: it

[ANN] 4D World Tour 2017 Topics - USA

2017-03-01 Thread Brian Young via 4D_Tech
Join us on the 2017 4D World Tour Every 4D developer will benefit from the free presentations on the latest platform advancements and inspired techniques. Register: http://events.4d.com/wt2017/ The 4D World Tour is a series of 38 events around the world. The USA offers six locations: -

Re: Can I programatically turn off multi-style on a text object in v13?

2017-03-01 Thread Jeremy Roussak via 4D_Tech
Thomas, I stand corrected. Apologies. I’ll have to upgrade to v16R2! Jeremy Jeremy Roussak j...@mac.com > On 1 Mar 2017, at 14:12, Thomas Maul via 4D_Tech <4d_tech@lists.4d.com> wrote: > >> As far as I know, you can neither turn it off nor turn it on by code in any >> version of 4D. > >

RE: Can I programatically turn off multi-style on a text object in v13?

2017-03-01 Thread Thomas Maul via 4D_Tech
> As far as I know, you can neither turn it off nor turn it on by code in any > version of 4D. Close, but not fully true, see: http://blog.4d.com/listbox-more-programming-possibilities/ The first picture shows "lk multi-style"

Primary key in a existant database

2017-03-01 Thread stardata.info via 4D_Tech
Hi All, I have done a conversion from V13 to V15 but for one table the field that was indicated like a primary key contain a duplicate values, so i must create another field unique, indexed, give a different values at this field and put this field like a primary key. This for several