VFP Date and General Fields


Author
Message
Ger Cannoll
Ger Cannoll
Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)
Group: StrataFrame Users
Posts: 430, Visits: 507
I have a VFP database table set up as a Business Object. In VFP. If I append a record in VFP ,I get "  /  /  " for a date field   (Date field which is Balnk)  and gen for a Genral Field (seems to be an empty gen field).

I am trying to do the same in the Buisness Object. How do I get a Blank Date into a date field and gen into a General Field. Currently, If I allow nulls, it seems to put a date of 01/01/1800 intot he date field.

Also, when I drop the Field onto the form, there is no automatic formatting based on the field size in the table (e.g. say Numeric field with 10 digits and 4 decimals is displayed as just decimals). Is there any automatic way to take the formatting from the table i.e. in example it would have a mask of 999999999.9999

Replies
Ger Cannoll
Ger Cannoll
Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)
Group: StrataFrame Users
Posts: 430, Visits: 507
Where in the BO would I put the Code to run the update command 
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
You could go about this a number of different ways.  The simplest would probably be to handle the AfterSave event and then update the dates after the BO and DAL have already done their work.  But you could go down a lot of roads here.  If this isn't what you want then let me know and I can throw out some more complicated approaches, but if this meets your needs then this would be the most simple approach.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search