Can't delete the record. It's being used.

[Drazen D. Babic]

Hi Andrew, 

for the interested readers, could you please suggest the best way of deleting the records with FK?

Any table referencing other tables with FK will raise the above error, and won't be deleted.

Cheers

D.

[Andrew Yushev]

Hi, Drazen

To delete such a record you have to remove any references to it.

For example, the invoices item has a customer field and a FK index on it.

If invoices have an invoice with this customer the database won't allow you to delete 

this customer.

Regards,

Andrew Yushev

ср, 17 нояб. 2021 г. в 13:10, Drazen D. Babic <bab...@gmail.com>:

--
You received this message because you are subscribed to the Google Groups "Jam.py Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jam-py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jam-py/a62911c5-5abd-47f6-8dad-596e2fbcaeccn%40googlegroups.com.

[Yeoresley Dominguez]

good afternoon

as I always need from you

could you help me?

I need to know how I can use the "select count (distinct ..." function when grouping and using functions in reports.

Cheers

[Andrew Yushev]

Hi, Yeoresley

I think it is better to create a connection to the database using the connect method of the task

https://jam-py.com/docs/refs/server/task/m_connect.html

execute an SQL query and use results in the report.

Regards,

Andrew Yushev 

чт, 18 нояб. 2021 г. в 01:31, Yeoresley Dominguez <yeoresl...@outlook.com>:

--

You received this message because you are subscribed to the Google Groups "Jam.py Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jam-py+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/jam-py/3af0a39a-4092-433f-bb7a-c64ca7ef0bf8n%40googlegroups.com.