Hi there,
We are currently getting PHP to talk to Progress. How you do it is thru ODBC. You
have to get a ODBC driver for Progress which you can get straight from Progress
(Merant driver) for $100 or you can get one from www.openlinksw.com for $500 with
multitier capabilities. I will warn you, the current ODBC drivers out there for
Progress are buggy. For some reason, when you add new records in the db it will not
trigger. So you can't do autoincrement with the Progress DB. You would have to turn
off triggers and code in your PHP to find the last number used in the table (if you
wanted an autoincrementing id number which you almost always do). There is also an
option of writing a java that does keeps track of the trigger for you but we don't do
java just yet and it sounds complicated. Let me know if you pursue that what your
code is.
Just keep these things in mind when you are designing your db. There's also the
problem with getting the last used record in the db and just adding one. What if a
"person" with id of 50 does a bunch of stuff, you have them saved in other table as 50
doing this and that. Then person 50 wants to be deleted. So you delete them and then
when you add a new person since 49 is the last used number person 51 gets added as 50.
NOw when person 51 needs things recorded in the other tables his data gets mixed up
with the old person 50. Have I confused you yet? I confused me! The best solution is
to keep a table called "id" where you keep track of every id number ever used and
don't delete from it just becvause the number may get deleted in another table. Hope
I haven't totally turned you around! :)
Angie
>>> Hector M Banda <[EMAIL PROTECTED]> 06/19/01 01:09PM >>>
Hi all,
Does any body have any information about how to access a PROGRESS
database using PHP?
I know this has been asked before and I just want to be upto date.
Thanks,
--
===================================
Hector M Banda
Fax: (425) 790-6379
Irvine Ca, 92618
===================================
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
