Re: Book recommendations for database development


"Michael Fritz" <spam_athome@xxxxxxxx> wrote in message news:cki7pehtjeix.zp3a74j79trt$.dlg@xxxxxxxxxxxxx

I'm interested in how is user data entered in the front-end, using DB aware
controls or perhaps just plain VCL controls? How is the input validated
before sending them to the RDBMs etc....

You can go the whole "Data Aware" route which has it place and has a lot of value
once you understand what it is doing for you. First I think you should take the
more manual approach first by looking at sqldirect-soft.com. We use SQLAPI++
but it should be the same.

Basically it works like this. When a user enters data in via a TEdit box or something
you pass the value into your Class. You then serialize that object (Class instance) across
your TCP (TIndy) connection to your Application Server (a TCP socket server you
developed). That server reconstructs the data back into an object (does some work on
it maybe) to which it then serializes to your database vencdor (ms, mysql, firebird, etc..)

This serialization to the database vendor is easy using libraries that abstract the different
database vendors. There are somethings to be aware of course...



.