Search results for query: *

I was going to ask a few questions but you've already answered them. Because the Pervasive engine still works for other clients, this seems to be related to the Flask API side of things. Here are a few questions that I still have: - Once you get the error, does it continue until you restart...

I'm reaching out to a few contacts I have from my Pervasive SQL days to see if any of them are aware of a good set of DDFs for Sage 50. If I find anything, I'll let you know. Mirtheil http://www.mirtheil.com

When using the Control Center (since v9) there have been three buttons. They are "execute into text", "execute into grid", and "execute all" (I think). In the picture below they are disabled but are the three next to the red arrow. They are enabled after you click the Execute SQL Commands...

The Actian DDF Builder is included with the Actian Zen Client / engine. It's called "Zen DDF Builder". Personally, I prefer using CREATE TABLE statements to create the tables within a database or get the DDFs from the vendor of the application. Mirtheil http://www.mirtheil.com

This suggestion is more for debugging but I would suggest checking one of the properties of the SqlClient. Maybe the UserName or Status or IP. You're right, not too many are using Python. I've used VB, C#, Delphi, and C / C++ with the DTO or DTI interfaces. I'm not as familiar with Python...

Because you aren't posting your code, I have a couple of questions: 1. Are you checking the result of the Connect? 2. Are you checking the count of SqlClients? 3. Before you Disconnect the SqlClient, are you checking that it's a valid session? 4. Have you tried the VBScript example in the docs...

The queries you've tried won't work because Pervasive doesn't support them. What is the command line you are using for the BDU. BDU must be run where the Pervasive engine is running. If you are running it on the client, you will get the "error 3392: Cannot open DBNAMES.CFG file" message. An...

...1 date_received as First_Date, min(cost) as lowest_cost from v_po_history where cost = (select min(cost) from v_po_history where part not like '*%' and date_received >= '2022-01-01' and date_received <= '2022-05-01' and location = 'HS' and part = '846060') group by date_received) as t_fd...

It is very possible. I wrote a scanner about 12 years ago for the company I worked for. Unfortunately, I don't have the code. I just haven't had the time to get back to this. It looks like you're not going far enough into the WNetEnumResource list. I found a console app (at...

What problem are you having? Is the code crashing, erroring out, giving wrong results, etc.? What is your end goal? Mirtheil http://www.mirtheil.com

It's been years but I've run the PSQL engine through a VPN and don't remember any specific problems. If you load the Pervasive Control Center and run a query or Function Executor and open a data file and read several records, does it work at a normal rate? Is the EXE that's displaying the...

...have you tried? What problem are you having? What database are you using? Your statement seems wrong. It generates something like: select * from bimar WHERE bimar.fname LIKE ''*''&''VALUE''&''*'' where VALUE is the value in Edit1.Text. Your SQL would probably be better like: 'select...

What do you mean by "the problem is the table?" The DDFs are there to describe the data file. The "table" is just a logical definition of the record structure of the file. What are the indexes on the data file? You can get that information by issuing a BUTIL -STAT on the data file. It is...

What are the data types for these fields like PO_NO or Router_Type? Are there indexes on these fields? Did the DDFs for these tables come from the ERP company or somewhere else? I've seen cases where the DDFs have the wrong datatype and it can cause problems like you're seeing. Mirtheil...

If you change the query to: Select * From PO_DATA_TABLE Where PO_NO like '%12345%' Do you get the same results in all of the databases? If so, you can compare the results to determine which ones are missing and what character is left padding the PO_NO. If this is a data issue, reinstalling...

You have to build the SQL statement and then execute it. So, you'll need something like: CREATE PROCEDURE Test(in :MyTable varchar(20)) returns (DateCreated DATE); BEGIN declare :s varchar(8000); set :s = 'select a.DateCreated from "' + :MyTable + '" a'; Exec(:s); END; Don't forget to...

If your views are stored as CREATE VIEW statements in *.SQL files, you should be able to store those in a git/github / subversion / source control system without any problem. If you want to store the actual DDFs, they are just binary file and should be easy to add to version control as well...

the source page in memo take 1 second to 2 second." -- What do you mean? How long does it take to issue a GET using Postman or another HTTP tool? For example, https://cnn.com takes 218ms (and https://cbc.ca takes 223ms) to issue the GET and get a response using Postman. How long does it...

What part is slow? How slow is slow? If it's the HTTP GET, what does Postman or some other tool for issuing an HTTP show for the time / speed? What debugging have you done? If you don't know which part is slow, you should debug line by line until you find the one that is slow. Mirtheil...

What do you mean it doesn't work? How is it failing? What debugging have you tried? What code do you currently have? Mirtheil http://www.mirtheil.com