![]() This cookie is set by GDPR Cookie Consent plugin. These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly. RAD Server Lite does not install on Linux.How to debug Array DML FireDAC queries?.Firedac with Interbase some forms only updates database after closing appalication.Newest questions tagged interbase – Stack Overflow.Delphi IXMLDOMDocument2 could not load XML file with % in the file name.Delphi 7 TChromium issue using Google Maps API 3.52.2.Cannot see/execute "c:\windows\system32\rdpclip.exe" from Delphi code, but can see it and execute it using the same user login in File Explorer.Newest questions tagged delphi – Stack Overflow.The meaning and result depend on the DBMS, as described in the following table. The GetLastAutoGenValue method returns the last autogenerated value. It uses whatever unique SQL query for each different database to return the last inserted ID. It will return the last inserted ID with support for a number of different databases including Oracle, InterBase/Firebird, MySQL, MSSQL, and some others as well. You can run this select directly or use the built in FireDAC feature.įireDAC offers a function which you can call from your TFDConnection component called GetLastAutoGenValue. MySQL for example has a SELECT query function that you can run called LAST_INSERT_ID() (example: SELECT LAST_INSERT_ID ( ) ). ![]() Different databases have different SQL queries to accomplish this. Once you use your TFDQuery to run your INSERT query you can run this second query to get the newly inserted auto increment ID. ![]() ![]() A common pattern when inserting data into a database table which has an auto increment field set on it is to use an SQL query to select the last inserted ID of the newly created record. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |