Append automem with vt

Hi all, I've a virtual table pointing to mssql table.
I need to insert a new record on the remote table.
Can I use append automem?
Thank
Fabio

Hi Fabio,

I susspected the answer is not, but when created a virtual table, local, and tried

Code:

---

store automem
append automem

---

it worked.
I don't know if remote will do. Try APPEND BLANK first.

Hi Josip, thanks.
But I've more "not null" fields..
Now I've some error on this fields.

As you don't properly describe what error is reported and don't try it but rather ask others to try for you it's difficult to know what it is you are wanting to achieve. However, you can also use the sql insert command with the memvar keyword.

https://www.lianja.com/doc/index.php/SQL_INSERT

Hi Fabio,

If you have "not null" fields, then it is understandable.
I suppose you tried APPEND BLANK with remote VT to get these errors.
APPEND BLANK was just an idea to check if such non-SQL concept works in remote VT like in local VT.

For APPEND AUTOMEM (if it works in remote) you need to assign some new values for unique key fields
and provide not null values for such fields

Code:

---

store automem
m.account_no = strzero(seqno(),5)
append automem

---

https://www.lianja.com/doc/index.php/APPEND_AUTOMEM

As has been discussed on various occasions if your remote table has autoinc columns or other auto generated columns you need to exclude those columns from the virtual table definition using the updatefieldlist property.

https://www.lianja.com/doc/index.php...ble_Properties

Hi all,
now I've solved with a direct insert into MSSQL via sqlexec and work.
In the next days I try again with append automem and insert SQL.
thanks
Fabio