DBGo | This is a programming exercise , do not use in serious code | Database library
kandi X-RAY | DBGo Summary
kandi X-RAY | DBGo Summary
"DBGo" is a light-weight relational database engine implemented in Go programming language. It is a programming exercise to learn Go. Edit on 2013-06-25: DBGo was originally written as a Golang exercise and there are some serious implementation flaws. Do not use in serious code.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- g8 creates a new person record .
- g7 creates a new Person object .
- LocksOf returns all locks for the given table .
- g6 show db
- g3 - example .
- g5 show db
- g4 - > db .
- Open opens the database at the specified path .
- RemoveLine removes a line from a file .
- PrepareForTriggers prepares triggers for triggers .
DBGo Key Features
DBGo Examples and Code Snippets
Community Discussions
Trending Discussions on DBGo
QUESTION
Delphi Rio - I have dbGO/ADO configured with Oracle (using Oracle's connector, not Microsoft's). I am working with a simple query.
...ANSWER
Answered 2021-Apr-19 at 14:29Looks like it uses ROWID for internal purposes like cursor navigating, so try to add 2 ROWID columns and wrap one in the nested subquery:
QUESTION
What happens: create delphi 32 bit application to open up a ms access database, the newer accdb one, created with access 2013 32 bit version. Using TADOConnection and dbgo. Works great. Change to 64 bit platform, as soon as I try opening up a table at runtime, I get the "provider cannot be found error". Although I can open up a table within the IDE. OS is windows 10 pro 64 bit.
I have tried uninstalling ms office, and then downloading and installing the access 2013 database engine, the 64 bit version one. If I drop a TADOConnection on a new project, there are no MS ACE 12 or 15 providers. If I uninstall the 64 bit database engine, and install the 32 bit database engine, I see providers in both delphi 32 and 64 bit target platforms. I tried installing the 64 bit database engine using the "passive" parameter but microsoft has apparently caught on to this trick and will give the usual error message about you cannot install both 32 and 64 bit versions. So I tried using the 2010 versions of the database engines and still get error messages, although different ones.
It just feels like I'm missing something here. The weird thing is that in the IDE, using 32 bit access engine and 64 bit delphi target platform, I can make the connection active and open a table. But if I try and open a table at run time I get the error. I have also tried uninstalling and reinstalling delphi.
...ANSWER
Answered 2021-Feb-26 at 15:23Ok so the short answer is yes it will work, but there are a few caveats:
- You can only install either the 32 bit or 64 bit access 2013 engine drivers or Office, or any combination of those two. Microsoft has disabled the /passive or /quiet way to bypass that. So you can't install both 32 bit and 64 bit at the same time. (at least in a straightforward manner) You can go to control panel and see which ODBC drivers are installed via admin tools.
- The IDE is 32 bit, and can only see 32 bit access engine providers when they are installed (via tadoconnect build data provider). Any 64 bit providers installed are not visible in the tadoconnect build connection string wizard.
- The good news is that the 32 bit and 64 bit access engine providers have exactly the same provider name. So if you install the 32 bit drivers, create your 32 bit project, you can also create your 64 bit target as well.
- with 32 bit drivers installed, your 32 bit target application will debug and run normally. If you try and run the 64 bit target, you'll get "provider not found"
- with 64 bit drivers installed, your 64 bit target application will run normally, and the 32 bit application will give the "provider not found" error. In addition, in the IDE, you will not be able to see the data provider via the build connection string in tadoconnect, just leave it alone as it has the exact same name. You can run or debug your 64 bit app, just assume the data provider is correct even though you can't see it.
A thanks to Ken White for a point in the right direction.
QUESTION
Consider we have a standard master-detail relationship with two TADOQuery
. When navigation over master dataset takes place, an AfterOpen
event doesn't rise for the detail dataset.
This event is rised in other data access packages, such as BDE. Why does this behavior differ for dbGo?
A part of .dfm:
...ANSWER
Answered 2019-Mar-28 at 19:17This event is raised in other data access packages, such as BDE. Why does
this behavior differ for dbGo?
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install DBGo
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page