Posts by Walkovyr • 29 points
5 posts
-
-1
votes2
answers81
viewsA: LIMIT 1 with LEFT JOIN
Then just sort the data by DESC endDate and limit the result to 1. SELECT a.*, b.name AS currentClubName, c.name AS transferorClubName, d.name AS contactName, d.phone AS contactPhone, d.phoneApp AS…
-
0
votes2
answers518
viewsA: Firebird perform automatic reset on Generator
If you want to limit it to a specific value, as in the case of 999999, use... SELECT MOD(GEN_ID(COD_PEDIDO, 1),999999) AS ID FROM RDB$DATABASE So you don’t have to deal with anything in the…
-
0
votes2
answers220
viewsA: Clientdataset for Excel
Excel.WorkBooks[1].Sheets[iSheet].Cells[eline,(vCol+1)].NumberFormat := 'Texto'; Excel.WorkBooks[1].Sheets[iSheet].Cells[eline,(vCol+1)] := pQr.Fields[i].AsString;
-
0
votes2
answers48
viewsA: Accessviolation when changing Borderstyle
procedure TfmContasPagar.FormCreate(Sender: TObject); var RedimensionarTela : String; begin RedimensionarTela := TUtil.Sql.SQLLinha('SELECT REDIMENSIONAR_TELA FROM USUARIOS WHERE COD_USUARIO = ' +…
-
3
votes1
answer518
viewsQ: Design structure
I have a project being developed with VRaptor and I have a question about the structure of project. The project I’m developing will be installed in several clients, each with a different structure.…