SQLite Inserting, Deleting and stuff
#3

Can I do something like this -

When I execute the command for deleting a business, it will only erase fields in that row and make them all NULL.
Now when I want to create a business, can it Select a row where , let's say, "IDFirme(Biz ID in english)" is NULL?

So, when I am in process of creating, there are two options:
1.) IF the script finds NULL under "IDFirme" it will just UPDATE the existing one and set default, fresh business values.
2.) ELSE if everything is okay and not NULL, it will just to the thing I already wrote.

Can you , sir, please help me with that?

Regards
Reply


Messages In This Thread
SQLite Inserting, Deleting and stuff - by Sime30 - 15.01.2015, 00:21
Re: SQLite Inserting, Deleting and stuff - by Jefff - 15.01.2015, 00:43
Re: SQLite Inserting, Deleting and stuff - by Sime30 - 15.01.2015, 00:57
Re: SQLite Inserting, Deleting and stuff - by Sime30 - 15.01.2015, 02:09
Re: SQLite Inserting, Deleting and stuff - by Sime30 - 15.01.2015, 16:07

Forum Jump:


Users browsing this thread: 1 Guest(s)