Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numeric fields in SQL vs VFP
Message
 
 
To
02/04/2010 18:27:08
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
General information
Forum:
Microsoft SQL Server
Category:
Database design
Environment versions
SQL Server:
SQL Server 2005
Application:
Desktop
Miscellaneous
Thread ID:
01458467
Message ID:
01458579
Views:
31
>>That would be a good idea if I would need to know general information about the field.
>>I need an exact structure information. I need to make sure that I will not get numeric data overflow error when saving to the server. So if my structure allows 9999999.99 number, the field in the view/cursor coming from the SQL server will be 999999999.99. And If I will not limit entry by formatting the field, the user can potentially enter a higher number.
>>
>
>What no business classes between the application and the data? :-)
>Tim

Good point. How you're suppose to structure biz object and how UI will interact with BO?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform