Welcome Guest, Not a member yet? Register   Sign In
db_join adds new record to left table

(01-22-2015, 05:06 PM)CroNiX Wrote: I would guess that your first query in the IF() is failing, which makes it go to the ELSE, which is:


Your first query is a select, not an insert or update, so it's impossible for that to be adding anything whatsoever to the database.

I took the if else off and against my prediction it worked especially because
calls a function that opens the create record window - still far from creating a record. And it is still a mystery why it uses the contents of the last table record to create a new on.

So thank you all - it works - even have no explanation.

Messages In This Thread
RE: db_join adds new record to left table - by alfred.laggner - 01-22-2015, 08:47 PM

Theme © iAndrew 2016 - Forum software by © MyBB