Question about Structure Meta Data

View: New views
20 Messages — Rating Filter:   Alert me  
< Prev | 1 - 2 | Next >

Question about Structure Meta Data

by Chris Norman-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Is there a way to extract information from the Structure Inspector?

I want to create a schema spreadsheet that shows each tables column  
name, data type, and help tip.

Thanks,

Chris Norman
(360) 594-9900 ext. 404
tcn@...

• This communication is for informational purposes only.  It is not  
intended as an offer or solicitation for the purchase or sale of any  
financial instrument or as an official confirmation of any transaction.
• Any comments or statements made herein do not  necessarily reflect  
those of Saturna Capital Corporation, Saturna Brokerage Services,  
Inc. or their affiliates.
• Since e-mail security and delivery is not guaranteed,  e-mail to us  
should not contain personal information, or time-sensitive, action-
oriented instructions (such as buy or sell orders), or items  
requiring your signature.
• Incoming and outgoing Saturna e-mail and telephone calls are  
electronically archived and recorded, and are subject to review,  
monitoring, and/or disclosure to parties other than Saturna, the  
sender and the recipient.






**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: Question about Structure Meta Data

by Mehboob Alam :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

The structure access commands should give you everything
you need. Do consider donating your code to the public :)

http://www.4d.com/docs/V6U/V6U00050.HTM

# Count tables  Number

# Count fields (tableNum | tablePtr) Number

# Table name (tableNum | tablePtr) String

# Field name (fieldPtr | tableNum{; fieldNum}) String

# Table (tableNum | aPtr) Pointer | Number

# GET TABLE PROPERTIES (tablePtr|tableNum; invisible{;
trigSaveNew{; trigSaveRec{; trigDelRec{; trigLoadRec}}}})

# Field (tableNum | fieldPtr{; fieldNum}) Number | Pointer

# GET FIELD PROPERTIES (fieldPtr | tableNum{; fieldNum;
fieldType{; fieldLength{; indexed{; unique{; invisible}}}})

# GET FIELD ENTRY PROPERTIES (fieldPtr|tableNum{; fieldNum;
list{; mandatory{; nonEnterable{; nonModifiable}}})

# GET RELATION PROPERTIES (fieldPtr|tableNum{; fieldNum;
oneTable; oneField{; choiceField{; autoOne{; autoMany}}})

# SET INDEX (field; index{; mode{; *}})

# Get database parameter ({table; }selector{; stringValue})
Longint

# SET DATABASE PARAMETER ({table; }selector; value)


--- Chris Norman <tcn@...> wrote:

> Is there a way to extract information from the Structure
> Inspector?


sincerely,
mehboob alam


"There cannot be a crisis next week. My schedule is already full." Henry Kissinger

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: [BULK] Re: Question about Structure Meta Data

by Chris Norman-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thanks!

I'm able to get everything I need except the "Help Tips" portion of  
the Field Attributes.

I would expect that to be part of the GET FIELD PROPERTIES or GET  
FIELD ENTRY PROPERTIES commands.

Any ideas?

Thanks again,
-Chris


On Jun 8, 2007, at 10:36 AM, Mehboob Alam wrote:

> The structure access commands should give you everything
> you need. Do consider donating your code to the public :)
>
> http://www.4d.com/docs/V6U/V6U00050.HTM
>
> # Count tables  Number
>
> # Count fields (tableNum | tablePtr) Number
>
> # Table name (tableNum | tablePtr) String
>
> # Field name (fieldPtr | tableNum{; fieldNum}) String
>
> # Table (tableNum | aPtr) Pointer | Number
>
> # GET TABLE PROPERTIES (tablePtr|tableNum; invisible{;
> trigSaveNew{; trigSaveRec{; trigDelRec{; trigLoadRec}}}})
>
> # Field (tableNum | fieldPtr{; fieldNum}) Number | Pointer
>
> # GET FIELD PROPERTIES (fieldPtr | tableNum{; fieldNum;
> fieldType{; fieldLength{; indexed{; unique{; invisible}}}})
>
> # GET FIELD ENTRY PROPERTIES (fieldPtr|tableNum{; fieldNum;
> list{; mandatory{; nonEnterable{; nonModifiable}}})
>
> # GET RELATION PROPERTIES (fieldPtr|tableNum{; fieldNum;
> oneTable; oneField{; choiceField{; autoOne{; autoMany}}})
>
> # SET INDEX (field; index{; mode{; *}})
>
> # Get database parameter ({table; }selector{; stringValue})
> Longint
>
> # SET DATABASE PARAMETER ({table; }selector; value)
>
>
> --- Chris Norman <tcn@...> wrote:
>
>> Is there a way to extract information from the Structure
>> Inspector?
>
>
> sincerely,
> mehboob alam
>
>
> "There cannot be a crisis next week. My schedule is already full."  
> Henry Kissinger
>
> **********************************************************************
> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>
> Now with more power: the 4D Web 2.0 Pack v1.1
> http://www.4d.com/products/4dweb20pack.html
> Data lives here
>
> To Unsubscribe:                        mailto:4DBasics-off@...
> **********************************************************************
>
>

Chris Norman
(360) 594-9900 ext. 404
tcn@...

• This communication is for informational purposes only.  It is not  
intended as an offer or solicitation for the purchase or sale of any  
financial instrument or as an official confirmation of any transaction.
• Any comments or statements made herein do not  necessarily reflect  
those of Saturna Capital Corporation, Saturna Brokerage Services,  
Inc. or their affiliates.
• Since e-mail security and delivery is not guaranteed,  e-mail to us  
should not contain personal information, or time-sensitive, action-
oriented instructions (such as buy or sell orders), or items  
requiring your signature.
• Incoming and outgoing Saturna e-mail and telephone calls are  
electronically archived and recorded, and are subject to review,  
monitoring, and/or disclosure to parties other than Saturna, the  
sender and the recipient.






**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Updating Structure

by Stephane Potvin-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Good day all,

I am wondering if there is a way to update a 4D made into a double-
clickable application without replacing the whole thing.

For example when updating a Microsoft or Adobe application, the  
updater simply "patches" the code. Is there anything like that with 4D?

I am currently using 4D 2004.6 Mac
Mac OX 10.4.9
I also have 4D 2004.6 on Windows XP for the purpose of testing and  
compiling for Windows.

Thank you,

Stephane Potvin

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: [BULK] Re: Question about Structure Meta Data

by Mehboob Alam :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Yes, you can get this through the free plugin "API Pack"
http://pluggers.nl/api_pack.html

API Pack exposes a lot of the 4D's internal interfaces that
are not implemented in the 4D language. I havent used this
part, but I expect this should do what you need.

"Procedurally create resources for which no 4D commands
exists (like tooltips, style sheets etc.)."

Even though it's free, I'd recommend making a small token
payment, as the plugin and the sample code are invaluable.


--- Chris Norman <tcn@...> wrote:

> Thanks!
>
> I'm able to get everything I need except the "Help Tips"
> portion of  
> the Field Attributes.
>
> I would expect that to be part of the GET FIELD
> PROPERTIES or GET  
> FIELD ENTRY PROPERTIES commands.
>
> Any ideas?
>
> Thanks again,
> -Chris


sincerely,
mehboob alam


"There cannot be a crisis next week. My schedule is already full." Henry Kissinger

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: Updating Structure

by Mehboob Alam :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

There is an option, though it may not be exactly what you
are looking for.

Updater44D
http://www.inforce.sk/product_updater.html



--- Stéphane Potvin <stephane.potvin@...> wrote:

> Good day all,
>
> I am wondering if there is a way to update a 4D made into
> a double-clickable application without replacing the
whole thing.


sincerely,
mehboob alam


"There cannot be a crisis next week. My schedule is already full." Henry Kissinger

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



OT - sorry - just a test

by Jorge Prates :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

No more messages since 2007-06-08 ?
Do I have a problem ?
Jp

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: OT - sorry - just a test

by Mehboob Alam :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Same here.. maybe just a glitch, or no traffic.

--- Jorge Prates <jorge.prates@...> wrote:

> No more messages since 2007-06-08 ?
> Do I have a problem ?
> Jp


sincerely,
mehboob alam


"There cannot be a crisis next week. My schedule is already full." Henry Kissinger

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Pop up menu

by Scott Kendall :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Greetings...

So, I want to create a pop up menu..

http://www.4d.com/docs/CMU/CMU00542.HTM


And the info and example are great...


except: " To add an icon to an item, place in the item text a circumflex
accent (^) followed by a character whose ASCII code plus 208 is the resource
ID of a Mac OS-based icon resource."


I want to add my own icon!

Is there a way to get pictures from the Picture Library? Can I add my own
pictures to the Icon Resource? Am I stuck?


Thanks,
Scott


**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: Pop up menu

by john convey :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


I've seen icons used with hierarchical lists. There is an example  
database on the 4d site
if that is of any help

http://www.4d.com/products/howdoi/hierarchicallists.html


John

john convey




On 19 Jun 2007, at 15:50, Scott Kendall wrote:

> Greetings...
>
> So, I want to create a pop up menu..
>
> http://www.4d.com/docs/CMU/CMU00542.HTM
>
>
> And the info and example are great...
>
>
> except: " To add an icon to an item, place in the item text a  
> circumflex
> accent (^) followed by a character whose ASCII code plus 208 is the  
> resource
> ID of a Mac OS-based icon resource."
>
>
> I want to add my own icon!
>
> Is there a way to get pictures from the Picture Library? Can I add  
> my own
> pictures to the Icon Resource? Am I stuck?
>
>
> Thanks,
> Scott
>
>
> **********************************************************************
> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>
> Now with more power: the 4D Web 2.0 Pack v1.1
> http://www.4d.com/products/4dweb20pack.html
> Data lives here
>
> To Unsubscribe:                        mailto:4DBasics-off@...
> **********************************************************************
>
>


**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: Pop up menu

by Scott Kendall :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thanks, but it's not what I'm looking for.


Maybe someone from 4D will catch this and can explain the following to me:

"To add an icon to an item: In the item text, place a circumflex accent (^)
followed by a character whose ASCII code plus 208 is the resource ID of a
Mac OS-based icon resource."

(From Pop up menu and APPEND MENU ITEM)

Thanks,
Scott


On 6/19/07 11:33 AM, "john convey" <john.convey@...> wrote:

>
> I've seen icons used with hierarchical lists. There is an example
> database on the 4d site
> if that is of any help
>
> http://www.4d.com/products/howdoi/hierarchicallists.html
>
>
> John
>
> john convey
>
>
>
>
> On 19 Jun 2007, at 15:50, Scott Kendall wrote:
>
>> Greetings...
>>
>> So, I want to create a pop up menu..
>>
>> http://www.4d.com/docs/CMU/CMU00542.HTM
>>
>>
>> And the info and example are great...
>>
>>
>> except: " To add an icon to an item, place in the item text a
>> circumflex
>> accent (^) followed by a character whose ASCII code plus 208 is the
>> resource
>> ID of a Mac OS-based icon resource."
>>
>>
>> I want to add my own icon!
>>
>> Is there a way to get pictures from the Picture Library? Can I add
>> my own
>> pictures to the Icon Resource? Am I stuck?
>>
>>
>> Thanks,
>> Scott
>>
>>
>> **********************************************************************
>> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>>
>> Now with more power: the 4D Web 2.0 Pack v1.1
>> http://www.4d.com/products/4dweb20pack.html
>> Data lives here
>>
>> To Unsubscribe:                        mailto:4DBasics-off@...
>> **********************************************************************
>>
>>
>
>
> **********************************************************************
> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>
> Now with more power: the 4D Web 2.0 Pack v1.1
> http://www.4d.com/products/4dweb20pack.html
> Data lives here
>
> To Unsubscribe:                        mailto:4DBasics-off@...
> **********************************************************************
>


**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: Pop up menu

by Josh Fletcher (4D, Inc.) :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Scott,

I don't know the answer to your question off the top of my head but if
you would like 4D Technical Support to investigate please do not
hesitate to call or submit a case online.

Kind regards,

Josh Fletcher

--
Josh Fletcher
Technical Support Engineer
4D, Inc.

Scott Kendall wrote:

> Thanks, but it's not what I'm looking for.
>
>
> Maybe someone from 4D will catch this and can explain the following to me:
>
> "To add an icon to an item: In the item text, place a circumflex accent (^)
> followed by a character whose ASCII code plus 208 is the resource ID of a
> Mac OS-based icon resource."
>
> (From Pop up menu and APPEND MENU ITEM)
>
> Thanks,
> Scott

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: Pop up menu

by Jorge Prates :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi!

I made 2 mistakes:
First, installed this toolbar component  
http://www.mitchenall.com/products/freeware/4d/toolbar_component/index.phtml
Second, didn't make a backup before :-(

Anyone has sugestions for removal ?
The main problem is the protected tables and procedures which I can't
delete/modify.

Thanks
Jp

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



removing toolbar component

by Jorge Prates :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi!

I made 2 mistakes:
First, installed this toolbar component
http://www.mitchenall.com/products/freeware/4d/toolbar_component/index.phtml
Second, didn't make a backup before :-(

Anyone has sugestions for removal ?
The main problem is the protected tables and procedures which I can't
delete/modify.

Thanks
Jp


**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: removing toolbar component

by Mehboob Alam :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Looks like you have to move your own structure to a new
file in order to leave everything else behind. Sorry.. the
backing up requirement is quite essential here..

--- Jorge Prates <jorge.prates@...> wrote:

> Hi!
>
> I made 2 mistakes:
> First, installed this toolbar component
>
http://www.mitchenall.com/products/freeware/4d/toolbar_component/index.phtml

> Second, didn't make a backup before :-(
>
> Anyone has sugestions for removal ?
> The main problem is the protected tables and procedures
> which I can't
> delete/modify.
>
> Thanks
> Jp
>
>
>
**********************************************************************

> 4D Basics hosted by 4D, Inc.                      
> http://www.4D.com/
>
> Now with more power: the 4D Web 2.0 Pack v1.1
> http://www.4d.com/products/4dweb20pack.html
> Data lives here
>
> To Unsubscribe:                      
> mailto:4DBasics-off@...
>
**********************************************************************
>
>
>


sincerely,
mehboob alam


"There cannot be a crisis next week. My schedule is already full." Henry Kissinger

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: removing toolbar component

by Jorge Prates :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Using 4D Insider ?



Mehboob Alam wrote:
> Looks like you have to move your own structure to a new
> file in order to leave everything else behind. Sorry.. the
> backing up requirement is quite essential here..
>
> --- Jorge Prates <jorge.prates@...> wrote:
>
>  
>  


**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Universal Binary

by Pete Seabolt :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Anyone have any ideal when we will get a universal binary version of  
4D for the intel macs?

Thanks

J. Allen (Pete) Seabolt
Home 706-864-6613
Work 706-864-2169 x1
N4KHQ


**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

Now with more power: the 4D Web 2.0 Pack v1.1
http://www.4d.com/products/4dweb20pack.html
Data lives here

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Moving users

by Jorge Prates :: Rate this Message: