date:20160830

Can't Save Record Mandatory field is null

2016-08-30 Thread Sannyasin Siddhanathaswami

Aloha,

I’m having a super weird error in our database. For maybe 1000 records I get an 
error when opening/saving a record.

It says :
Cannot Save record…
Cannot update record…
Mandatory field is Null in record…

I’ve run verify records in the maintenance center and it didn’t find any errors.

I don’t have any mandatory fields in this table, and confirmed that with this:
$lastFieldNum:=Get last field number(->[Members])
For ($x;1;$lastFieldNum)
GET FIELD ENTRY 
PROPERTIES(Table(->[Members]);$x;$list;$mandatory;$nonenterable;$nonModifiable)
If ($mandatory)
ALERT(Field name(Table(->[Members];$x)))
End if

Any clue what’s going on here?




--
Sannyasin Siddhanathaswami

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

Re: Upgrading 2004 to v15

2016-08-30 Thread Doug Hall

Thanks, Guy. I'll definitely check it out.

On Tue, Aug 30, 2016 at 6:57 PM, Guy Algot  wrote:

> No problem Doug. If it changes let me know.
>
> You probably want to visit the Foundation page and upgrade your component.
> There’s also a support list over there as well.
>
> > On Aug 30, 2016, at 5:03 PM, Doug Hall  wrote:
> >
> > Thanks for the responses so far! I'm so glad I still have help here! (I'm
> > gonna need it.) How wonderful to hear from some of you old-timers -- all
> > the way back to the CompuServe days (Douglas von Roeder and Lee Hinde for
> > sure, and Chip Scheide might have been around in those days. My memory
> > fails me.) I can hear that blasted 9600 baud modem screeching, to this
> day!
> > :-))  <--- Yes, I've adopted a double chin, now. Gotta get rid of that
> > stupid thing. :-((
> >
> > After a little plowing through 4D Insider, I've found a few plugins that
> I
> > wasn't even using, but never bothered to clean out. I've already
> > removed Expat4D, 4D Open and PrintList Pro. I had already removed the MD5
> > plugin I mentioned earlier, but I had forgotten I had. (I was working off
> > an old list of plugins.)
> >
> > Before I waste more of your time, I'm going to need to dive into the
> > upgrade manuals and do some further preening of my code, to make sure
> that
> > I'm only porting the code that I'm actually using. 4D Insider will help
> me
> > locate stuff I'm not using. By the way, is there a replacement for that
> > functionality now that there is no more 4D Insider?
> >
> > I am glad to hear that it's actually possible to go straight to v15. I'm
> > going to have lots of questions along the way. I hope you guys don't get
> > tired of me.
> >
> > Guy Algot, I appreciate the offer of help, but we're pretty low budget in
> > this state office. Just upgrading the software is sending shock waves. I
> > appreciate the offer, though.
> >
> >
> > On Tue, Aug 30, 2016 at 4:45 PM, Chip Scheide <4d_o...@pghrepository.org
> >
> > wrote:
> >
> >> as for BASH:
> >> list which methods in it you are using.  THere are likely bits of code
> >> out there to replace the functionality (if 4D has not already done that)
> >>
> >>
> >> On Tue, 30 Aug 2016 16:17:26 -0500, Doug Hall wrote:
> >>> For various reasons, we have put off upgrading 4D. We originally
> intended
> >>> to just move off of 4D all at once, but that turned out to be
> impossible.
> >>> I've added onto our existing structure in spurts, but for the most
> part,
> >>> I've been out of active 4D development for almost a decade, now.So,
> now I
> >>> begin the journey of a million miles, with a single step. The first is
> >>> advise from you guys. Should I shoot for an interim version, say v13,
> or
> >> is
> >>> it possible (practical) to go all the way from 2004 to v15?
> >>>
> >>> I know that the Bash component we're using has not been supported for
> >>> years. Has anyone reverse engineered the methods in this component? If
> >> so,
> >>> please email me privately.
> >>>
> >>>
> >>> Here's what we're currently using in 4D 2004:
> >>>
> >>> Foundation (v3.7.2?)
> >>>
> >>> Components:
> >>> Bash Component: I've heard there is no way to upgrade. Please advise.
> >>> Rollover (Used by ToolBar) No longer available.
> >>>
> >>> Plugins:
> >>> AreaList Pro 7.9
> >>> Active4D
> >>> MD5 Plugin
> >>> PDF Plugin
> >>> PostgreSQL Plugin
> >>>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Using ListBoxes as Output forms

2016-08-30 Thread John DeSoi

> On Aug 30, 2016, at 3:48 PM, Alan Tilson  wrote:
> 
> Most of the time there is a matching 4D table but there could also be times
> where all the data is coming from an external source, so I suppose I am
> talking about array based listboxes.

It takes some work, but selection based listboxes work well for displaying 
large result sets from external databases. I use this all the time with 
Postgres. You need a "dummy" table to create a record selection with the number 
of rows in the result set. A table with a single boolean field is all you need. 
You can use the On Display Detail event to cache just a subset of the data 
needed to display the visible rows.

It would be really nice if array based listboxes supported formula columns and 
the on Display Detail event. Then all you would need to do is create a boolean 
array with the right size and manage data fetching for the visible rows.

John DeSoi, Ph.D.

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

Re: Upgrading 2004 to v15

2016-08-30 Thread Lee Hinde

No, but you can quickly search the database for specific objects. 
Command/Control-Shift-F


> On Aug 30, 2016, at 4:03 PM, Doug Hall  wrote:
> 
> Before I waste more of your time, I'm going to need to dive into the
> upgrade manuals and do some further preening of my code, to make sure that
> I'm only porting the code that I'm actually using. 4D Insider will help me
> locate stuff I'm not using. By the way, is there a replacement for that
> functionality now that there is no more 4D Insider?

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

Re: Upgrading 2004 to v15

2016-08-30 Thread Doug Hall

Oops. I accidentally sent the above before I was finished.

Anyway, I'd like to pick some brains of those who've transitioned from a
similar environment. Did you just rewrite the Bash routines? That's got to
be a pain. Is there nothing out there that does a lot of the same stuff? I
primarily used the DTS (DateTimeStamp) and DSS modules. UI probably used
NULL, too, but not much. I'm a little worried about all the time it will
take to recreate this functionality.

Most of the other stuff, I think I'm going to be okay upgrading. Active4D
and ObjectTools are still supported by Aparajita Fishman, and PDF Plugin
and PostgreSQL Plugin are in good hands with Rob Laveaux. AreaList Pro I
see has changed hands and the licensing structure has changed. Are there
any other surprises there, or should the upgrade be pretty straightforward?

Do I make the leap all the way from 2004 to v15, or should I try to shoot
for interim versions? Do I need to get each version to work, or will the
data upgrade from version to version be fine from an uncompiled (and
non-functioning) version. I know I'll have to remove the components, like
Bash. What other lovely surprises await me?

Many thanks ahead of time!
Doug Hall

On Tue, Aug 30, 2016 at 4:17 PM, Doug Hall  wrote:

> For various reasons, we have put off upgrading 4D. We originally intended
> to just move off of 4D all at once, but that turned out to be impossible.
> I've added onto our existing structure in spurts, but for the most part,
> I've been out of active 4D development for almost a decade, now.So, now I
> begin the journey of a million miles, with a single step. The first is
> advise from you guys. Should I shoot for an interim version, say v13, or is
> it possible (practical) to go all the way from 2004 to v15?
>
> I know that the Bash component we're using has not been supported for
> years. Has anyone reverse engineered the methods in this component? If so,
> please email me privately.
>
>
> Here's what we're currently using in 4D 2004:
>
> Foundation (v3.7.2?)
>
> Components:
> Bash Component: I've heard there is no way to upgrade. Please advise.
> Rollover (Used by ToolBar) No longer available.
>
> Plugins:
> AreaList Pro 7.9
> Active4D
> MD5 Plugin
> PDF Plugin
> PostgreSQL Plugin
>
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

feature request

2016-08-30 Thread Charles Miller

I have added a feature request to create a setter to allow or disallow
savings of user names and another for passwords. I for one thought it was a
great feature that 15.1 did not have ability

Regards

Chuck

-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Sever connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Using ListBoxes as Output forms

2016-08-30 Thread Alan Tilson

Hello everyone,

Is there anything new to add to this discussion?

I'm looking for a way to display records from an external database synced
with records stored in 4D.

Most of the time there is a matching 4D table but there could also be times
where all the data is coming from an external source, so I suppose I am
talking about array based listboxes.

As Walt said to start this thread, I'd rather not reinvent the wheel!

And right now we are using v13.6 but are planning on moving to v15 before
too long, so I'd love to find something that could work in both places.

Thanks,
Alan

On Mon, Feb 14, 2011 at 9:56 AM, Ortwin Zillgen  wrote:

> > Walt, we looked at replacing output forms with list boxes - until we
> > realised that they had the same problem that output forms have - you
> > cannot stop the left column (say, the ID field) from scrolling off
> > screen when the list is wider than the window and you scroll right.
> >
> > At least, that's the way it was in early v11.
> > If later v11 or v12 has *finally* added a "freeze column" ability, I
> > would be very pleased to hear it.
> > I know AreaList does that.
>
> planned for V13
>
> splitting in V2004, sort of
> 
> and footers, too
> 
>
>
> Regards
> Ortwin Zillgen
> ___
> Stadt Land Fluß * Geographic Informationsystems
>    
> RSS 
> RSS 
> member of developer-network 
>
> **
> 4D v12.1 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-unsubscr...@lists.4d.com
> **
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Anyone have code for rendering a document list array to an hList?

2016-08-30 Thread Keisuke Miyako

in practice, it helps to make the list item label display the file name,
while storing its absolute path (as well as other information) as custom 
parameters.

http://doc.4d.com/4Dv15R4/4D/15-R4/SET-LIST-ITEM-PARAMETER.301-2824560.en.html

> 2016/08/30 18:13、Ortwin Zillgen  のメール：
> just in case, are you looking for
> ARRAY TO LIST 
> 
> ARRAY TEXT($docPath_T;0)
> DOCUMENT LIST("yourPath";$docPath_T)
> documentList:=New list
> ARRAY TO LIST($docPath_T;documentList)


宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

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

Re: 4D command returning a value request

2016-08-30 Thread Bill Weale

ummm….

divine wisdom = Engineering?

or, Engineering:=divine wisdom?



www

> On Aug 30, 2016, at 12:47 AM, Keisuke Miyako  wrote:
> 
> but this is just my own way of reasoning, not divine wisdom (I did not 
> consult Engineering).

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

Re: Anyone have code for rendering a document list array to an hList?

2016-08-30 Thread Ortwin Zillgen

> Before I reinvent this particular wheel does anyone feel like sharing their
> code for turning a document list (think of the fully annotated list you get
> from Document List) into a hierarchical list? After all these years I have
> need of such capability.

just in case, are you looking for
ARRAY TO LIST 


ARRAY TEXT($docPath_T;0)
DOCUMENT LIST("yourPath";$docPath_T)
documentList:=New list
ARRAY TO LIST($docPath_T;documentList)


Regards
O r t w i n  Z i l l g e n
-
   
 
member of developer-network 

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

Can't Save Record Mandatory field is null

Re: Upgrading 2004 to v15

Re: Using ListBoxes as Output forms

Re: Upgrading 2004 to v15

Re: Upgrading 2004 to v15

feature request

Re: Using ListBoxes as Output forms

Re: Anyone have code for rendering a document list array to an hList?

Re: 4D command returning a value request

Re: Anyone have code for rendering a document list array to an hList?

10 matches

Site Navigation

Mail list logo

Footer information