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

Reply
Dustin Taylor
Dustin Taylor
StrataFrame Team Member (938 reputation)
Group: StrataFrame Users
Posts: 364, Visits: 771
Hi Gerard,

Just to echo Trent and Paul's comments, I'd definately look into SQL Express as an alternative to MySQL if possible. MySQL is a fine database, but in my experience, SQL Express provides a great (also free) alternative that will give you much more room for growth and a tighter integration with .NET. I haven't had much experience with MySQL recently, so many of my old gripes may have bene resolved, but SQL Express will certainly give you a better "ceiling" by way of the enterprise edition both on scaling and on the coding end as well (i.e. T-SQL support.) 

Obviously, the main caveat to going with SQL Express is if the memory or cpu limitations Trent mentioned are going to really hamper you (i.e. you are planning on using it in a demanding or high-volume environment.) For 15 users, however, I highly doubt you'll notice the limitations at all. 

The file size issue isn't as big of a deal unless you are planning on storing media files within the database. As Paul mentioned, you can always split your database into multiple file groups to handle a larger number of records (which, excluding media files, would need to be pretty large to begin with to exceed 4 GB.)

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