Telefon: 01629645795

SQL extend a Recordset / VBA DAO etc.

Sometimes you will get a problem if you want to add a data entry to a recordset, it can be done without the need of inserting the data entry to the table.

It is a little bit tricky but with a union statement you can do following:

your normal statement looks like:

 

and if you want to add a entry without insert then you can union like:

 

Kommentar verfassen

Diese Website verwendet Akismet, um Spam zu reduzieren. Erfahre mehr darüber, wie deine Kommentardaten verarbeitet werden.