Re: v13+ - injecting code into a host.

[Wayne Stewart via 4D_Tech]

Foundation stores the method text within another method.

I actually made a component to make this easier.  I'll send it to you off list.

Regards,

Wayne



On Wed, 22 Aug 2018 at 04:21, Chip Scheide via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> good idea! thanks
>
> On Tue, 21 Aug 2018 10:27:27 -0700 (MST), Patrick Emanuel via 4D_Tech
> wrote:
> > Hi,
> >
> > If you don't want that user have access to your code, in this case, save it
> > in a crypted blob.
> > Your component will have the key to read it and by the way, just your
> > component.
> >
> > In my case, I do like Dani.
> >
> > Patrick
> >
> >
> >
> > -
> > Patrick EMANUEL
> > 
> > Administrator
> > www.association-qualisoft.eu
> > (Soft1002, Simply Asso & QS_Toolbox)
> > --
> > Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> > **
> > 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
> > **
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 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
**

sql server unavailable

[Randy Jaynes via 4D_Tech]

What does it mean when a method suddenly starts getting a runtime error in a 
compiled database that says

Remote SQL Server is not available

The line number it gives is the End SQL line in the method.

The SQL code is a simple
SELECT field1, field 2 from table where (field3 = value) into var1, 
var2.

This is an older database using 4D v13.5, but the code has been running for a 
couple years and this is the first report of this issue.

Is it possible network department started blocking ports on their firewall, or 
just another  random SQL Server issue in 4D?

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.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: Export/ImportSQL

[Pat Bensky via 4D_Tech]

Thanks y'all.
I updated the database to v17 to both export and import the data - this was
even worse!
So ... Chip ... yes please!

Thanks

Pat

On Tue, 21 Aug 2018 at 06:44, Nils Kollandsrud via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 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
> **



-- 
*
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
**

Re: v13+ - injecting code into a host.

[Chip Scheide via 4D_Tech]

good idea! thanks

On Tue, 21 Aug 2018 10:27:27 -0700 (MST), Patrick Emanuel via 4D_Tech 
wrote:
> Hi,
> 
> If you don't want that user have access to your code, in this case, save it
> in a crypted blob.
> Your component will have the key to read it and by the way, just your
> component.
> 
> In my case, I do like Dani.
> 
> Patrick 
> 
> 
> 
> -
> Patrick EMANUEL
> 
> Administrator
> www.association-qualisoft.eu 
> (Soft1002, Simply Asso & QS_Toolbox)
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: v13+ - injecting code into a host.

[Dani Beaubien via 4D_Tech]

Perhaps put it in the Resources of the Component. Makes it a bit more hidden. 

The alternative is to have it saved someplace entirely. But then that makes the 
auto updating of the files a bit more challenging.

Dani


> On Aug 21, 2018, at 10:44 AM, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> Thanks
> 
> that is basically what i was in the process of doing.
> a method to run in 'On Shut Down', which (when the component is not 
> compiled) gets the code of the method, and writes to a text file - but 
> in the database folder of the component.
> 
> The resource folder gets shared to clients, and there is no reason for 
> a client to have this source code.
> Chip
> 
> On Tue, 21 Aug 2018 10:38:05 -0600, Dani Beaubien wrote:
>> I have had to do this. I store a copy of the methods I need in a 
>> folder in the Resources folder.
>> 
>> Only downside is that the code is outside of the structure so the 
>> maintenance is a bit more effort. You could add a bit of code to the 
>> On Exit method on the component that updates the copy of the method 
>> on disk from the method in 4D. That helps to make maintenance a bit 
>> easier. 
>> 
>> Dani
>> 
>> 
>>> On Aug 21, 2018, at 10:23 AM, Chip Scheide via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> I have written code which injects (creates) needed methods in a host 
>>> database.
>>> The code for injecting works interpretedly, I was just testing the 
>>> component compiled, and ran into an error. I am getting the code of a 
>>> method in the component, and then injecting it into the host.
>>> METHOD GET CODE("Methodname";$Text)
>>> METHOD SET CODE("Methodname";$Text;*)
>>> 
>>> And of course, once the component is compiled, I can no longer GET the 
>>> method's code (duh!).
>>> 
>>> So, anyone who is doing this, how are you going about storing the code 
>>> to inject?
>>> - written to a text file?
>>> - in a data file --problematic for a component
>>> - ???
>>> 
>>> Thanks
>>> 
>>> ---
>>> Gas is for washing parts
>>> Alcohol is for drinkin'
>>> Nitromethane is for racing 
>>> **
>>> 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
>>> **
>> 
>> 
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 

**
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: v13+ - injecting code into a host.

[Chip Scheide via 4D_Tech]

Thanks

that is basically what i was in the process of doing.
a method to run in 'On Shut Down', which (when the component is not 
compiled) gets the code of the method, and writes to a text file - but 
in the database folder of the component.

The resource folder gets shared to clients, and there is no reason for 
a client to have this source code.
Chip

On Tue, 21 Aug 2018 10:38:05 -0600, Dani Beaubien wrote:
> I have had to do this. I store a copy of the methods I need in a 
> folder in the Resources folder.
> 
> Only downside is that the code is outside of the structure so the 
> maintenance is a bit more effort. You could add a bit of code to the 
> On Exit method on the component that updates the copy of the method 
> on disk from the method in 4D. That helps to make maintenance a bit 
> easier. 
> 
> Dani
> 
> 
>> On Aug 21, 2018, at 10:23 AM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I have written code which injects (creates) needed methods in a host 
>> database.
>> The code for injecting works interpretedly, I was just testing the 
>> component compiled, and ran into an error. I am getting the code of a 
>> method in the component, and then injecting it into the host.
>> METHOD GET CODE("Methodname";$Text)
>> METHOD SET CODE("Methodname";$Text;*)
>> 
>> And of course, once the component is compiled, I can no longer GET the 
>> method's code (duh!).
>> 
>> So, anyone who is doing this, how are you going about storing the code 
>> to inject?
>> - written to a text file?
>> - in a data file --problematic for a component
>> - ???
>> 
>> Thanks
>> 
>> ---
>> Gas is for washing parts
>> Alcohol is for drinkin'
>> Nitromethane is for racing 
>> **
>> 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
>> **
> 
> 
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: v13+ - injecting code into a host.

[Dani Beaubien via 4D_Tech]

I have had to do this. I store a copy of the methods I need in a folder in the 
Resources folder.

Only downside is that the code is outside of the structure so the maintenance 
is a bit more effort. You could add a bit of code to the On Exit method on the 
component that updates the copy of the method on disk from the method in 4D. 
That helps to make maintenance a bit easier. 

Dani


> On Aug 21, 2018, at 10:23 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have written code which injects (creates) needed methods in a host 
> database.
> The code for injecting works interpretedly, I was just testing the 
> component compiled, and ran into an error. I am getting the code of a 
> method in the component, and then injecting it into the host.
> METHOD GET CODE("Methodname";$Text)
> METHOD SET CODE("Methodname";$Text;*)
> 
> And of course, once the component is compiled, I can no longer GET the 
> method's code (duh!).
> 
> So, anyone who is doing this, how are you going about storing the code 
> to inject?
> - written to a text file?
> - in a data file --problematic for a component
> - ???
> 
> Thanks
> 
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 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
**

v13+ - injecting code into a host.

[Chip Scheide via 4D_Tech]

I have written code which injects (creates) needed methods in a host 
database.
The code for injecting works interpretedly, I was just testing the 
component compiled, and ran into an error. I am getting the code of a 
method in the component, and then injecting it into the host.
METHOD GET CODE("Methodname";$Text)
METHOD SET CODE("Methodname";$Text;*)

And of course, once the component is compiled, I can no longer GET the 
method's code (duh!).

So, anyone who is doing this, how are you going about storing the code 
to inject?
- written to a text file?
- in a data file --problematic for a component
- ???

Thanks

---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: Query for null/empty UUID

[Epperlein, Lutz (agendo) via 4D_Tech]

Found that:


> Subject: Query for null/empty UUID
> 
> What's the best way to query for a null/blank UUID () ?
**
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: Query for null/empty UUID

[Tai Bui via 4D_Tech]

Hi,

Not sure if these are the Best Solutions, but there are two Tech Tips regarding 
this topic:

Find and fix all Blank or Null UUID fields in an entire database:
http://kb.4d.com/assetid=77576

A utility method that tests for a NIL UUID
http://kb.4d.com/assetid=77266

Hopefully this helps.

Best Regards,
-Tai B.



**
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
**

Query for null/empty UUID

[Jeffrey Kain via 4D_Tech]

What's the best way to query for a null/blank UUID () ?
**
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

[Patrick Emanuel via 4D_Tech]

Thanks a lot.

Patrick



-
Patrick EMANUEL

Administrator
www.association-qualisoft.eu 
(Soft1002, Simply Asso & QS_Toolbox)
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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 Jeff,

Thanks for sharing!

> -Oorspronkelijk bericht-
> Van: Jeffrey Kain 
> Verzonden: maandag 20 augustus 2018 19:20
> Aan: 4d_tech@lists.4d.com
> Onderwerp: Re: Web Area display PDF
> 
> 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
**

pdfCreator problem

[Keith Goebel via 4D_Tech]

Hi all.
We have suddenly struck a problem with pdfCreator v1.7.2 not working when using 
a built 4D Client via Remote Desktop Connection access.
It used to work, but started giving problems about a month ago (that's when we 
first detected it).

pdfCreator works just fine when the 4D Client is accessed via Ericom and the 
Chrome browser, but not when accessed via Remote Desktop Connection.
In the latter case, the problem manifests itself when the document that 
pdfCreator is told to create in the Temp folder in the User folder doesn't 
happen, and an error is then generated when the code tries to access it. The 
error can be trapped but the document is needed.
It is not a user permissions problem because the code can write csv files to 
the same folder.

It happens for both 4D v15.2 and v17.0 HF1. 
The computer is a cloud server VM running OS is Windows Server 2008 R2 
Datacenter / Service Pack 1.

Has anyone come across this or something like it?
Thanks, Keith
**
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
**