Re: Export/ImportSQL

2018-08-20 Thread Nils Kollandsrud via 4D_Tech
Hi Pat, I started using Export/import sql to compact/move data between versions since v12, and I remember having issues with certain versions of v12 when the exported fields contained single-quotes in that they were not escaped correctly. If I remember correctly, it was fixed in late v12 versions

Re: Export/ImportSQL

2018-08-20 Thread Guy Algot via 4D_Tech
Pat, There is a bug with dates when importing using SQL in v12. I don’t know if it has been addressed in v16 but check that you don’t have years that have 5 digits. > On Aug 20, 2018, at 5:22 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm exporting data from a v12

Re: Export/ImportSQL

2018-08-20 Thread Chip Scheide via 4D_Tech
Pat, I have 4D native code that can do this task for you. if you need ti let me know can get it to you tomorrow Chip > I'm exporting data from a v12 database using EXPORT SQL and importing it > into a v16 database. > For the most part this works OK, but in some tables, records are missing. > I

Re: Export/ImportSQL

2018-08-20 Thread Chuck Miller via 4D_Tech
Hi pat I have out code to clone data in v11 at one of summits. If you install that code it should get all data for you. I am in Alaska on vacation so can not get I for you till I return. Please advise if you have it. Regards Chuck Sent from my iPhone > On Aug 20, 2018, at 1:22 PM, Pat

RE: How to show subtotals in a list box

2018-08-20 Thread lists via 4D_Tech
Hi Dani, Take a look at hierarchical list box. The idea is to insert a line at the end of each break and present the subtotal there. You could also present the subtotal in the top line, allowing the user to suppress or show the details under that group. Cheers, Lahav -Original

Re: How to show subtotals in a list box

2018-08-20 Thread Keith Culotta via 4D_Tech
Starting at the top and working down an array based listbox: A column could be "manually" subtotaled by inserting rows at the break points of a sorted column. These rows would need a marker in an invisible column so they could be deleted in the next sort or selection change. Or add a numeric

Re: How to show subtotals in a list box

2018-08-20 Thread Kirk Brooks via 4D_Tech
Dani, I am interested to know how you resolve this one. On Mon, Aug 20, 2018 at 2:05 PM Dani Beaubien via 4D_Tech < 4d_tech@lists.4d.com> wrote: > My situation is that I have a list box that has 1 level of break rows and > I have been asked to add a subtotal of the rows within each break level.

Export/ImportSQL

2018-08-20 Thread Pat Bensky via 4D_Tech
I'm exporting data from a v12 database using EXPORT SQL and importing it into a v16 database. For the most part this works OK, but in some tables, records are missing. I can't see anything consistently different or wrong within the missing records. All text fields are stored within the records.

How to show subtotals in a list box

2018-08-20 Thread Dani Beaubien via 4D_Tech
My situation is that I have a list box that has 1 level of break rows and I have been asked to add a subtotal of the rows within each break level. I am looking for suggestions on how to approach this? Thanks in advance. Dani Beaubien

Re: Web Area display PDF

2018-08-20 Thread Jeffrey Kain via 4D_Tech
No problem - I thought that was an error message from the demo until someone else reported it... :) > On Aug 20, 2018, at 12:54 PM, Jeffrey Kain wrote: > > Mac or Windows? > > I've only gotten this to work on Mac so far, even though the requirements for > PDFjs indicate it should work on

Re: Web Area display PDF

2018-08-20 Thread Jeffrey Kain via 4D_Tech
Sorry - looks like the link I posted earlier had expired. Try this one: https://1drv.ms/u/s!Akpn2ti2N9ePuRF0W74wLMHsvfzb > On Aug 20, 2018, at 8:30 AM, Jeffrey Kain wrote: > > I have a component that you can drop into any database - 32-bit or 64-bit - > that will render PDFs using

Re: Web Area display PDF

2018-08-20 Thread Jeffrey Kain via 4D_Tech
I wasn’t able to get it working in Windows. It seems really close though. But the IE rendering engine is so ancient. It ought to work fine on 4D Windows 64-bit with a Blink web area, but haven’t tried it yet. > On Aug 20, 2018, at 1:13 PM, Randy Engle <4d.l...@xc2.us> wrote: > > Jeff, >

Re: Web Area display PDF

2018-08-20 Thread Jeffrey Kain via 4D_Tech
Mac or Windows? I've only gotten this to work on Mac so far, even though the requirements for PDFjs indicate it should work on Microsoft's web engine. > On Aug 20, 2018, at 10:55 AM, Randy Engle <4d.l...@xc2.us> wrote: > > However, I'm getting a message: > > "This item might not exist or is

Re: QR REPORT DOCUMENTS folder

2018-08-20 Thread stardata.info via 4D_Tech
Solved... In V16 must be in dtabase folder... in others 4D Versions the locations is not the same Thanks Ferdinando Il 20/08/2018 18:11, stardata.info ha scritto: Hi All, I use the command: QR REPORT for print a myreport.4qr report. For a compiled application i need to know the

QR REPORT DOCUMENTS folder

2018-08-20 Thread stardata.info via 4D_Tech
Hi All, I use the command: QR REPORT for print a myreport.4qr report. For a compiled application i need to know the folder to put myreport .4qr document I try to put the quick report document in : C:\Users\User\AppData\Roaming\MY4dAPP\MY4dAPP.4DC But the command not find the .4QR document.

RE: Web Area display PDF

2018-08-20 Thread Randy Engle via 4D_Tech
Hi Jeff, Thanks for posting this Sounds great! >> I have a component that you can drop into any database - 32-bit or 64-bit - >> that will render PDFs using Mozilla's open source PDFjs renderer. >> >> https://1drv.ms/u/s!Akpn2ti2N9ePuQFPa0jiG91YjE2z However, I'm getting a message:

Re: Web Area display PDF

2018-08-20 Thread Jeffrey Kain via 4D_Tech
I don't mind at all - glad you find it useful. > On Aug 20, 2018, at 9:47 AM, Luc Devar wrote: > > Jeffrey, > > If you do not mind, I will certainly use this in conjuncture with QPDF > Plugins for one of my projects. > A neat component I must say and it will add a nice touch to the

Re: Web Area display PDF

2018-08-20 Thread Luc Devar via 4D_Tech
Jeffrey, If you do not mind, I will certainly use this in conjuncture with QPDF Plugins for one of my projects. A neat component I must say and it will add a nice touch to the application. Luc Devar > On Aug 20, 2018, at 8:30 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I

Re: Web Area display PDF

2018-08-20 Thread Jeffrey Kain via 4D_Tech
I have a component that you can drop into any database - 32-bit or 64-bit - that will render PDFs using Mozilla's open source PDFjs renderer. https://1drv.ms/u/s!Akpn2ti2N9ePuQFPa0jiG91YjE2z -- Jeffrey Kain jeffrey.k...@gmail.com > On Aug 20, 2018, at 8:16 AM, Piotr Chabot

Re: Web Area display PDF

2018-08-20 Thread Piotr Chabot Stadhouders via 4D_Tech
Hi Miyako, About 3 months ago there was a discussion about viewing PDFs in a webarea on High Sierra Then it was the believe that when using this in 4D 64-bit the problem was solved However, now we are testing 64-bit for the first time, and when viewing a PDF in a webarea on High Sierra it