Hello from a Filemaker renegade
Brian Yennie
briany at qldlearning.com
Tue Apr 6 17:33:35 EDT 2004
> Those are all very basic database terms. The fact that they are
> unfamiliar
> and do not appear much in Rev database discussions suggests that the
> state
> of affairs in Rev database management is not very robust.
Bruce,
There are scores of tools for managing your database schema and
relationships in various database back-ends (MySQL, Postgres, Oracle,
ODBC, Valentina...). But they aren't a part of the Rev environment-
that's often the difference between using a multi-tiered database
independent tool and one like FileMaker or Access who's entire purpose
is to build database apps.
Do have a feeling of what backend you are going to use? If so, maybe we
could point you to the appropriate tools. There's everything from free
browser based tools to extra-expensive "professional" suites with UML
and SQL generators, etc.
As for data validation, it may not be built-in to special database
controls, but it's pretty easy to script:
For example (off the top of my head):
## in your stack script
function validateNumber tValue, tMin, tMax
if (tValue is a number) AND (tValue >= tMin) AND (tValue <= tMax)
then return TRUE
return FALSE
end validateNumber
## in your field script
on closeField
if not validateNumber(the text of me, 1, 100) then
select char 1 to -1 of me
answer error "Please enter a number between 1 and 100"
else
pass closeField
end if
end closeField
HTH!
Brian
More information about the use-livecode
mailing list