Posts by M. O. Pereira • 91 points
9 posts
-
0
votes1
answer110
viewsA: Suggestion SQL generator on embedded system
Below is a simple suggestion to help resolve the issue: In a new form add a Memo, a Grid and 3 buttons (Query, Change and Clean). A connection component with the database (Adoconnection1, for…
-
0
votes3
answers4847
viewsA: INSERT inside a SELECT - SQL Server
Another way to do this would be by using a Cursor: /* Procedimento que serve para: incluir registro em uma tabela com base em uma consulta e uma condição Criado em: 08/08/2016 */ USE Sample1 -- Não…
-
0
votes1
answer190
viewsA: Exclude Unit from Lazarus
To delete a Unit from the project go to [Menu / Project / Remove from the project]: Select the desired Unit. Check if there is any other form referencing the excluded Unit in the USES clause. See…
lazarusanswered M. O. Pereira 91 -
1
votes1
answer896
viewsA: Access function equivalent to COALESCE
I tested your inclusion script and found an extra parenthesis after the word COALESCE. Making the change would look like this: INSERT INTO CONTA(COD_CONTA, DESCRICAO, SALDO_INICIAL) VALUES ((SELECT…
-
1
votes1
answer271
viewsA: Lazarus depurador invalido
Try this: On the Options/ IDE Debugger/ General screen: Debugger_startup_options --> Change "Disableloadsymbolsforlibraries" to "True" See details in: gdb.exe has stopped Working…
-
2
votes2
answers163
viewsA: Error message when closing the application
I made some modifications to the onClick event of the imgLogin component: (Considering the Login and Home Forms on the Auto-create side in the project options). procedure…
-
0
votes2
answers823
viewsA: How to create a FOREIGN KEY using uniqueidentifier in SQL Server
It was not clear the need for use of the type uniqueidentifier in creating their tables. The unique data type stores 16 byte binary values operating as Guids (Globally Unique Identifiers). A GUID is…
-
0
votes2
answers1523
viewsA: Doubt with DROP COLUMN sql server command
The message indicates that a constraint (Constraint) has been created with default value for the column we are trying to delete. Before excluding this column, the restriction should be excluded.…
-
2
votes2
answers390
viewsA: How to implement A/B testing?
The A/B test is used when you have two implementation options that are equally valid. For example: If during the development phase of a web page (e-commerce) your team believes that the placement of…
testinganswered M. O. Pereira 91