Linden

i know this forum is not about sql but i am still posting this here because i have trouble doing this in max!

basicly i want to do something like this:

https://www.youtube.com/watch?v=ynWgSZBoUkU

but i dont know how to format the messages correct, which are shown in the video.

is it possible? i followed andrew bensons database tutorial.

When i want call the ROW_NUMBER function it says there is no function ROW_NUMBER.

Hello Forum,
i know this forum is not about sql but i am still posting this here because i have trouble doing this in max!
basicly i want to do something like this:
https://www.youtube.com/watch?v=ynWgSZBoUkU

but i dont know how to format the messages correct, which are shown in the video.
is it possible? i followed andrew bensons database tutorial.
When i want call the ROW_NUMBER function it says there is no function ROW_NUMBER.
Do i have to write this into the js?
would be great if someone could help me
thx!


how-to-delete-duplicates-from-database

maybe it is easier to avoid the duplicates files on import?

noone familiar here with sql and max?
maybe it is easier to avoid the duplicates files on import?
but how?
i am stuck!


so if anybody is interested i solved it by adding UNIQUE statment. very simple if you know about it and where to put it.

exec("CREATE TABLE IF NOT EXISTS dumpster(Id INTEGER PRIMARY KEY, name VARCHAR(256) UNIQUE,filetype VARCHAR(256))");

so if anybody is interested i solved it by adding UNIQUE statment. very simple if you know about it and where to put it.
you can write this into the js object.
exec("CREATE TABLE IF NOT EXISTS dumpster(Id INTEGER PRIMARY KEY, name VARCHAR(256) UNIQUE,filetype VARCHAR(256))");


how to delete duplicates from database