Re: Export/ImportSQL

[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 (v12.6?). Also,
I had to make sure I hadn't renamed any tables/fields.



On Mon, Aug 20, 2018 at 11:22 PM Pat Bensky via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 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.
>
> Anybody have any ideas about this?
>
> --
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
Nils Kollandsrud
Ixmal Intelesis AS, Pilestredet 75 C, Postboks 5130 Majorstuen, 0302 Oslo,
Norway
Tel: +47 22121212 Mob: +47 920 15550
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Export/ImportSQL

[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 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.
> 
> Anybody have any ideas about this?
> 


Later,
Guy

--
Guy Algot, Solutions Specialist
Edmonton, Alberta
(780) 974-8538

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Export/ImportSQL

[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 can't see anything consistently different or wrong within the missing
> records.
> 
> All text fields are stored within the records.
> 
> Anybody have any ideas about this?

Hell is other people 
 Jean-Paul Sartre
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Export/ImportSQL

[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 Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 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.
> 
> Anybody have any ideas about this?
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: How to show subtotals in a list box

[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 Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Dani Beaubien via 
4D_Tech
Sent: Monday, August 20, 2018 3:06 PM
To: 4D iNug Technical <4d_tech@lists.4D.com>
Cc: Dani Beaubien 
Subject: How to show subtotals in a list box

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
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How to show subtotals in a list box

[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 column to the right of the numeric column to be subtotaled, 
and put each subtotal in the last break line. As you go down the list, a zero 
or a subtotal amount could be put in each Nth cell.

Keith - CDI

> On Aug 20, 2018, at 4: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.
> 
> I am looking for suggestions on how to approach this?
> 
> Thanks in advance.
> 
> Dani Beaubien


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How to show subtotals in a list box

[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.
>
> I am looking for suggestions on how to approach this?
>
> Thanks in advance.
>
> Dani Beaubien
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Export/ImportSQL

[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.

Anybody have any ideas about this?

-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

How to show subtotals in a list box

[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
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Web Area display PDF

[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 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 no longer available"

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Web Area display PDF

[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 Mozilla's open source PDFjs renderer.

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Web Area display PDF

[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,
> 
> We are "Windows Only"
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Web Area display PDF

[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 no longer available"
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: QR REPORT DOCUMENTS folder

[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 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.

Someone can help me?

Thanks
Ferdinando


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

QR REPORT DOCUMENTS folder

[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.

Someone can help me?

Thanks
Ferdinando
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Web Area display PDF

[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:

"This item might not exist or is no longer available"

Randy Engle, Director
XC2 Software LLC – XC2LIVE!




**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Web Area display PDF

[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 application.
> 
> Luc Devar
> 
>> On Aug 20, 2018, at 8:30 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> 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
>> 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Web Area display PDF

[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 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
> 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Web Area display PDF

[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 Stadhouders via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Do you, or someone else, what is the problem with this? A solution would be 
> appreciated.

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Web Area display PDF

[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 crashes after viewing only two PDFs

Do you, or someone else, what is the problem with this? A solution would be 
appreciated.

Gr,

Piotr



there was a word on the release note.

evidently it was caused by the 32-bit version of PDFKit (Apple framework, part 
of the OS)



http://download.4d.com/Documents/Products_Documentation/LastVersions/Line_16/VIntl/4D_v16_3_ReleaseNotes.pdf



> 2018/05/15 17:10、Piotr Chabot Stadhouders via 4D_Tech 
> <4d_t...@xxx.xxx> のメール：

> We also have problems viewing PDF in a webarea with 4D 32-bit on High Sierra

> Do you know if this is a 32-bit problem?

> So going to 64-bit would solve the problem?

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**