Re: v12 - Query problem
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 4D_Tech
<4d_tech@lists.4d.com> のメール：
If I run the query editor in the 'user environment', I get 45 records,
and the above reference record with a date of 2/28/17 is (correctly)
not found.
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
Re: v12 - Query problem
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 date field for all of them. Then do the query again. If it works as expected the issue is something about the data. I bet that's going to be the thing. On Wed, Mar 1, 2017 at 2:44 PM, Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > 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 > environment' to see all records > Shows 46 records, with 1 record which has a Sent_Date value of 2/28/17 > !!! > > If I run the query editor in the 'user environment', I get 45 records, > and the above reference record with a date of 2/28/17 is (correctly) > not found. > > I have even tried re-signing the date to the date field on the one > 2/28/17 record - incase there was something "weird" no change > > I have deleted the index (both by hand, and by code) and added it back. > Flushed the buffers to insure the change to the index and data are on > disk. > I have now run MSC verify (all OK) and the compacted the datafile (just > to be sure) > > The anomalous result still persists... > Any Ideas at all? > > Thanks! > Chip > > --- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > ** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** -- Kirk Brooks San Francisco, CA === ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Can I programatically turn off multi-style on a text object in v13?
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 > > like Word docs which can introduce a lot of extraneous crap. The user was > > looking for options to control that. > > Pasting data from Word is problematic. Sometimes it works great and styles > are preserved. Other times the resulting paste is a big mess. No easy fix. > You need to get example Word documents that cause problems and then analyze > the info in the pasteboard. > > I ran into a similar problem and I had to put a button on the form called > “Paste With No Style”. This would look at the data in the pasteboard, clean > it up and remove stuff and then add it to the field. I added keyboard > shortcut of Ctrl-Shift-V to the button for convenience. > > Here’ some sample code: > > // Paste With No Style button on Case Activity Notes input form > > C_TEXT($theText_t) > C_LONGINT($start;$end) > > $theText_t:=Get text from pasteboard > $theText_t:=ST Get plain text($theText_t) > > GET HIGHLIGHT([CaseActivityNotes]Comments;$start;$end) > > If (($start=1) & ($end=1)) // at the beginning of the field >[CaseActivityNotes]Comments:=$theText_t+[CaseActivityNotes]Comments > Else // somewhere else, so put it at the end >[CaseActivityNotes]Comments:=[CaseActivityNotes]Comments+$theText_t > End if > > > Of course it also brought up issues of what happens to existing data when > > the option is toggled... > > If you have a field that has styled text stored in it, and you turn off > the Multi-style property on the form, you will just see all the span tags. > > For debugging purposes put 2 copies of the field on a form on top of each > other. Turn on the Multi-style property on one, turn it off for the other. > Set the non-Multi-style field to be “Invisible by Default". Then put an > invisible button on the form with a secret keyboard shortcut only you know. > Have the button toggle visibility of the 2 fields so that you can switch > between “normal” Multi-style viewing and “raw” viewing so you can see all > the span tags. > > This is very useful for tracking down and fixing unescaped characters like > “&”, “<“ and “>” that cause Multi-style fields to display as a big mess. > > Tim > > > Tim Nevels > Innovative Solutions > 785-749-3444 > timnev...@mac.com > > > ** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** > -- Kirk Brooks San Francisco, CA === ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
v12 - Query problem
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 environment' to see all records Shows 46 records, with 1 record which has a Sent_Date value of 2/28/17 !!! If I run the query editor in the 'user environment', I get 45 records, and the above reference record with a date of 2/28/17 is (correctly) not found. I have even tried re-signing the date to the date field on the one 2/28/17 record - incase there was something "weird" no change I have deleted the index (both by hand, and by code) and added it back. Flushed the buffers to insure the change to the index and data are on disk. I have now run MSC verify (all OK) and the compacted the datafile (just to be sure) The anomalous result still persists... Any Ideas at all? Thanks! Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Going Paperless with 4D...
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 could scrap emails and extract docs out of them... On Wed, 1 Mar 2017 at 01:14, Robert ListMail via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I’m in the process of going paperless…. is there a way to program 4D to > access my online bills, download all available statements (not already in > the local archive) and to file the applicable PDFs in a logical folder… > Thanks, > > Robert > > ** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Can I programatically turn off multi-style on a text object in v13?
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 affects display only. If you have multistyle text and you turn off the multistyle display, you see all the and similar directives: they are regarded as part of the text and so are no longer interpreted. Jeremy Jeremy Roussak j...@mac.com > On 1 Mar 2017, at 16:48, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Thanks for verifying this Jeremy. > > In this case an record entry field sometimes has data pasted in from things > like Word docs which can introduce a lot of extraneous crap. The user was > looking for options to control that. > > Of course it also brought up issues of what happens to existing data when > the option is toggled... > > > On Wed, Mar 1, 2017 at 4:29 AM, Jeremy Roussak 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. It’s a source of considerable frustration when writing >> generic listbox code. >> >> Jeremy >> >> >> Jeremy Roussak >> j...@mac.com >> >> >> >>> On 28 Feb 2017, at 20:21, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >>> >>> Title says it all. >>> >>> thanks >>> >>> -- >>> Kirk Brooks >>> San Francisco, CA >>> === >>> ** >>> 4D Internet Users Group (4D iNUG) >>> FAQ: http://lists.4d.com/faqnug.html >>> Archive: http://lists.4d.com/archives.html >>> Options: http://lists.4d.com/mailman/options/4d_tech >>> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >>> ** >> >> ** >> 4D Internet Users Group (4D iNUG) >> FAQ: http://lists.4d.com/faqnug.html >> Archive: http://lists.4d.com/archives.html >> Options: http://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >> ** > > > > > -- > Kirk Brooks > San Francisco, CA > === > ** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
[ANN] 4D World Tour 2017 Topics - USA
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: - Chicago April 3 & 4 - Boston April 6 & 7 - Raleigh April 10 & 11 - Denver May1 & 2 - Long Beach May4 & 5 - San JoseMay8 & 9 Day 1: (Free) Topics (USA): - Controlling the user experience - Informative user dashboards - Open source project integration - Facial recognition - Voice messaging - Geolocation & clustered location mapping - PDF data extraction - 4D Write Pro - Custom developer tools - Dramatic improvements of 4D v16 Day 2: (Partner Pricing: $299) State-of-the-art training (USA) will encourage you to move: - From schemaful to schemaflex data structures - From static to dynamic variables - From numbers to names - From 32-bit to 64-bit - From CALL PROCESS to CALL FORM - From process to worker - From cooperative to preemptive Plus: - Modernize and modularize your forms to create a more flexible and reusable UI ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Can I programatically turn off multi-style on a text object in v13?
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. > > Close, but not fully true, see: > http://blog.4d.com/listbox-more-programming-possibilities/ > > The first picture shows "lk multi-style" > > > > > ** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Can I programatically turn off multi-style on a text object in v13?
> 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" ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Primary key in a existant database
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 installations, so i ask if someone have done a procedure for do this. Thanks Ferdinando ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
