Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Clear database after date added?

R

rekaa0251 last edited by rekaa0251

Can anyone give me an example of what i could possibly do to remove entries in my database (local) by time passed?

for example: If i added an entry to the database 5 days ago then i want it to be cleared if 5 days has passed if not, keep it. Possible or not?

Thanks so much in advance!
Reply Quote 0
1 Reply Last reply

1
Posts

69
Views

Y

select record from database with DATE filter (earlier than/later than) not working
Support • • yourfriendkarol

2

0
Votes

2
Posts

216
Views

Y

nvm it worked sry
Y

SUGGESTION: let us change mouse speed of "SET COMBOBOX BY XXX"and "clear edit"
Support • • yourfriendkarol

2

0
Votes

2
Posts

79
Views

@yourfriendkarol said in SUGGESTION: let us change mouse speed of "SET COMBOBOX BY XXX"and "clear edit": as above, or is there reason why we cant set their speed or make them "mouse-disabled" ? when in loops, it sloows down the project a lot You can use the "Move On Element" action before setting the combo box value.
Y

solution for massive database data check other than select db by criteria (high I/O)?
Support • • yourfriendkarol

2

0
Votes

2
Posts

314
Views

@yourfriendkarol said in solution for massive database data check other than select db by criteria (high I/O)?: What I do is: get some data select by criteria db action, it gives u list if length of that list > 0 it means record is in db already - continue. If its not there, then it adds. its good way to do it but i think with many threads my I/O is on max and it gets kinda slow, but maybe im wrong and its something else slowing me. i basically have such thing as i described above running 24/7 and cant speed it up for some reason nomatter how many threads I add. CPU, memory, disk, is all ok on low usage, only I/O high This all depends, is the data within the table long/a lot? 1million + with a high character rate? Have you tried other Database actions and/or filters to minimize the search criteria? Would an external MongoDB you set-up & configure yourself might change the I/O bottleneck? External DB: http://wiki.bablosoft.com/doku.php?id=how_to_setup_mongodb_server
Y

Is File Resource More Computer-Heavy Task Than Database-Resource?
Support • • yourfriendkarol

1

0
Votes

1
Posts

98
Views

No one has replied
A

Select Database Group ID
Support • • andykaufseo

25

1
Votes

25
Posts

3991
Views

@andykaufseo I didn't read all thread, but here is answer for original question. You can insert only to new group, which is created with Create Group action. Create Group returns group id, which can be used later inside Insert Record action. There will be interface to search/edit/delete groups but later.
A

Enforcing UNIQUE KEY constraint in BAS database ?
Support • • andy231

2

0
Votes

2
Posts

182
Views

@andy231 said in Enforcing UNIQUE KEY constraint in BAS database ?: This can be done when i am using remote database but is it possible to apply in local database ? i want to prevent duplicate entry in database . Only with a filter on the content of the data in the table.
Y

Possible to use database resource to obtain rows with DESCENDING value while also removing it?
Support • • yourfriendkarol

1

0
Votes

1
Posts

378
Views

No one has replied
H

Close Browser - will clear cache?
Support • • Hifive

1

0
Votes

1
Posts

91
Views

No one has replied

1 / 1

Clear database after date added?

select record from database with DATE filter (earlier than/later than) not working Support • • yourfriendkarol

SUGGESTION: let us change mouse speed of "SET COMBOBOX BY XXX"and "clear edit" Support • • yourfriendkarol

solution for massive database data check other than select db by criteria (high I/O)? Support • • yourfriendkarol

Is File Resource More Computer-Heavy Task Than Database-Resource? Support • • yourfriendkarol

Select Database Group ID Support • • andykaufseo

Enforcing UNIQUE KEY constraint in BAS database ? Support • • andy231

Possible to use database resource to obtain rows with DESCENDING value while also removing it? Support • • yourfriendkarol

Close Browser - will clear cache? Support • • Hifive

select record from database with DATE filter (earlier than/later than) not working
Support • • yourfriendkarol

SUGGESTION: let us change mouse speed of "SET COMBOBOX BY XXX"and "clear edit"
Support • • yourfriendkarol

solution for massive database data check other than select db by criteria (high I/O)?
Support • • yourfriendkarol

Is File Resource More Computer-Heavy Task Than Database-Resource?
Support • • yourfriendkarol

Select Database Group ID
Support • • andykaufseo

Enforcing UNIQUE KEY constraint in BAS database ?
Support • • andy231

Possible to use database resource to obtain rows with DESCENDING value while also removing it?
Support • • yourfriendkarol

Close Browser - will clear cache?
Support • • Hifive