Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Take the image through OpenDialog and record in the Blob Field of BDE FireBird 2.5 - delphi

M
magpie QA Engineer last edited by
We need to take pictures through opendialog and put the file on the button. blob- Half base Firebird♪ In the absence of good experience, I cannot match and adjust the code for myself (in those examples that have been seen). As long as I've learned it's worth doing through the flow, and this is a special thing for me... Who cares?
```
    IBQuery2.Open; 
    IBQuery2.Active:=false; 
    IBQuery2.Edit; 
    IBQuery2.SQL.Add('insert into MainTable (img) VALUES (?img)'); 
    (IBQuery1.FieldByName('IMG') as TBlobField).LoadFromFile(OpenDialog1.FileName);
    IBQuery2.Active:=true; 
    IBQuery2.ExecSQL;
```
IBQuery1 has a request for a sample of all fields, that is, he's showing me what's needed when the application is launched. IBQuery2, the request is not written, it is used to request a new line in the base, and then the Blob-field idea needs to write a picture.
Use standard components Delphi 7 - Interbase, Lazarus - with SQLdb
delphi 7 / lazarus
Reply Quote 0
1 Reply Last reply
K
kalena last edited by

There's a component of TDBImage. Put it in the interface as a field of OBD and... forward.
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

Change a record with a WebService REST
Software Programming • java delphi web servic languagee • • jeanid

2

0
Votes

2
Posts

0
Views

R

Well, as you haven't specified, I'm going from the premise you're using JAX-RS on your Controller. When vc does not specify the parameter type, JAX understands that you want to use it as the request body.In this case, you should specify in your client, the request container-type, and pass the bank name in the body. In this case, both "text/plain" and "application/json" should work, since all String is a valid Json.Another possibility would be you to use @QueryParam, and pass its value as a query parameter. It would be more or less so the url:http://localhost:8080/{seuContexto}/Banco/put/{codigo}?nome={nomeDoSeuBanco}
C

Firebird does not use the primary key index when requested
Software Programming • sql firebird • • chanisef

2

0
Votes

2
Posts

0
Views

J

Probably no extra index. From documentation:Compared to other CBDs, the Firebird indices have another feature, the scanning of the index is always single-handed, from smaller keys to larger ones. Often, this index is referred to as single-handed and says there are only signs on the next knot and there is no previous indicator. ♪ ♪ ♪This feature leads to the inability the use of the ASC-indicx for DESC-grade or MAX calculations and vice versa, the impossibility of using the DESC-indicator for ASC-grade or MIN calculation.
D

Configure Delphi Berlin for api 16 or 17 or 18 (Jelly bean version of android)
Software Programming • delphi • • derk

2

0
Votes

2
Posts

0
Views

C

See this https://www.devmedia.com.br/sdk-android-instalacao-configuracao-do-sdk-e-avd/22241 there explains how to set up SDK the Android No Delphi.No https://www.embarcadero.com/starthere/xe7/mobdevsetup/android/en/installing_the_android_development_tools.html also says how to set up, but is in English.You also have that https://www.youtube.com/watch?v=NZOxjt_IY7E that shows how to set up.Just choose the version that you want and set up.
Z

Image (blob) from mysql php
Software Programming • php web programming • • zymir

2

0
Votes

2
Posts

0
Views

J

There's an answer to your question.Original: https://stackoverflow.com/a/6273415 You can use a few different methods depending on which library of php images is installed. Here are a few examples. Look, echo is just a trick I'm using to display several images from the same violin php in the cycling of the resource of MySQL. You can also drive through your header, as @NAVEED showed.GD:$image = imagecreatefromstring($blob); ob_start(); //You could also just output the $image via header() and bypass this buffer capture. imagejpeg($image, null, 80); $data = ob_get_contents(); ob_end_clean(); echo '<img src="data:image/jpg;base64,' . base64_encode($data) . '" />'; ImageMagick (iMagick):$image = new Imagick(); $image->readimageblob($blob); echo '<img src="data:image/png;base64,' . base64_encode($image->getimageblob()) . '" />'; GraphicsMagick (gMagick):$image = new Gmagick(); $image->readimageblob($blob); echo '<img src="data:image/png;base64,' . base64_encode($image->getimageblob()) . '" />';
Y

Adjusted completion of the Excel process
Software Programming • delphi excel ole • • yajahira

2

0
Votes

2
Posts

0
Views

Try keeping the sheet before you leave the program.In addition, I'll add my similar code: //Saving log-file(called from MyComm) procedure TForm1.SaveToFile(FData:Variant;LogCounter:Integer); var i:Integer; begin ExcelApp:=CreateOleObject('Excel.Application'); ExcelApp.Visible:=False; ExcelApp.DisplayAlerts:=False; ExcelApp.Application.EnableEvents:=False; //Open existing log-file try ExcelApp.Workbooks.Open(LogFileName(CurrDate)); ExcelSheet:=ExcelApp.Workbooks[1].WorkSheets[1]; //Writing to log in loop for i:=1 to LogCounter do begin CellCounter:=CellCounter+1; ExcelSheet.Cells[cellCounter,1].Value:=FData[i,1]; ExcelSheet.Cells[cellCounter,2].Value:=FData[i,2]; end; ExcelApp.WorkBooks.Item[1].SaveAs(LogFileName(CurrDate)); finally ExcelApp.Quit; ExcelApp:=Unassigned; ExcelSheet:=Unassigned; end; end;
Check if I have data on query when giving next or prior
Software Programming • mysql delphi query firedac language • • carriann

2

0
Votes

2
Posts

0
Views

To know if it is the first or last registration is to use the functions dataset.bof (Begin Of File, file start) and dataset.eof (End of File, file end)So typically the loop of a dataset is made like this:dataset.first; while not dataset.eof do begin // dataset.next; end;
Difference of result between MySql 5.5 and MariaDB 5.5
Software Programming • mysql mariadb • • Demir

2

0
Votes

2
Posts

0
Views

Incompatibilities between MariaDB 5.1 and MySQL 5.1.In a few cases MariaDB has to be incompatible to allow MariaDB to provide more and better information than MySQL.Here is the list of all known user level incompatibilities you may have when using MariaDB 5.1 instead of MySQL 5.1.The names of the installation packages start with MariaDB instead of MySQL.Times can be different as MariaDB is, in many cases, faster than the MySQL.MySQLd in MariaDB also reads the sections [MariaDB] of your my.cnf files.You cannot use a binary single storage mechanism library with MariaDB if it is not compiled for exactly the same version MariaDB. (This is because the internal THD structure server is different between MySQL and MariaDB. This is also common among the different versions of MySQL). This should not be a problem because most people do not load new storage mechanisms and MariaDB comes with more storage mechanisms than MySQL.CHECKSUM TABLE can give different result as MariaDB does not ignore NULL in columns of how MySQL 5.1 does (future versions of MySQL must calculate the check sums in the same way as MariaDB). You can get the checksum "old style" in MariaDB starting MySQLd with the option --. Note however what _ and Aria storage mechanisms in MariaDB are using the new verification internally, so if you are using --old, the command CHECKSUM will be slower since you need to calculate the line-by-line checksum.The slow query log has more information about the query, which can be a problem if you have a script that analyzes the slow query log.MariaDB, by default, takes a little more memory than the MySQL because we have enabled by default the Aria storage mechanism for handling internal temporary tables. If you need MariaDB take very little memory (at performance cost), you can set the value aria_pagecache_buffer_size to 1M (the standard is 128M).If you are using new command options, new features of the MariaDB or new storage mechanisms, you cannot move easily and backwards between MySQL and MariaDB.Source: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/ Man, it looks like the differences will start to appear now, but the older ones don't have much difference.
A

how do I mount a select with two fields using colletivehtml in laravel 5.5?
Software Programming • laravel 5 laravel blade laravel c languageollec l • • Anderson

2

0
Votes

2
Posts

0
Views

Do with the command https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_concat of MySQL to unite the fields and with the method https://laravel.com/docs/5.7/queries#selects the https://laravel.com/api/5.3/Illuminate/Database/Eloquent/Builder.html to write a select equal to this:Local::selectRaw("id‚CONCAT(codigolocal,' ',descricaolocal) as n")->pluck('n','id'); Other examples: https://pt.stackoverflow.com/questions/175096/extens%C3%A3o-de-fun%C3%A7%C3%A3o-no-laravel/175100#175100 https://forum.imasters.com.br/topic/265908-concatenar-campos-em-uma-string/ https://www.todoespacoonline.com/w/2014/10/concat-no-mysql/ References: https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_concat https://laravel.com/api/5.3/Illuminate/Database/Eloquent/Builder.html https://laravel.com/docs/5.7/queries
E

Modify version ASP.NET Core 2.2.0 by 2.2.3
Software Programming • asp.net asp.net core net core • • elysha

2

0
Votes

2
Posts

0
Views

C

Microsoft.AspNetCore.App and Microsoft.AspNetCore. All used https://docs.microsoft.com/en-us/dotnet/core/tools/csproj#implicit-version-for-some-package-references ♪ The version is defined at the time of assembly, the studio is simply not frozen and always shows 2.2. 0.The real version of the Microsoft.AspNetCore.App depends on the SDK used, you'll probably have SDK 2.2.300 and 2.2.5.
B

Pivoting date data
SQL, Database Testing • sql server firebird pivot interbase • • Burma

2

0
Votes

2
Posts

0
Views

C

Assuming you have SQL SERVER as a base You can try with this DECLARE @HelpTable TABLE( ID INT, Fecha DATE ) INSERT INTO @HelpTable VALUES (0,'2007/01/12'), (0,'2018/02/15'), (1,'2006/05/21') ,(1,'2017/12/03') ,(1,'2007/09/01') ,(1,'2018/11/23') -- CTE TO GET THE VALUES ;WITH CTE AS ( SELECT ROW_NUMBER() OVER(ORDER BY(SELECT NULL)) AS N, A.Fecha as part ,ID AS IDReal FROM @HelpTable A ) --SELECT THE DATA SELECT IDReal,[1],[2],[3],[4]--[5],[6] etc FROM( SELECT IDReal,part, ROW_NUMBER() OVER(partition by IDReal ORDER BY IDReal) AS [rn] FROM CTE ) AS [a] --USE A PIVOT PIVOT(MAX(part) FOR [rn] IN([1],[2],[3],[4])) AS [pvt]; Do not fill in all the data but with that you can give yourself an idea I attach a link where you can see the example https://dbfiddle.uk/?rdbms=sqlserver_2017&fiddle=73ef9d5cf770df291f4ed95d7a86d1a1
D

MS SQL to FireBird
Software Programming • c sharp sql server firebird • • derk

2

0
Votes

2
Posts

0
Views

S

First option:Read the Gide: http://www.firebirdsql.org/pdfmanual/MSSQL-to-Firebird.pdf Create the necessary structure in FireBird.With, for example, Import and Export Data, a SQL Server Management Studio, making the data unloaded through requests. At this point, the correct INSERT request can be made immediately:Second option:Use side programmes, for example, http://download.cnet.com/DBSync-for-Firebird-and-MS-SQL/3000-2065_4-10969427.html or http://www.findthatzipfile.com/search-16516099-hZIP/winrar-winzip-download-sql2gdb-zip.htm
A

Firebird Transaction in PHP
Software Programming • php firebird • • Amritpal

2

0
Votes

2
Posts

0
Views

A

You need to check the outcome of each Query to find out if it's wrong or not. It is not necessary to make a variable for each STRING that are the querys and it is not necessary to put each QUERY in a variable.Consider the following; check each transaction with tender operations and in case of failure run rollback and finish the PHP script.function errorEnTransaccion(&$link){ ibase_rollback($link); exit('Error fatal, se hizo Rollback!'); } $tr = ibase_trans ($conexion, IBASE_DEFAULT); ibase_query ($tr, "INSERT INTO....") ? : errorEnTransaccion($tr); ibase_query ($tr, "INSERT INTO...") ? : errorEnTransaccion($tr); ibase_commit($tr); OUR INPUTS!
C

How can I print my arithmetic expression so that if I enter 5+2*4/2 I will print it by operation?
Software Programming • java data struc languagetures • • courtlanda

2

0
Votes

2
Posts

0
Views

For that kind of trouble the most natural thing is to use recursion. The following code only works with integers, it looks extensive but it's because there's enough repeat code for simplicity.import java.util.regex.Matcher; import java.util.regex.Pattern; class Calculadora{ public String reducir(String expresion){ // patron para buscar expresion binaria: a+b,a-c,a*b,a/b Pattern operacionBinaria = Pattern.compile("^\\d+[+|\\-|*|\\/]\\d+$"); Matcher matcherOperacionBinaria = operacionBinaria.matcher(expresion); if(matcherOperacionBinaria.find()){ // es una operacion binaria, se resuelve y se devuelve el resultado if(expresion.contains("*")){//es multiplicacion //separar los numeros String[] partes = expresion.split("\\*"); //multiplicar ambas partes y devolver el resultado como cadena return String.valueOf(Integer.parseInt(partes[0]) * Integer.parseInt(partes[1])); } if(expresion.contains("/")){ //separar los numeros String[] partes = expresion.split("\\/"); //dividir ambas partes y devolver el resultado como cadena return String.valueOf(Integer.parseInt(partes[0]) / Integer.parseInt(partes[1])); } if(expresion.contains("+")){ //separar los numeros String[] partes = expresion.split("\\+"); //sumar ambas partes y devolver el resultado como cadena return String.valueOf(Integer.parseInt(partes[0]) + Integer.parseInt(partes[1])); } if(expresion.contains("-")){ //separar los numeros String[] partes = expresion.split("-"); //restar ambas partes y devolver el resultado como cadena return String.valueOf(Integer.parseInt(partes[0]) - Integer.parseInt(partes[1])); } } //primero buscamos las operaciones de mayor jerarquia (multiplicacion y division) Pattern multiplicacionDivision = Pattern.compile("\\d+[*|\\/]\\d+"); Matcher matcher = multiplicacionDivision.matcher(expresion); //si hay una multiplicacion o division if(matcher.find()){ String expresionSuperior = matcher.group(0); String primeraParte = expresion.substring(0,expresion.indexOf(expresionSuperior)); String segundaParte = expresion.substring(primeraParte.length() + expresionSuperior.length()); //imprimir resultado intermedio String resultado = primeraParte+ reducir(expresionSuperior) + segundaParte; System.out.println(resultado); //llamada recursiva a reducir return reducir(primeraParte+ reducir(expresionSuperior) + segundaParte); } // si no hay multiplicaciones o divisiones entonces se procesan las sumas y restas //patron para buscar sumas y restas Pattern sumaResta = Pattern.compile("\\d+[+|\\-]\\d+"); Matcher sumaRestaMatch = sumaResta.matcher(expresion); sumaRestaMatch.find(); //se encuentra la primera suma o resta String sumaOResta = sumaRestaMatch.group(0); // dividimos la expresion en dos partes //la primera parte contiene lo que esta antes de la suma o resta String primeraParte = expresion.substring(0,expresion.indexOf(sumaOResta)); //la segunda parte contiene lo que esta despues de la suma o resta String segundaParte = expresion.substring(sumaOResta.length()); //imprimir resultado intermedio String resultado = primeraParte+ reducir(sumaOResta) + segundaParte; System.out.println(resultado); //llamada recursiva a reducir return reducir(primeraParte+ reducir(sumaOResta) + segundaParte); } } public class Test{ public static void main(String... args){ Calculadora calculadora = new Calculadora(); String resultado = calculadora.reducir("2*2+1+2/2"); System.out.println(resultado); } } Practically works like this:is evaluated if the expression is binary (a+b,a-b,a*b,a/b), if it is calculated and the result returnedIf it is not binary then the operation of greater hierarchy is sought (multiplication or division)If there is a multiplication or division the extract and makes a recursive call to the function reduce()If there are no multiplications or divisions then process the sums and subtractionsIn each return print the intermediate step
J

remove part of sequence 1 2 3 3 3 4 4 4 4 5 5 5 5 per python 3
Software Programming • python python 3.x algorithm • • jules

2

0
Votes

2
Posts

0
Views

O

Your mistake is, in the last operator, you're cutting the impact line, suggesting that the numbers contained in it have a length of one symbol. But it's naturally not. To avoid this error, for example, lists can be used:v = [] for i in range(1, n+1): v += [str(i)] * i print(" ".join(v[:n])) Using the roster generators, all this can be recorded in one line:print(" ".join([str(i) for i in range(1, n+1) for j in range(i)][:n])) It is true that the entire code above is ineffective because it generates much more data than it is necessary to get on the screen.And here's a more effective code that generates exactly as much data as it takes:v = [] for i in range(1, n+1): c = min(n, i) n = n - c v += [str(i)] * c if n <= 0: break print(" ".join(v)) Without losing efficiency, but gaining clarity, you can play a little with it. generators (not confused with List generators!def generator(m): c = 0 for i in range(1, m+1): for j in range(i): c += 1 if c > m: return yield str(i) print(" ".join(generator(n)))
C

Delphi 2 faster than Delphi XE8?
Software Programming • delphi • • Cleofas

2

0
Votes

2
Posts

0
Views

A

Have you tried using any other type of profiler? It's very unbelievable that a narrow spot can be a banal disincentive of the indicator unless it's 100,000 thousand grand. Please note that the process measurement itself distorts her. So try to draw up a test application where you're gonna compare specific operations outside the link to another, so the probe speed measurements.Also check that you've got a release collection, optimization, and all the debauchery is off.

Take the image through OpenDialog and record in the Blob Field of BDE FireBird 2.5 - delphi

Suggested Topics

Change a record with a WebService REST Software Programming • java delphi web servic languagee • • jeanid

Firebird does not use the primary key index when requested Software Programming • sql firebird • • chanisef

Configure Delphi Berlin for api 16 or 17 or 18 (Jelly bean version of android) Software Programming • delphi • • derk

Image (blob) from mysql php Software Programming • php web programming • • zymir

Adjusted completion of the Excel process Software Programming • delphi excel ole • • yajahira

Check if I have data on query when giving next or prior Software Programming • mysql delphi query firedac language • • carriann

Difference of result between MySql 5.5 and MariaDB 5.5 Software Programming • mysql mariadb • • Demir

how do I mount a select with two fields using colletivehtml in laravel 5.5? Software Programming • laravel 5 laravel blade laravel c languageollec l • • Anderson

Modify version ASP.NET Core 2.2.0 by 2.2.3 Software Programming • asp.net asp.net core net core • • elysha

Pivoting date data SQL, Database Testing • sql server firebird pivot interbase • • Burma

MS SQL to FireBird Software Programming • c sharp sql server firebird • • derk

Firebird Transaction in PHP Software Programming • php firebird • • Amritpal

How can I print my arithmetic expression so that if I enter 5+2*4/2 I will print it by operation? Software Programming • java data struc languagetures • • courtlanda

remove part of sequence 1 2 3 3 3 4 4 4 4 5 5 5 5 per python 3 Software Programming • python python 3.x algorithm • • jules

Delphi 2 faster than Delphi XE8? Software Programming • delphi • • Cleofas

Change a record with a WebService REST
Software Programming • java delphi web servic languagee • • jeanid

Firebird does not use the primary key index when requested
Software Programming • sql firebird • • chanisef

Configure Delphi Berlin for api 16 or 17 or 18 (Jelly bean version of android)
Software Programming • delphi • • derk

Image (blob) from mysql php
Software Programming • php web programming • • zymir

Adjusted completion of the Excel process
Software Programming • delphi excel ole • • yajahira

Check if I have data on query when giving next or prior
Software Programming • mysql delphi query firedac language • • carriann

Difference of result between MySql 5.5 and MariaDB 5.5
Software Programming • mysql mariadb • • Demir

how do I mount a select with two fields using colletivehtml in laravel 5.5?
Software Programming • laravel 5 laravel blade laravel c languageollec l • • Anderson

Modify version ASP.NET Core 2.2.0 by 2.2.3
Software Programming • asp.net asp.net core net core • • elysha

Pivoting date data
SQL, Database Testing • sql server firebird pivot interbase • • Burma

MS SQL to FireBird
Software Programming • c sharp sql server firebird • • derk

Firebird Transaction in PHP
Software Programming • php firebird • • Amritpal

How can I print my arithmetic expression so that if I enter 5+2*4/2 I will print it by operation?
Software Programming • java data struc languagetures • • courtlanda

remove part of sequence 1 2 3 3 3 4 4 4 4 5 5 5 5 per python 3
Software Programming • python python 3.x algorithm • • jules

Delphi 2 faster than Delphi XE8?
Software Programming • delphi • • Cleofas