Database not Posts

"Database not" Message Board Posts |
Thread 3 of 3 |  gwatchmaker | Database not open on executeqbe{Too Long!} | 2 replies. Last post: |  Steven.G | {Too Long!} |
|
 782 Hits | |
Thread 2 of 3 |  PS_3060 | Connecting to PostgresSQL serverHi,
I have been dragged back from retirement to fix a small Paradox database we use for design.
Previously I used the Paradox ODBC to connect to the DB and all was well. The DB is now a PostgreSQL databse.
I have installed the ODBC connection and can connect useing Access. PostgreSQL35W ODBC System DSN
On the paradox form I have a button to connect to the DB useing the following Code
dynalias["UserName"] = "aaaaa", dynalias["Password"] = "XXXXXX"
if not db.open(":PostgreSQL35W:", dynalias) then ;Which Is the ODBC System DSN, , msginfo("Caliach Database Not Open", "stop")
else
message.visible = true ;UPDATE NEW PARTS, message = ("UPDATING PARTS DATA")
sqlvar = sql
SELECT PTMPTNO, PTMP1CD, PTMSTUM, PTMSEQ,PTMSATX , PTMUSE1, PTMUSE2, FROM altro.PTMFILE altro_ptmfile, WHERE PTMSEQ > ~oldptmseq, endsql
executeSql(db, sqlvar, ":caliachData:NewParts"), , endif
How do I change this to connect to the Postsgres35 DYN?
| 1 Reply: |  Steven.G | > ":PostgreSQL35W:"
are you certain that the alias itself is correctly defined in the BDE and/or the app?
> msginfo("Caliach Database Not Open", "stop")
throw in an errorshow(), too.. might answer the question
|
|
 561 Hits | |
Thread 1 of 3 |  Daniel Fought | Preventing locking, concurrency and speed problems{Too Long!} | 4 replies. Last post: |  Dan | --------------------------------------------------------------------------------, One more question. , , 1. When doing a query to a linked database on local machine linked to network file, will it still create network traffic? , No data editing made, only browsing. |
|
 6255 Hits | |
"Database not" Knowledge Base Posts |
|
| |
KB Article |
|
|
PS_4793
|
1. Why Choose Delphi for Web Development?
Delphi offers a versatile development environment capable of producing WinCGI executables, ISAPI DLLs, and even Apache modules. You can easily start with a WinCGI executable during development and seamlessly transition to an ISAPI DLL for deployment—without needing to rewrite your code.
For experienced Delphi developers, the benefits are immediate. You can build powerful web applications using the language and tools you already know, all within a fast, feature-rich IDE.
Delphis Web Broker framework includes a compact yet powerful set of web-aware components, designed to simplify web development. It even comes with a project wizard to help you hit the ground running. Components like TPageProducer and TTableProducer let you dynamically generate HTML content with ease—much like how mail merge works in word processors. dog barks
A major strength of Delphi lies in its deep integration with databases. Virtually every major database system is supported, making it ideal for data-driven applications.
Delphi also shines with its robust object-oriented programming (OOP) capabilities. Complex logic can be elegantly managed by encapsulating functionality into objects, promoting modular and maintainable code.
Another key advantage: your intellectual property remains secure. Unlike scripting-based solutions (PHP, Perl, classic ASP, etc.), which often expose your business logic in plain text, Delphi lets you compile your code into secure binaries. With DLL deployment, your source remains protected.
Lastly, Delphi compiles directly to fast, native machine code. This means no runtime interpreters, no script engines, and no JIT compilation like ASP.NET—just high-performance applications that run natively on Windows.
|
 KB Post
 217 Hits
|
 Coding & OO
|
PS_4637
|
2. Best Cat Translator App
First things first: how do these cat translator apps even claim to work? Some cat translator tools, like Furlingo or PetTalk, use algorithms and databases of cat sounds to “translate” meows into human language.
A few even claim to have input from animal behaviorists, which sounds legit, right?
Picture this: Me, cross-legged on the floor, holding my phone like a meow Ouija board. Mr. Whisker saunters over, sniffs the screen, and delivers a dramatic “MRAOOP!” The app declares: “Let’s play! Bring the feather wand!” Best Cat Translator App
Meanwhile, Mr. Whisker’s actual agenda? He’d just stepped on a crinkle ball. It was a war cry.
Here’s what I learned:
1. Apps Speak “Human,” Not “Cat” Tools like Furlingo use fancy algorithms and meow dictionaries. But cats? They’re freelance vocalists. That “feed me” meow at 5 AM? To another cat, it probably means, “Human slave, awaken and grovel.”
After weeks of app-induced confusion, I realized: I’d already cracked Mr. Whisker’s code.
Silent Meow + Blink: “You’re tolerable… for a hairless ape.” The Doorframe Rub + Purr: “Admire my floof.” Toe Bite at 3 AM: “Your suffering sustains me.” Yes, cat translator apps do work—especially the good ones. They can be surprisingly accurate when it comes to decoding basic meows, purrs, and chirps.
But do we believe them 100%? I wouldn’t go that far. At the end of the day, we’re cat owners. We know our furry overlords better than any app ever could. We’ll always trust our instincts and observations over a digital translation.
That said, these apps can definitely help with basic day-to-day queries. Is Mr. Whisker meowing because he’s hungry, bored, or just feeling chatty? A translator might give you a clue. But remember, it’s just a tool—not a replacement for the bond you share with your cat.
So, if you’re curious, give one a try! Just don’t be surprised if your cat still manages to keep a few mysteries up their furry sleeve. After all, that’s part of what makes them so endlessly fascinating, right?
|
 KB Post
 836 Hits
|
 Technical Writing
|
NE Ohio Computer Guy
|
3. The US Government DO NOT CALL Download Files Should Be Structured Better
This article discusses why I think the US government’s DO NOT CALL download data files should be structured better so most people can import them into commonly used database programs.
7 years ago, and updated 6 years ago
|
 Article
 1561 Hits
|
 Computer Tech
|
NE Ohio Computer Guy
|
4. The Situation Dictates Whether or Not Technology is Obsolete
This article discusses a real life example of how I used obsolete technology to revive a Visual Foxpro manufacturing database that was attacked by viruses.
10 years ago, and updated 6 years ago
(2 Comments
, last by sailong.m )
|
 Article
 4829 Hits
|
 Visual FoxPro
|
Mike Prestwood
|
5. 1 of 2, AppName 1.0
Step 1 of 2: Discovery
- PSDP Feasibility Phase: Setup legacy system for coders. Document legacy system using automated tools.
- PSDP Requirements Phase: Identify forms and reports to convert. Document terms, actors, and identify use cases. Identify enhancements (if any). Identify tables in use.
- PSDP Design Phase: Build new database. Initial screen design mockup. Document business rules and additional documentation of use cases.
Step 1 deliverables usually include a project plan for the Step 2 of 2 build-it phase which serves as the requirements, a new database, and a GUI mockup. Each form and report becomes a task in step 2 of our 2-step process along with other known tasks such as build data migration program, build MVC Shell Application, user subsystem, and admin forms for maintaining users, lookup tables, etc.
Step 1 of our 2 step approach is used to start a project with discovery. Step 2 is build. The goal of discovery is to document known requirements, some initial design, and a project plan. Step 1 of our 2 step includes at least the following tasks: Gather Requirements, Build GUI Mockup, and Create the Initial Database. The Requirements task becomes the project plan for step 2, Build.
Discovery can include additional tasks such as documenting an existing application, data cleanup, and even a task or two from the initial coding phase such as implementing our Prestwood ASP.Net MVC shell which includes some initial design, and member management.
If this ticket is not authorized, the printed version of the Project Plan is the Project Proposal for Discovery. Once authorized, the tasks of this project are completed. The requirements task is completed by creating a Step 2 of 2 project ticket which becomes the project plan and/or the proposal for Step 2, Build.
9 years ago, and updated 9 years ago
(1 Comments
, last by Ameli.K )
|
 SS
 2159 Hits
|
 Prestwood IT Solutions
|
|