PDA

View Full Version : Documentation On Column, Table constraints need links to Create Table, etc.



HankFay
2012-08-29, 08:12
In looking at the doc on CREATE TABLE, I see a RECALCULATE keyword. By doing a search I found docs on RECALCULATE (wow, field triggers -- we can do a lot with that!), but only by doing a search. It wasn't linked to anything else that I could find.

But that leaves me wondering: have I seen references to all the types of column and table constraints? Do I know what to search?

If you could post of list of all types of column constraints and table constraints, I can do the searching. I just don't want to miss out on any goodness (in VFP Frank and I built in field triggers at the framework level and would have done that for Lianja).

thanks,

Hank

lianjasupport
2012-08-29, 08:28
http://www.lianja.com/wiki/index.php/SQL_Constraints

lazyfox
2012-08-29, 09:36
If you could post of list of all types of column constraints and table constraints, I can do the searching. I just don't want to miss out on any goodness (in VFP Frank and I built in field triggers at the framework level and would have done that for Lianja).


As this was not planned for first level generation I had not coded to most exceptions - but you can find and search in table after receiving latest mail ;-)

HankFay
2012-08-29, 12:06
http://www.lianja.com/wiki/index.php/SQL_Constraints

Ah, just what I was looking for! Thanks.

HankFay
2012-08-29, 12:09
As this was not planned for first level generation I had not coded to most exceptions - but you can find and search in table after receiving latest mail ;-)

Fantastic! Now I don't have to search all over the place. Looks like a 5 minute Lianja App (Thomas has downloaded the Wiki into a dbf with all the information for each entry available in HTML -- which I'll display in a WebView, and in Text). I'll have that app open constantly as I'm developing.

Hank