Posts by AnselmoMS • 240 points
7 posts
-
0
votes1
answer311
viewsA: How to post a record of details in an Fdquery with the parent record in insert mode?
Unfortunately, in Delphi XE5, using the DetailCascade is not possible through the native properties of the component. Only from the Berlin version or higher by deselecting the property…
-
0
votes1
answer311
viewsQ: How to post a record of details in an Fdquery with the parent record in insert mode?
I’m using two FDQuery with master-detail relationship and found a problem: using property CachedUpdates and relating both FDQuery à um FDSchemaAdapter. Call "Insert / Append" in the Mestre and then…
-
2
votes1
answer1339
viewsA: Postgresql - Inserting data into linked tables by Foreign Key
Try the following: WITH venda AS (insert into venda(inicio) values (now()) returning id), item as (insert into item(nome) values ('batata-frita') returning id), participante as(insert into…
-
1
votes1
answer876
viewsQ: How to make an INSERT in postgresql with conditional default value?
We have the following simplified table for the example: create table teste( id serial not null ); The commands below cause syntax error: insert into teste( select (case when 1=1 then DEFAULT end) );…
-
1
votes1
answer536
viewsQ: Delphi shortcut to move code block
In eclipse there is a shortcut that greatly increases my productivity: In the code editor, to move to lines above or below a code block is used by default ALT+ Key DOWN/UP. At Delphi, I’ve looked at…
-
4
votes1
answer156
viewsQ: How to create a view with Crosstab in SQLITE via Android?
I have the following tables: ┌──────────────┐ ┌──────────────┐ ┌─────────────────────────────┐ │ TABLE pessoa | | TABLE lente | | TABLE pessoa_lente | ├──────────────┤ ├──────────────┤…
-
4
votes1
answer218
viewsQ: How to set position of a cursor in the Onchanged of a Customview in a Listview?
I’m wearing a customview calling for android-spinnerwheel. I inserted her into a listview connected to a CursorAdapter. If I use the OnitemClickListener from Listview, the cursor goes to the…