Paul Ringsmuth | 1 Aug 2011 01:58
Favicon

Re: Dual Boot Lion for 4D test platform help

John, I found the following information pertaining to Snow Leopard at Apple Support Communities. Perhaps
something similar would work on Lion. 

"Doing a so-called 'clean' install means installing Snow Leopard from scratch on a freshly formatted
drive; in this case your SSD. I would assume your data, i.e., your Home folder would be put on the hard drive
rather than on the SSD to save disk space. That means you must configure OS X to use a Home folder located on
another drive other than the startup drive. This done in Accounts preferences. As for Applications, etc.
they can be installed on the hard drive rather than the SSD, then create an alias to the folder and put the
alias in place of the real Applications folder."

Best Regards,
Paul Ringsmuth

On Jul 31, 2011, at 4:08 PM, John Baughman wrote:

> I am trying to create a dual boot for lion on an SSD I installed in my MacBook Pro's optical drive slot. My
intention is to use it as my test platform for 4D until we I am confident that v12 is compatible.
> 
> I have tried twice to install lion on the SSD and both times I ran into what I think are permission issues. The
problem is that my SSD is only 120GBs  so I had to pair my user folder down considerably and let the migration
assistant only migrate my user folder and settings. So 4D and all the database is on the internal hard drive
and Lion is on the SSD. 
> 
> Here is a chronology of the problems I ran into.
> 
> 1. When I tried to open a v12.2 database 4D said that it could not save the 4D folder. So I added Me and admin to
Sharing & Permissions in Get Info on the Library folder 
> 
> 2. Tried 4D again, this time I did not get the 4D folder error and was able to get into 4D, but Canvas and QPix
threw  invalid license errors, and I could not get to the Design environment. There is still no 4D folder in
(Continue reading)

Jeremy Roussak | 1 Aug 2011 09:03
Picon

Re: A little bit of styled text

Yes. Depending on what selector I use when retrieving the data from the clipboard, I get nothing, the
unstyled text or a vast quantity of style definitions with a few bytes of text buried (I think) somewhere in it.

Jeremy Roussak
jbr@...

On 31 Jul 2011, at 17:23, Ben Kershaw wrote:

> Jeremy Roussak wrote:
> 
>> What's the easiest and simplest way in v12.2 to put a line of styled text on the
>> clipboard (it only needs to work on a Mac) without using Write?
> 
> Have you tried copying styled text in Word and then reading it from 4D to see how it should be formatted?
> 
> Regards,
> Ben Kershaw
> 
> **********************************************************************
> 4D v12.2 is Available - Now Powered with 64-bit server
> http://www.4d.com/products/new.html
> 
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> **********************************************************************

**********************************************************************
(Continue reading)

stardata.info | 1 Aug 2011 10:25

Default database in 4D Client

Hello,

I installed two 4D Server database on one server.
With 4D Client want to set a default database.
With tcp.opt I can do it. Where do I copy tcp.opt?

Ferdinando
**********************************************************************
4D v12.2 is Available - Now Powered with 64-bit server 
http://www.4d.com/products/new.html

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

Pierre Leblanc | 1 Aug 2011 10:48

Re: A little bit of styled text


On Aug 1, 2011, at 9:03 AM, Jeremy Roussak wrote:

> Yes. Depending on what selector I use when retrieving the data from the clipboard, I get nothing, the
unstyled text or a vast quantity of style definitions with a few bytes of text buried (I think) somewhere in it.
> 

Have you considered html ?
What I'd try is :
Build some html like "Hello <b>world</b>"
Put it in a blob and append it to the pasteboard (append data to pasteboard) using "public.html" in macOs or
just "HTML" in windows.

Just a guess.

Pierre Leblanc.**********************************************************************
4D v12.2 is Available - Now Powered with 64-bit server 
http://www.4d.com/products/new.html

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

Keisuke Miyako | 1 Aug 2011 11:08

Re: Dropping a Table in V12

If I may extend on Josh's comment;

in general, Begin/End SQL with EXECUTE IMMEDIATE offers the easiest way to implement dynamic SQL.
one catch is that you can't embed local variables in the statement when compiled,
but otherwise it's a very powerful command.

yet, from a technical perspective,
SQL EXECUTE (the former native ODBC commands)
tends offer a superior solution.

first, you protect your code against injection.

with either command, the table names etc. are managed by string concatenation,
but normally you don't depend on user input for that piece of information so that's fine.

but suppose you let the user supply values to the WHERE clause,
well, a malicious use may deliberately include a semicolon in the value and start a new line of SQL code.

that can cause serious harm with Begin/End SQL.

with SQL EXECUTE you don't have to construct by string concatenation,
you have the option to use place holders ( ? ) and parameters instead,
which lets you guard the code from such attacks.

second, you have control over the result data set size.

using Begin/End SQL,
you could potentially end up creating an array with millions of elements.
which might have negative impact on performance.

(Continue reading)

Keisuke Miyako | 1 Aug 2011 11:14

Re: Copy Text From Non-enterable Variable

I think the magic combination is.

enterable + focusable.

note that focusable and "hide focus ring" refers to different aspects of the object.
focusable means that object will take away the focus from the current focus object.

for example, if a text object is being focused,
and a focusable button is clicked,
the text object will lose it focus and the On Losing Focus event will fire.
this is true even if "hide focus ring" is enabled.

in contrast, if a non-focusable button is clicked,
the text object will retain its focus and the event will not fire.

in both instances the button does not have a focus ring,
but the outcomes are different.

miyako

On 2011/07/31, at 6:56, Cannon Smith wrote:

> I just gave it a try, but it doesn't work. When Enterable is deselected,
> Tabable doesn't show up.

**********************************************************************
4D v12.2 is Available - Now Powered with 64-bit server 
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
(Continue reading)

Milan Adamov | 1 Aug 2011 12:50
Picon
Gravatar

Re: Dual Boot Lion for 4D test platform help

Hi John,

first, you don't need to copy everything, just point the either Lion or Snow Leopard to your old home folder
using advanced option in Account system preferences preference pane (unlock the account pane,
right-click on the user and choose the path to your old home folder, then reboot). However, you have to be
careful not to run Mail (if you have POP accounts, if you have IMAP you can always delete the account and
recreate it in "other" system), iCal or AddressBook in Lion if you intend to continue using them in Snow
Leopard, Lion might convert their files making them unusable in older system.

Please find some answers below:
On 31.07.2011., at 23.08, John Baughman wrote:

> I am trying to create a dual boot for lion on an SSD I installed in my MacBook Pro's optical drive slot. My
intention is to use it as my test platform for 4D until we I am confident that v12 is compatible.
> 
> I have tried twice to install lion on the SSD and both times I ran into what I think are permission issues. The
problem is that my SSD is only 120GBs  so I had to pair my user folder down considerably and let the migration
assistant only migrate my user folder and settings. So 4D and all the database is on the internal hard drive
and Lion is on the SSD. 
> 

If 4D and the databases are within home folder and you still have permission issues, keep in mind that even of
you have user "john" under both systems, that is not the same "john" for Lion install as the "john" from Snow
Leo install. So you have to give proper permissions to both "johns" under Lion. Maybe it would be better to
create user with shortname other than "john" on Lion, that way you can see for which folder your user
doesn't have correct permissions.

> Here is a chronology of the problems I ran into.
> 
> 1. When I tried to open a v12.2 database 4D said that it could not save the 4D folder. So I added Me and admin to
(Continue reading)

Cannon Smith | 1 Aug 2011 14:29

Re: Copy Text From Non-enterable Variable

Stephen J. Orth wrote:
>
>  When you deselect "Enterable" is there a "Focusable" checkbox?
>
>  What about selecting that?

I just realized that I only replied privately to Steve's last 
suggestion. For the record, this suggestion works.

Thanks again, Steve.

--

-- 
Cannon Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236
<cannon@...>
<www.synergyfarmsolutions.com>

**********************************************************************
4D v12.2 is Available - Now Powered with 64-bit server 
http://www.4d.com/products/new.html

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

(Continue reading)

Cannon Smith | 1 Aug 2011 14:39

Re: Copy Text From Non-enterable Variable

Hi Miyako,

Yes, if enterable is off, but focusable is on it works.

Thanks.

-- 
Cannon Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236
<cannon@...>
<www.synergyfarmsolutions.com>

Keisuke Miyako wrote:
> enterable + focusable.
**********************************************************************
4D v12.2 is Available - Now Powered with 64-bit server 
http://www.4d.com/products/new.html

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

Bill Weale | 1 Aug 2011 14:46

Re: 4D (Mac OS) external SQL query

Thanks David--

That's correct; I was just trying some TS suggestions to try to get an external server to recognize 4D
variable values within a SELECT. SQL EXECUTE and EXECUTE IMMEDIATE both require building an extensive
text string, if you are trying to pull in records with 100+ columns.

I was trying to do it with Begin/End SQL originally.

Bill

On Jul 29, 2011, at 11:29 AM, David Lieb wrote:

> 
> Can you post the part of your code that includes the variable?
> 
> The docs for EXECUTE IMMEDIATE say: "This command cannot be used within a
> connection to an external data source (SQL pass- through) established using
> the USE EXTERNAL DATABASE 4D command."
> 
> David

**********************************************************************
4D v12.2 is Available - Now Powered with 64-bit server 
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
(Continue reading)


Gmane