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).

Positioning for needed id in DBLookupComBox

K
Kadyn last edited by
Morning.
Such a question:
There's a table1 with three fields.
```
«id» «last_name» «firm»
 1     Федотов   фирма №3
 2     Федотов   фирма №4
```
with which data are collected DBLookupComBox♪
In " List Field " and " Key Field " parametersDBLookupComBoxa field of "last_name " is established. Displacement DBLookupComBox♪ DBGrid Table 1 shows that the courseor is moving in notes (1 and 2).
How to make a user choose a name like
c "id" = 1, theor may have positioned on the selected record, with id = 1,
or
c "id" = 2, the courseor could be positioned on the selected record, with id = 2.
Not just on the record, with id = 1?
Now, when you choose different lines DBLookupComBox, positioning occurs at all times with id = 1.
Thank you.
Reply Quote 0
1 Reply Last reply
C
courtlanda last edited by
There was a response from the discussions.
```
"KeyField" := 'last_name; ID'; 
```
Key Field is a field to be delivered to Data Field
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

ADODataSet: How do you know how many records are left after the filter?
Software Programming • delphi • • Marcee

2

0
Votes

2
Posts

0
Views

T

Everything's fine, normal RecordCount is right.
M

Why do I have this mistake on my pick?
Software Programming • firebird • • magpie

2

0
Votes

2
Posts

0
Views

E

if (b.fecha >= :inicio as date and b.fecha <=:fin as date ) then select b.codigoproveedor ,(SELECT a.nombreproveedor FROM proveedores a WHERE a.codigoproveedor = b.codigoproveedor) ,sum (b.cantidad) FROM produccion b group by b.codigoproveedor,(SELECT a.nombreproveedor FROM proveedores a WHERE a.codigoproveedor = b.codigoproveedor)
Removing the line from the text file in ListBox. Delphi 7
Software Programming • delphi delphi 7 • • Laycee

2

0
Votes

2
Posts

0
Views

Download. Delete. Safe.How disposal is done:ListBox1.Items.Delete(42); // удалит 43 строку (нумерация идет с 0) ListBox1.DeleteSelected; // удалит выбранную(ые) строки в ListBox1 Total:ListBox1.Items.LoadFromFile('notes.txt'); ListBox1.Items.Delete(42); ListBox1.DeleteSelected; ListBox1.Items.SaveToFile('notes.txt'); If you need clearance without ListBox1, use TStringList, for example.procedure DeleteLine(const aPath: string; aLineToDelete: Integer); var // Локальная переменная вместо with, во избежании путаницы SL: TStringList; begin SL := TStringList.Create; try SL.LoadFromFile(aPath); SL.Delete(aLineToDelete); SL.SaveToFile(aPath); finally SL.Free; end; end;
B

Sending only the id
Software Programming • php • • baileigh

2

0
Votes

2
Posts

0
Views

M

1st MYSQLMySQL functions had become obsolete after updates. It is currently used MYSQLi for its performance being superior and some advantages. Read about this link: https://secure.php.net/manual/pt_BR/book.mysqli.php 2nd CONEXION WITH DATA BANKAs a way to ensure more security and better handling with DB, a part-to-part page should be made for the connection as follows.1 - Create a php page called conexao.php. After creating, add your connection to this page. Staying like this:<?php $servidor = "localhost"; $usuario = "root"; $senha = ""; $dbname = "copa"; //Criar a conexao $conn = mysqli_connect($servidor, $usuario, $senha, $dbname); if(!$conn){ die("Falha na conexao: " . mysqli_connect_error()); } ?> Thus avoiding the duplicate of connections. Save your connection wherever you wish (Preferably in the root folder along with the pages to follow this tutorial correctly).3rd FORMYou should first make the form send your data to PHP.at the beginning of the tag, assign it as POST method.<form enctype="multipart/form-data" name="form" method="POST"> After assigning, add a name to your button:<input type="submit" value="Cadastrar" name="btnForm"> So you can call the data when the button is triggered.Save your form where you want (Preferably in the root folder along with the pages to follow this tutorial properly)._You need to transfer your form input values into the INSERT.This way:<?php include_once("conexao.php"); // Incluir sua conexão com o banco de dados. include_once("formulario.php"); // Incluir a página do seu formulário. $btnForm = filter_input(INPUT_POST, 'btnForm', FILTER_SANITIZE_STRING); if($btnForm){ include_once 'conexao.php'; $dados = filter_input_array(INPUT_POST, FILTER_DEFAULT); $inserirBD = "INSERT INTO palpites (nome, email, palpites, palpites2, palpites3) VALUES ( '" .$dados['nome']. "', '" .$dados['email']. "', '" .$dados['palpites']. "', '" .$dados['palpites2']. "', '" .$dados['palpites3']. "' )"; $resultado = mysqli_query($conn, $inserirBD); if(mysqli_insert_id($conn)){ echo " <META HTTP-EQUIV=REFRESH CONTENT = '0;URL=http://localhost/PASTA/formulario.php'> <script type="text/javascript"> alert("Dados inseridos com sucesso."); </script> "; // Cria um alerta para seu cadastro. }else{ echo " <META HTTP-EQUIV=REFRESH CONTENT = '0;URL=http://localhost/PASTA/formulario.php'> <script type="text/javascript"> alert("Erro ao inserir dados."); </script> "; // Cria um alerta para seu cadastro. } } ?> Remembering that when you create an id on MySql, you can put it to be AUTO INCREMENT, where it will count every time you add a new hunch, all automatic, not needing to add it to the Mysql INSERT.
F

Why do you need..._fspath_?
Software Programming • python python 3.x • • fbio

2

0
Votes

2
Posts

0
Views

Because the challenge. str(path) There are mistakes. str(obj) works for any facility in Pitton, but not all objects.♪ Example https://www.python.org/dev/peps/pep-0519 : open(str(None), 'w') Could create a file, instead of making a mistake. https://docs.python.org/dev/library/os.html#os.fspath returning the show. pathsuitable for the file system and avoids silent errors:>>> import os >>> os.fspath(None) Traceback (most recent call last): File "<stdin>", line 1, in <module> TypeError: expected str, bytes or os.PathLike object, not <class 'NoneType' at ...> Examples of candidates __fspath__ Protocol: https://docs.python.org/3/library/pathlib.html ♪ os.DirEntry (generated) https://docs.python.org/3/library/os.html#os.scandir )Your example, you can rewrite this:from pathlib import Path import appdirs # $ pip install appdirs path = Path(appdirs.user_data_dir(appname, appauthor)) config_path = path / 'configs' / 'sub_configs' / 'my_super_config.ini' conf = config_path.open(encoding="utf-8") If you're really data from a file that's relatively installed, you want to use it. https://docs.python.org/3/library/pkgutil.html#pkgutil.get_data or setuptools' https://setuptools.readthedocs.io/en/latest/pkg_resources.html#resourcemanager-api ♪In this case, there is no difference between os.path functions and pathlib Interface. But in general, there are advantages in using special facilities to replace common lines of study. https://www.python.org/dev/peps/pep-0519 :At issue is the fact that while all file system paths can be represented as strings or bytes, not all strings or bytes represent a file system path. This can lead to issues where any e.g. string duck-types to a file system path whether it actually represents a path or not.As demonstrated by a mistake to the top, sometimes the answer to the lines that are not pathways (str(None)(d) Possibilities of interpretation and special facilities such as pathlib.Path There is no shortage.Plus, a special facility can provide a richer special interface, for example, path.read_text()♪ There were and there were modules that used objects to show paths, such as: https://github.com/jaraco/path.py ♪In practice, if there is a possibility to use Pitton 3 or to put https://pypi.python.org/pypi/pathlib2/ the code that works with the file system is nicer. pathlib.Path/os.DirEntry write. Here. https://ru.stackoverflow.com/a/500275/23044 https://ru.stackoverflow.com/a/530158/23044 where pathlib makes the code more readable. Examples of where the same functionality is realized and without os.scandir(): https://ru.stackoverflow.com/a/477013/23044 https://ru.stackoverflow.com/a/461144/23044
Select dependent save id, but I need to save the variable
Software Programming • php mysql ajax • • Analeea

2

0
Votes

2
Posts

0
Views

C

You can access the text of the selected variable from the onchange as shown in the example. Once stored you can send it as part of the data ajax Like the id.$('#provincia').on('change',function(){ var provinciaID =$(this).val(); var provinciaText = $(this).find('option:selected').text(); //..... alert(provinciaID + "---" + provinciaText); });<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script> <select id="provincia"> <option value="1">Texto1</option> <option value="2">Texto2</option> <option value="3">Texto3</option> </select>
Problem with delphi
Software Programming • delphi • • Mystic

2

0
Votes

2
Posts

0
Views

G

In order to create a module, we need to press File-state-NewUnit or File-State-New-Other, and in the open window select the Unit. What's the Delphi version? Something I didn't quite understand: the application couldn't be created or the module? I've always had both. If you're wondering why you have this problem, there may be a few options: a curve may have been set (to complete decommission and reset), a left version may have been caught, maybe your Vinda didn't like it or liked did not like the an (if version 5-7).
footer positioning!
Software Programming • html5 css3 • • inna

2

0
Votes

2
Posts

0
Views

D

If the situation is just the footer catches the entire screen, you can add the css below and see if it solves:footer{ background-color: green; width: 100%; height: 20px; position: fixed; bottom: 0; left: 0; }
R

Xcode - Need constraits for Y position
Software Programming • ios swift xcode uikit • • Rossere

2

0
Votes

2
Posts

0
Views

G

Look carefully where you're chaining up top and bottom liners.There's a beautiful website. https://www.wtfautolayout.com in which it is possible to simply introduce a log of errors from the construction industry and make recommendations to the decision.
P

unable to load dbxmss. dll on Delphi XE4
Software Programming • sql delphi delphi xe4 • • Pearlaqua

2

0
Votes

2
Posts

0
Views

By default this Dll( http://docwiki.embarcadero.com/RADStudio/XE5/en/Deploying_dbExpress_Database_Applications ) is by default in the directory Bin(C:\Program...\Embarcadero\RAD Studio\<Versão>\bin) Delphi.If you do not have the file(what would be unlikely) you will have to download it and put it in the folder, or perform reinstallation/repair.
J

Swap function
Software Programming • c sharp delphi • • Jolied

2

0
Votes

2
Posts

0
Views

K

In the commentaries, they asked where to look at the:For the type of ushort:private ushort Swap(ushort number) { var hi = (byte)(number >> 8); var lo = (byte)(number & 0xff); return (ushort)((lo << 8) | hi); } For Type Int data:int SwapInt(int number) { var hi = (byte)(number >> 24); var lo = (byte)(number & 0xff); return ((number & 0xffff00) | (lo << 24) | hi); }
O

Long Delphi calculations
Software Programming • delphi • • Oba22

2

0
Votes

2
Posts

0
Views

T

The simplest crutch isApplication.ProcessMessages; This function passes all of the system ' s applications.In a more complex but more productive version, the calculation transactions are streamed into a separate flow (the Native Class TThread) and the intermediate results to the main flow are transmitted through asynchronous methods.
M

Where do you find the option of importing the library?
Software Programming • delphi delphi 7 delphi xe • • meriah

2

0
Votes

2
Posts

0
Views

R

In RAD, it was replaced by an entire import dialogue. Menu Component = Item Import Component and import.
Final id
Software Programming • php mysql sql • • jeanid

2

0
Votes

2
Posts

0
Views

K

http://www.w3schools.com/sql/sql_orderby.asp may accept several arguments. First it's the first one, then the second. In your case, there's something like that. SELECT * FROM wall WHERE wall='$_GET[id]' ORDER BY id1, id2 LIMIT 0,4♪ The type of classification may be added, e.g. ORDER BY id1 DESC, id2 DESC
multiple reproducing one wav of the file on top of it.
Software Programming • delphi audio bass.dll • • Mystic

2

0
Votes

2
Posts

0
Views

E

In the course of the examination of the matter, the best solution was the use of the Bass.dll Library. You can download it by reference. http://www.un4seen.com/ Installation instructions if someone has difficulties:Put bass.dll in the file with the program;♪ Uses add Bass;To global variables add Channel: Cardinal;♪ FormCreate ♪ BASS_Init(-1, 44100, 0, application.Handle, nil);Recovery:procedure TForm1.FormKeyPress(Sender: TObject; var Key: Char); begin if key=#49 then begin Channel := BASS_StreamCreateFile(FALSE, PChar('res/snd/1A.wav'), 0, 0, 0); BASS_ChannelPlay(Channel, False); end; end;

Positioning for needed id in DBLookupComBox

Suggested Topics

ADODataSet: How do you know how many records are left after the filter? Software Programming • delphi • • Marcee

Why do I have this mistake on my pick? Software Programming • firebird • • magpie

Removing the line from the text file in ListBox. Delphi 7 Software Programming • delphi delphi 7 • • Laycee

Sending only the id Software Programming • php • • baileigh

Why do you need..._fspath_? Software Programming • python python 3.x • • fbio

Select dependent save id, but I need to save the variable Software Programming • php mysql ajax • • Analeea

Problem with delphi Software Programming • delphi • • Mystic

footer positioning! Software Programming • html5 css3 • • inna

Xcode - Need constraits for Y position Software Programming • ios swift xcode uikit • • Rossere

unable to load dbxmss. dll on Delphi XE4 Software Programming • sql delphi delphi xe4 • • Pearlaqua

Swap function Software Programming • c sharp delphi • • Jolied

Long Delphi calculations Software Programming • delphi • • Oba22

Where do you find the option of importing the library? Software Programming • delphi delphi 7 delphi xe • • meriah

Final id Software Programming • php mysql sql • • jeanid

multiple reproducing one wav of the file on top of it. Software Programming • delphi audio bass.dll • • Mystic

ADODataSet: How do you know how many records are left after the filter?
Software Programming • delphi • • Marcee

Why do I have this mistake on my pick?
Software Programming • firebird • • magpie

Removing the line from the text file in ListBox. Delphi 7
Software Programming • delphi delphi 7 • • Laycee

Sending only the id
Software Programming • php • • baileigh

Why do you need..._fspath_?
Software Programming • python python 3.x • • fbio

Select dependent save id, but I need to save the variable
Software Programming • php mysql ajax • • Analeea

Problem with delphi
Software Programming • delphi • • Mystic

footer positioning!
Software Programming • html5 css3 • • inna

Xcode - Need constraits for Y position
Software Programming • ios swift xcode uikit • • Rossere

unable to load dbxmss. dll on Delphi XE4
Software Programming • sql delphi delphi xe4 • • Pearlaqua

Swap function
Software Programming • c sharp delphi • • Jolied

Long Delphi calculations
Software Programming • delphi • • Oba22

Where do you find the option of importing the library?
Software Programming • delphi delphi 7 delphi xe • • meriah

Final id
Software Programming • php mysql sql • • jeanid

multiple reproducing one wav of the file on top of it.
Software Programming • delphi audio bass.dll • • Mystic