busco y encuentro registros en un rango de fechas... y necesito borrarlos I search and find records in a date range... and I need to delete them... - Forum
busco y encuentro registros en un rango de fechas... y necesito borrarlos I search and find records in a date range... and I need to delete them...
Quote from joferar333 on January 23, 2025, 10:15 pm@emo, @gaev, @vadim
Hola gente a ver si me pueden tirar un centro...
Con esta sentencia y comando logro filtrar desde la tabla los registros entre un rango de fechas, hasta aca perfecto...
dbpQuery "kioscos" "ingresos3" "Fecha BETWEEN #[desde]# AND #[hasta]#"
una vez obtenido todos los registros que corresponden al rango ingresado como puedo hacer para eliminar todos los registros encontrados, solo los registros filtrados no todas los registros del campo....
desde ya mil gracias lo que intento me da error...
ENGLISH
Hi people, can you give me a tip...
With this sentence and command I can filter the records from the table between a range of dates, so far so good...
dbpQuery "kioscos" "ingresos3" "Fecha BETWEEN #[desde]# AND #[hasta]#"
Once I have obtained all the records that correspond to the range entered, how can I eliminate all the records found, only the filtered records, not all the records in the field... Thank you so much, what I'm trying to do is give me an error...
Hola gente a ver si me pueden tirar un centro...
Con esta sentencia y comando logro filtrar desde la tabla los registros entre un rango de fechas, hasta aca perfecto...
dbpQuery "kioscos" "ingresos3" "Fecha BETWEEN #[desde]# AND #[hasta]#"
una vez obtenido todos los registros que corresponden al rango ingresado como puedo hacer para eliminar todos los registros encontrados, solo los registros filtrados no todas los registros del campo....
desde ya mil gracias lo que intento me da error...
ENGLISH
Hi people, can you give me a tip...
With this sentence and command I can filter the records from the table between a range of dates, so far so good...
dbpQuery "kioscos" "ingresos3" "Fecha BETWEEN #[desde]# AND #[hasta]#"
Once I have obtained all the records that correspond to the range entered, how can I eliminate all the records found, only the filtered records, not all the records in the field... Thank you so much, what I'm trying to do is give me an error...
Quote from Gaev on January 24, 2025, 12:12 am@joferar333
With this sentence and command I can filter the records from the table between a range of dates, so far so good...
dbpQuery "kiosks" "revenue3" "Date BETWEEN #[from]# AND #[to]#"Once I have obtained all the records that correspond to the range entered, how can I eliminate all the records found, only the filtered records, not all the records in the field
After executing the dbpQuery command ...
dbpDeleteAll "kiosks" "revenue3"
As per the Help file ... https://neodbprohelp.visualneo.com/AddModify.html#dbpDeleteAll ... Note that ...
Delete all records matching current search query (see dbpQuery).
If no query is active, the entire table will be deleted. Use this action with caution - there is no way to restore deleted records!
Look at the example in the Help file that shows you how to make sure that there is at least one matching record (otherwise, all records will be deleted).
With this sentence and command I can filter the records from the table between a range of dates, so far so good...
dbpQuery "kiosks" "revenue3" "Date BETWEEN #[from]# AND #[to]#"
Once I have obtained all the records that correspond to the range entered, how can I eliminate all the records found, only the filtered records, not all the records in the field
After executing the dbpQuery command ...
dbpDeleteAll "kiosks" "revenue3"
As per the Help file ... https://neodbprohelp.visualneo.com/AddModify.html#dbpDeleteAll ... Note that ...
Delete all records matching current search query (see dbpQuery).
If no query is active, the entire table will be deleted. Use this action with caution - there is no way to restore deleted records!
Look at the example in the Help file that shows you how to make sure that there is at least one matching record (otherwise, all records will be deleted).
Quote from joferar333 on January 25, 2025, 9:08 pmThanks @gaev!!!!
Thanks @gaev!!!!