This topic is locked

3.1 (143) false SQL-String in EDIT-Page

8/29/2006 3:19:43 PM
PHPRunner General questions
Pfeiffer author

Hi,
the edit-page builts the following string for update

update `schueler` set `BLZ`='12', `Konto`='12', `Kontoinhaber`='12' where (`schueler`.`Schueler_ID` is null) and (`schueler`.`Schueler_ID`=4481)
Of course this will not work. I have no idea why `schueler`.`Schueler_ID` is null

is built from the generator. The rest (`schueler`.`Schueler_ID`=4481) is okay.
May be because it's a view. Schueler_ID is defined as Primary EDIT-Key.

Alexey admin 8/31/2006

Hi,
could you send to support@xlinesoft.com your PHPRunner project file along with database creation script ?

I'll resolve this issue running your project on my test box.