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]

Reply via email to