Pavel, My guess that, in a batch task, it would actually run faster to do it the old fashioned way using Output Form in the Record Suffix and with no window open at all. It'd be an interesting test an

ProgramHeaders.xml

Jordan, If the user is still connected, you can review their usage, in bytes and time, in the Pervasive Monitor. The new monitor utility in v12 is really, very nice, but the older monitor will be able

Jordan, Pervasive does not provide a mechanism by which one could throttle a user. Utterly disconnect, yes. Throttle, no. That said, something is wrong. An Excel spreadsheet, even one that had direct

Why not? Jacques uses Magic v8.3. Don't feel bad, you had no way of knowing. The only reason I know is because Jacques is an old-timer. Like me. And Uncle Sherm. ;)

Lado, Start with Windows' Character Map applet: In the combo box at the top, select the same font in use in your Magic application. Locate the desired currency symbol in the map and click on it. At th

Jim, In Options, Settings, Databases' Properties dialog on the Options tab, if Check Definition is unchecked (off) in the production environment, then it won't report a mismatch even if one exists. Or

So, you just confirmed my first sentence. Check Definition is off in production and there really IS a mismatch. How does it happen? There are any number of ways, but I'll wager it involves having mult

Ewout, The Pervasive Client's bitness must match that of the application, not the server. Since Magic xpa is a 32-bit application, it will only work with the 32-bit Pervasive Client. A 32-bit Pervasiv

Darren, How much does it cost to rent a clown? Depends on the clown. In this case, factors include, but are not limited to: 1) The annual revenue and location of the company for whom developed. 2) Fun

NVARCHAR is Unicode. Perhaps you need: Trim(UnicodeToANSI(FP)) & ... Sent from my iPhone

Erwin, I don't believe you will be able to achieve the results you expect using an XML DataSource; I believe the only way will be to employ the XML direct functions such as XMLGet(), for input, and XM

Usually, shutting down the broker service (uniRQBroker.exe) will stop any engines (uniRTE.exe) that are still active, unless they're hung or busy for some reason and can't respond to the request to te

Arch, Are you declaring the tables in the calling program(s)? If not, doing so will help. Steve Blank

Summing Invoice lines? Direct SQL.

Pervasive ISAM? Create DDFs and now you ALSO have SQL gateway. Steve Blank

Nothing has to change about Arch's program except for the one batch task that currently reads invoice lines and sums them. That one batch task is easily rewritten as a Direct SQL batch task, End Task

It sounds like a network layer problem between the uniPaaS Enterprise Server and the Pervasive Database server. Possible culprits include the network card in either machine, the switches to which they

Another option would be to update the status in a parallel batch task. Parallel tasks execute within their own transaction. Steve Blank

Option 1) Check the PVSW.LOG files on both the server- and client-sides. Option 2) Enable MAGIC_LOGGING for the DBMS. Steve Blank