Posts by Francisco Fabio • 111 points
5 posts
-
2
votes1
answer9012
viewsQ: Truncate decimal places arbitrarily with Postgresql
I am making an SQL query using the function sum(). This function sums integers and fractional numbers. The problem is that it returns a double Precision with very large number. How do I limit up to…
-
2
votes1
answer390
viewsQ: Capture date from Qdateedit
I need to pick a date QDateEdit. I did the designer using Qt Designer, in properties activated calendarPopup and the displayFormat for dd/MM/yyyy. I want to capture this date to insert in a query. I…
-
2
votes1
answer725
viewsQ: Dynamic table in python
I have a problem and I can’t identify the mistake. I am creating a dynamic table in Python where it will be filled with database information. The problem is the code is repeating the first line of…
-
2
votes1
answer103
viewsQ: Create Views in the database from function
I am developing a simple application where you will need to create a views in Postgresql through Python function. Until then it seems a simple code, but what I did it does not create the views in…
pythonasked Francisco Fabio 111 -
2
votes3
answers431
viewsQ: How to convert variable to String?
I have a function that takes a postgresql database code and visualize setting in QLabel with the function setText(). The problem is that this code comes from the database in strange format, between…