IP Office SQL Database

[manofdos]

Has anyone been able to update a record in an SQL database? I'm able to use the DB Execute to add additional rows but I'm having trouble updating values in existing rows.

I tried entering standard SQL update statement but it seems if VMPRO doesn't like it.


Thanks,

Bill

 

[AACon]

In a db execute, do this:

UPDATE TblName
SET TblOption = "NewValue"
WHERE (TblOptionMatch = "MatchOption"

NewValue could be $CP0, $DBD[0], or whatever; same with MatchOption


I've always had this work fine.


I wish the wizard had update commands built in...would make it easier. Maybe R8 will be better (here's to hoping...)



-Austin
ACE: Implement IP Office